Question
Hawaii Medical Service Association
US
Last activity: 22 Aug 2016 11:11 EDT
How to resolved 'To table field length error in BIX extract rule ' while choosing output format as Database Schema
While attempting to save a BIX extract rule for output format in database schema, I got above error, please advise.
-
Like (0)
-
Share this page Facebook Twitter LinkedIn Email Copying... Copied!
Accepted Solution
Pegasystems Inc.
US
There is a database limit on the length of table names and column names. You need to modify the target table name to be shorter, usually the limit is 30 characters.
Pegasystems Inc.
US
Greetings,
Have more information? I don't see any error listed here...
It would sound like you have a destination schema that is not in sync with BIX.
You should generate the BIX Schema output and use that to create the target schema, see:
https://docs-previous.pega.com/bix-71-user-guide
-X Generate only a set schema file for the export. No data is exported.
I assume there is a mismatch?
Best Regards,
Dean
Hawaii Medical Service Association
US
Greetings Dean,
I planning to use the extractwithaurg activity to generate the database schema? will it work or not?
Pegasystems
IN
Yes it will work with pxExtractDataWithArgs activity when used with -X option.
Accepted Solution
Pegasystems Inc.
US
There is a database limit on the length of table names and column names. You need to modify the target table name to be shorter, usually the limit is 30 characters.
DPIE
AU
Pegasystems
IN
Please share the screenshot on the value of the "To Table" field for these properties to understand the issue better.
DPIE
AU
Hi Rajiv,
Please refer the screenshot and help me to resolve this issue.
Pega Version- Pega 7.1.8
Framework -CPM 7.1.3
FYI, I went through a PDN link where it appears the issue is similar
https://community.pega.com/support/support-articles/pyname-property-limited-30-characters-bix
Thanks
Pegasystems
IN
Please request for HFIX-23185 to fix this issue in Pega 7.1.8. The fix exists from 7.1.9 onwards.