Salve,
ho creato un workflow di esempio usando la versione 2 del sw con tws 4.4, il wf deve chiamare la funzione postgres:
CREATE OR REPLACE FUNCTION protocolloab(OUT protocollo bigint)
RETURNS bigint AS
$BODY$
BEGIN
select nextval('abcomissit') into "protocollo" ;
END
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;
ALTER FUNCTION protocolloab()
OWNER TO postgres;
nella quale in protocollo viene salvato il valore incrementato di una sequenza.
nel wf ho creato un task nel quale
richiamo la store procedure postgresql con il metodo call.Function
proto=
cmdb,callFunction("protocolloab")
.execute()
ProtocolloAB=proto.get("protocollo")
l'secuzione però si interrompe con un errore:
arget exception: javax.xml.ws.soap.SOAPFaultException: Fault occurred while processing.
at bsh.BSHPrimarySuffix.doName(Unknown Source)
at bsh.BSHPrimarySuffix.doSuffix(Unknown Source)
at bsh.BSHPrimaryExpression.eval(Unknown Source)
at bsh.BSHPrimaryExpression.eval(Unknown Source)
at bsh.BSHAssignment.eval(Unknown Source)
at bsh.Interpreter.eval(Unknown Source)
at bsh.Interpreter.eval(Unknown Source)
...
at java.lang.Thread.run(Thread.java:722)
Caused by: Sourced file: eval stream : Method Invocation execute : at Line: 2 : in file: eval stream : .execute ( )
Target exception: javax.xml.ws.soap.SOAPFaultException: Fault occurred while processing.
at bsh.BSHPrimarySuffix.doName(Unknown Source)
at bsh.BSHPrimarySuffix.doSuffix(Unknown Source)
at bsh.BSHPrimaryExpression.eval(Unknown Source)
at bsh.BSHPrimaryExpression.eval(Unknown Source)
at bsh.BSHAssignment.eval(Unknown Source)
at bsh.Interpreter.eval(Unknown Source)
at bsh.Interpreter.eval(Unknown Source)
... 51 more
2013-10-16 06:35:16,883: Activity[Process Id=1012_Package_comitato_Process_comitato, Id=960_1012_Package_comitato_Process_comitato_Process_comitato_act3, ba=null, ActDefId=Process_comitato_act3] - failed to execute script [type=text/java,value=proto=cmdb.callFunction("protocolloab")
.execute();
ProtocolloAB=proto.get("protocollo");]: org.enhydra.shark.api.internal.toolagent.ToolAgentGeneralException: Sourced file: eval stream : Method Invocation execute
2013-10-16 06:35:16,883: activity 'Process_comitato_act3' closed
2013-10-16 06:35:16,883: Process[key=1012_Package_comitato_Process_comitato,mgrname=Package_comitato#14#Process_comitato] - Activity[Process Id=1012_Package_comitato_Process_comitato, Id=960_1012_Package_comitato_Process_comitato_Process_comitato_act3, ba=null, ActDefId=Process_comitato_act3] is terminated.
sapreset consigliarmi cosa guardare