Support Article
Unable to add a new row in a data table
SA-56652
Summary
Unable to add a new row in a data table.
Error Messages
Not returning connection 9 for database "pegadata" to the pool as it previously encountered the following error User ID: nm34617 Last SQL: SELECT data.pr_read_from_stream('.MHUID', "PC0".pzInsKey, "PC0".pzPVStream) AS "MHUID" , data.pr_read_from_stream('.TargetDealerID', "PC0".pzInsKey, "PC0".pzPVStream) AS "TargetDealerID" , data.pr_read_from_stream('.TargetDealer', "PC0".pzInsKey, "PC0".pzPVStream) AS "TargetDealer" , data.pr_read_from_stream('.DealerEmailID', "PC0".pzInsKey, "PC0".pzPVStream) AS "DealerEmailID" , "PC0"."pzinskey" AS "pzInsKey" FROM data.pr_other "PC0" WHERE "PC0"."pxobjclass" = ? ORDER BY 1 ASC org.postgresql.util.PSQLException: ERROR: function data.pr_read_from_stream(unknown, character varying, bytea) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 8 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2412) ~[postgresql-driver-42.0.0.jar:42.0.0] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2125) ~[postgresql-driver-42.0.0.jar:42.0.0] at
Steps to Reproduce
- Select any data table
- Map the data table class to pr_other table
- Add a row to the data table
- Refresh the data table
Root Cause
An issue in the custom application code or rules. Columns are not exposed in pr_other table.
Resolution
Perform the following local-change:Expose the columns in the pr_other table to display the data.
Published July 23, 2018 - 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.