Error : "Error during ODI Process Submission. ODI Connection information may not be correct or ODI Agent may not be running. Please check and resubmit the job" When Running Data Load Rules in FDMEE (Doc ID 2805580.1)

Last updated on JUNE 10, 2024

Applies to:

Symptoms

Error when running data load rules in FDMEE:

"Error during ODI Process Submission. ODI Connection information may not be correct or ODI Agent may not be running. Please check and resubmit the job"

erpintegrator.log shows the following error:

<ErpIntegrator0> <[STANDBY] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <...> <...> <[severity-value: 8] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-149205> <Failed to initialize the application "opss-data-source" due to error weblogic.application.ModuleException: java.sql.SQLInvalidAuthorizationSpecException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Login failed for user '<prefix>_OPSS'.
weblogic.application.ModuleException: java.sql.SQLInvalidAuthorizationSpecException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Login failed for user '<prefix>_OPSS'.
...
Caused By: java.sql.SQLInvalidAuthorizationSpecException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Login failed for user '<prefix>_OPSS'.

Cause

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