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.

jordan.moises-user8678781

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 Akker

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

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

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

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

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 Akker

Oh, Nice! Good Job!

Martien van den Akker

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