Page 1 of 1

addtable error ABEND: exception 0xC0000005 (ACCESS_VIOLATION)

Posted: Tue Nov 11, 2014 10:00 am
by josmani
I am trying to upgrade one of our databases to from Texis version 6 32bit to version 7 64bit.

I've created a new database on the new server and when I try to use "addtable" to add the table file from the old server to new one (with -b 32 flag), I get the "ABEND: exception 0xC0000005 (ACCESS_VIOLATION)" error message and only a temp tbl file gets added to the database.

Any ideas on how to get around this error message? Many thanks.

addtable error ABEND: exception 0xC0000005 (ACCESS_VIOLATION)

Posted: Tue Nov 11, 2014 10:47 am
by Kai
What version of texis is addtable from (texis -version)?

addtable error ABEND: exception 0xC0000005 (ACCESS_VIOLATION)

Posted: Tue Nov 11, 2014 10:49 am
by josmani
Texis Web Script (Vortex) Copyright (c) 1996-2013 Thunderstone - EPI, Inc.
Commercial Version 7.00.1376340754 20130812 (i686-intel-winnt-64-32)

addtable error ABEND: exception 0xC0000005 (ACCESS_VIOLATION)

Posted: Tue Nov 11, 2014 10:52 am
by mark
If texis 6 and 7 are on different machines you can use cpdb to copy the tables across while implicitly converting.

addtable error ABEND: exception 0xC0000005 (ACCESS_VIOLATION)

Posted: Tue Nov 11, 2014 11:16 am
by Kai
cpdb can also be used if the databases are on the same machine. You'll just need to run a cpdb (e.g. as server) from the old version 6, then copy from it with the new version 7.

addtable error ABEND: exception 0xC0000005 (ACCESS_VIOLATION)

Posted: Tue Nov 11, 2014 11:24 am
by josmani
I understand that, but as the server is behind the firewall and the cpdb port is not open yet, I thought I could use addtable.

addtable error ABEND: exception 0xC0000005 (ACCESS_VIOLATION)

Posted: Tue Nov 11, 2014 11:52 am
by Kai
Normally addtable should work; we'll have to investigate what is causing the ABEND.

In the meantime you'll have to use cpdb. You can run it on a different port than its default if another one is open through the firewall.

Or if you can copy the texis 6 (32-bit) cpdb, addtable and creatdb to the new server (that already has texis 7 and the old table), you can create a temp texis 6 db, texis-6 addtable the table there, then run texis-6 cpdb as a local server on that db, and finally copy the table locally from that db with a texis-7 cpdb client to the 64-bit db.