cancel
Showing results for 
Search instead for 
Did you mean: 

Company Database Upgrade Error

Former Member
0 Kudos

Hi,

I recently upgraded SAP B1 from 8.81 PL 5 to 8.82 PL 6. During the upgrade, the company database upgrade failed while upgrading one of the tables belonging to one of the add-ons installed. The error code was 1343077  - Upgrade Wizard Precheck: user-defined table unique index.

Since this was not the only database, I decided to go ahead with the upgrade assuming that the database would still function is the previous format (I assumed there would be backward compatibility).

After the upgrade, I realized I can no longer access the database since it has not been upgraded. There is no way for me to disable or delete the add on and upgrading the database always give the same error.

How can I fix this? I would appreciate any assistance.

Regards

Debola

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member186095
Active Contributor
0 Kudos

Hi Debola,

Based on this solution part of the sap note 1343077, you do not need to raise a ticket to sap support. See the solution part below:

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.


 

Other terms

UTB; User-defined table; consistent; inconsistent; consistency; duplicate


   
       

Header Data

  
Released On 20.06.2012 09:41:23   
Release Status Released for Customer   
Component SBO-BC-UPG Upgrade   
Priority   Recommendations/additional info   
Category   Upgrade information   
  
      

References

This document refers to:

  SAP Business One Notes
1076082 UDT & UDF related issues
1357462 Upgrade Wizard Precheck: Collective note for all check items
1059761 Create unique index terminated because a duplicate key - UDT

This document is referenced by:

   SAP Business One Notes (2) 
  1357462   Upgrade Wizard Precheck: Collective note for all check items
  1059761   Create unique index terminated because a duplicate key - UDT
   
    
      

Validity

Software Component

Version

SAP BUSINESS ONE

8.8

   
      

Attachments

File Name

File Size (KB)

Mime Type

UDT_Query_fixed2.txt

5590

text/plain

    

So, if you have raised a ticket, it will be noted as support level 1&2 which is it should be tasks of the sap partner in your country to the support level 1&2. SAP support only handle support level 3.

So, next time, if you create a discussion here, you must check another's answer in this dicussion forum before raise a ticket or check the sap note.

JimM

Former Member
0 Kudos

Hi Jimmy,

Thanks for your response. I actually saw this but did not want to tamper with the UDT since I do not know the effect the changes will have on the add-on.

I will consult the add-on developers on the fix.

Regards

Debola

Former Member
0 Kudos

Hi Adebola Adenusi,

Try to Clean Install only the upgrade version  SAP 8.82 PL 6. using the Autorun.exe of SAP 8.82 Installation file. This will give you a clean installation of SAP 8.82 and it will also install all the add-ons without having an upgrade from SAP 8.81 PL5. But you have to back-up the rest of the Company Databases you have on  SAP 8.81 in order for you to restore that database into SAP 8.82 PL6

Thanks and Regards,

Jhun

Former Member
0 Kudos

Hi Debola.........

In this case you need SAP Support.

Please raise a ticket they will definitely find some solution and fix it as soon as possible you want.

Regards,

Rahul

Former Member
0 Kudos

Hi Rahul,

It is a demo system we use for presentations to prospects and not a client installation. Can I still use SAP Support for this?

Regards

Debola

Former Member
0 Kudos

Yes........

To know what would be the fix you must raise ticket rather doing R&Ds from backend.

Else go for new Database if it is only the test DB........

Or try to restore some old DB which may work proper after upgradation too...

Regards,

Rahul

Former Member
0 Kudos

Hi Debola,

SAP support doesn't include Demo db. You  need solve the problem on you own. You may just delete the UDT to make the functional system first. Then fix your UDT problem.

Thanks,

Gordon

Former Member
0 Kudos

Hi Gordon,

Thanks for the response. The add-on is a demo version from a software partner. I tried removing the UDT but got another error. I also do not know the effect deleting the UDT will have on the add-on.

I have downloaded a new version of the demo database and will reinstall the add ons. I would have loved to know how to deal with this in a production environment.

Regards

Debola