Question8Replies679Views DyanG412 Member since 2013 212 posts Hawaii Medical Service Association Posted: February 23, 2016Last activity: August 22, 2016 Closed Solved How to resolved 'To table field length error in BIX extract rule ' while choosing output format as Database SchemaWhile attempting to save a BIX extract rule for output format in database schema, I got above error, please advise. Data Integration Reporting ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post 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. Posted: 4 years agoEllisDean PEGA replied to DyanG412Greetings,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://pdn.pega.com/documents/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 Posted: 4 years agoDyanG412 Hawaii Medical Service Association replied to EllisDeanGreetings Dean,I planning to use the extractwithaurg activity to generate the database schema? will it work or not? Posted: 4 years agonistr PEGA replied to DyanG412Yes it will work with pxExtractDataWithArgs activity when used with -X option. Accepted Solution Posted: 4 years agoCelesteDufresne_GCS PEGA replied to DyanG412There 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. Posted: 4 years agoKumar Infosys replied to DyanG412 .pyName: ** 'To Table' field length of "PBOCRecord" cannot be more than 30 characters .pyName: ** 'To Table' field length of "ProcessIDList" cannot be more than 30 characters .pyName: ** 'To Table' field length of "WOReason" cannot be more than 30 characters All these names of the table associated is less than 30 characters, while check-in error is coming. Please let me know how to resolve this. Posted: 4 years agonistr PEGA replied to KumarPlease share the screenshot on the value of the "To Table" field for these properties to understand the issue better. Posted: 4 years agoKumar Infosys replied to DyanG412Hi 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://pdn.pega.com/support-articles/pyname-property-limited-30-characters-bix#comment-363866 Thanks Posted: 4 years agonistr PEGA replied to KumarPlease request for HFIX-23185 to fix this issue in Pega 7.1.8. The fix exists from 7.1.9 onwards.