postgres loopback connector throws error when used in ibm App connect

[venkatachalam-visvan]

hi

we get the below error with the Postgresql loopback connector. Appreciate any insight and help.

JavaScript exception 'Uncaught AssertionError: all() must be implemented by the connector' was caught in module 'assert.js' at line '394', offset '4'-'5'. Stack: AssertionError [ERR_ASSERTION]: all() must be implemented by the connector

Detailed error
2022-09-06 13:03:42.767024 1656 UserTrace BIP13055I: The LoopBackRequest connector for data source 'postgres' is about to perform the 'Retrieve' operation on object 'retries'.
2022-09-06 13:03:42.767672 11544 UserTrace BIP2231E: Error detected whilst processing a message in node 'Retrieve_Retry_Records.Loop Back Request2'.
The integration node detected an error whilst processing a message in node 'Retrieve_Retry_Records.Loop Back Request2'. The message has been augmented with an exception list and has been propagated to the node's failure terminal for further processing.
See the following messages for details of the error.
2022-09-06 13:03:42.767728 11544 UserTrace BIP3865E: A JavaScript exception 'Uncaught AssertionError: all() must be implemented by the connector' was caught in module 'assert.js' at line '394', offset '4'-'5'. Stack: AssertionError [ERR_ASSERTION]: all() must be implemented by the connector
at Function.find (C:\Program Files\IBM\ACE\12.0.5.0\server\nodejs_all\node_modules\loopback-datasource-juggler\lib\dao.js:1542:3)
at iibLBInteractionRetrieve (C:\Program Files\IBM\ACE\12.0.5.0\server\nodejs_all\node_modules@ibm-app-connect\iib-loopback-connector\src\iib-loopback-interaction-retrieve.js:361:15)
at iibCreateRequestInteraction.request (C:\Program Files\IBM\ACE\12.0.5.0\server\nodejs_all\node_modules@ibm-app-connect\iib-loopback-connector\src\iib-loopback-interaction.js:176:9).
An exception occurred while executing JavaScript module 'assert.js', which was not handled within the module and was caught by Node.js.
Use the information contained in the message to identify the cause and rectify the failure. If the problem persists, contact your IBM support center.
2022-09-06 13:03:42.767924 11544 UserTrace BIP2540I: Node 'Retrieve_Retry_Records.Log Error': Finished evaluating expression 'CURRENT_TIMESTAMP' at (, 1.3). The result was 'TIMESTAMP '2022-09-06 13:03:42.767896''.
2022-09-06 13:03:42.767972 11544 UserTrace BIP2539I: Node 'Retrieve_Retry_Records.Log Error': Evaluating expression 'Root' at (, 2.3). This resolved to 'Root'. The result was 'ROW... Root Element Type=16777216 NameSpace='' Name='Root' Value=NULL'.
2022-09-06 13:03:42.768108 11544 UserTrace BIP4067I: Message propagated to output terminal for trace node 'Retrieve_Retry_Records.Log Error'.
The trace node 'Retrieve_Retry_Records.Log Error' has received a message and is propagating it to any nodes connected to its output terminal.
No user action required.