Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

PRMDB-1701-A importing fault code

4 replies [Last post]
craig roberts
User offline. Last seen 3 years 20 weeks ago. Offline
Joined: 3 Nov 2011
Posts: 11
Groups: None

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

Replies

Zoltan Palffy
User offline. Last seen 3 weeks 3 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

he needs to get the previledges 

craig roberts
User offline. Last seen 3 years 20 weeks ago. Offline
Joined: 3 Nov 2011
Posts: 11
Groups: None

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.

craig roberts
User offline. Last seen 3 years 20 weeks ago. Offline
Joined: 3 Nov 2011
Posts: 11
Groups: None

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

Zoltan Palffy
User offline. Last seen 3 weeks 3 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

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)