Hi All,
When try to import a P6 XML file, show up an error window saying "Valvue too large for cloumn WBS_Name (actuall:116, maximum :100)", Any advice on how to solve it or where can adjust my WBS name Maximum Characters.
thanks and regards
WBS Name Maximum Characters
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
Jason,
The 100 character limit is an absolute maximum if you are using SQL Server (or I presume Oracle Database).
It can however be exceeded when using SQLite as the database due to the difference in how this operates compared to the other 2 Database types, but I don't think that this would have been done inside the Primavera interface.
The Primavera software should not allow you to exceed the 100 character limit for compatibility, however if the file is edited outside of Primavera then it can be exceeded when it shouldn't have.
I have modified an XER file & imported into Primavera OK when using a SQLite database. Exporting from this database into an SQL Server database then failed (XER Import not XML).
This setting cannot be altered within Primavera & is hard coded into the Database structure. It could theoretically be changed at the database level, but would not recommend going down this route.
You would need to adjust the WBS Name to 100 characters or less to allow the import.
Regards,
Steven
all setting for lenghts are in the Admin Preferences setting.
one solution is to shorten the name
where did the xlm come from ?
what program created it
are you sure its not the wbs tree limit ?
This is the answer from the SQL Server.
[[wysiwyg_imageupload:7460:]]