ACS7.2 bootstrap issues

prakashpatel87 — Thu, 23 Jun 2022 20:06:11 GMT

I am upgrading to ACS7.2 from 5.2. I have created a new db for alfresco 7.2. When I start vanilla ACS7.2 it fails saying "Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'alf_audit_model'".

I checked db and 'alf_audit_model' doesnt exist. I studied alfresco-repository code and there is db-schema-context.xml that is infact having scripts to create alf_audit_model and other tables. How do I make alfresco execute so it creates all tables and completes bootstrap?

I have db.schema.update=true in global properties.

Re: ACS7.2 bootstrap issues

14bce127 — Mon, 18 Jul 2022 11:52:22 GMT

Please verify that DB has enough elivated right to do Create the table

Also if you are trying in Dev env you can copy the create alf_audit_model query and try to execute it manually with the same user which is provided in alfresco global properties file , just to verify the user you are using have enough access to create table

topic ACS7.2 bootstrap issues in Alfresco Forum

ACS7.2 bootstrap issues

Re: ACS7.2 bootstrap issues