nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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

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

Find more posts tagged with

Alfresco Process Services

Comments

beringsea

I found both USER_INFO and SERVRE_CONFIG tables have a column "password". After I changed the column name to "PASSWORD", the 'ORA-00904: "SERVERCONF0_"."PASSWORD": invalid identifier' error was gone. I am curious to know why the column name "password" has all lower-case character, while other column names have all upper-case characters. Is this a liquibase problem with oracle dialect?

ryandawson

I presume that the problem is that 'password' is a reserved word in oracle. I am not sure why changing the case resolved it but I think it has something to do with How do I escape a reserved word in Oracle? - Stack Overflow . Some tables use a prefix before the column name for the password Activiti/db-changelog.xml at 6.x · Activiti/Activiti · GitHub but that one doesn't Activiti/db-changelog.xml at 6.x · Activiti/Activiti · GitHub .

beringsea

Thank you.