Configure an alfresco instance with existing db

[dkmorb]

Hi all, i'm new here.
I should configure a new Alfresco installation possibly on a existing SQL server 2005 database. I try to copy the original folder alf_data from "source" machine and change paths in custom-repository.properties, but at the end, i obtain this error:

16:14:28,968 INFO  [STDOUT] 16:14:28,968 User:System INFO  [domain.schema.SchemaBootstrap] No changes were made to the schema.
16:14:30,546 INFO  [STDOUT] 16:14:30,546 User:System WARN  [node.index.FullIndexRecoveryComponent] The indexes are not synchronized with the database.
16:14:30,546 INFO  [STDOUT] 16:14:30,546 User:System INFO  [repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: C:\jbossAlfresco\alf_data
16:14:30,593 INFO  [STDOUT] 16:14:30,593 User:System INFO  [admin.patch.PatchExecuter] Checking for patches to apply …
16:14:31,062 INFO  [STDOUT] 16:14:31,062 User:System INFO  [repo.module.ModuleServiceImpl] Found 0 module(s).
16:14:31,562 INFO  [STDOUT] 16:14:31,562  ERROR [quartz.core.JobRunShell] Job DEFAULT.userUsageBootstrapDetail threw an unhandled Exception: 
java.lang.NullPointerException
   at org.alfresco.repo.usage.UserUsageTrackingComponent$4.execute(UserUsageTrackingComponent.java:308)
   at org.alfresco.repo.usage.UserUsageTrackingComponent$4.execute(UserUsageTrackingComponent.java:279)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:236)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:185)
   at org.alfresco.repo.usage.UserUsageTrackingComponent.recalculateUsage(UserUsageTrackingComponent.java:324)
   at org.alfresco.repo.usage.UserUsageTrackingComponent.execute(UserUsageTrackingComponent.java:195)
   at org.alfresco.repo.usage.UserUsageBootstrapJob.execute(UserUsageBootstrapJob.java:54)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
16:14:31,562 INFO  [STDOUT] 16:14:31,562  ERROR [quartz.core.ErrorLogger] Job (DEFAULT.userUsageBootstrapDetail threw an exception.
org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: java.lang.NullPointerException]
   at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: java.lang.NullPointerException
   at org.alfresco.repo.usage.UserUsageTrackingComponent$4.execute(UserUsageTrackingComponent.java:308)
   at org.alfresco.repo.usage.UserUsageTrackingComponent$4.execute(UserUsageTrackingComponent.java:279)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:236)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:185)
   at org.alfresco.repo.usage.UserUsageTrackingComponent.recalculateUsage(UserUsageTrackingComponent.java:324)
   at org.alfresco.repo.usage.UserUsageTrackingComponent.execute(UserUsageTrackingComponent.java:195)
   at org.alfresco.repo.usage.UserUsageBootstrapJob.execute(UserUsageBootstrapJob.java:54)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
   … 1 more
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Any suggestion accepted!!
Thanks in advance,
Dkmorb.

[krishna]

hi,
we r also facing wit same prob..
any luck in this case…
do share with us…

thx…

[dkmorb]

Hi krishna,
ok, no problem for me, but my experience are limited to this particular case, so… I've not idea on how solve this issue. How can I preceede?

Bye,
dkmorb.

[krishna]

Hi,
my prob of configuring to existin ms sql server is solved.
We need to create a folder called org.repo.admin.dialect.AlfrescoSQLServerDialect in activities folder.
Copy the 3 files in them.
Change the custom-repository.properties file to enter ur db name, user name and password.
Also copy jaxb-api 2.1 jar in tomcat\common\endorsed folder.

suppose if you get error of "schema auto-update failed", then make change in shared\extension\custom-repository.properties as dbschema.update= false.

hope This works to u tooo….

Krishna..

[dkmorb]

Hi krishna,
my problem is just a little different from your, probably because i've success to connect my alfresco to alfresco db (MS SQL Server 2005) but i can't connect to already populated db on that server.  :cry:

I don't know…
dkmorb

[dkmorb]

Men, i'm poor programmer so…
I've solved my problem deleting original hibernate lib (3 files) in jboss and adding them to alfresco.war file (WEB-INF/lib). Now all my 2 application works perfectly togheter with Alfresco.

Byez,
dkmorb.