Error importing projection salary table

Owned by Knowledge Assistant
Jan 06, 2023
1 min read



Description of Issue

Getting error when importing Projection Salary table 

Error executing pmgrtabio_insert.

ID:[Insert 1023] record [1223:2000:1609 07/01/2022] status -6732 [ISAM -5000] “

“[SQL Server] Cannot insert duplicate key row in object ‘dbo.payrollGrades’ with unique index ‘IX_PayrollGrades_Unique’. The Duplicate “



Context

  • Payroll

  • Financials

  • Budget Processing

  • Salary and Benefit Projection

  • Projection Start and Status



Cause

Salary table already exists in the system.



Resolution

To confirm the Salary Table exists: 

  1. Go to Projection Start and Status ( Financials > Budget Processing > Salary and Benefit Projection>Projection Start and Status )

  2. Search for Projection run. Click Accept. 

  3. Click on Salary tables

  4. Search for Effective date, Rank, Group BU, etc. 

  5. Click Accept. 



Additional Information