My Oracle Support Banner

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 later
Information 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


 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.colid,,c.length,c.prec,c.scale,c.isnullable         from SYSCOLUMNS c, SYSOBJECTS o, SYSTYPES t        where =        and c.usertype = t.usertype        and o.type = 'U'        and = :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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.