CMDBuild Forum

TWE e Workflow

Old Versions
#1

L'esecuzione di un workflow costruito per il CMDBuild da l'errore

 

org.cmdbuild.workflow.CMWorkflowException: org.cmdbuild.workflow.CMWorkflowException:
java.lang.Exception: Process 504_Package_processodiprova_Process_processodiprova does not exist
    at org.cmdbuild.workflow.service.AbstractSharkService.advanceActivityInstance(AbstractSharkService.java:433)
    at org.cmdbuild.workflow.service.TransactedSharkService.access$1301(TransactedSharkService.java:16)
    at org.cmdbuild.workflow.service.TransactedSharkService$13.command(TransactedSharkService.java:225)
    at org.cmdbuild.workflow.service.TransactedSharkService$13.command(TransactedSharkService.java:222)
    at org.cmdbuild.workflow.service.TransactedSharkService$TransactedExecutor.execute(TransactedSharkService.java:24)
    at org.cmdbuild.workflow.service.TransactedSharkService.advanceActivityInstance(TransactedSharkService.java:222)
    at org.cmdbuild.workflow.WorkflowEngineWrapper.advanceActivity(WorkflowEngineWrapper.java:250)
    at org.cmdbuild.logic.WorkflowLogic.updateActivity(WorkflowLogic.java:266)
    at org.cmdbuild.logic.WorkflowLogic.updateProcess(WorkflowLogic.java:224)
    at org.cmdbuild.logic.WorkflowLogic.updateProcess(WorkflowLogic.java:212)
    at org.cmdbuild.servlets.json.Workflow.saveActivity(Workflow.java:170)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.cmdbuild.servlets.JSONDispatcher.dispatch(JSONDispatcher.java:94)
    at org.cmdbuild.servlets.JSONDispatcher.doPost(JSONDispatcher.java:55)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.cmdbuild.filters.AuthFilter.doFilter(AuthFilter.java:54)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.cmdbuild.filters.PatchManagerFilter.doFilter(PatchManagerFilter.java:28)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.cmdbuild.filters.ConfCheckFilter.doFilter(ConfCheckFilter.java:31)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.cmdbuild.filters.TranslationFilter.doFilter(TranslationFilter.java:37)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
    at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1822)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
Caused by: org.cmdbuild.workflow.CMWorkflowException: java.lang.Exception: Process 504_Package_processodiprova_Process_processodiprova does not exist
    at org.cmdbuild.workflow.service.AbstractSharkService.getProcessInstanceVariables(AbstractSharkService.java:338)
    at org.cmdbuild.workflow.service.TransactedSharkService.access$801(TransactedSharkService.java:16)
    at org.cmdbuild.workflow.service.TransactedSharkService$8.command(TransactedSharkService.java:171)
    at org.cmdbuild.workflow.service.TransactedSharkService$8.command(TransactedSharkService.java:168)
    at org.cmdbuild.workflow.service.TransactedSharkService$TransactedExecutor.execute(TransactedSharkService.java:24)
    at org.cmdbuild.workflow.service.TransactedSharkService.getProcessInstanceVariables(TransactedSharkService.java:168)
    at org.cmdbuild.workflow.LegacyWorkflowPersistence.syncProcessStateActivitiesAndMaybeVariables(LegacyWorkflowPersistence.java:66)
    at org.cmdbuild.workflow.LegacyWorkflowPersistence.syncProcessStateActivitiesAndVariables(LegacyWorkflowPersistence.java:52)
    at org.cmdbuild.workflow.WorkflowEventManagerImpl.processEvents(WorkflowEventManagerImpl.java:90)
    at org.cmdbuild.workflow.UpdateOperationListenerImpl.activityInstanceAdvanced(UpdateOperationListenerImpl.java:46)
    at org.cmdbuild.workflow.service.AbstractSharkService.advanceActivityInstance(AbstractSharkService.java:430)
    ... 46 more
Caused by: java.lang.Exception: Process 504_Package_processodiprova_Process_processodiprova does not exist
    at org.apache.axis.message.SOAPFaultBuilder.createFault(SOAPFaultBuilder.java:222)
    at org.apache.axis.message.SOAPFaultBuilder.endElement(SOAPFaultBuilder.java:129)
    at org.apache.axis.encoding.DeserializationContext.endElement(DeserializationContext.java:1087)
    at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
    at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
    at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
    at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
    at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
    at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
    at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
    at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
    at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
    at org.apache.xerces.jaxp.SAXParserImpl.parse(Unknown Source)
    at org.apache.axis.encoding.DeserializationContext.parse(DeserializationContext.java:227)
    at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:696)
    at org.apache.axis.Message.getSOAPEnvelope(Message.java:435)
    at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke(MustUnderstandChecker.java:62)
    at org.apache.axis.client.AxisClient.invoke(AxisClient.java:206)
    at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
    at org.apache.axis.client.Call.invoke(Call.java:2767)
    at org.apache.axis.client.Call.invoke(Call.java:2443)
    at org.apache.axis.client.Call.invoke(Call.java:2366)
    at org.apache.axis.client.Call.invoke(Call.java:1812)
    at org.enhydra.shark.ejb.client.ws.WAPIEJBEndpointPortSoapBindingStub.listProcessInstanceAttributes(Unknown Source)
    at org.cmdbuild.workflow.service.AbstractSharkService.getProcessInstanceVariables(AbstractSharkService.java:329)
    ... 56 more

 

