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


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


Diag shows ORA-01422: exact fetch returns more than requested number of rows


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 19Oct05 10:34:07.859-PDT [7348.9256] YCS158-75 ARAXI PMainDirectoryD iDBIF_ThrowDBException.cpp(96): A database-related error occurred; [SERVERERROR] Error from Server: ORA-01422: exact fetch returns more than requested number of rows

ORA-06512: at "PRINERGY.DBCS_REGFILE_I", line 50

ORA-06512: at line 2

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

E 19Oct05 10:34:07.921-PDT [7348.9256] YCS158-75 ARAXI PMainDirectoryD iJKDR_RegisterDistortionProfileWithSystemOpImpl.cpp(378): Error 1004050; [SERVERERROR] Error from Server: ORA-01422: exact fetch returns more than requested number of rows

ORA-06512: at "PRINERGY.DBCS_REGFILE_I", line 50

ORA-06512: at line 2

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


Symptoms

 

The main directory daemon crashes with the error shown.


Cause

  There may be duplicate entries in the database for the same web growth profile.

i.e. DBCS_RegisteredFile table contains two rows that have the same pathId of the web growth profile. When main directory daemon tries to find the regfileId of the file, it expects to get one value returned but gets more than one value.


Solution

 

Call product development to resolve the problem.

Permanent fix:


See also

 


Keywords

 

daemon, web growth [distortion]


Technical contact(s)
 

Stan Yoshida

Submitted by
 

Stan Yoshida

Date submitted
 

08 Mar 2006


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