5 Replies Latest reply on Apr 26, 2017 11:34 AM by dmarrazzo

Problem starting JBPM Suite 6.5.0 on WAS

f.gazzo Apr 19, 2017 3:08 AM

Hi all,

i've installed the 6.4.0 on my WAS but during the starting opereations i see an "TABLE OR VIEW DOES NOT EXIXTS" error in my log.

I'm using an Oracle 11 xe Database and i've installed the DDL downloaded with the Supplementary Tolls to this URL: Red Hat JBoss BPM Suite Download | Red Hat Developers.

Can someone help me with this issue?

Thanks in advance,

Federico

1. Re: Problem starting JBPM Suite 6.5.0 on WAS

dmarrazzo Apr 24, 2017 10:38 AM (in response to f.gazzo)

Hi,
Double check the following procedure:

https://access.redhat.com/documentation/en-us/red_hat_jboss_bpm_suite/6.4/html/ibm_websphere_installation_and_configurat…

For some reason you are pointing to a wrong DB or using wrong credentials.
Actions
2. Re: Problem starting JBPM Suite 6.5.0 on WAS

f.gazzo Apr 26, 2017 3:41 AM (in response to dmarrazzo)

Hi,

thanks for your support, i've checked the procedure again and i've tested the connection from the Admin Console and it works correctly.
It seems not be a connection error.
Any other ideas?

Thanks
Actions
3. Re: Problem starting JBPM Suite 6.5.0 on WAS

dmarrazzo Apr 26, 2017 5:46 AM (in response to f.gazzo)
I would try to connect to the DB using a java client (i.e. Squirrel) with the same driver and the same credentials.
Check whether:
you can see the table
you can insert/delete rows.
Actions
4. Re: Problem starting JBPM Suite 6.5.0 on WAS

f.gazzo Apr 26, 2017 10:29 AM (in response to dmarrazzo)

Yes, i'm logged on the DB using a SQLDeveloper and i see the tables.
Actions
5. Re: Problem starting JBPM Suite 6.5.0 on WAS

dmarrazzo Apr 26, 2017 11:34 AM (in response to f.gazzo)

In this way you are not sure that you are using exactly the same driver and same credentials.
Double check the credentials: if I recall correctly they are configured as JAAS alias in WAS.
Anyway
Option 2: raise the JDBC logs level to TRACE
Option 3: write a servlet and place it in the same war to inquire the DB
Actions

Go to original post