Skip to Content
author's profile photo Former Member
Former Member

Error on database tables during the upgrade

Hi experts,

We are trying to upgrade a database from 882067 to 900056 and we are getting warning references on SAP None 1360832.

We execute the following query to verify that all UDO are correct and we get an error for the table named “@AZAM_TABLE1” saying that had a record out of values.

We checked the length of all the records on this table and everything looks fine.

SQL Query

declare @TableID nvarchar(20);

declare @AliasId nvarchar(18);

declare @EditSize smallint;

declare @RealSize smallint;

declare @statement nvarchar(max);

declare @params nvarchar(max);

declare alfa_udfs cursor for

select TableID, AliasID, EditSize from cufd where TypeID = 'A';

open alfa_udfs;

FETCH NEXT FROM alfa_udfs

INTO @TableID, @AliasId, @EditSize;

WHILE @@FETCH_STATUS = 0

After that, we checked the warning to continue the process and when the upgrade finished we got an error for another table named “@AZAM_TABLE2”, and the database must be restored.

Has anyone faced a same issue?

Thank you in advanced.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 02, 2013 at 05:22 PM

    Hi,

    What kind of UDO is this? Is it document type?

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 03, 2013 at 12:16 AM

    Hi Vassilis,

    You should get the results generated for this table / field and leave all the other line with the same size. If records are extremely important copy for a temporary table and then go back to the original table or save a copy of the database.

    Regards,

    Marcelo Silva Santos

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 03, 2013 at 12:49 AM

    Hi Vassilis,

    I suggest you to upgrade to SAP B1 9.0 PL05 and then to SAP B1 9.0 PL07. Or directly to SAP B1 9.0 PL07.

    Sometimes, we need to use trial and error in order to get the problem solved. If you have done that but the problem is not solved yet, you can directly escalate to sap global support.

    Probably you can try to drop the udo table and then upgrade again. After that, creating the UDO table again.

    Rgds,

    Jimmy

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 03, 2013 at 01:07 AM

    Hi,

    The above SAP note valid for 8.8 version. Further there is another SAP note 1494460 which explains same problem in 8.8 version.

    Please advice your existing version and updating version with PL.

    Thanks & Regards,

    Nagarajan

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.