Support Article

BIX - Save an Extract rule fails with table name error

SA-31985

Summary



When doing a Save on an Extract rule that has the output format of Database Schema, it fails with the below error.   

Error Messages



Several in the form of:
.pyName: ** 'To Table’ field length of "TestPeriodRangeValues" cannot be more than 30 characters


Steps to Reproduce



Try to save an Extract rule.


Root Cause



This 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.


Resolution



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

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.