AnsweredAssumed Answered

Failed to start activiti-admin with oracle database due to an error 'ORA-00904: "SERVERCONF0_"."PASSWORD": invalid identifier'

Question asked by beringsea on Feb 16, 2018
Latest reply on Feb 21, 2018 by beringsea

I am new to Activiti. I have installed and run the db script in two oracle schemas: one for activiti-admin, the other for activiti-app. Activiti-app is running fine, but activiti-admin failed to start because of the following error. Please help. Thanks.

 

11:13:31,190 [main] DEBUG com.activiti.conf.DatabaseConfiguration  - Configuring Liquibase
11:13:32,408 [main] DEBUG com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool  - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@749a2cc4] on CHECKOUT.
11:13:32,424 [main] DEBUG com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool  - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@749a2cc4] on CHECKOUT has SUCCEEDED.
11:13:34,018 [C3P0PooledConnectionPoolManager[identityToken->2ym9xt9t18849bx17stx9u|23202c31]-HelperThread-#1] DEBUG com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool  - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@749a2cc4] on CHECKIN.
11:13:34,033 [C3P0PooledConnectionPoolManager[identityToken->2ym9xt9t18849bx17stx9u|23202c31]-HelperThread-#1] DEBUG com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool  - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@749a2cc4] on CHECKIN has SUCCEEDED.
11:13:34,127 [main] INFO  com.activiti.domain.generator.MinimalDataGenerator  - Verifying if minimal data is present
11:13:34,158 [main] DEBUG com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool  - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@749a2cc4] on CHECKOUT.
11:13:34,158 [main] DEBUG com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool  - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@749a2cc4] on CHECKOUT has SUCCEEDED.
11:13:34,674 [main] DEBUG com.mchange.v2.c3p0.impl.NewPooledConnection  - com.mchange.v2.c3p0.impl.NewPooledConnection@749a2cc4 handling a throwable.
java.sql.SQLSyntaxErrorException: ORA-00904: "SERVERCONF0_"."PASSWORD": invalid identifier

 

Outcomes