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

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

beringsea — Fri, 16 Feb 2018 16:26:29 GMT

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.Dat

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

beringsea — Fri, 16 Feb 2018 17:55:54 GMT

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?

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

ryandawson — Mon, 19 Feb 2018 14:53:17 GMT

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 .

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

beringsea — Wed, 21 Feb 2018 02:49:23 GMT

Thank you.