Appian Primary DS is working. Getting the following error: java.lang.

GouthamKrishna over 9 years ago

Appian Primary DS is working. Getting the following error:

java.lang.IllegalStateException: [jdbc/primaryds] The schema is invalid.

Please let me know, what can be done to solve this error...

Discussion posts and replies are publicly visible

Parents

0 clintont over 9 years ago

We have a similar issue. Updating a previous database copy to version 7.6.

Error log:
Caused by: java.lang.IllegalStateException: [java:/jdbc/AppianPrimaryDS] The schema is invalid.
          at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.ensureSchema(DataSourceManagerHbImpl.java:626) [appian-rdbms.jar:]
          at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.getEntityManagerFactory(DataSourceManagerHbImpl.java:585) [appian-rdbms.jar:]
          at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.getSessionFactory(DataSourceManagerHbImpl.java:577) [appian-rdbms.jar:]
          at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.initialize(DataSourceManagerHbImpl.java:413) [appian-rdbms.jar:]
          at com.appiancorp.rdbms.config.PrimaryDataSourceConfig.finish(PrimaryDataSourceConfig.java:22) [appian-rdbms.jar:]
          ... 18 more
Caused by: org.hibernate.HibernateException: Wrong column type in APPIAN2.dbo.sail_state_cache for column entry_value. Found: image, expected: varbinary(MAX)
          at org.hibernate.mapping.Table.validateColumns(Table.java:283) [hibernate-core-3.6.3.Final.jar:3.6.3.Final]
          at org.hibernate.cfg.Configuration.validateSchema(Configuration.java:1316) [hibernate-core-3.6.3.Final.jar:3.6.3.Final]
          at org.hibernate.tool.hbm2ddl.SchemaValidator.validate(SchemaValidator.java:139) [hibernate-core-3.6.3.Final.jar:3.6.3.Final]
          at com.appiancorp.rdbms.hb.SchemaManagerHbImpl.validateSchema(SchemaManagerHbImpl.java:50) [appian-rdbms.jar:]
          at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.ensureSchema(DataSourceManagerHbImpl.java:623) [appian-rdbms.jar:]

Any thoughts? We checked that table and such and is reflecting correctly as varbinary(MAX)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 clintont over 9 years ago

We have a similar issue. Updating a previous database copy to version 7.6.

Error log:
Caused by: java.lang.IllegalStateException: [java:/jdbc/AppianPrimaryDS] The schema is invalid.
          at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.ensureSchema(DataSourceManagerHbImpl.java:626) [appian-rdbms.jar:]
          at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.getEntityManagerFactory(DataSourceManagerHbImpl.java:585) [appian-rdbms.jar:]
          at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.getSessionFactory(DataSourceManagerHbImpl.java:577) [appian-rdbms.jar:]
          at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.initialize(DataSourceManagerHbImpl.java:413) [appian-rdbms.jar:]
          at com.appiancorp.rdbms.config.PrimaryDataSourceConfig.finish(PrimaryDataSourceConfig.java:22) [appian-rdbms.jar:]
          ... 18 more
Caused by: org.hibernate.HibernateException: Wrong column type in APPIAN2.dbo.sail_state_cache for column entry_value. Found: image, expected: varbinary(MAX)
          at org.hibernate.mapping.Table.validateColumns(Table.java:283) [hibernate-core-3.6.3.Final.jar:3.6.3.Final]
          at org.hibernate.cfg.Configuration.validateSchema(Configuration.java:1316) [hibernate-core-3.6.3.Final.jar:3.6.3.Final]
          at org.hibernate.tool.hbm2ddl.SchemaValidator.validate(SchemaValidator.java:139) [hibernate-core-3.6.3.Final.jar:3.6.3.Final]
          at com.appiancorp.rdbms.hb.SchemaManagerHbImpl.validateSchema(SchemaManagerHbImpl.java:50) [appian-rdbms.jar:]
          at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.ensureSchema(DataSourceManagerHbImpl.java:623) [appian-rdbms.jar:]

Any thoughts? We checked that table and such and is reflecting correctly as varbinary(MAX)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data