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
#53204 - 09/06/17 02:53 PM DB Dump Error - Select (ec-133)
Daboys
Member


Registered: 08/17/05
Posts: 346
Loc: USA
Sage 2016
SQL

When running a DB Dump I get the error.

DBSpy list the following:

13:49:31.41 CLOSE-TABLE ( handle=ASACTLOG-0 )
13:49:31.41
13:49:31.41 GET-TABLE-INFO ( table=ASUSER )
13:49:31.41
13:49:31.41 GET-FIELD-NAMES ( table=ASUSER , flags=1, bfrsize=5110 )
13:49:31.41 count <-- 2
13:49:31.41 GET-FIELD-INFO ( table=ASUSER , field=USERID )
13:49:31.42
13:49:31.42 GET-FIELD-NAMES ( table=ASUSER , flags=1, bfrsize=5110 )
13:49:31.42 count <-- 2
13:49:31.42 GET-FIELD-INFO ( table=ASUSER , field=USERNAME )
13:49:31.42
13:49:31.42 GET-KEY-INFO ( table=ASUSER , keyno=0 )
13:49:31.42
13:49:31.42 OPEN-TABLE ( table=ASUSER , flags=1 )
13:49:31.42 handle <-- 0
13:49:31.42 SELECT ( handle=0, filter=<NULL>, keyno=0, ascending=1 )
13:49:31.42 ==> 133 <DBS_TABLE_NOT_FOUND>
13:49:31.43 GET-HANDLE-INFO ( handle=ASUSER-0 )
13:49:31.43
13:49:31.43 CLOSE-TABLE ( handle=ASUSER-0 )
13:49:31.43
13:49:31.45 UNLINK ( )


Any ideas?
Thank you

Top
#53205 - 09/06/17 02:55 PM Re: DB Dump Error - Select (ec-133) [Re: Daboys]
Jay Converse Administrator
Member


Registered: 07/31/00
Posts: 7536
Loc: Location, Location
It's not a valid database, or its data dictionary is corrupt. Run Database Setup/Verify on it.

Edited by Jay Converse (09/06/17 02:55 PM)
_________________________
Jay Converse
Sage 300 Whisperer

Top
#53206 - 09/06/17 03:04 PM Re: DB Dump Error - Select (ec-133) [Re: Jay Converse]
Daboys
Member


Registered: 08/17/05
Posts: 346
Loc: USA
Thank you. It came back clean.

0 error(s) found in total.

This is a live database that is operating without issues. Any other way to fix this?

Thank you

Top
#53207 - 09/06/17 03:17 PM Re: DB Dump Error - Select (ec-133) [Re: Daboys]
Jay Converse Administrator
Member


Registered: 07/31/00
Posts: 7536
Loc: Location, Location
I've never seen this problem on a good production database.
_________________________
Jay Converse
Sage 300 Whisperer

Top
#53208 - 09/06/17 03:19 PM Re: DB Dump Error - Select (ec-133) [Re: Jay Converse]
Daboys
Member


Registered: 08/17/05
Posts: 346
Loc: USA
Thank you Jay. I will dig deeper and report back.
Top
#53211 - 09/07/17 09:21 AM Re: DB Dump Error - Select (ec-133) [Re: Daboys]
Daboys
Member


Registered: 08/17/05
Posts: 346
Loc: USA
Not sure how but a table was added to the database - ASUSER. This table only had two fields in it, user id's and user names. The "table" name was in the following format "DOMAIN\User.ASUSER". In the table DATADIC it was looking for the table ASUSER. So when I deleted the table "DOMAIN\User.ASUSER" the DB dump still didn't work because it was looking for the table ASUSER. I had to remove that row in the DATADIC table.

I have no idea how all this happened. How did this table get added, no idea.

Everything is working now after my edits.
Thank you

Top
Page 1 of 1 1


Moderator:  Jay Converse 
Hop to: