Home | Contact Us | Submit Troubleshooting Info | Search | Help
Output | Software Solutions | Proofing | Color, Screening and Calibration | Scanning | Digital Photography | Consumables | POS
Home | Contact Us | Submit Troubleshooting Info | Search | Help
Output | Software Solutions | Proofing | Color, Screening and Calibration | Scanning | Digital Photography | Consumables | POS
|
|
||
Product |
Prinergy Connect 2.1 ; Prinergy Direct 2.1 ; Prinergy Access 2.1 ; Prinergy Powerpack 2.1 ; 3.0.3.0 | |
Platform |
Intel |
|
Operating system |
Windows 2000 |
|
|
|
||
Error |
E 09Feb06 15:26:00.312-PST [5040.1876] BIRD AraxiLab PPurgeJTP iDBIF_ThrowDBException.cpp(96): A database-related error occurred; [SERVERERROR] Error from Server: ORA-01455: converting column overflows integer datatype rw err = 5; db err #1 = 1455; db err #2 = 0; db msg #1 = 'AraxiDBServer' |
|
|
|
||
Symptoms |
The system was upgraded to 3.1.0.0 and when they attempt to purge jobs, they get the error shown. or The system was downgraded from 3.1.0.0 to 3.0.3.0 or lower after archives were done in Prinergy 3.1.0.0 and after downgrading back to 3.0.3.0, purge fails with the error shown. |
|
|
|
||
Cause |
In Prinergy 3.1, the CRC value can be larger than a signed integer, however, in Prinergy 3.0.3 and below, CRC values larger than a signed integer are not allowed. | |
|
|
||
Solution |
To fix the problem after upgrading to 3.1.0.0: Change any CRC value less than 0 within the DBCS_ArchiveFile table to a positive number. 1) Start SQLPLUS from a command prompt window. - D:\> sqlplus prinergy/araxi@araxidbserver 2) Update the database. - SQL> UPDATE DBCS_ArchiveFile SET archivefilecrc = archivefilecrc + 4294967296 WHERE archivefilecrc < 0; 3) Commit the transaction. - SQL> commit; 4) Exit SQLPLUS 5) Check that purging is now successful. --------------------------------------------------------------------- --------------------------------------------------------------------- To fix the problem after downgrading to 3.0.3 or lower: Change any CRC value greater than 2147483647 within the DBCS_ArchiveFile table to a negative value. 1) Start SQLPLUS from a command prompt window. - D:\> sqlplus prinergy/araxi@araxidbserver 2) Update the database. - SQL> UPDATE DBCS_ArchiveFile SET archivefilecrc = archivefilecrc - 4294967296 WHERE archivefilecrc > 2147483647; 3) Commit the transaction. - SQL> commit; 4) Exit SQLPLUS - SQL> exit; 5) Check that purging is now successful. Permanent fix: |
|
|
|
||
See also |
||
|
|
||
Keywords |
archiver, archiver - retrieve, oracle |
|
|
|
||
Technical contact(s) |
Stan Yoshida |
|
Submitted by |
Stan Yoshida |
|
Date submitted |
17 Feb 2006 |
|