cancel
Showing results for 
Search instead for 
Did you mean: 

DATABASE VERSION UPGRADE

Former Member
0 Kudos

Am Upgrading a database from SAP 8.82 to SAP 9.1  PL 5 and it is giving me the following error..............

Duplicate records found for unique indexes in User defined table ..SAP NOTE 1343077

Question

Is there a way i can rebuild the indexes so that I can be able to upgrade the database to 9.1 PL 5?

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member

Hi,

1343077  - Upgrade Wizard Precheck: user-defined table unique index 
Version   3   Validity: 20.06.2012 - active
Language   English
   

Content:      Summary    |    Header Data    |    References    |    Validity    |    Attachments

Symptom

When you run the SAP Business One upgrade wizard, the following error message may appear in the pretest step: "Duplicate records found for unique indexes in user-defined table".


Cause

Consulting

The wizard found a duplicate record a in user-defined table.

This check verifies if a company database has user-defined tables that are inconsistent with the SAP Business One default structure, as follows:
1. User table of type "No object" - the Code and Name values should both be unique.
2. User table of type "Master data" - the Code and DocEntry values should both be unique.
3. User table of type "Master data rows" - the combination of Code and docEntry should be unique.
4. User table of type "Document" - the DocEntry value should be unique.
5. User table of type "Document rows" - the combination of DocEntry and Line ID should be unique.

A table that is not consistent with the SAP Business One user-defined table default structure can be located in the log file.

Example log:
Table '@BCENOTE' contain 3 duplicate records for field 'Code', duplicate field value is '00000002'.
Table '@BCENOTE' contain 2 duplicate records for field 'Code', duplicate field value is '0000000C'.
Table '@SI_QPLDET' contain 2 duplicate records for combination of fields 'Code' and 'LineId', duplicate field value is '(1, 1)'
Table '@SI_QPLDET' contain 2 duplicate records for combination of fields 'Code' and 'LineId', duplicate field value is '(11, 2)'

According to the SAP Business One user-defined table default structure, the 'Code' field in table '@BCENOTE' should be unique, but the example log means that:

    1. There are 3 records containing the value '00000002'.
    2. There are 2 records containing the value '0000000C'.


According to the SAP Business One user-defined table default structure, the combination of the 'Code' field and the 'LineId' field in table '@SI_QPLDET' should be unique, but the example log means that:

    3. There are 2 records containing the same combined value of: the value of 'Code' is 1, the value of 'LineId' is 1.
    4. There are 2 records containing the same combined value of: the value of 'Code' is 11, the value of 'LineId' is 2.


Solution


You need to get the customer's approval to update the duplicated field values and clear the duplications.

We recommend generating a database backup before updating any object from the company database.

You may run the attached script UDT_Query_fixed2.txt that might help you detect the UDT that is causing the issue.

If you have inconsistent UDTs/UDFs then please also refer to SAP Note 1076082 how to fix them.

Regards

SP Samy

Former Member
0 Kudos

HI Samy

Am working from test database, can you provide me with script so that I execute it and see its implication on the database

former_member188586
Active Contributor
0 Kudos

hi check bellow thread it may help you

Steps for migrating from 8.82 to 9.1 | SCN

--Ramudu