BrettAllen Member since 2015 7 posts
Posted: March 9, 2018
Last activity: March 14, 2018

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?

System Administration
Moderation Team has archived post
Share this page LinkedIn