Upgrade SAP B1 8.82 PL09 to SAP 9.0 PL04 fails in Intrastat Wizard

[PedroMariano]

Hi All,

I'm trying to upgrade a DB from 8.82 PL09 to 9.0 PL04 but with no success: the upgrade fails in Intrastat Wizard.

Knowing that B1 9.0 already has the Intrastat in its core, I removed the Add-On from the DB in 8.82 and tried the upgrade again but with no more luck than the previous try.

I got the following error:

28/06/2013  15:47:52:757227

Sys

Err

I

Biz

Business Object Flow: Upgrade failed, err number is -10 # #

TID=2360

_BusinessObjectMethods.h

36

ID=19dc54e8

BO=Intrastat Wizard

Customized=0

28/06/2013  15:47:52:757227

Upg

Err

FromVersion=882072

ToVersion=900056

UPG_DoObjectUpgradeInt 2, error in object index=469, object name=Intrastat Wizard, object ID=1470000047, error code=-10

Has anyone already gone through this or know what have to be done?

Thanks in advance,

Best regards,

Pedro Mariano

[kothandaraman_nagarajan · Accepted solution]

Hi,

It is an application error.

Please refer SAP notes:

1871964 - Database upgrade fails to version 9.0 with Intrastat
Add-on installed

Symptom

Database upgrade to version 9.0 fails with an error message:
[Err FromVersion=<> ToVersion=<> UPG_DoObjectUpgradeInt 2, error in
object index=469, object name=Intrastat Wizard, object ID=1470000047, error
code=-10 Year 2005, Month 0 and Day 1 do not make a valid date.]

Prerequisites:

You are upgrading database from version prior to 9.0 with Intrastat Add-on
installed.

Cause

Application error

Solution

SAP intends to provide a patch or patches in order to solve the problem
described.

The section Reference to Related Notes below will list the
specific patches once they become available.

The corresponding Info file of the patches in SAP Service
Marketplace will also show the SAP Note number.

Be aware that these references can only be set at patch release date.

SAP will deliver patches only for selected releases at its own discretion,
based on the business impact and the complexity of the
implementation.

Hope helpful.

Thanks & Regards,

Nagarajan

[PedroMariano]

Thanks Naja,

The error is corrected in 9.0 PL 06, as is in note 1884044.

Best regards,

Pedro Mariano

[Former Member]

Hi Pedro,

Please check the files in..

C:\Users\pedro\Local Settings\Application Data\SAP\SAP Business One\Log\UpgradeWizard

Note: the path may change according to your OS

In this directory you can get more information about what is happening. Can also debug files in order to find the error. But to find the error zip the directory and place attached to see if we can help you or contact with SAP (local partner) and make a call. If possible remove the add-on and comment on TransactionNotification and run the following command to check the fields of users.

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

BEGIN

IF  EXISTS (SELECT * FROM sys.tables WHERE name = @TableId)

BEGIN

set @RealSize = 0

set @params = '@RealSizeOut smallint output';

set @statement = 'select @RealSizeOut = max(len(U_' + @AliasID + ')) from [' + @TableId + '] where U_' + @AliasID +' is not null';

EXECUTE sp_executesql @statement, @params, @RealSizeOut = @RealSize OUTPUT;

if @RealSize is not null

BEGIN

if @EditSize < @RealSize

BEGIN

select @TableID As TableName, 'U_' + @AliasId As UDFName, @RealSize As RealSize, @EditSize As DefinedSize

END

END

END

FETCH NEXT FROM alfa_udfs

INTO @TableID, @AliasId, @EditSize;

END

CLOSE alfa_udfs;

DEALLOCATE alfa_udfs;

or

1357462  - Upgrade Wizard Precheck: Collective note for all check items

1846125  - Upgrade of DB with Intrastat from 8.82 to 9.0 failed - OCRD

1871964 - Database upgrade fails to version 9.0 with Intrastat Add-on installed

Regards,

Marcelo Silva Santo