E-PORTAL: Running PORTAL_CSS Runs Throws Error on SQL SERVER 2012 (Doc ID 1638769.1)

Last updated on AUGUST 26, 2015

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.53 and later
Information in this document applies to any platform.

Symptoms


SQL error. Stmt #: 3642 Error Position: 0 Return: 805 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert duplicate key row in object 'dbo.PSPRSMPERM' with unique index 'PS_PSPRSMPERM'. The duplicate key value is (EMPLOYEE , F, PT_ADMINISTRATION , PTPT1000)


Failed SQL stmt: INSERT INTO PSPRSMPERM (PORTAL_NAME, PORTAL_REFTYPE, PORTAL_OBJNAME, PORTAL_PERMNAME, PORTAL_ISCASCADE, PORTAL_PERMTYPE) VALUES (:1, :2, :3, :4, 0, :5)

SQL.Fetch: object isn't open on a select. (2,288) PORTAL_CSS.CREFPERM.GBL.default.1900-01-01.Step01.OnExecute PCPC:7771 Statement:163

Process 224 ABENDED at Step PORTAL_CSS.CREFPERM.Step01 (PeopleCode) -- RC = 24 (108,524)

Temporary Table processing failure during deallocation phase. (108,531)


Database version : Microsoft SQLServer 2012.
SQL Server Native Client Version : SQL Server Native Client 11.0


Cause

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