Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Migration and Modernization
E-Business Suite
PeopleSoft Enterprise
JD Edwards World
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums



Primavera P6 Enterprise Project Portfolio Management

Primavera error The database has not been configured to run background

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 - 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 - 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.

Related Links

information related primavera progress reporter
Cost loading in P6
Unable to login P6 R8.2 Professional Application
No of Users in Primavera - Web ??
Application Error - Impossible to login with windows client
Error 500--Internal Server Error in a Project Gantt Chart portlet
How to prevent certain Users from deleting a resource while in the project?
Print Error in Primavera P6 R8.1
Controlling the project complete percentage -- Actual versus Elapsed
Getting an Event error code while importing the excel sheet to primavera P6
P6 API Install - RMI Configuration
Exception EAccessViolation
Primavera Progress Reporter (Timesheets)
display language setting
P6 R8.2 Web Services