Product

Kodak^® Prinergy^® Connect^™, version 4.x

Operating system

• Microsoft^® Windows^® 2000 Server
• Microsoft Windows Server^® 2003

Error

01-Apr-2008 21:47:05 ERROR: Update Prinergy Update 4.1.0.0 b installation failed! ***
01-Apr-2008 21:47:05 ERROR: Cause: exceptions.Exception Error: Failed to upgrade database schema.
Details: exceptions.Exception Error: Failed to upgrade database schema 157 to 158.
...
Starting anonymous block...
Dropping index DBCS_HISTLOGDETAIL_IDX2
=> Done.
Re-creating index DBCS_HISTLOGDETAIL_IDX2 ( JCKDID, HISTLOGDETAILCREATEDTM )
ERROR: exception occurred; SQLCODE = -1187
SQLERRM = ORA-01187: cannot read from file 65 because it failed verification

Symptoms

The upgrade fails on the emergency platemaking (EPM) server and the error message appears in the Prinergy Update (PPU) log file.

Cause

The DBCS_HistoryDetail table is corrupt.

Solution

Run the makefile SQL command.

Important: Apply this solution only on an EPM server. The makefile SQL script rebuilds all the tables and indexes for the database and removes all data.

1. On the EPM server, open a command-prompt window.
2. Change the directory to \%araxihome%\CreoAraxi\setup\Config\Sql
3. Type sqlplus prinergy/araxi@araxidbemergencyserver
4. Type @makefile.sql;

The system rebuilds the tables and indexes in the database and removes all the data.
5. At the sql> prompt, type exec dbcs_compileobjects;
6. Locate the \%AraxiHome%\CreoAraxi\support\patches\admin folder, and delete the PPURetryPreventionFlag.txt file.
7. Perform the Prinergy upgrade again.

Keywords

upgrades, EPM

Technical contact(s)

Submitted by

Date submitted

03 Apr 2008