adamspeak
(Member)
01/30/11 10:03 AM
Accpac Dump Error - SELECT (ec=133)

Hi

Has anyone got an idea why below error is popping up when trying to take an accpac dump.
If any idea how to overcome?

SELECT (ec=133)

Accpac version is 5.4 and the database is pervasive 9.5

Thanks & regards
Udara


Jay ConverseAdministrator
(Member)
01/30/11 10:06 AM
Re: Accpac Dump Error - SELECT (ec=133)

What table does it happen on?

Jay ConverseAdministrator
(Member)
01/30/11 10:11 AM
Re: Accpac Dump Error - SELECT (ec=133)

Also, run Database Setup/Verify, you might have a data dictionary problem.

adamspeak
(Member)
01/31/11 02:28 AM
Re: Accpac Dump Error - SELECT (ec=133)

Thanks Jay, but can you please give a little help with the sequence of the process please? how to run a verification?

Not sure about the table as it is not giving much details. however this pops up when taking the DAT dump.


Jay ConverseAdministrator
(Member)
01/31/11 02:31 AM
Re: Accpac Dump Error - SELECT (ec=133)

Start
Run
Sage Accpac
Database Setup
Select the company
Verify

For the table, it's giving lots of details. Read the table names on the screen.


Seisa Tjela
(Member)
05/06/19 04:01 AM
Re: Accpac Dump Error - SELECT (ec=133)

Hello Jay,

I have just ran into similar problem with my client who is running Sage 300 2018. I believe it fails on table "PTACCT". The Client has Pacific Technologies Purchasing Workflow module that was never implemented. I suspect that it must have been installed in prior versions, but it's not installed with 2018. How do I ensure that the Database Dump or Verification does not reference this file?


Jay ConverseAdministrator
(Member)
05/06/19 04:02 AM
Re: Accpac Dump Error - SELECT (ec=133)

Remove it from CSAPP and DATADICT

Seisa Tjela
(Member)
05/06/19 04:25 AM
Re: Accpac Dump Error - SELECT (ec=133)

I can't remember what the application selector or Program ID is. Can you please remind me what the Program ID is for Pacific Audit Logger and Workflow?

Jay ConverseAdministrator
(Member)
05/06/19 04:26 AM
Re: Accpac Dump Error - SELECT (ec=133)

PT

Seisa Tjela
(Member)
05/06/19 04:33 AM
Re: Accpac Dump Error - SELECT (ec=133)

Thank you very much, Jay.

The problem was in the DATADICT table. I cleared/deleted the tables with prefix "PT" and Database Verify is now clean.