Hello.
I try add workorders to CM and give whit error (
Generic error
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT "Number" AS _number, "PrecWO" AS _precwo, "ActivityName" AS _activityname, "ActivityDescription" AS _activitydescription, "ExecutorRole" AS _executorrole, (SELECT "Description" FROM "Role" WHERE "Id" = _wfchangemgtloadwos."ExecutorRole" AND "Status" = 'A') AS __executorrole_description, "ExpectedTime" AS _expectedtime, "FormName" AS _formname, "Condition" AS _condition, "PreScript" AS _prescript, "PostScript" AS _postscript FROM wf_changemgt_load_wos(32485) _wfchangemgtloadwos]; nested exception is org.postgresql.util.PSQLException: ERROR: structure of query does not match function result type Detail: Returned type integer does not match expected type bigint in column 1. Where: PL/pgSQL function wf_changemgt_load_wos(bigint) line 6 at RETURN QUERY, caused by: org.postgresql.util.PSQLException: ERROR: structure of query does not match function result type Detail: Returned type integer does not match expected type bigint in column 1. Where: PL/pgSQL function wf_changemgt_load_wos(bigint) line 6 at RETURN QUERY
sql exception = org.postgresql.util.PSQLException: ERROR: structure of query does not match function result type
Detail: Returned type integer does not match expected type bigint in column 1.
Where: PL/pgSQL function wf_changemgt_load_wos(bigint) line 6 at RETURN QUERY on query = SELECT "Number" AS _number, "PrecWO" AS _precwo, "ActivityName" AS _activityname, "ActivityDescription" AS
_activitydescription, "ExecutorRole" AS _executorrole, (SELECT "Description" FROM "Role" WHERE "Id" = _wfchangemgtloadwos."ExecutorRole" AND "Status" = 'A') AS __executorrole_description, "ExpectedT
ime" AS _expectedtime, "FormName" AS _formname, "Condition" AS _condition, "PreScript" AS _prescript, "PostScript" AS _postscript FROM wf_changemgt_load_wos(32485) _wfchangemgtloadwos;