Close popover
Brett Allen (BrettAllen)
Principal Technical Architect
Pegasystems Inc.
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,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.