My Oracle Support Banner

E1:ORCH: Getting "Failed to obtain a DB connection from data source 'E1QuartzDataSource':java.sql.SQLException" Error Message when Attempting to Start the Quartz Scheduler for the First Time. (Doc ID 2730930.1)

Last updated on AUGUST 13, 2021

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.

Symptoms



When attempting to start the Quartz Scheduler  (resilience) for the first time getting "Failed to obtain a DB connection from data source 'E1QuartzDataSource':java.sql.SQLException:Connections could not be acquired from underlying database?" error message.

Error:

message": "Failure obtaining db row lock: ORA-01950: no privileges on tablespace 'QUARTZ_DV_USER'\n",
  "exception": "LockException",
  "timeStamp": "2020-10-16T08:53:13.282-0600"


POPUP error:

Failed to obtain a DB connection from data source 'E1QuartzDataSource':java.sql.SQLException:Connections could not be acquired from underlying database?


AIS debug:

Nov 2020 11:39:41,609[MANDATORY][AIS]Request Monitor START - Starting orchestration monitor user session 03 Nov 2020 11:39:41,622[WARN][AIS]E1.Scheduler AutoStart START at Tue Nov 03 11:39:41 MST 2020 03 Nov 2020 11:39:41,623[WARN][AIS]E1.Scheduler AutoStart config properties are valid. 03 Nov 2020 11:39:44,918[MANDATORY][AIS]*** AIS Server Startup Initialization Complete *** 03 Nov 2020 11:39:46,072[MANDATORY][STUDIO]*** Studio Startup Initiated *** 03 Nov 2020 11:39:46,075[MANDATORY][STUDIO]*** Studio Startup Initialization Complete *** 03 Nov 2020 11:40:07,440[SEVERE][AIS]E1.Scheduler Resilient Scheduler DB Config Exception:  java.sql.SQLException: ORA-28000: the account is locked03 Nov 2020 11:40:49,756[MANDATORY][AIS]E1.Scheduler AutoStart Quartz Started Successfully During Autostart Startup 03 Nov 2020 11:41:09,764[WARN][AIS]E1.Scheduler AutoStart Proceeded after waiting 0 minutes and 20 seconds waiting for successful ping. Ping count 1. Additional Scheduler Start Wait of 10000. Additional Final Wait of 20000 03 Nov 2020 11:41:09,766[WARN][AIS]E1.Scheduler AutoStart config properties are valid. 03 Nov 2020 11:41:10,52



Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.