org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute statement; uncategorized SQLException; SQL state [S0001]; error code [40515]; Reference to database and/or server name in 'Confluence.dbo.CONTENT' is not supported in this version of SQL Server.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Reference to database and/or server name in 'Confluence.dbo.CONTENT' is not supported in this version of SQL Server.
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89)
caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Reference to database and/or server name in 'Confluence.dbo.CONTENT' is not supported in this version of SQL Server.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265)
This looks like your test server is using an unsupported (too old) version of MS-SQL server. What version of Confluence and MS-SQL are you using here?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yep, thought so, you'll need to move to using a more recent version of the database (I think 12 is nearly a decade out of date)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Nic Brough -Adaptavist- - I got this same error, but I'm running Azure SQL in both instances, and it only shows up in my non-prod instances. I think ti might have something to do with the DB Refresh.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Which Azure database are you running?
Jira only works with Postgres, Oracle, MySQL and MS-SQL, but Azure can support all of them, so I'm questioning which one you mean by "Azure SQL"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Unfortunately, that is not an option for me. The database table for prod and test live in the same error so I can't rename it the same. What's odd was I was able to do this before with no issue. This issue just now started.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.