Hi All.
I get this error sometimes, if I select the class ""Server" from GUI. The values for Server are loaded by an upload script, which fills the table with values from a foreigen server table.
I copy the SQL Statement into pgadmin client and from this point of view this part
WHERE "Server"."Id" = ? AND "Server"."Status" = ?
is the problem.
Call: services/json/management/modcard/getcard ----------------------------------------------- Error: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [
SELECT
“Server#SysLocation”.“Description” AS “Server#SysLocation#Description”, “Server#SysState”.“Description” AS “Server#SysState#Description”, “Server#SysPriority”.“Description” AS “Server#SysPriority#Description”, “Server#SysDesign”.“Description” AS “Server#SysDesign#Description”, “Server#SysType”.“Description” AS “Server#SysType#Description”, “Server”.“Code” AS “Server#Code”, “Server”.“Description” AS “Server#Description”, “Server”.“Notes” AS “Server#Notes”, “Server”.“Active” AS “Server#Active”, “Server”.“Visible” AS “Server#Visible”, “Server”.“SysLocation” AS “Server#SysLocation”, “Server”.“SysState” AS “Server#SysState”, “Server”.“SysPriority” AS “Server#SysPriority”, “Server”.“SysDesign” AS “Server#SysDesign”, “Server”.“SysType” AS “Server#SysType”, “Server”.“SysInstDate” AS “Server#SysInstDate”, “Server”.“SysTaskDesc” AS “Server#SysTaskDesc”, “Server”.“SysTaskDescShort” AS “Server#SysTaskDescShort”, “Server”.“SysCompany” AS “Server#SysCompany”, “Server”.“SysContTech” AS “Server#SysContTech”, “Server”.“SysContBusiness” AS “Server#SysContBusiness”, “Server”.“SysRebootInfo” AS “Server#SysRebootInfo”, “Server”.“SysSpecInst” AS “Server#SysSpecInst”, “Server”.“IdClass”::oid AS “_Server_IdClass”, “Server”.“Id” AS “_Server_Id”, “Server”.“User” AS “_Server_User”, “Server”.“BeginDate” AS “_Server_BeginDate”
FROM “Server” AS “Server”
LEFT JOIN “OptType” AS “Server#SysType” ON “Server#SysType”.“Id” = “Server”.“SysType” AND “Server#SysType”.“Status” = ‘A’
LEFT JOIN “OptSystemState” AS “Server#SysState” ON “Server#SysState”.“Id” = “Server”.“SysState” AND “Server#SysState”.“Status” = ‘A’
LEFT JOIN “OptLocation” AS “Server#SysLocation” ON “Server#SysLocation”.“Id” = “Server”.“SysLocation” AND “Server#SysLocation”.“Status” = ‘A’
LEFT JOIN “OptDesign” AS “Server#SysDesign” ON “Server#SysDesign”.“Id” = “Server”.“SysDesign” AND “Server#SysDesign”.“Status” = ‘A’
LEFT JOIN “OptPriority” AS “Server#SysPriority” ON “Server#SysPriority”.“Id” = “Server”.“SysPriority” AND “Server#SysPriority”.“Status” = ‘A’
WHERE “Server”.“Id” = ? AND “Server”.“Status” = ?
LIMIT 1
OFFSET 0]; SQL state [0A000]; error code [0]; ERROR: cached plan must not change result type; nested exception is org.postgresql.util.PSQLException: ERROR: cached plan must not change result type
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
After reload the page I can access the Server class without any error message. Any suggestions to look deeper into the problem. Perhaps References and/or Domains?