could not get table metadata: JBPM_VARIABLEINSTANCE

[asurjit]

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 like

1) Give File privileges to Alfresco user.

mysql> use mysql;
Database changed
mysql> select Host, User, File_priv from user;
+———————–+———-+———–+
| Host                  | User     | File_priv |
+———————–+———-+———–+
| localhost             | root     | Y         |
| localhost             | wpadmin  | Y         |
| localhost             | alfresco | Y         |
| localhost.localdomain | alfresco | Y         |
+———————–+———-+———–+
4 rows in set (0.08 sec)

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.

3) Removing and creating the tables again from alfresco/extra/database/mysql scripts but nothing has helped.

Appreciate if some one can provide more information on the below given error.

Environment details

Windows XP, MySql 5.0, Alfresco 3 stable version …

19:47:40,610  ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed
org.hibernate.exception.GenericJDBCException: could not get table metadata: JBPM_VARIABLEINSTANCE
   at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
   at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
   at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:105)
   at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:954)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:649)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1123)
   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)
Caused by: java.sql.SQLException: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_b68_0.MYI' (Errcode: 13)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3118)
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3047)
   at com.mysql.jdbc.Statement.executeQuery(Statement.java:1166)
   at com.mysql.jdbc.DatabaseMetaData$2.forEach(DatabaseMetaData.java:2046)
   at com.mysql.jdbc.DatabaseMetaData$IterateBlock.doForAll(DatabaseMetaData.java:76)
   at com.mysql.jdbc.DatabaseMetaData.getColumns(DatabaseMetaData.java:1920)
   at org.hibernate.tool.hbm2ddl.TableMetadata.initColumns(TableMetadata.java:146)
   at org.hibernate.tool.hbm2ddl.TableMetadata.<init>(TableMetadata.java:32)
   at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:90)
   … 13 more
Exception in thread "main" org.alfresco.error.AlfrescoRuntimeException: Schema auto-update failed
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1192)
   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)
Caused by: org.hibernate.exception.GenericJDBCException: could not get table metadata: JBPM_VARIABLEINSTANCE
   at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
   at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
   at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:105)
   at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:954)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:649)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1123)
   … 10 more
Caused by: java.sql.SQLException: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_b68_0.MYI' (Errcode: 13)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3118)
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3047)
   at com.mysql.jdbc.Statement.executeQuery(Statement.java:1166)
   at com.mysql.jdbc.DatabaseMetaData$2.forEach(DatabaseMetaData.java:2046)
   at com.mysql.jdbc.DatabaseMetaData$IterateBlock.doForAll(DatabaseMetaData.java:76)
   at com.mysql.jdbc.DatabaseMetaData.getColumns(DatabaseMetaData.java:1920)
   at org.hibernate.tool.hbm2ddl.TableMetadata.initColumns(TableMetadata.java:146)
   at org.hibernate.tool.hbm2ddl.TableMetadata.<init>(TableMetadata.java:32)
   at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:90)
   … 13 more

[mikeh]

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

[asurjit]

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)

[asurjit]

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)

[mikeh]

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

[asurjit]

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?

[mikeh]

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

Thanks,
Mike

[asurjit]

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)

[asurjit]

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!