Hi, when I try to reinitialize Primavera job processes (system_monitor and data_monitor). I am getting following error C:\Documents and Settings\Administrator>sqlplus SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jan 27 11:32:22 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. Enter user-name: sys as sysdba Enter password: Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options SQL> exec admuser.initialize_background_procs; BEGIN admuser.initialize_background_procs; END; * ERROR at line 1: ORA-06502: PL/SQL: numeric or value error ORA-06512: at "ADMUSER.SETTINGS_READ_STRING", line 8 ORA-06512: at "ADMUSER.INITIALIZE_BACKGROUND_PROCS", line 6 ORA-06512: at line 1
Pretty sure this error does not do anything to the running of Primavera. I had this happen with a previous employer and it did nothing to the actual workings of the program. Hope this helps. Mick
Try running the procedure as the admuser account and not SYS. If that still does not work try the below: DELETE FROM settings WHERE namespace like 'database.background.Symon'; DELETE FROM settings WHERE namespace like 'database.background.Damon'; COMMIT; EXEC initialize_background_procs; COMMIT; If you still receive the error you may need to drop and rebuild the procedure.