Support Article
WSDL import fails with an SQL exception
Summary
User imports a WSDL file for updating some changes in one of the existing SOAP Connectors. The WSDL import fails with an SQL exception.
Error Messages
Caused by:
com.pega.pegarules.pub.PRRuntimeException: caught db exception: There was a problem getting a list: code: -302 SQLState: 22001 Message: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=127.0.0.1
at com.pega.pegarules.data.internal.dictionary.PropertyInfoConclusionImpl._initialize(PropertyInfoConclusionImpl.java:964)
at com.pega.pegarules.data.internal.dictionary.PropertyInfoConclusionImpl.initialize(PropertyInfoConclusionImpl.java:919)
at com.pega.pegarules.exec.internal.basic.dictionary.ConclusionCacheImpl.getOrCreate(ConclusionCacheImpl.java:933)
at com.pega.pegarules.exec.internal.basic.dictionary.ConclusionCacheImpl.getOrCreate(ConclusionCacheImpl.java:971)
at com.pega.pegarules.data.internal.dictionary.DictionaryCacheImpl.getPropertyInfoConclusion(DictionaryCacheImpl.java:274)
at com.pega.pegarules.data.internal.clipboard.DirectStreamEncoder$PageSection.addProperty(DirectStreamEncoder.java:903)
at com.pega.pegarules.data.internal.clipboard.DirectStreamEncoder$PageSection.addPage(DirectStreamEncoder.java:678)
at com.pega.pegarules.data.internal.clipboard.DirectStreamEncoder$PageSection.addProperty(DirectStreamEncoder.java:968)
at com.pega.pegarules.data.internal.clipboard.DirectStreamEncoder$PageSection.addPage(DirectStreamEncoder.java:678)
at com.pega.pegarules.data.internal.clipboard.DirectStreamEncoder.encode(DirectStreamEncoder.java:301)
at com.pega.pegarules.data.internal.clipboard.StorageStreamCommonImpl.encode(StorageStreamCommonImpl.java:759)
at com.pega.pegarules.data.internal.clipboard.StorageStreamCommonImpl.encode(StorageStreamCommonImpl.java:728)
at com.pega.pegarules.data.internal.clipboard.ClipboardPageImpl.getStreamForm(ClipboardPageImpl.java:2838)
at com.pega.pegarules.data.internal.access.PageDatabaseMapperImpl.getStreamFormOfPage(PageDatabaseMapperImpl.java:1263)
at com.pega.pegarules.data.internal.access.DatabaseImpl.preprocessInstancesBeforeCriticalCommitSection(DatabaseImpl.java:3217)
Steps to Reproduce
Root Cause
A third-party product issue. The issue stems from code that attempts to select a column on the PR4_RULE_PROPERTY table. The host variable is too long for the column width. Hence, DB2 causes the error.
Resolution
Perform the following local-change:
- Alter the PR4_RULE_PROPERTY database table to increase the size of the PXINSID column (to 255 in this case) to be large enough to accomodate the host variable that is used.
- Consult the database administrator
- Back up the PegaRULES database as per the requirement
- Run the Alter statement
ALTER TABLE PRPC.PR4_RULE_PROPERTY ALTER COLUMN PXINSID SET DATA TYPE VARCHAR(255)
Published January 28, 2020 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.