Refresh Benefit Snapshot Error: SQL Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot Insert Duplicate Key Row in Object 'PS_BN_SNAP_JOB' with Unique Index 'PS_BN_SNAP_JOB'. (Doc ID 1053910.1)

Last updated on AUGUST 04, 2015

Applies to:

PeopleSoft Enterprise HRMS Human Resources - Version 8.8 SP1 and later
Information in this document applies to any platform.

Symptoms

Benefits Snapshot, BEN100A.SQR, is failing with duplicate inserts with the following error:


...Create-Job-Info (10:09:25.787)
d:\psoft\hrprd\sqr\ben100a.sqr: ENROLLMENT REPORTING SNAPSHOT - SQL Statement =

SQL Status = 2601, SQL Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'PS_BN_SNAP_JOB' with unique index 'PS_BN_SNAP_JOB'.


Error on line 56:
(SQR 3301) Program stopped by user request.

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