Accpac Profile Error

[trmeupey]

Hi,
I'm tryng to Open Accpac but I'm getting the following message error when I try to open my company database.
"Accpac Profile for database "XXXXXX" appears to be corrupt or incompatible".
Accpac 5.5
SQL 2008.
Thank you for your support.

Thomas

 

[ettienne]

Run Scan Isam: click start, programs, accpac, tools, scan isam OR click start, run and type in scanisam and click OK.
See if it reports any errors.

 

[trmeupey]

Hi Ettienne,
I ran the scanISAM utility but no error reported.
I'm stiil getting the message when when opening the company database.

 

[Jay Converse]

Run Dbspy as you open the company, look for SQL errors.

 

[trmeupey]

Hi Tuba,
Please find below the dbspy Log

======================================================================
DBSpy Log Date: 08-17-2012 Time: 12:44:07.71
======================================================================

Link 0: GADATA, AS9010; Read-Only - CLOSED
12:43:19.50 GET-DRVR-INFO ( )
12:43:19.50
12:43:19.50 OPEN-TABLE ( table=CSAPP , flags=0 )
12:43:19.50 handle <-- 0
12:43:19.50 SELECT ( handle=0, filter=<NULL>, keyno=0, ascending=1 )
12:43:19.50
12:43:19.50 FETCH ( handle=0, fetch=20 )
12:43:19.50 fetched <-- 20
12:43:19.50 FETCH ( handle=0, fetch=20 )
12:43:19.50 ==> 121 <DBS_NO_MORE_DATA>, fetched <-- 6
12:43:19.50 CLOSE-TABLE ( handle=0 )
12:43:19.50
12:43:19.77 OPEN-TABLE ( table=CSCOM , flags=1 )
12:43:19.77 handle <-- 0
12:43:19.77 GET ( handle=0, keyno=0 )
12:43:19.77 ==> (DBERROR=490712523)
12:43:19.77 CLOSE-TABLE ( handle=0 )
12:43:19.77
12:43:19.77 OPEN-TABLE ( table=CSCOM , flags=1 )
12:43:19.77 handle <-- 0
12:43:19.77 GET-GE ( handle=0, keyno=0, filtersegs=0, expdrecs=1 )
12:43:19.77 ==> (DBERROR=490712523)
12:43:19.77 CLOSE-TABLE ( handle=0 )
12:43:19.77
12:43:21.38 UNLINK ( )

 

[Jay Converse]

Run Accpac Database setup, and look at the SQL account used. Then, login to SQL Enterprise Manager with that account, and see if you can see anything.

 

[trmeupey]

SA account is used in Accpac Database setup
I can connect to SQL enterprise Manager with the same account and see the files.

 

[Jay Converse]

In Accpac database setup, edit that company and re-enter the SA password.

 

[trmeupey]

I did it but no change. I still cannot open the company.
The same error is displayed.

 

[Jay Converse]

Run Database Setup/Verify

 

[ettienne]

Edit the system db as well and re-enter the SA password.

 

[trmeupey]

Still not OK after re-entering the password for system database.

 

[Jay Converse]

Run Database Setup/Verify

 

[trmeupey]

Already done. No error.

 

[Jay Converse]

Reboot the server

 

[ettienne]

I'm reaching here.... could "Accpac Profile for database "XXXXXX" appears to be corrupt or incompatible" be referring to the user ISM files under the USER folder?
Maybe network permissions - try log in as a different network user.
Maybe a corrupted Accpac user profile - try log in to Accpac as a different Accpac user.

 

[trmeupey]

I tried another user without success.
Even after reboot of server.

 

[Jay Converse]

Run SQL Profiler as you try to login.

 

[Jay Converse]

FWIW, the error "appears to be corrupt or incompatible" has appeared only once on the Accpac technical forum, and that was in 2004 for version 5.0 on SQL 2000. That person had set up his database with a SQL restore, instead of following the steps in the documentation.

 

[trmeupey]

This is my case.
This a SQL restored database.