My Oracle Support Banner

E1: KER: EnterpriseOne 9.0 Services Fail when Using Independent Auxiliary Storage Pool (IASP) (Doc ID 1207383.1)

Last updated on SEPTEMBER 26, 2018

Applies to:

JD Edwards EnterpriseOne Tools - Version SP23 and Prior and later
IBM i on POWER Systems


EnterpriseOne is installed using IBM's Independent Auxiliary Storage Pool (IASP).  E1 services fail to start and the log shows the following errors:

456/9 MAIN_THREAD Fri Aug 27 10:37:11.284768 jdeksec.c778

456/9 MAIN_THREAD Fri Aug 27 10:37:11.417792 dbdrv_log.c196
OS400QL017 - PrepareAndOrDescribe:Prepare failed. QSQLMSG *LIBL - SQL0204 - &1 in &2 type *&3 not found

After addressing the above error, HTML/Web clients cannot connect and JAS logs show the following error:

01 Sep 2010 22:09:16,156 [SEVERE] - [BASE] com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 900. java.sql.SQLException: The application requester cannot establish the connection. (TAKEOVERIP).




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

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

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