BIX - Save an Extract rule fails with table name error
SummaryWhen doing a Save on an Extract rule that has the output format of Database Schema, it fails with the below error.
Error MessagesSeveral in the form of:
.pyName: ** 'To Table’ field length of "TestPeriodRangeValues" cannot be more than 30 characters
Steps to ReproduceTry to save an Extract rule.
Root CauseThis issue was determined to be a product enhancement request.
The product is behaving as designed and an edit of the table names generated must be done.
When extracting to a database, Business Intelligence Exchange (BIX) automatically normalizes the data, storing the top-level properties of a class in one table and data embedded page lists and page groups in separate tables. The default generation of the table name for an embedded page list or page group property is a combination of the based on class name and the property name.
In this example, the based on class for this extract is PegaSampleTest and TestPeriodRangeValues is a page list property.
The default generated table name is PegaSampleTest_TestPeriodRangeValues which is greater than the 30 character limit for the database table name.
An enhancement request, FDBK-17848, has been created for consideration by Pega Product Management.
The request is to generate default names that comply with the 30 character limit.
Published December 29, 2016 - Updated January 11, 2017