Workflow Action Error

We’ve created a new copy of the Simple Workflow. We’re trying to add a new Transition using the ‘sys_createTranslations’ Workflow Action. When we test the changes, we get the following error messages:

Processing Error: Request preprocessing
ID Message
0 An error occurred while pre-processing the request submitted by the host (-not available-).
1 An exception occurred while processing the “Java/global/percussion/workflow/sys_wfPerformTransition” extension: com.percussion.workflow.PSEntryNotFoundException: No records were found…

Any ides what may be causing this?

Thanks!

This error is caused when the performTransition exit doesn’t find an entry in the database, usually for the user, community, or locale. A stack trace would tell us more. What’s in the server’s log file?

We’ve searched the \Rhythmyx\AppServer\server\rx\log\server.log file and did not find anything regarding the error message below. Should we be looking within a different log file? We’ve also searched the contents of all files and did not find the string “com.percussion.workflow.PSEntryNotFoundException” in any files under the Percussion install directories.

No, that’s the correct file.

I’ll go look and see if there’s some way to force it to output a stack trace. What version is this? 6.5?

Dave

We’re on 6.5.1.

In /Rhythmyx/rxconfig/Workflow/rxworkflow.properties, add the lines:

PSCONSOLETRACEMESSAGES=TRUE
PSCONSOLESTACKTRACE=TRUE

You will need to restart the server, but once you do, any new workflow errors will be written the system console. They should appear in both console.out and system.log.

Let me know what you find

Dave

Here’s the output from the server.log file:

2007-11-20 11:26:59,266 INFO [Workflow]
Authenticate User enter preProcessRequest…
2007-11-20 11:26:59,282 INFO [Workflow] Entering authenticateUser
2007-11-20 11:26:59,298 INFO [Workflow] User is Admin, done.
Exiting authenticateUser
2007-11-20 11:26:59,298 INFO [Workflow] Authenticate User : exit preProcessRequest
2007-11-20 11:26:59,298 INFO [Workflow]
Perform Transition: enter preProcessRequest
2007-11-20 11:26:59,313 INFO [Workflow] Entering Method performTransition
2007-11-20 11:26:59,313 INFO [Workflow] Enter checkInOut
2007-11-20 11:26:59,313 INFO [Workflow] Perform Transition: exit preProcessRequest
2007-11-20 11:26:59,344 INFO [Workflow]
Update History: enter processResultDocument
2007-11-20 11:26:59,344 INFO [Workflow] update history: - no transition action happened - no historywill be written
2007-11-20 11:26:59,344 INFO [Workflow] Update History: exit processResultDocument
2007-11-20 11:26:59,344 INFO [Workflow]
PSExecute WorkflowActions: enter processResultDocument
2007-11-20 11:26:59,344 INFO [Workflow] No workflow actions.
PSExecute WorkflowActions: exit processResultDocument
2007-11-20 11:26:59,360 INFO [Workflow]
Notify Assignees: enter processResultDocument
2007-11-20 11:26:59,360 INFO [Workflow] Notify assignees: - no transition was performed - no notifications will be sent
2007-11-20 11:26:59,360 INFO [Workflow] Notify Assignees: exit processResultDocument
2007-11-20 11:26:59,407 INFO [Workflow]
Authenticate User enter preProcessRequest…
2007-11-20 11:26:59,407 INFO [Workflow] Entering authenticateUser
2007-11-20 11:26:59,407 INFO [Workflow] User is Admin, done.
Exiting authenticateUser
2007-11-20 11:26:59,407 INFO [Workflow] Authenticate User : exit preProcessRequest
2007-11-20 11:26:59,610 INFO [Workflow]
Add Possible Transitions: enter processResultDocument
2007-11-20 11:26:59,626 INFO [Workflow] Entering method addWorkflowInfo
2007-11-20 11:26:59,688 INFO [PSServerLogHandler] appid: 0 type: 1 time: Tue Nov 20 11:26:59 PST 2007 msg: An internal error (end-condition) was encountered. An unexpected exception occurred:
An unexpected exception occurred. The reason was: No records were found… Please consult the log for further information…
The call-stack was:
com.percussion.workflow.PSEntryNotFoundException: No records were found.
at com.percussion.workflow.PSStateRolesContext.<init>(Unknown Source)
at com.percussion.workflow.PSExitAddPossibleTransitionsEx.addAssignedRolesInfo(Unknown Source)
at com.percussion.workflow.PSExitAddPossibleTransitionsEx.addActions(Unknown Source)
at com.percussion.workflow.PSExitAddPossibleTransitionsEx.addWorkflowInfo(Unknown Source)
at com.percussion.workflow.PSExitAddPossibleTransitionsEx.processResultDocument(Unknown Source)
at com.percussion.data.PSExtensionRunner.processResultDoc(Unknown Source)
at com.percussion.data.xb.runPostProcessingExtensions(Unknown Source)
at com.percussion.data.xb.runPostProcessingExtensions(Unknown Source)
at com.percussion.cms.handlers.PSQueryCommandHandler.o00000(Unknown Source)
at com.percussion.cms.handlers.PSQueryCommandHandler.makeInternalRequestEx(Unknown Source)
at com.percussion.cms.handlers.PSContentEditorHandler.makeInternalRequest(Unknown Source)
at com.percussion.cms.handlers.PSWorkflowCommandHandler$ItemValidator.o00000(Unknown Source)
at com.percussion.cms.handlers.PSWorkflowCommandHandler$ItemValidator.<init>(Unknown Source)
at com.percussion.cms.handlers.PSWorkflowCommandHandler.processRequest(Unknown Source)
at com.percussion.cms.handlers.PSContentEditorHandler.processRequest(Unknown Source)
at com.percussion.server.PSApplicationHandler.processRequest(Unknown Source)
at com.percussion.servlets.PSAppServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.percussion.webdav.PSWebDavRequestFilter.doFilter(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.percussion.servlets.PSSecurityFilter.doFilter(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Unknown Source)

2007-11-20 11:26:59,688 ERROR [Workflow] An unexpected exception occurred. The reason was: No records were found… Please consult the log for further information.

It’s not finding any entries in the STATEROLES table for the specific Workflow state of that item.

Although the user is an “Admin” (and therefore passes all of the access tests), you still need to assign some roles to the State, or this error will occur.

I hope this helps

Dave

We added the Role to the new State but then got the following error:

Processing Error: Back end query
ID Message
0 An error occurred processing the query submitted by session id ba8a7dc37e566c1b13ad4fc2236ce6571e4d0d8b.
1 Failed to clone (or create a new copy of) Content Item (id=1517,
revision=1) since Content Type Id, ‘311’, is not visible by Community Id, ‘1023’. 2 workflow

Once we made sure both the Workflow and Content Type was assigned to all of the Translation Communities, everything worked fine.

Thanks for the support!
Jay