Skip to main content
kishoren0003
Known Participant
Sep 14, 2021 12:30 PM UTC
Question

PostGre SQL Data fetching issue

Hi All,

We have a Postgre SQL DB connected to Appian system, and we are trying to fetching the data from respective table.

i created CDT, entity mapping verified & Data store published successfully. In Rule Expression, when we tried the query entity for this DSE, we are getting below error. 

Expression evaluation error at function a!queryEntity: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [AAFAssetDT2555], query: [queryentity expression], order by: [[Sort[assetpreviousstatus asc]]], filters:[null])

could you please suggest me to resolve the issue.

    9 replies

    vimals
    vimals
    Participating Frequently
    Sep 14, 2021 12:47 PM UTC

    kishoren0003,

    Error Message you shared doesn't have enough information to debug. Check your Tomcat Server Log for more information and share here?

    A possible reason could be your data store entity is not published properly.

    kishoren0003Author
    Known Participant
    Sep 14, 2021 12:58 PM UTC

    Thank you.. Vimalkumars, for responding.

    yes, i will check logs and share here to debug more. below is data store published. PFA.

    this may helps to find more. 

    Terms & ConditionsAccessibility statement