Question
Pegasystems Inc.
US
Last activity: 14 Mar 2018 16:18 EDT
BIX schema generation error
Hi All,
I'm trying to do a BIX extract to database (7.3.1) for a work class FS-PM-XXX-Work. I clicked the gear icon on this and changed the "From Class" dropdown to FS-FW-XXXFW-Work and selected several properties including a singe page called AccountingVoucher.
When I try to generate the schema I get an error: Error in writing DDL. Table Name FS_PM_XXX_Work_AccountingVoucher cannot be more than 30 characters. Since AccountingVoucher is a single page I wouldn't expect it to have it's own table, and if I click the gear icon for this property it doesn't have the "To Table" and "Key Name" fields that a page list would. Without those fields there's no way to change the table name. I thought possibly shortening the table name for FS-PM-XXX-Work would apply to downstream properties but that made no difference.
So, is there any situation where table DDL should be generated for a single page property? And any suggestions how I can modify this value so it's under 30 characters?
Accepted Solution
Pegasystems Inc.
US
We were able to resolve this issue by removing the property, saving the extract, adding the property again, and saving again. DDL then generated without error.
Pegasystems Inc.
US
That enhancement will be useful for Oracle 12.2, but we're using 12.1 and the limit actually is 30 characters. In this case we need a way to modify the SQL or another workaround.
Accepted Solution
Pegasystems Inc.
US
We were able to resolve this issue by removing the property, saving the extract, adding the property again, and saving again. DDL then generated without error.