topic Re: Ensure that the 'dir.root' property 'C:\ALFRES~4\alf_data' is pointing to the correct data location. in Alfresco Forum

Ensure that the 'dir.root' property 'C:\ALFRES~4\alf_data' is pointing to the correct data location.

kranthi — Thu, 16 Nov 2017 10:15:12 GMT

while I try to install the alfresco community 5.2 with MYSQL it is getting error like Ensure that the 'dir.root' property 'C:\ALFRES~4\alf_data' is pointing to the correct data location.2017-11-16 15:10:33,853 ERROR [repo.admin.ConfigurationChecker] [localhost-startStop-1] CONTENT INTEGRITY ERROR: S

Re: Ensure that the 'dir.root' property 'C:\ALFRES~4\alf_data' is pointing to the correct data location.

afaust — Thu, 16 Nov 2017 11:17:33 GMT

You have existing data in the database that is pointing to a file on disk that could not be found. Either make sure that the listed property in alfresco-global.properties points to a directory in which that file exists, or reset / clear your database to start from a clean slate (if this is supposed to be a new / empty system).

Re: Ensure that the 'dir.root' property 'C:\ALFRES~4\alf_data' is pointing to the correct data location.

kranthi — Thu, 16 Nov 2017 12:00:42 GMT

need to clear total database or alf_content_url table. because I am using common data base where other my development tables are also exists.

Re: Ensure that the 'dir.root' property 'C:\ALFRES~4\alf_data' is pointing to the correct data location.

afaust — Thu, 16 Nov 2017 12:29:19 GMT

What? Every Alfresco instance should have its own, separate database / schema (can be same server, but properly isolated). Clearing only alf_content_url would never be sufficient. What other "development tables" also exist? Tables of Alfresco or are you putting in custom tables as well?

Clearing only alf_content_url will not work because those entries are referenced from alf_content_data, you cannot clear alf_content_data because those entries are referenced from alf_node_properties, and so on...

Re: Ensure that the 'dir.root' property 'C:\ALFRES~4\alf_data' is pointing to the correct data location.

kranthi — Thu, 16 Nov 2017 12:40:23 GMT

some custom tables are there.Exortal is db where in that citizen tables along with alfresco tables.Now what I need to do.

Re: Ensure that the 'dir.root' property 'C:\ALFRES~4\alf_data' is pointing to the correct data location.

afaust — Fri, 17 Nov 2017 08:25:20 GMT

Well - then you'd need to manually drop the Alfresco tables only in the right sequence or with foreign key constraint validation disabled... There is a reason why it is not recommended to put custom tables in the same database / schema as the Alfresco tables. It is more difficult to handle administratively.

Re: Ensure that the 'dir.root' property 'C:\ALFRES~4\alf_data' is pointing to the correct data location.

kranthi — Fri, 17 Nov 2017 09:11:22 GMT

one more doubt in this.can we use install alfresco setup in different systems with one single MYSQL ??. May be that's why I am this issue ??.

I want to install alfresco in multiple systems in our development team with common MYSQL.

Re: Ensure that the 'dir.root' property 'C:\ALFRES~4\alf_data' is pointing to the correct data location.

afaust — Fri, 17 Nov 2017 11:49:09 GMT

You can... Just configure the database connection in alfresco-global.properties accordingly and create a properly isolated schema / database inside your common MySQL server.