topic Re: could not get table metadata: JBPM_VARIABLEINSTANCE in Alfresco Archive

could not get table metadata: JBPM_VARIABLEINSTANCE

asurjit — Sun, 12 Jul 2009 19:03:26 GMT

Hi All,I am getting below error when I am trying to build the example project SDKFirstFoundationClient. There are similar errors in the posted earlier as well and I tried the suggested solutions like1) Give File privileges to Alfresco user.mysql> use mysql;Database changedmysql> select Host, U

Re: could not get table metadata: JBPM_VARIABLEINSTANCE

mikeh — Sun, 12 Jul 2009 21:34:13 GMT

2) I have McAfee active on my developer machine and we can not disable it. So I am not sure how to try that part.

That's your problem. McAfee interferes with the database files in the temp folder. You don't need to disable it completely, just prevent it scanning .myi files.

Mike

Re: could not get table metadata: JBPM_VARIABLEINSTANCE

asurjit — Mon, 13 Jul 2009 01:45:58 GMT

Thanks Mike for the information…

I did the complete set up on new machine where I do not have Mcafee problem and this issue seems to be resolved (not 100% sure because this project is still not getting complied)

I am getting new error now which is

Few steps which I performed,

1) I did a fresh installation of Alfresco and mysql and ran the sample sdk project for firstFoundationClient
2) Cleaned up the lucene indexes couple of times and then rebuild by turning on
index.recovery.mode=AUTO
3) root dir is pointing to the correct location which is dir.root=C:/Alfresco/alf_data
4) Looked into the JIRA issue and performed the mentioned steps but did not make any difference

Only thing which I can think is cleaning up the database and then fixing the database again but it sounds quite weird to me if I need to go this route

Any help is appreciated why I am getting this error

02:42:15,425 Userystem WARN [node.index.FullIndexRecoveryComponent] The indexes are not synchronized with the database.
02:42:15,796 Userystem WARN [node.index.AVMFullIndexRecoveryComponent]     Index for avm store sitestore is out of date
02:42:17,318 Userystem INFO [repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: C:Alfrescoalf_data
02:42:17,448 Userystem ERROR [repo.admin.ConfigurationChecker] CONTENT INTEGRITY ERROR: Indexes not found for 7 stores.
02:42:17,448 Userystem INFO [repo.admin.ConfigurationChecker] You may set 'index.recovery.mode=FULL' if you need to rebuild the indexes.
02:42:17,448 Userystem ERROR [repo.admin.ConfigurationChecker] CONTENT INTEGRITY ERROR: System content not found in content store.
02:42:17,448 Userystem ERROR [repo.admin.ConfigurationChecker] Ensure that the 'dir.root' property is pointing to the correct data location.
Exception in thread "main" org.alfresco.error.AlfrescoRuntimeException: Ensure that the 'dir.root' property is pointing to the correct data location.
   at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationChecker.java:312)
   at org.alfresco.repo.admin.ConfigurationChecker.access$000(ConfigurationChecker.java:72)
   at org.alfresco.repo.admin.ConfigurationChecker$1.execute(ConfigurationChecker.java:178)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:320)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:246)
   at org.alfresco.repo.admin.ConfigurationChecker.onBootstrap(ConfigurationChecker.java:182)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
   at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
   at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:91)
   at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:75)
   at org.alfresco.util.ApplicationContextHelper.getApplicationContext(ApplicationContextHelper.java:55)
   at org.alfresco.sample.FirstFoundationClient.main(FirstFoundationClient.java:69)

Re: could not get table metadata: JBPM_VARIABLEINSTANCE

asurjit — Mon, 13 Jul 2009 10:25:20 GMT

I think, this is acting a real pain now!!

I have installed alfresco, mysql, sdk again but still I am getting the same error. Can someone shed some light on this?

Really appreaciate it

