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
Member for
16 years 3 months
Member for16 years4 months
Submitted by Zoltan Palffy on Mon, 2020-06-29 13:56
Member for
8 years 1 monthJason,The 100 character limit
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
Member for
16 years 3 monthsall setting for lenghts are
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 ?
Member for
7 years 7 monthsThis is the answer from the
This is the answer from the SQL Server.
[[wysiwyg_imageupload:7460:]]