Data activation error when activating IC 5.5A

[winstz]

Hi all,

I am testing to upgrade ACCPAC ERP 500 5.3A to ACCPAC ERP 500 5.5A.

I have do all the upgrading step but i have an error when activate Inventory Control in Data Activation ACCPAC 5.5A

Here is the screenshot :

http://img87.imageshack.us/my.php?image=erroric.jpg

Please help me how to solve this error.

Thanks.

 

[winstz]

somebody help me please

 

[Jay Converse]

Use this method:

http://community.sageaccpac.com/forums/t/535.aspx

 

[winstz]

here is the error when i load old company dump (5.3A) to ACCPAC 5.5A with .DCT from the empty company (5.5A) with identical module activated.

http://img4.imageshack.us/img4/2866/errorload.gif

any solution ? thanks.

 

[Jay Converse]

Which collation order?
Which version of SQL?
Which ODBC driver?

 

[winstz]

my collation is SQL_Latin1_General_CP1_CI_AS
my SQL version is SQL Server 2005 Standard Edition
my ODBC driver is SQL Server
is it ok?

 

[Jay Converse]

That sounds normal. But since it's crashing on the very first table, maybe you should try case sensitive. I'm really not sure at this point, you're having a very unusual problem.

 

[ettienne]

The error "invalid character value for cast specification" normally means there is unexpected data in a field, like a messed up date value or something like that.
But wait... are you loading 5.3 data using a DCT file from a 5.5 dump??? That's not gonna work.

 

[Jay Converse]

Exactly, I missed that. When you use this method

http://community.sageaccpac.com/forums/t/535.aspx

you have to make an empty company with the _exact_ modules installed.

 

[winstz]

hi ettienne,
i do the method suggested by tuba2007 :

http://community.sageaccpac.com/forums/t/535.aspx

if that's not gonna work, what should i do ?
here is my error when activating Inventory Control in ACCPAC 5.5A :

http://img87.imageshack.us/my.php?image=erroric.jpg

any solution ?
thanks.

 

[ettienne]

The instructions are good, but create the new company in 5.3.
It will not work if you create the new company in 5.5.

 

[winstz]

@ettienne : ok, i will try... thanks.

 

[winstz]

finally inventory control 5.5a data activation is success.

my steps for migrating to 5.5a :
1. dump old company data (5.3a)[all AR, AP, AM transactions have been posted]
2. dump new empty company with the same modules activated in accpac 5.3a
3. replace .DCT file in old company with the .DCT file from new empty company
4. load old company to accpac 5.5a

thanks tuba2007 and ettienne.