cosa posso guardare?

 

grazie

 

Nicola

 

#2

Salve

 

ho provato sul vostro sito di demo a caricare il processo di prova che sulla mia installazione da l'errore che avevo segnalato e meravigliosamente funziona.

Non riesco a capire come mai.

 

Potreste dirmi dove posso guardare e cosa?

 

Grazie

 

Nicola

 

Previously Nicola wrote:

L'esecuzione di un workflow costruito per il CMDBuild da l'errore

 

org.cmdbuild.workflow.CMWorkflowException: org.cmdbuild.workflow.CMWorkflowException:
java.lang.Exception: Process 504_Package_processodiprova_Process_processodiprova does not exist
    ...........

 

cosa posso guardare?

 

grazie

 

Nicola

 

 

#3

Salve

Ho abilitato il logging più approfondito ed ho estratto i messaggi che precedono l'errore:

 

DEBUG 2013-01-31 17:08:46 [jsonrpc ]     parameter "classId": 57415

DEBUG 2013-01-31 17:08:46 [jsonrpc ]     parameter "attributes": {}

DEBUG 2013-01-31 17:08:46 [jsonrpc ]     parameter "activityInstanceId": 314_603_Package_processodiprova_Process_processodiprova_Process_processodiprova_act3

DEBUG 2013-01-31 17:08:46 [jsonrpc ]     parameter "advance": true

INFO  2013-01-31 17:08:46 [workflow] processing events for session '51'

INFO  2013-01-31 17:08:46 [workflow] synchronizing process state, activities and (maybe) variables

INFO  2013-01-31 17:08:46 [workflow] synchronizing variables

DEBUG 2013-01-31 17:08:46 [jsonrpc ] Uncaught exception calling method class org.cmdbuild.servlets.json.Workflow.saveActivity

 

può essere utilie per capire il motivo?

 

Grazie

 

Previously Nicola wrote:

Salve

 

ho provato sul vostro sito di demo a caricare il processo di prova che sulla mia installazione da l'errore che avevo segnalato e meravigliosamente funziona.

Non riesco a capire come mai.

 

Potreste dirmi dove posso guardare e cosa?

 

Grazie

 

Nicola

 

Previously Nicola wrote:

L'esecuzione di un workflow costruito per il CMDBuild da l'errore

 

org.cmdbuild.workflow.CMWorkflowException: org.cmdbuild.workflow.CMWorkflowException:
java.lang.Exception: Process 504_Package_processodiprova_Process_processodiprova does not exist
    ...........

 

cosa posso guardare?

 

grazie

 

Nicola

 

 

 

#4

qualche idea dove guardare?

 

Grazie

 

Previously Nicola wrote:

Salve

 

ho provato sul vostro sito di demo a caricare il processo di prova che sulla mia installazione da l'errore che avevo segnalato e meravigliosamente funziona.

Non riesco a capire come mai.

 

Potreste dirmi dove posso guardare e cosa?

 

Grazie

 

Nicola

 

Previously Nicola wrote:

L'esecuzione di un workflow costruito per il CMDBuild da l'errore

 

org.cmdbuild.workflow.CMWorkflowException: org.cmdbuild.workflow.CMWorkflowException:
java.lang.Exception: Process 504_Package_processodiprova_Process_processodiprova does not exist
    ...........

 

cosa posso guardare?

 

grazie

 

Nicola

 

 

 

#5

Salve,

ho fatto ulteriori prove senza alcun successo il log di cmdbuild riporta:

 

