PRMDB-1701-A importing fault code

PRMDB-1701-A

 

I am imprting a MSP file or excel file once converted.

i am on 16.2 but unfortunatly the fault code PRMDB-1701-A occurs.

 

what should my IT do to fix this problem.

 

Kind Regards Craig

C
craig roberts 👤 Member for 14 years 7 months

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.

C
craig roberts 👤 Member for 14 years 7 months

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

Z
Zoltan Palffy 👤 Member for 16 years 10 months

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)

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts