Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
29 replies
Subscribers
7 subscribers
Views
10354 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Administration
Appian Primary DS is working. Getting the following error: java.lang.
GouthamKrishna
over 10 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...
OriginalPostID-117700
OriginalPostID-117700
Discussion posts and replies are publicly visible
Parents
0
sonalk
over 10 years ago
It worked ! All my Engines are restored. Thanks a lot Edurado.
But actually we still have some other issues. When we start JBOSS we getting an error named "The Schema is invalid"
Please find the log snippet below:
Caused by: com.appiancorp.common.config.FatalConfigurationException: An unexpected error occurred while trying to initialize and validate the primary data source.
at com.appiancorp.rdbms.config.PrimaryDataSourceConfig.finish(PrimaryDataSourceConfig.java:31)
at com.appiancorp.common.config.ConfigObject.init(ConfigObject.java:66)
at com.appiancorp.common.config.ConfigObjectRepository.initConfigObject(ConfigObjectRepository.java:313)
at com.appiancorp.common.config.ConfigObjectRepository.initConfigObject(ConfigObjectRepository.java:222)
at com.appiancorp.common.config.ConfigObjectRepository.initConfigObject(ConfigObjectRepository.java:214)
at com.appiancorp.common.config.ConfigObjectRepository.getConfigObjectImpl(ConfigObjectRepository.java:91)
at com.appiancorp.common.config.ConfigObjectRepository.getConfigObject(ConfigObjectRepository.java:81)
at com.appiancorp.common.config.AbstractConfiguration.getDecryptedString(AbstractConfiguration.java:294)
... 23 more
Caused by: java.lang.IllegalStateException: [jdbc/primaryds] The schema is invalid.
at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.ensureSchema(DataSourceManagerHbImpl.java:614)
at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.getEntityManagerFactory(DataSourceManagerHbImpl.java:573)
at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.getSessionFactory(DataSourceManagerHbImpl.java:565)
at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.initialize(DataSourceManagerHbImpl.java:401)
at com.appiancorp.rdbms.config.PrimaryDataSourceConfig.finish(PrimaryDataSourceConfig.java:22)
... 30 more
Caused by: org.hibernate.HibernateException: Missing column: author in 27primarydslatest.tp_comment
at org.hibernate.mapping.Table.validateColumns(Table.java:276)
at org.hibernate.cfg.Configuration.validateSchema(Configuration.java:1316)
at org.hibernate.tool.hbm2ddl.SchemaValidator.validate(SchemaValidator.java:139)
at com.appiancorp.rdbms.hb.SchemaManagerHbImpl.validateSchema(SchemaManagerHbImpl.java:50)
at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.ensureSchema(DataSourceManagerHbImpl.java:611)
... 34 more
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
sonalk
over 10 years ago
It worked ! All my Engines are restored. Thanks a lot Edurado.
But actually we still have some other issues. When we start JBOSS we getting an error named "The Schema is invalid"
Please find the log snippet below:
Caused by: com.appiancorp.common.config.FatalConfigurationException: An unexpected error occurred while trying to initialize and validate the primary data source.
at com.appiancorp.rdbms.config.PrimaryDataSourceConfig.finish(PrimaryDataSourceConfig.java:31)
at com.appiancorp.common.config.ConfigObject.init(ConfigObject.java:66)
at com.appiancorp.common.config.ConfigObjectRepository.initConfigObject(ConfigObjectRepository.java:313)
at com.appiancorp.common.config.ConfigObjectRepository.initConfigObject(ConfigObjectRepository.java:222)
at com.appiancorp.common.config.ConfigObjectRepository.initConfigObject(ConfigObjectRepository.java:214)
at com.appiancorp.common.config.ConfigObjectRepository.getConfigObjectImpl(ConfigObjectRepository.java:91)
at com.appiancorp.common.config.ConfigObjectRepository.getConfigObject(ConfigObjectRepository.java:81)
at com.appiancorp.common.config.AbstractConfiguration.getDecryptedString(AbstractConfiguration.java:294)
... 23 more
Caused by: java.lang.IllegalStateException: [jdbc/primaryds] The schema is invalid.
at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.ensureSchema(DataSourceManagerHbImpl.java:614)
at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.getEntityManagerFactory(DataSourceManagerHbImpl.java:573)
at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.getSessionFactory(DataSourceManagerHbImpl.java:565)
at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.initialize(DataSourceManagerHbImpl.java:401)
at com.appiancorp.rdbms.config.PrimaryDataSourceConfig.finish(PrimaryDataSourceConfig.java:22)
... 30 more
Caused by: org.hibernate.HibernateException: Missing column: author in 27primarydslatest.tp_comment
at org.hibernate.mapping.Table.validateColumns(Table.java:276)
at org.hibernate.cfg.Configuration.validateSchema(Configuration.java:1316)
at org.hibernate.tool.hbm2ddl.SchemaValidator.validate(SchemaValidator.java:139)
at com.appiancorp.rdbms.hb.SchemaManagerHbImpl.validateSchema(SchemaManagerHbImpl.java:50)
at com.appiancorp.rdbms.hb.DataSourceManagerHbImpl.ensureSchema(DataSourceManagerHbImpl.java:611)
... 34 more
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data