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


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


Retrieve fails with "file is not archived" after upgrading to 3.0.2


Product

  Prinergy 3.0.2

Platform

 

Operating system

 


Error

 

Unable to process the file \\YOWIE\AraxiVolume_YOWIE_H\Jobs\CCP19030 - QANTAS CLUB 2PP\UserDefinedFolders\Imposition\19030.job; the file is not archived.[1054520]


Symptoms

 

After upgrading to 3.0.2, it could not retrieve the old 2.x jobs back, error failed with "file is not archived", but the job has been archived onto tape and the actual archive set is on the tape.


Cause

  The prinergy system is rehosted or the servername is renamed, PChangeJobShare was run to move the jobs on oldservername to newservername. The DBCD_Path table contains two sets of paths for essentially the same file.

One path is on OldServerName, and the other is on NewServerName.


Solution

 

Workaround:

Restore the job using NTbackup.

To confirm the problem, ran the following script: Take the filename that it has problem to retrieve to check the path for the file. In the below example, I take the 19030.job, see error message.

Query 1

SVRMGR> select RPAD(' ', 2*(LEVEL-1)) || pathcomponentname

2> from dbcs_path

3> start with pathid

4> in (select pathid

5> from dbcs_path

6> where pathcomponentname

7> like '19030.job')

8> connect by prior pathparentid = pathid;

Result:

RPAD('',2*(LEVEL-1))||PATHCOMPONENTNAME

--------------------------------------------------------------------------------

19030.job

Imposition

UserDefinedFolders

CCP19030 - QANTAS CLUB 2PP

Jobs

AraxiVolume_YOWIE_H

YOWIE

19030.job

Imposition

UserDefinedFolders

CCP19030 - QANTAS CLUB 2PP

Jobs

AraxiVolume_KOALA_M

KOALA

14 rows selected.

SVRMGR>

Query 2:

SVRMGR> select dbcs_paths.GetPathLocationById(pathid) from dbcs_path where pathcomponentname like '19030.job';

RESULT:

DBCS_PATHS.GETPATHLOCATIONBYID(PATHID)

--------------------------------------------------------------------------------

\YOWIE\AraxiVolume_YOWIE_H\Jobs\CCP19030 - QANTAS CLUB 2PP\UserDefinedFolders\Im

\KOALA\AraxiVolume_KOALA_M\Jobs\CCP19030 - QANTAS CLUB 2PP\UserDefinedFolders\Im

2 rows selected.

From the above queries results, you can see the same file has two location, one is \YOWIE, the other is in \KOALA.

Permanent fix:


See also

 


Keywords

 

archiver - retrieve


Technical contact(s)
 

Amy Chan

Submitted by
 

Amy Chan

Date submitted
 

4 Aug 2005


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