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

(Doc ID 1207383.1)

Last updated on MAY 30, 2017

Applies to:

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

Symptoms

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
INITIALIZING SECURITY SERVER KERNEL

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

Cause

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 hundreds of Community platforms