Support Article
Unable to map a data table to an external database
SA-568
Summary
Unable to map an external database table to a data table within PRPC.
Error Messages
Cannot perform a list on an External table with no selection criteria.: code: SQLState: Message: "
2014-08-11 11:25:53,211 [TABTHREAD0] [ ] ( internal.mgmt.Executable) ERROR <site, user> - Exceptioncom.pega.pegarules.pub.PRRuntimeException: PRRuntimeException at com.pegarules.generated.activity.ra_action_listeditor_3112fd400e3bd474b18706254caceb6b.step15_circum0(ra_action_listeditor_3112fd400e3bd474b18706254caceb6b.java:1586) at
Steps to Reproduce
- Create another database instance.
- Create a table with a few columns like ID, Name, Desc, and so on.
- Try to map a data table to it using Data Model - Data Tables - Data Tables.
Root Cause
A defect in Pegasystems’ code or rules. There are missing table details in a final rule.
Resolution
This issue is resolved in Pega 7.1.7.
Published December 7, 2016 - 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.