Generic "Table/View does not exist" error

Follow

Shashank Srivastava -

Issue

If we setup a new instance of XLR from an existing XLR instance or upgrade from older version, we sometimes (due to not following proper steps) see errors related to Table/View while creating a new Release.

Environment

XL-Release

Resolution

Ensure that Archive directory from older instance is copied to new instance before bringing that up.

Cause

If the new instance of XL-Release lacks this directory or is out of synch, it will not be able to find its Archiving database & hence those Tables/Views won't be visible to XL-Release.

Additional Information

ERROR c.x.d.UnhandledExceptionMapper - Unhandled Exception: {}
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT COUNT(*) FROM RELEASES WHERE releaseId = ?]; nested exception is java.sql.SQLSyntaxErrorException: Table/View 'RELEASES' does not exist.

Tags
 XL-Release, archiving database

 

 

Have more questions? Submit a request
Powered by Zendesk