对象名 'BANDANA' 无效

jg cui

Confluence 7.12  +   SQL Server 2019  in  Win10

	com.atlassian.core.filters.HeaderSanitisingFilter.doFilter(HeaderSanitisingFilter.java:37)
	com.atlassian.confluence.servlet.FourOhFourErrorLoggingFilter.doFilter(FourOhFourErrorLoggingFilter.java:64)
	com.atlassian.confluence.internal.diagnostics.HttpRequestMonitoringFilter.doFilter(HttpRequestMonitoringFilter.java:35)
	com.atlassian.confluence.web.filter.DebugFilter.doFilter(DebugFilter.java:46)
	com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:32)

根本原因。

com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'BANDANA' 无效。
	com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:260)
	com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1547)
	com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:528)
	com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:461)
	com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7342)
	com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2688)
	com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:224)
	com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:204)
	com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:383)
	com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1471)
	org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:60)
	org.hibernate.loader.Loader.getResultSet(Loader.java:2168)
	org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1931)
	org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1893)
	org.hibernate.loader.Loader.doQuery(Loader.java:938)
	org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
	org.hibernate.loader.Loader.doList(Loader.java:2692)
	org.hibernate.loader.Loader.doList(Loader.java:2675)
	org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2507)
	org.hibernate.loader.Loader.list(Loader.java:2502)
	org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:502)
	org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:392)

 

Shannon S

Hello!

Thank you for raising this with Atlassian Community. From what I can see, you're running Confluence on-premise version 7.12 with an unsupported database. Check Supported Platforms for information on which databases Confluence supports.

MS SQL would have to be versions 2016, 2017, or Azure. I recommend you review the article Migrating to another database for steps on how to get onto a supported platform.

If you continue to have issues, please have your administrator raise a ticket with the Confluence Server team to get individual support.

Thank you, and take care!

Shannon