Skip to content
ProjectControls.com
Oracle Primavera - PM6

duplicate key in object 'dbo.TRSRCFIN'.

In the Open Standard
Gün GöksuMember for 21 years 6 months
Created
3
3
0

Hi everyone,

I am working on a system running MSSQL and P6 EPPM v15.2.

Trying to import a schedule backup in XML form with baseline into the database through P6 client.

SEVERE: DBEngine.executeUpdate: Violation of PRIMARY KEY constraint 'pk_trsrcfin'. Cannot insert duplicate key in object 'dbo.TRSRCFIN'. The duplicate key value is (150, 6275459).

This prevents me from importing the backup.

I get the same error on both the production and the backup testing server.

 
Anyone encountered this before? a google search and an oracle support search did not turn anything usefull.
 
Kind regards,
Gün
Save Follow Follow forum Report
Reply New topic

3 replies

Oldest first
  1. 0
    Zoltan Palffy ·
    #1

    The error TRSRCFIN has to

    The error TRSRCFIN has to with the financial periods for the resource assignments. 

    you need Release 15.2.3.0 Patch Set

    since it is a xml file I am not sure that you can change it 

    try to open the sml in a text editior and do a search for (150, 6275459) it should be in there twice. Whne you find it delete one of the instances. 

    Report
  2. 0
    Gün Göksu ·
    #2

    Thanks for the reply Zoltan,I

    Thanks for the reply Zoltan,

    I have figured as much, and a quick chat with someone who has been here (the office) longer confirms the financial periods have been changed.

    I managed to import the XML files by deleting the financialperiod tag.

    however, it is interesting that the dbo.TRSRCFIN table is actually empty.

    Thanks also for the tip on the patch set.

    Kind regards,

    Edit: This is the bit I removed. maybe it'l be usefull to someone who stumbles here.

    <FinancialPeriod>
    <EndDate>2013-06-30T00:00:00</EndDate>
    <Name>2013-06-01</Name>
    <ObjectId>155</ObjectId>
    <StartDate>2013-06-01T00:00:00</StartDate>
    </FinancialPeriod>
    Report
  3. 0
    Zoltan Palffy ·
    #3

    glad that I could help you

    glad that I could help you

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?