DEBUG 2013-02-12 09:02:28 [sql     ] SELECT DISTINCT "Processodiprova"."User" AS "Processodiprova_User", "Processodiprova"."Description" AS "Processodiprova_Description", "Processodiprova"."BeginDate" AS "Processodiprova_BeginDate", "Processodiprova"."PrevExecutors" AS "Processodiprova_PrevExecutors", "Processodiprova"."UniqueProcessDefinition" AS "Processodiprova_UniqueProcessDefinition", "Processodiprova"."Code" AS "Processodiprova_Code", "Processodiprova"."ProcessCode" AS "Processodiprova_ProcessCode", "LookUp_FlowStatus"."Id" AS "Processodiprova_FlowStatus", "LookUp_FlowStatus"."Description" AS "Processodiprova_FlowStatus_Description", "Processodiprova"."Notes" AS "Processodiprova_Notes", "Processodiprova"."Status" AS "Processodiprova_Status", "Processodiprova"."NextExecutor" AS "Processodiprova_NextExecutor", "Processodiprova"."IndirizzoIP" AS "Processodiprova_IndirizzoIP", "Processodiprova"."ActivityDefinitionId" AS "Processodiprova_ActivityDefinitionId", "Processodiprova"."ActivityInstanceId" AS "Processodiprova_ActivityInstanceId", "Processodiprova"."Indicatore" AS "Processodiprova_Indicatore", "Processodiprova"."Id" AS "Processodiprova_Id", "Processodiprova"."Nome" AS "Processodiprova_Nome", '"Processodiprova"'::regclass::int4 AS "Processodiprova_IdClass" FROM "Processodiprova" AS "Processodiprova" LEFT JOIN "LookUp" AS "LookUp_FlowStatus" ON "LookUp_FlowStatus"."Id" = "Processodiprova"."FlowStatus" WHERE ("Processodiprova"."Id" = 549) ORDER BY "Processodiprova"."Id" ASC

DEBUG 2013-02-12 09:02:28 [sql     ] UPDATE "Processodiprova" SET "User" = 'admin' WHERE ("Processodiprova"."Id" = 549)

DEBUG 2013-02-12 09:02:28 [sql     ] SELECT  "Role"."startingClass"::int4 AS "Role_startingClass", "Role"."User" AS "Role_User", "Role"."Description" AS "Role_Description", "Role"."BeginDate" AS "Role_BeginDate", "Role"."DisabledModules" AS "Role_DisabledModules", "Role"."Administrator" AS "Role_Administrator", "Role"."ProcessWidgetAlwaysEnabled" AS "Role_ProcessWidgetAlwaysEnabled", "Role"."DisabledProcessTabs" AS "Role_DisabledProcessTabs", "Role"."Code" AS "Role_Code", "Role"."HideSidePanel" AS "Role_HideSidePanel", "Role"."Notes" AS "Role_Notes", "Role"."Status" AS "Role_Status", "Role"."SimpleHistoryModeForCard" AS "Role_SimpleHistoryModeForCard", "Role"."DisabledCardTabs" AS "Role_DisabledCardTabs", "Role"."Email" AS "Role_Email", "Role"."FullScreenMode" AS "Role_FullScreenMode", "Role"."SimpleHistoryModeForProcess" AS "Role_SimpleHistoryModeForProcess", "Role"."Id" AS "Role_Id", '"Role"'::regclass::int4 AS "Role_IdClass", "Role"."CloudAdmin" AS "Role_CloudAdmin" FROM "Role" AS "Role"  WHERE ("Role"."Code" = 'SuperUser') ORDER BY "Role"."Id" ASC

DEBUG 2013-02-12 09:02:28 [sql     ] SELECT  "User"."Notes" AS "User_Notes", "User"."User" AS "User_User", "User"."Status" AS "User_Status", "User"."Description" AS "User_Description", "User"."BeginDate" AS "User_BeginDate", "User"."Email" AS "User_Email", "User"."Password" AS "User_Password", "User"."Username" AS "User_Username", "User"."Id" AS "User_Id", "User"."Code" AS "User_Code", '"User"'::regclass::int4 AS "User_IdClass" FROM "User" AS "User"  WHERE (("User"."Username" = 'shark') AND ("User"."Status" = 'A')) ORDER BY "User"."Id" ASC

INFO  2013-02-12 09:02:28 [soap    ] event received

INFO  2013-02-12 09:02:28 [soap    ] event for process update: 139 / Process_processodiprova / 806_Package_processodiprova_Process_processodiprova

DEBUG 2013-02-12 09:02:28 [sql     ] SELECT  "User"."Notes" AS "User_Notes", "User"."User" AS "User_User", "User"."Status" AS "User_Status", "User"."Description" AS "User_Description", "User"."BeginDate" AS "User_BeginDate", "User"."Email" AS "User_Email", "User"."Password" AS "User_Password", "User"."Username" AS "User_Username", "User"."Id" AS "User_Id", "User"."Code" AS "User_Code", '"User"'::regclass::int4 AS "User_IdClass" FROM "User" AS "User"  WHERE (("User"."Username" = 'shark') AND ("User"."Status" = 'A')) ORDER BY "User"."Id" ASC

INFO  2013-02-12 09:02:28 [soap    ] event received

