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.

Primavera Critical import issue

No replies
Alex Lyaschenko
User offline. Last seen 5 weeks 4 days ago. Offline
Joined: 15 Aug 2011
Posts: 59
Groups: None

During Import of XER file the appication is intercepted. Then it is not possible to start P6 at all.

Log file: 

Bad Data Row for table UDFTYPE

UDF_TYPE_ID = 828

TABLE_NAME = TASK

UDF_TYPE_NAME = user_field_828

UDF_TYPE_LABEL = OLD_MS_UID

LOGICAL_DATA_TYPE = (null)

SUPER_FLAG = (null)

INDICATOR_EXPRESSION = (null)

SUMMARY_INDICATOR_EXPRESSION = (null)

I understand that it could be something wrong with the XER file but really surpriseby that P6 is so unstable. It is absolutelly abnormal that one bad import can kill the whole sysem.
 

It is something easy to fix or the only way is to re-install P6? 

 

8616
p6_error.png

Rodel Marasigan
User offline. Last seen 2 days 17 hours ago. Offline
Joined: 25 Oct 2006
Posts: 1699

It is an XER issue, not a P6 issue. The XER file contained bad data, preventing P6 from importing to avoid data corruption. It is an easy fix if you know how to read XER using a normal text editor, XER manager, or XER parser. You just need to remove the UDF type and UDF value that is causing the error. If you wish, you can send me your XER, and I can fix it for you.

david kelly
User offline. Last seen 11 hours 31 min ago. Offline
Joined: 12 Feb 2016
Posts: 33
Groups: None
hmm logical data type of null is not valid. Someone been editing the XER file?
david kelly
User offline. Last seen 11 hours 31 min ago. Offline
Joined: 12 Feb 2016
Posts: 33
Groups: None
hmm logical data type of null is not valid. Someone been editing the XER file?
david kelly
User offline. Last seen 11 hours 31 min ago. Offline
Joined: 12 Feb 2016
Posts: 33
Groups: None
Frankly, Alex, if you are stuck....... I will have a look
david kelly
User offline. Last seen 11 hours 31 min ago. Offline
Joined: 12 Feb 2016
Posts: 33
Groups: None
Frankly, Alex, if you are stuck....... I will have a look