11:19:52,106 Userystem WARN [node.index.FullIndexRecoveryComponent] The indexes are not synchronized with the database.
11:19:52,486 Userystem WARN [node.index.AVMFullIndexRecoveryComponent]     Index for avm store sitestore is out of date
11:19:54,369 Userystem INFO [repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: C:Alfrescoalf_data
11:19:54,539 Userystem ERROR [repo.admin.ConfigurationChecker] CONTENT INTEGRITY ERROR: Indexes not found for 7 stores.
11:19:54,539 Userystem INFO [repo.admin.ConfigurationChecker] You may set 'index.recovery.mode=FULL' if you need to rebuild the indexes.
11:19:54,539 Userystem ERROR [repo.admin.ConfigurationChecker] CONTENT INTEGRITY ERROR: System content not found in content store.
11:19:54,539 Userystem ERROR [repo.admin.ConfigurationChecker] Ensure that the 'dir.root' property is pointing to the correct data location.
Exception in thread "main" org.alfresco.error.AlfrescoRuntimeException: Ensure that the 'dir.root' property is pointing to the correct data location.
   at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationChecker.java:312)
   at org.alfresco.repo.admin.ConfigurationChecker.access$000(ConfigurationChecker.java:72)
   at org.alfresco.repo.admin.ConfigurationChecker$1.execute(ConfigurationChecker.java:178)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:320)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:246)
   at org.alfresco.repo.admin.ConfigurationChecker.onBootstrap(ConfigurationChecker.java:182)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
   at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
   at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:91)
   at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:75)
   at org.alfresco.util.ApplicationContextHelper.getApplicationContext(ApplicationContextHelper.java:55)
   at org.alfresco.sample.FirstFoundationClient.main(FirstFoundationClient.java:69)

Re: could not get table metadata: JBPM_VARIABLEINSTANCE

mikeh — Mon, 13 Jul 2009 11:18:56 GMT

11:19:54,369 Userystem INFO [repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: C:Alfrescoalf_data

The value looks wrong. What's the exact path you're setting?

Mike

Re: could not get table metadata: JBPM_VARIABLEINSTANCE

asurjit — Mon, 13 Jul 2009 11:38:21 GMT

There are three locations we have this value

1) custom-repository.properties
dir.root=C:\Alfresco\alf_data

2) repository.properies
dir.root=C:\Alfresco\alf_data

3) custom-repository.properties (SDKFirstFoundation Project)
dir.root=C:\Alfresco\alf_data

Is there any issue with the slashes?

Re: could not get table metadata: JBPM_VARIABLEINSTANCE

mikeh — Mon, 13 Jul 2009 11:48:48 GMT

Yes, they must be escaped as mentioned here: http://wiki.alfresco.com/wiki/Developer_Runtime_Configuration#Configuring_Repository_Location

Thanks,
Mike

Re: could not get table metadata: JBPM_VARIABLEINSTANCE

asurjit — Mon, 13 Jul 2009 12:47:40 GMT

Thanks Mike, appreciate your help here..

But problems do not end still..I am getting next error with regards to jlan.jar. I have copied the alfresco-jlan-embed.jar file from Alfresco installation but it did not help still.

Anything you can suggest on this…Too much struggle to get the first SDK foundation project..I am going to write step by step instructions after running it once!!

Exception in thread "main" java.lang.IncompatibleClassChangeError
   at org.alfresco.jlan.server.filesys.DefaultShareMapper.initializeMapper(DefaultShareMapper.java:89)
   at org.alfresco.jlan.server.config.SecurityConfigSection.<init>(SecurityConfigSection.java:108)
   at org.alfresco.filesys.ServerConfigurationBean.processSecurityConfig(ServerConfigurationBean.java:2289)
   at org.alfresco.filesys.ServerConfigurationBean.init(ServerConfigurationBean.java:516)
   at org.alfresco.filesys.ServerConfigurationBean.onApplicationEvent(ServerConfigurationBean.java:3098)
   at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
   at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
   at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:91)
   at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:75)
   at org.alfresco.util.ApplicationContextHelper.getApplicationContext(ApplicationContextHelper.java:55)
   at org.alfresco.sample.FirstFoundationClient.main(FirstFoundationClient.java:69)

Re: could not get table metadata: JBPM_VARIABLEINSTANCE

asurjit — Mon, 13 Jul 2009 14:25:56 GMT

Finally I am able to run the SDK Foundation Client Project!!!!!

Just to close this thread, I was able to resolve the last issue and it was happening because I have two Alfresco-jlan jars in my build path which was causing the issue. I removed alfresco-jlan.jar and then tried to run it again and it worked fine finally.

Excited to explore it further now!