Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

RES 3700. Database error code -141

Status
Not open for further replies.
myu0516

myu0516

IS-IT--Management
May 11, 2019
110
0
16
CA
For whatever reason, a check summary report cannot run. Checked 3700d log and found log below. Error code -141 means "Table '%1' not found" . Is there a way to see which table is not found? Thanks!

[pre]Mon Jan 2 12:04:01 2023 | MICROSPOS | AutoSeqServer | 0 | Autosequence 10310 step 1 of type R has begun. |
Mon Jan 2 12:04:01 2023 | MICROSPOS | AutoSeqServer | 0 | 40_Col Employee Check Summary |
Mon Jan 2 12:04:01 2023 | MICROSPOS | Autosequence.dll | 0 | WaitForSingleObject( g_hmutex, 60000 ) |
Mon Jan 2 12:04:01 2023 | MICROSPOS | Autosequence.dll | 0 | Signaled - Continuing After Waiting For Mutex [g_hmutex] was signaled. |
Mon Jan 2 12:04:01 2023 | MICROSPOS | Autosequence.dll | 0 | Template Filename = Custom\40_col_chk_102_new.rpt |
Mon Jan 2 12:04:01 2023 | MICROSPOS | AutoSeqServer | 0 | Autosequence 10310 step 1 of type R has begun a print job...40_Col Employee Check Summary |
Mon Jan 2 12:04:02 2023 | WKS-09 | PrintAdapter | 0 | DoTimeoutProcessing: Deleting orphaned job [MICROSPOS Task 61466 Gen 0][2821781][C3700_JOB_TERMINATED] |
Mon Jan 2 12:04:02 2023 | WKS-09 | PrintAdapter | 0 | DoTimeoutProcessing: Deleting orphaned job [MICROSPOS Task 61463 Gen 0][2821781][C3700_JOB_TERMINATED] |
Mon Jan 2 12:04:02 2023 | WKS-09 | PrintAdapter | 0 | DoTimeoutProcessing: Deleting orphaned job [MICROSPOS Task 61462 Gen 0][2821766][C3700_JOB_TERMINATED] |
Mon Jan 2 12:04:02 2023 | WKS-09 | PrintAdapter | 0 | DoTimeoutProcessing: Deleting orphaned job [MICROSPOS Task 61461 Gen 0][2821765][C3700_JOB_TERMINATED] |
Mon Jan 2 12:04:05 2023 | MICROSPOS | CrystalEngine | 0 | Could not export report.Failed to retrieve data from the database.
Details: [Database Vendor Code: -141 ]
Failed to retrieve data from the database.
Error in File 40_col_chk_102_new 5500_8156_{3DB729A3-517A-47CA-AFCD-21CC2423B8FF}.rpt:
Failed to retrieve data from the database.[/pre]
 
Sort by date Sort by votes
Update: figured out. Found a faulty SQL statement via profiler, turned out this location called a legacy report template that is slightly different with other location
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JimFromCanada
  • Question
RE: MICROS RES 3700: IFS error 1
Replies
6
Views
171
JimFromCanada
JimFromCanada
B
  • Question
MICROS RES 3700 - Desperate!
Replies
4
Views
355
bdavidson024
B
HDK
  • Locked
  • Question
RES 3700 Database Manager combase.dll errors crashing
Replies
1
Views
88
HDK
HDK
LeonCL
  • Locked
  • Question
Micros RES 3700 Sample Database 1
Replies
5
Views
145
Andrew Miller
Andrew Miller
GPig
  • Question
RES 3700 lab system
Replies
3
Views
184
myu0516
myu0516

Part and Inventory Search

Sponsor

Back
Top