Error on database tables during the upgrade

[Former Member]

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.

[kothandaraman_nagarajan]

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

[former_member186095]

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

[Former Member]

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

[Former Member]

Hi,

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

Thanks,

Gordon