Posted: 9 Mar 2018 18:25 EST Last activity: 14 Mar 2018 16:18 EDT
BIX schema generation error
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?