Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Johnny Cocker
Starting Member
1 Post |
 Posted - 2009-05-13 : 01:41:09
|
| I was trying to import an .XER that i created in Permaster 8.5 into Primavera P6 but this is the error i get when i try to import:event code: PRMDB-1960-8PRM DBAccess Error: Database Server Error: The statement has been terminated.Cannot insert the value NULL into column 'rsrc_name', table 'pmdb$primavera.dbo.RSRC'; column does not allow nulls. INSERT fails.'pmdb$primavera.dbo.RSRC'; column does not allow nulls. INSERT fails.The Table NAme is DBO.RSRC The Column is the RSRC_Name (VARCHAR (100), not null)Should I change the (not null) to Null?Any Advise on this....EprmDBSQLExecutionFailurePRMDB-3238-Dtable 'pmdb$primavera.dbo.PROJECT'; column does not allow nulls. INSERT fails.PRM DBAccess Error: Database Server Error: The statement has been terminated.Cannot insert the value NULL into column 'proj_short_name', table 'pmdb$primavera.dbo.PROJECT'; column does not allow nulls. INSERT fails.The Table NAme is dbo.PROJECT The Column is the proj_short_name (VARCHAR (40), not null)Should I change the (not null) to Null?and i DID and now i get this:'PROJECT' table- Unable to modify table. Cannot insert the value NULL into column 'proj_short_name', table 'pmdb$primavera.dbo.Tmp_PROJECT'; column does not allow nulls. INSERT fails.The statement has been terminated.Any Advise on this....Mr. Johnny Cocker |
|
|
|
|
|
.XER Import into Primavera P6 W/SQL 05 Express