EPT8.48: Errors after upgrading database to Microsoft SQL Server 2005
(Doc ID 650773.1)
Last updated on AUGUST 11, 2022
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.4 and laterInformation in this document applies to any platform.
SPECIFIC TO: Microsoft SQL Server 2005, Tools 8.48 or higher.
This document was previously published as Customer Connection Solution 201024976
Symptoms
Errors after upgrading database from MS SQL Server 2000 to 2005 or doing a manual install for PT 8.48 or higher for MS SQL Server 2005. PT 8.48 or higher only is supported.
In App Designer:
SQL error. Stmt #: 2972 Error Position: 0 Return: 8010 - [Microsoft][SQL Native Client][SQL Server]Invalid column name 'ISNULLABLE'.
select c.name,c.colid,t.name,c.length,c.prec,c.scale,c.isnullable from SYSCOLUMNS c, SYSOBJECTS o, SYSTYPES t where c.id = o.id and c.usertype = t.usertype and o.type = 'U' and o.name = :1 order by c.colid
error in dbcc checkdb:
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (role_principal_id=16384) of row
(role_principal_id=16384,member_principal_id=1) in sys.database_role_members
does not have a matching row (principal_id=16384) in sys.database_principals.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |