7 Replies Latest reply on Dec 18, 2017 10:27 AM by Martien van den Akker

    Error while deploying any workflow using bpm studio 12.2.1.3.0

    3576796

      Hi, deployment failed when trying to deploy helloworldbpm application.
      And the log trace below:

      Caused By: oracle.fabric.common.FabricException: Error occurred during deployment of component: RequestHolidayTask to service engine: implementation.workflow, for composite: HolidayRequestProcess: ORABPEL-30257

       

      exception.code:30257

      exception.type: ERROR

      exception.severity: 2

      exception.name: Error while Querying workflow task metadata.

      exception.description: Error while Querying workflow task metadata.

      exception.fix: Check the underlying exception and the database connection information.  If the error persists, contact Oracle Support Services.

      : exception.code:30257

      exception.type: ERROR

      exception.severity: 2

      exception.name: Error while Querying workflow task metadata.

      exception.description: Error while Querying workflow task metadata.

      exception.fix: Check the underlying exception and the database connection information.  If the error persists, contact Oracle Support Services.

       

      Caused By: oracle.fabric.common.FabricDeploymentException: ORABPEL-30257

       

       

      Caused By: java.sql.SQLSyntaxErrorException: Column 'WFTM.PACKAGENAME' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'WFTM.PACKAGENAME' is not a column in the target table.