Unable To Connect WCI Portal to MS SQL Database Server Due to Exception "set the compatibility level for current database to 80"
Last updated on DECEMBER 02, 2016
Applies to:Oracle WebCenter Interaction - Version 10.3.3.0 and later
Information in this document applies to any platform.
When attempting to run Webcenter Interaction Portal Diagnostics and/or Ptverify, the following error occurs:
OpenKernel SQL exception. Verify your database is not corrupt. Try rebuilding your indexes. Report this error to Oracle Support.
PortalObjectsFactory Initialization Failure (.NET)
RECOMMENDATION: Review the exception listed below for more details.
Since OpenKernel initialized correctly, this usually means
that the portal database is not scripted or properly configured,
or there is an installation problem related to .NET assemblies.
This may mean the search libraries are not on your path. Try
com.plumtree.openkernel.exceptions.OKSQLException: Error in function PTSession.C
onnect (iUserID == 2, SecurityProviderInfo == ): Error in function PTSessionInfo
.CheckPropertySearchRight (nPropertyID == 26): Error in function PTBaseObjectMan
ager.Query (nPropIDMask == 1, lFolderID == -1, vOrderBy == 16, nSkipRows == 0, n
MaxRows == -1, vQueryFilter == [ [131072, 8192], [4, 6], [0, 1] ]): Error in fun
ction PTBaseObjectManager.QueryInternal (nPropIDMask == 1, lFolderID == -1, vOrd
erBy == System.Int32, nSkipRows == 0, nMaxRows == -1, vQueryFilter == [ [13107
2, 8192], [4, 6], [0, 1] ]): Exception: The query uses non-ANSI outer join opera
tors ("*=" or "=*"). To run this query without modification, please set the comp
atibility level for current database to 80, using the SET COMPATIBILITY_LEVEL op
tion of ALTER DATABASE. It is strongly recommended to rewrite the query using AN
SI outer join operators (LEFT OUTER JOIN, RIGHT OUTER JOIN). In the future versi
ons of SQL Server, non-ANSI join operators will not be supported even in backwar
Could not use view or function 'PTVPROPERTIES' because of binding errors. SQL: '
/* SELECT_SUBQUERY_ORDERBY:ANSI */ SELECT A.* FROM (/* QUERY_ALL_NONSECURE:ANSI
*/ SELECT DISTINCT (A.OBJECTID),A.NAME,A.ISLOCALIZED,A.LOCKED FROM PTVPROPERTIES
A, PTMIGRATION M WHERE A.OBJECTID > 0 AND M.OBJECTID=A.OBJECTID AND M.CLASSID=3
6 AND A.SEARCHABLE > ?) A ORDER BY LOWER(A.NAME) ASC'
MS SQL Database server was upgraded to a version higher than SQL 2000.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms