2. job_data_x column in the dbo.JOBSVC table not displaying varbinary(max), null as a datatype.the solution is to run the sspm_settings.sql located in the database\scripts\<PM_$Version>\install directory.
To alter the job_data_x column type, run the sspm_settings.sql script against the database as the sa user.
This script can be found within in the P6 EPPM media files at database/scripts/install/PM_<$Version>/sspm_settings.sql
After the script is run successfully, confirm the dbo.JOBSVC column shows as job_data_x (varbinary(max), null)
Member for
16 years 3 monthshe needs to get the
he needs to get the previledges
Member for
14 yearswere importing xlm via the
were importing xlm via the web interface.
the above imformation was very useful especially column x.
he has noticed a variation but does not have the privaleges to change it at the moment.
Kind regards Craig
i would like some more attention on this as i can't start without having this fixed.
Member for
14 yearsok were going through the
ok were going through the primavera enterprise.
i have been told we can not do regular imports /experts.
Is this true.
we have togo through the web interface .
The web interface only works to a status report after importing that says failed.
kind regards Craig
fairly urgent now
Member for
16 years 3 months1. the excel file needs to be
1. the excel file needs to be an xlsx
2. job_data_x column in the dbo.JOBSVC table not displaying varbinary(max), null as a datatype.the solution is to run the sspm_settings.sql located in the database\scripts\<PM_$Version>\install directory.
To alter the job_data_x column type, run the sspm_settings.sql script against the database as the sa user.
This script can be found within in the P6 EPPM media files at database/scripts/install/PM_<$Version>/sspm_settings.sql
After the script is run successfully, confirm the dbo.JOBSVC column shows as job_data_x (varbinary(max), null)