Skip to main content
K
kishoren0003
September 14, 2021
Question

PostGre SQL Data fetching issue

  • September 14, 2021
  • 9 replies
  • 0 views

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
    September 14, 2021

    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.

    K
    kishoren0003Author
    September 14, 2021

    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