Normal Topic Q&A System Error 080A (Read 2059 times)
david.lyon@cgi.com
Member
*
Offline



Posts: 16
Location: Ottawa, Ontario, Canada
Joined: Jun 19th, 2006
Q&A System Error 080A
Jun 30th, 2006 at 1:27pm
Print Post Print Post  
DB Copy failed with a system error 080a.

Performed a successful recover followed by a successful null mass update.

Re-tried DB Copy but still fails with a system error 080a.

Can someone please enlighten me as to what the problem is.

Thanks

Dave

  
Back to top
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Q&A System Error 080A
Reply #1 - Jun 30th, 2006 at 1:32pm
Print Post Print Post  
Dave,

A complete list of the Q&A Error Codes as provided to the Q&A User Group can be downloaded from here:
http://www.qaug.com/qafiles/errcodes.zip

Meanwhile, here is the list of 08 codes.

-----------------------------------------------------
ERROR CODES - 08??

These errors typically indicate problems with the report module and Program Spec. They are often not fatal to the database and can often be repaired using the recommended procedures.

Possible solutions:
Re-compile the Program Spec (or Derived Columns screen) by making
    a change to it then pressing F10. If that doesn't work, try
    simplifying the spec until the problem disappears.
Check access rights to Temp File Subdirectory if the error is
    related to temp files
Try Copy Design/Records.

Below is a listing of all known 08?? error codes. If you encounter an error code that is not on this list, please contact Technical Support for assistance.
Many of these codes are described with very cryptic meanings. Do not be concerned if their meaning is undecipherable. Try the suggested solutions and then call Technical Support for assistance if necessary.

Error         Meaning
0801          Unexpected op-code.
0803          @Mod produced a negative result.
0805          Bad FF-code encountered.
0808,09,0A    Syntax error.
080B          Error parsing Column/Sort Spec.
080C,0D       Buffer overflow or underflow.
080E,0F       Problems in memory.
0810          Out of memory.
0811          Buffer already started.
0812,13       Negative "lng" passed to function.
0814          Unexpected zero in Global cpiSp. (?)
0815,16,17    Unexpected return value.
0818          Unexpected null colp. (?)
081F,20-27    Error creating, reading, writing, or deleting a
             temp file.
082F          Upgrade failure. (?)
0840          Error in Derived Column.
0841          Error in CCHelp.
0872          Insufficient length for phanerosource. (cool name)
0873          Illegal data type.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
david.lyon@cgi.com
Member
*
Offline



Posts: 16
Location: Ottawa, Ontario, Canada
Joined: Jun 19th, 2006
Re: Q&A System Error 080A
Reply #2 - Jun 30th, 2006 at 2:49pm
Print Post Print Post  
So I've narrowed the problem down to report specs (deleted all report specs and problem disappeared) but can not identify which ones are causing the problem (it is multiple specs causing the problem).

Any suggestions on how to proceed.
  
Back to top
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Q&A System Error 080A
Reply #3 - Jun 30th, 2006 at 6:08pm
Print Post Print Post  
Quote:
Re-compile the Program Spec (or Derived Columns screen) by making 
    a change to it then pressing F10. If that doesn't work, try 
    simplifying the spec until the problem disappears.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Q&A System Error 080A
Reply #4 - Jul 1st, 2006 at 3:18am
Print Post Print Post  
1.  Make a copy of the database.  Perform next steps on the copy
2.  Verify you are getting the error code - (when does this happen?)
3.  Delete Report Spec 1
4.  See if you still get the error code.
.....YES, Repeat again at Step 3
.....NO ...That is good, you have just identified the report that causes the problem
5.  Make another copy of the original database
6.  Go into the Report Spec that was last deleted above and review all specs of the report
Be sure to check all four pages of derived columns, there are 16 possible formulas
Also Check Page Specs for Header/Footer that can also have programming and can reference derived columns
7.  Keep checking until you no longer get the errors.
8.  When you get this resolved, then go back into the original file and make the appropriate changes.
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged