Plus Community - for users of ACCPAC & Adagio accounting software

Welcome to the PlusCommunity forums! PlusCommunity is a gathering place for companies running Simply Accounting, ACCPAC Plus, Sage Accpac ERP (ACCPAC Advantage/ACCPAC for Windows), and Adagio Accounting.
New visitors, please click here!

Page 1 of 1 1
Topic Options
#42949 - 01/30/11 10:03 AM Accpac Dump Error - SELECT (ec=133)
adamspeak
Member


Registered: 01/11/11
Posts: 50
Loc: Maldives
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

Top
#42950 - 01/30/11 10:06 AM Re: Accpac Dump Error - SELECT (ec=133) [Re: adamspeak]
Jay Converse Administrator
Member


Registered: 07/31/00
Posts: 7750
Loc: Location, Location
What table does it happen on?
_________________________
Jay Converse
Sage 300 Whisperer

Top
#42951 - 01/30/11 10:11 AM Re: Accpac Dump Error - SELECT (ec=133) [Re: Jay Converse]
Jay Converse Administrator
Member


Registered: 07/31/00
Posts: 7750
Loc: Location, Location
Also, run Database Setup/Verify, you might have a data dictionary problem.
_________________________
Jay Converse
Sage 300 Whisperer

Top
#42953 - 01/31/11 02:28 AM Re: Accpac Dump Error - SELECT (ec=133) [Re: Jay Converse]
adamspeak
Member


Registered: 01/11/11
Posts: 50
Loc: Maldives
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.

Top
#42954 - 01/31/11 02:31 AM Re: Accpac Dump Error - SELECT (ec=133) [Re: adamspeak]
Jay Converse Administrator
Member


Registered: 07/31/00
Posts: 7750
Loc: Location, Location
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.
_________________________
Jay Converse
Sage 300 Whisperer

Top
#53936 - 05/06/19 04:01 AM Re: Accpac Dump Error - SELECT (ec=133) [Re: Jay Converse]
Seisa Tjela
Member


Registered: 03/21/05
Posts: 605
Loc: Lesotho; Southern Africa
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?
_________________________
Rgds,
SeisaT

"The greatest test of courage on earth is to bear defeat without losing heart."

Top
#53937 - 05/06/19 04:02 AM Re: Accpac Dump Error - SELECT (ec=133) [Re: Seisa Tjela]
Jay Converse Administrator
Member


Registered: 07/31/00
Posts: 7750
Loc: Location, Location
Remove it from CSAPP and DATADICT
_________________________
Jay Converse
Sage 300 Whisperer

Top
#53938 - 05/06/19 04:25 AM Re: Accpac Dump Error - SELECT (ec=133) [Re: Jay Converse]
Seisa Tjela
Member


Registered: 03/21/05
Posts: 605
Loc: Lesotho; Southern Africa
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?
_________________________
Rgds,
SeisaT

"The greatest test of courage on earth is to bear defeat without losing heart."

Top
#53939 - 05/06/19 04:26 AM Re: Accpac Dump Error - SELECT (ec=133) [Re: Seisa Tjela]
Jay Converse Administrator
Member


Registered: 07/31/00
Posts: 7750
Loc: Location, Location
PT
_________________________
Jay Converse
Sage 300 Whisperer

Top
#53940 - 05/06/19 04:33 AM Re: Accpac Dump Error - SELECT (ec=133) [Re: Jay Converse]
Seisa Tjela
Member


Registered: 03/21/05
Posts: 605
Loc: Lesotho; Southern Africa
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.
_________________________
Rgds,
SeisaT

"The greatest test of courage on earth is to bear defeat without losing heart."

Top
Page 1 of 1 1


Moderator:  Jay Converse 
Hop to: