Error Sql Duplicate in Load Operation

Hi,
For a migration, I'm doing load operation for a docbase of 70.000 documents.

(Content Server 6.7 To 7.3)

I have used this script for load operation:

trace,c,10,C:\DOCUMENTUM\load_trace.log
create,c,dm_load_record
set,c,l,file_name
C:\DOCUMENTUM\dump.dmp
save,c,l
getmessage,c

After some houres, I obtain this error:

_[DM_LOAD_E_OBJECT_SAVE_FAILED]error: "Save of object 49000d8080000100 failed -- load terminated"

[DM_OBJ_MGR_E_SAVE_FAIL]error: "save failed for object with handle 49000d8080000100 of type dmi_package: table on which save failed was dmi_package_s; error from database system was -- Object already exists -- STATE=23000, CODE=2601, MSG=[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'dbo.dmi_package_s' with unique index 'd_1f000d808000018b'. The duplicate key value is (4d000d8080000102, 1, input:1 , package
ERROR(-1) "_

Any idea?
Thanks
Fra

Answers

  • Unfortunately, dump and load is not supported across versions. Additionally, you cannot do a full dump and load. In the meantime, what have you included as part of your dump script?
    Is your goal to make a copy to upgrade from 6.7 to 7.3? If so, you may be better doing a repository copy as per the migration guide.

    Russell Kavanagh
    Documentum SME | Opentext

  • Francesco_RositaniFrancesco_Rositani Francesco Rositani
    edited June 11

    Hi rkavanagh,
    I have understood that full_docbase_dump is not supported for 6.7 and 7.3 release.

    My dump script was:

    create,c,dm_dump_record
    set,c,l,file_name
    D :\MIGRATION\dump_docbase.dmp
    set,c,l,dump_operation
    full_docbase_dump
    set,c,l,include_content
    T
    append,c,l,dump_parameter
    compress_content=T
    save,c,l
    getmessage,c

    At the moment I'm organizing myself for backup and restore of DB and copy of filestore.

    I was thinking of following this path:

    1. Source: CS 6.7 (su SqlServer 2008 e WindowsServer 2008)
    2. Source: Backup Docbase and copy of filestore
    3. Target: Create an environment and docbase 6.7 (with SqlServer 2014 and WindowsServer 2012)
    4. Target: Create docbase
    5. Target: Restore DB and copy filestore
    6. Target: Fixing docbase
    7. Target: Upgrade environment server 6.7 to 7.3

    In your opinion, is the right approach?
    I have some doubt on point 3: I can create environment 6.7 on WindowsServer 2012 and SqlServer 2012?
    Other doubts are on point 5: what operations i must execute?

    Thanks
    Fra

  • Hi Francesco.
    With your current version, is it 32 bit or 64 bit? You can open the docbase log and near the top it will give you the version.
    This will determine your options for upgrade.

    Russell Kavanagh
    Documentum SME | Opentext

Sign In or Register to comment.