1. BI Publisher for JD Edwards EnterpriseOne Guide
  2. Query Builder Does Not Load JD Edwards EnterpriseOne Tables

Query Builder Does Not Load JD Edwards EnterpriseOne Tables

Error: Query Builder throws the error "Could not load schema information. Please make sure that this connection is active." This error occurs even though the JDBC data source test connection is successful. The error occurs with or without Proxy Authentication in the JDBC Data Source.

Cause: The e1root log represents that the log in credentials are incorrect in [JDBj-BOOTSTRAP SESSION] section of jdbj.ini, as shown below.

06 Dec 2011 17:47:58,000 [SEVERE] - [JDBJ] Sign on: valid = 
false
Sign on: status = 2
Sign on: error message ID = 331

Solution: To resolve this issue, ensure that you entered valid user, password, role and environment parameters in the [JDBj-BOOTSTRAP SESSION] section. There should not be any blanks.

For example:

[JDBj-BOOTSTRAP SESSION]
role=*ALL
user=JDE
password=xxxxxxxx
environment=JPD900

Additionally:

  • Use Server Manager to enter the password, so that it will be encrypted properly. If you enter the password directly in jdbj.ini, it will not be encrypted. An unencrypted password will cause issues in Query Builder.

  • The JDBC data source connection string should use the same environment as the one in the [JDBj-BOOTSTRAP SESSION] section. Otherwise the test connection will fail.

  • After making changes to the jdbj or jas.ini files, restart the BI server to make the changes effective.