Home | Contact Us | Submit Troubleshooting Info | Search | Help


    Output | Software Solutions | Proofing | Color, Screening and Calibration | Scanning | Digital Photography | Consumables | POS


(2.0) Archiver fails with a database-related error


Product

  Prinergy Connect 2.0

Platform

 

Intel

Operating system

 

Windows 2000 Server


Error

 


Symptoms

 

When trying to archive to two pools, archiver fails with a database-related error, see error below :

E 17Oct01 12:05:52.015-PDT [4664.3292] YCS707-341 ARAXI PArchRetJTP.ArchiveThread: 3292 iDBIF_ThrowDBException.cpp(96): A database-related error occurred; [SERVERERROR] Error from Server: ORA-00600: internal error code, arguments: [25012], [2], [788], [], [], [], [], []

rw err = 5; db err #1 = 600; db err #2 = 0; db msg #1 = 'AraxiDBServer'

E 17Oct01 12:05:52.031-PDT [4664.3292] YCS707-341 ARAXI PArchRetJTP.ArchiveThread: 3292 AJTP_ArchiveService.cpp(357): Unexpected COMN exception caught = code = 1004050; developer-speak message = '[SERVERERROR] Error from Server: ORA-00600: internal error code, arguments: [25012], [2], [788], [], [], [], [], []

rw err = 5; db err #1 = 600; db err #2 = 0; db msg #1 = 'AraxiDBServer''; source file = Cannot Determine File Context; localized message = '( code = 1004050 )'


Cause

  An Oracle problem causes the Archive/Retrieve JTP to fail with an Oracle error when it fetchs from the Archive Medium table, and in a different (but simultaneous) transaction, updates the two columns in the Archive Medium table that hold the tape's remaining freespace.

The problem occurrs when there is only a single row in the Archive Medium table (although there may be other circumstance under which this problem occurs). The problem disappears when the index on these two columns is eliminated.


Solution

 

Temporary workaround:

1. Go to a DOS prompt and type "sqlplus prinergy/araxi" to log in to SQL.

2. At SQL> type "drop index DBCS_ARCHMEDM_FREESPACE_IDX1;". This will drop the index for the archiver freespace table.

3. Type "exec DBCS_compileobjects;".

Permanent fix: Prinergy 2.0


See also

 


Keywords

 

archiver


Technical contact(s)
 

Amy Chan

Submitted by
 

Amy Chan

Date submitted
 


    Copyright © 2005 Creo Inc. All rights reserved. Confidential. Back to top.