ODI-1400 and ODI-1545: Missing odi supervisor credentials in credential store map

Version:

ODI 11.1.1.7.0 64 bit

Issue:

The startManagedWeblogic log has following errors and OracleDIAgent status would be down in Enterprise Manager.

Unable to set the activation state to true for the application 'oraclediagent'.
weblogic.application.ModuleException: [HTTP:101216]Servlet: "AgentServlet" failed to preload on startup in Web application: "oraclediagent".

ODI-1400: Agent OracleDIAgent start failure: JDBC connection error occurs while connecting to the master repository.

Caused by: ODI-1545: Missing odi supervisor credentials in credential store map [oracle.odi.credmap] with key [SUPERVISOR].

Reason:

Security must be set up for the JAVA EE application to have access to the ODI repository. The entry will be created within the credential store, which will allow the JAVA EE Agent to authenticate itself to be able to use the required resources. The user is already set up in the ODI Security, in this case SUPERVISOR.

Action:

Execute Web Logic Scripting Tool (WLST), connect to our running Admin server and add the credential store

Steps:

1. Start WLST and connect

cd $ODI_HOME/common/bin

wlst.sh

wls:/offline> connect('weblogic','welcome1','t3://hostname.domain:7001')

2. Add the correct credential store for ODI Supervisor 

createCred (map="oracle.odi.credmap", key="SUPERVISOR", user="SUPERVISOR", password="SUNOPSIS", desc="ODI SUPERVISOR Credential")

Eg:
wls:/odi11g_domain/serverConfig> createCred(map="oracle.odi.credmap", key="SUPERVISOR", user="SUPERVISOR", password="sunopsis", desc="ODI SUPERVISOR Credential") 
Location changed to domainRuntime tree. This is a read-only tree with DomainMBean as the root. 
For more help, use help(domainRuntime)

3. Add the correct credential store for the  ODI Domain

createCred (map="oracle.odi.credmap", key="ODI Domain Name", user="weblogic", password="welcome1", desc="ODI-DOMAIN Credential")

Eg:
createCred(map="oracle.odi.credmap", key="odi11g_domain", user="weblogic", password="welcome1", desc="ODI-DOMAIN Credential")


4. Restart the Managed Server

./startManagedServer.sh odi_server1

Note:

To delete the credentials you can use deleteCred function from wlst

Eg:

deleteCred(map="oracle.odi.credmap", key="SUPERVISOR")