Topic Options
#53959 - 06/13/17 10:29 AM AP data conversion error 2406 in upgrade to 9.2B
JohnDilworth Offline
Adagio Buff

Registered: 10/13/10
Posts: 53
Loc: Orlando, FL USA
I am converting data from AP 8.1F to 9.2B
During the conversion I get a message "Error 2406 occurred when attempting to add record to check audit list".
So then I tried upgrading to 9.2A first and it was successful. I ran data integrity and it showed no errors. Then I tried upgrading to 9.2B and I got the same error. After that it says the conversion failed. What is going wrong here?

Top
#53962 - 06/13/17 10:56 AM Re: AP data conversion error 2406 in upgrade to 9.2B [Re: JohnDilworth]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11321
Loc: Vancouver, BC Canada
Hi John,

I've seen this error a couple of times with this file. In version 9.2B of Payables, file structure changed in a number of places, including the check number audit list file. This file gets converted to a slightly new layout in 9.2B, to support more information, and has not changed for a long time and may not have been purged for a long time.

In the cases where this error has occurred, there has been corruption in the file, and conversion fails. In both cases, there was a considerable chunk of records that were random ASCII characters, rather than just a character or two.

If you have GridView Read/Write, you could choose to create an inquiry on the check number audit list file, locate the bad rows, and delete them. It's likely that the corruption was well in the past. Otherwise, before you do the conversion to 9.2B, you would need to manually remove the APCAUD data file, open Payables at the 8.1F (or 9.2A) version to replace the missing file, then perform the conversion to 9.2B.
_________________________
Regards,
Softrak Tech Support

Top
#53964 - 06/13/17 11:58 AM Re: AP data conversion error 2406 in upgrade to 9.2B [Re: Softrak Support]
JohnDilworth Offline
Adagio Buff

Registered: 10/13/10
Posts: 53
Loc: Orlando, FL USA
OK that works. Thanks.

Top


Moderator:  Christa_Meissner 
Who's Online
1 registered (Carol Wojick), 69 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1848 Members
5 Forums
14239 Topics
69736 Posts

Max Online: 359 @ 11/18/19 09:08 PM
May
Su M Tu W Th F Sa
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31