INFO  2013-02-12 09:02:28 [soap    ] event for process update: 139 / Process_processodiprova / 806_Package_processodiprova_Process_processodiprova

INFO  2013-02-12 09:02:28 [workflow] processing events for session '139'

DEBUG 2013-02-12 09:02:28 [sql     ] SELECT DISTINCT "Processodiprova"."User" AS "Processodiprova_User", "Processodiprova"."Description" AS "Processodiprova_Description", "Processodiprova"."BeginDate" AS "Processodiprova_BeginDate", "Processodiprova"."PrevExecutors" AS "Processodiprova_PrevExecutors", "Processodiprova"."UniqueProcessDefinition" AS "Processodiprova_UniqueProcessDefinition", "Processodiprova"."Code" AS "Processodiprova_Code", "Processodiprova"."ProcessCode" AS "Processodiprova_ProcessCode", "LookUp_FlowStatus"."Id" AS "Processodiprova_FlowStatus", "LookUp_FlowStatus"."Description" AS "Processodiprova_FlowStatus_Description", "Processodiprova"."Notes" AS "Processodiprova_Notes", "Processodiprova"."Status" AS "Processodiprova_Status", "Processodiprova"."NextExecutor" AS "Processodiprova_NextExecutor", "Processodiprova"."IndirizzoIP" AS "Processodiprova_IndirizzoIP", "Processodiprova"."ActivityDefinitionId" AS "Processodiprova_ActivityDefinitionId", "Processodiprova"."ActivityInstanceId" AS "Processodiprova_ActivityInstanceId", "Processodiprova"."Indicatore" AS "Processodiprova_Indicatore", "Processodiprova"."Id" AS "Processodiprova_Id", "Processodiprova"."Nome" AS "Processodiprova_Nome", '"Processodiprova"'::regclass::int4 AS "Processodiprova_IdClass" FROM "Processodiprova" AS "Processodiprova" LEFT JOIN "LookUp" AS "LookUp_FlowStatus" ON "LookUp_FlowStatus"."Id" = "Processodiprova"."FlowStatus" WHERE (("Processodiprova"."ProcessCode" = '806_Package_processodiprova_Process_processodiprova') AND ("Processodiprova"."Status" = 'A')) ORDER BY "Processodiprova"."Id" ASC

INFO  2013-02-12 09:02:28 [workflow] synchronizing process state, activities and (maybe) variables

INFO  2013-02-12 09:02:28 [workflow] synchronizing variables

DEBUG 2013-02-12 09:02:28 [jsonrpc ] Uncaught exception calling method class org.cmdbuild.servlets.json.Workflow.saveActivity

 

quando si genera l'errore.

 

Avete indicazioni di cosa guardare?

Unico dubbio è la versione di postgres va bene la 9.2?

 

Grazie

Nicoal

 

#6

Non so se può essere utile ma abilitando il log in debug di shark ottengo il messaggio:

 

DELETE SHKProcesses 1000939]

java.lang.Throwable: EXEC WRITE...

 at org.enhydra.dods.dbtransaction.SortingDBTransaction.write(Unknown Source)

 at org.enhydra.dods.dbtransaction.SortingDBTransaction.commit(Unknown Source)

 

 

seguito poi da

2013-02-12 15:19:17,177: SyncDBTransaction.afterCompletion 56

2013-02-12 15:19:17,177: WAPIImpl -> User shark is logged on

2013-02-12 15:19:17,187: SyncDBTransaction.constructed 57

2013-02-12 15:19:17,187: _runQuery() 4 SHKProcesses select SHKProcesses.* from SHKProcesses WHERE SHKProcesses.Id = '402_Package_processodiprova_Process_processodiprova'

2013-02-12 15:19:17,187: ...going to db... resultsFromQCache:false

2013-02-12 15:19:17,187: SyncDBTransaction.beforeCompletion 57

2013-02-12 15:19:17,187: SyncDBTransaction.afterCompletion 57

2013-02-12 15:19:17,197: WAPIImpl -> User shark is logged on

2013-02-12 15:19:17,207: WAPIImpl -> User shark is logged on

2013-02-12 15:19:17,207: SyncDBTransaction.constructed 58

2013-02-12 15:19:17,207: _runQuery() 4 SHKProcesses select SHKProcesses.* from SHKProcesses WHERE SHKProcesses.Id = '402_Package_processodiprova_Process_processodiprova'

2013-02-12 15:19:17,207: SyncDBTransaction.afterCompletion 58

2013-02-12 15:19:17,207: SyncDBTransaction.afterCompletion rolling back 58

2013-02-12 15:19:17,217: WAPIImpl -> User shark is logged on

 

suggerisce qualcosa di utile?

 

Grazie