Receiving "[SECURITY_ERROR] A Security Error Occurred"
These errors occur when you create models in Oracle BI Publisher Enterprise using JD Edwards EnterpriseOne tables.
Data Access Driver (DAD) logs contain the following messages:
Sign on: valid = false Sign on: status = 17 Sign on: error message ID = 348 com.jdedwards.database.base.JDBException: [SECURITY_ERROR] A security error occurred. com.jdedwards.database.base.JDBException: [SECURITY_ERROR] A security error occurred. com.jdedwards.database.base.JDBException: [SECURITY_ERROR] A security error occurred. Cause exception com.jdedwards.database.base.JDBException: [SECURITY_ERROR] A security error occurred. JDESpec error code = SPEC_REP_LOAD_FAILED com.peoplesoft.pt.e1.base.metadata.dataAccess.JDESpecException: Spec repository implementation could not be loaded. Spec repository implementation could not be loaded. com.peoplesoft.pt.e1.base.metadata.dataAccess.JDESpecException: Spec repository implementation could not be loaded. For package <PD114> in data source <Central Objects - PD812>, failed to find the package manifest. Aborting the discovery process, this package is not functional. com.jdedwards.database.services.packagelookup.PackageLookupServic eException: Spec repository implementation could not be loaded. com.jdedwards.base.spec.SpecException: [SECURITY_ERROR] A security error occurred. com.jdedwards.database.base.JDBException: [SECURITY_ERROR] A security error occurred. com.jdedwards.base.spec.SpecException: [SECURITY_ERROR] A security error occurred. com.jdedwards.base.spec.SpecException: SECURITY_ERROR] A security error occurred. ROJDBC - getColumnsInfo specMap.getSpec() is causing exception for table=F4101 com.jdedwards.base.spec.SpecException: [SECURITY_ERROR] A security error occurred.
Cause: This error occurs when the security token allocated for a Data Access Driver has expired. DAD starts its connection to EnterpriseOne when the BI Publisher Enterprise instance is started. At that time, it requests and obtains a security token from the Security Kernel running on the Enterprise Server. This token is used to grant DAD access to EnterpriseOne tables. The security token has a lifetime, and after it expires transactions between DAD and EnterpriseOne tables will fail.
Solution: See document 885414.1 on My Oracle Support.