Forum Stats

  • 3,824,920 Users
  • 2,260,440 Discussions
  • 7,896,347 Comments

Discussions

Error while deploying any workflow using bpm studio 12.2.1.3.0

3576796
3576796 Member Posts: 3

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.

Martien van den Akker3576796Prakash Chavan

Best Answer

  • jordan.moises-user8678781
    jordan.moises-user8678781 Member Posts: 16
    edited Nov 30, 2017 11:17AM Answer ✓

    I already managed to fix the error.

    It seems that the "WFTASKMETADATA" table is missing the "PACKAGENAME" field, it was not an alias problem as it believed, since it did not fail with the other fields.

    It is solved like this:

    1) Run the Jdeveloper

    2) Start the IntegratedWebLogicServer

    3) With some client for derby db (I used squirrel is graphic, you can also use ij that comes with the derby); connect to localhost (if you are on that same computer) (or the ip or server name) to port 1527 with the user "soainfra" password "soainfra".

    3.1) Execute the query

    ALTER TABLE SOAINFRA.WFTASKMETADATA ADD PACKAGENAME varchar (200);

    4) Deploy without problems

    Fortunately, the change DOES NOT LOSE when the IntegratedWebLogicServer restart.

    Regards

    Jordán

    Martien van den Akker35767963576796Prakash Chavan

Answers

  • Martien van den Akker
    Martien van den Akker Member Posts: 2,776 Bronze Crown
    edited Oct 30, 2017 9:44AM

    Hi,

    Apparently you're trying to do someting using the DB  adapter? Apparently you refer to a JNDI name that points to a datasource refering a database that does not know of the WFTM.PACKAGENAME. If so, which JNDI name did you use in the DB adapter config? And to which server do you try to deploy?

    Could it be that you're trying to deploy it to the Integrated weblogic with a default JNDI, like eis/DB/soademo ?

    Regards,
    Martien

  • 3576796
    3576796 Member Posts: 3
    edited Oct 30, 2017 10:59AM

    Actually i don`t use any thing related to database.. like DB adapter, just simple initiator.
    Any BPM Application i try to deploy to integrated weblogic server i face the above Error.

    I try to reinstall the Integrated weblogic server and the same problem.

  • jordan.moises-user8678781
    jordan.moises-user8678781 Member Posts: 16
    edited Nov 28, 2017 5:38PM

    I have the same problem even with a human task in soa

    They say that it is related with compat weblogic domain at development and derby

    See this post

    BPM quickstart 12.2.1.3 issue deploying workflow

  • jordan.moises-user8678781
    jordan.moises-user8678781 Member Posts: 16
    edited Nov 29, 2017 6:38PM

    Sorry but the other thread is not exactly the same.

    I ran the weblogic in debug mode for everything related to JDBC and I got the following error

    <Nov 29, 2017 8: 03: 20,379 PM ART> <Debug> <JDBCSQL> <BEA-000000> <[weblogic.jdbc.w[email protected]572]

    prepareStatement (

    SELECT wftm.id, wftm.uri, wftm.name, wftm.title, wftm.description, wftm.domainId, wftm.processName, wftm.processId, wftm.processVersion,

    wftm.componentName, wftm.compositeDN, wftm.compositeName, wftm.compositeVersion, wftm.applicationName, wftm.namespace, wftm.organizationalUnitId,

    wftm.descriptionKey, wftm.category, wftm.packageName

    FROM WFTaskMetadata wftm WHERE wftm.id LIKE?

    )

    throws 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.

    With which it seems that he does not understand that wftm is the alias for the WFTaskMetadata table.

    Information about Jdeveloper

    About

    -----

    Oracle JDeveloper 12c 12.2.1.3.0

    Studio Edition Version 12.2.1.3.0

    Build JDEVADF_12.2.1.PATCHSETS_GENERIC_170820.0914.S

    IDE Version: 12.2.1.3.42.170820.0914

    Product ID: oracle.jdeveloper

    Product Version: 12.2.1.3.42.170820.0914

    Version

    -------

    Component Version

    ========= =======

    Oracle IDE 12.2.1.3.42.170820.0914

    Java(TM) Platform 1.8.0_131

    Versioning Support 12.2.1.3.42.170820.0914

    SOA Composite Editor 12.2.1.3.0.25.57

    BPMN Editor 12.1.3.00.00

    Service Bus JDeveloper IDE Extensions 12.2.1.3.0.170820.1705

    Any help is appreciated.

    Regards

    Jordán

  • jordan.moises-user8678781
    jordan.moises-user8678781 Member Posts: 16
    edited Nov 30, 2017 11:17AM Answer ✓

    I already managed to fix the error.

    It seems that the "WFTASKMETADATA" table is missing the "PACKAGENAME" field, it was not an alias problem as it believed, since it did not fail with the other fields.

    It is solved like this:

    1) Run the Jdeveloper

    2) Start the IntegratedWebLogicServer

    3) With some client for derby db (I used squirrel is graphic, you can also use ij that comes with the derby); connect to localhost (if you are on that same computer) (or the ip or server name) to port 1527 with the user "soainfra" password "soainfra".

    3.1) Execute the query

    ALTER TABLE SOAINFRA.WFTASKMETADATA ADD PACKAGENAME varchar (200);

    4) Deploy without problems

    Fortunately, the change DOES NOT LOSE when the IntegratedWebLogicServer restart.

    Regards

    Jordán

    Martien van den Akker35767963576796Prakash Chavan
  • Martien van den Akker
    Martien van den Akker Member Posts: 2,776 Bronze Crown
    edited Dec 12, 2017 11:09AM

    Oh, Nice! Good Job!

  • Martien van den Akker
    Martien van den Akker Member Posts: 2,776 Bronze Crown
    edited Dec 18, 2017 5:27AM

    Again, thanks for the great tip. (Saved my BPM Training on this point) By the way, you can do the change as easily from JDeveloper itself: Darwin-IT: BPM 12.2.1.3: Exception when deploying BPM project with Human tasks

    Regards,
    Martien

    3576796
This discussion has been closed.