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 ?
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.
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.wrapper.PoolConnection_org_apache_derby_client_net_NetConnection@572]
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?
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
Oracle JDeveloper 12c 126.96.36.199.0
Studio Edition Version 188.8.131.52.0
IDE Version: 184.108.40.206.42.170820.0914
Product ID: oracle.jdeveloper
Product Version: 220.127.116.11.42.170820.0914
Oracle IDE 18.104.22.168.42.170820.0914
Java(TM) Platform 1.8.0_131
Versioning Support 22.214.171.124.42.170820.0914
SOA Composite Editor 126.96.36.199.0.25.57
BPMN Editor 12.1.3.00.00
Service Bus JDeveloper IDE Extensions 188.8.131.52.0.170820.1705
Any help is appreciated.
1 person found this helpful
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.
Oh, Nice! Good Job!
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 184.108.40.206: Exception when deploying BPM project with Human tasks