This is Ahmed

Title

"com.sunopsis.core.SecurityAccessException: Invalid password" when executing a scenario from the command prompt

Date

2009-02-05

Summary

When starting a scenario from the command prompt, you may receive the following error:

C:\oracle\product\10.1.3\odi_1\oracledi\bin>startscen TRANSFEREMPLOYEES 001 GLOBAL
OracleDI: Starting scenario TRANSFEREMPLOYEES 001 in context GLOBAL ...
com.sunopsis.core.SecurityAccessException: Invalid password
        at com.sunopsis.security.DefaultDwgSecurityManager.getDefaultSecurityManager(DefaultDwgSecurityManager.java)
        at com.sunopsis.security.DefaultDwgSecurityManager.getDefaultSecurityManager(DefaultDwgSecurityManager.java)
        at com.sunopsis.dwg.cmd.DwgCommandScenario.b(DwgCommandScenario.java)
        at com.sunopsis.dwg.cmd.DwgCommandScenario.treatCommand(DwgCommandScenario.java)
        at com.sunopsis.dwg.cmd.DwgCommandBase.prepare(DwgCommandBase.java)
        at com.sunopsis.dwg.cmd.e.t(e.java)
        at com.sunopsis.dwg.cmd.e.y(e.java)
        at com.sunopsis.dwg.DwgJv.treatCmd(DwgJv.java)
        at com.sunopsis.dwg.DwgJv.main(DwgJv.java)
        at oracle.odi.Agent.main(Agent.java)
com.sunopsis.core.SecurityAccessException: Invalid password
        at com.sunopsis.security.DefaultDwgSecurityManager.getDefaultSecurityManager(DefaultDwgSecurityManager.java)
        at com.sunopsis.security.DefaultDwgSecurityManager.getDefaultSecurityManager(DefaultDwgSecurityManager.java)
        at com.sunopsis.dwg.cmd.DwgCommandScenario.b(DwgCommandScenario.java)
        at com.sunopsis.dwg.cmd.DwgCommandScenario.treatCommand(DwgCommandScenario.java)
        at com.sunopsis.dwg.cmd.DwgCommandBase.prepare(DwgCommandBase.java)
        at com.sunopsis.dwg.cmd.e.t(e.java)
        at com.sunopsis.dwg.cmd.e.y(e.java)
        at com.sunopsis.dwg.DwgJv.treatCmd(DwgJv.java)
        at com.sunopsis.dwg.DwgJv.main(DwgJv.java)
        at oracle.odi.Agent.main(Agent.java)

Details

Ensure that the Repository Connection Information is configured correctly in the %ODI_HOME%/bin/odiparams.bat (or odiparams.sh) file. For example:

set ODI_SECU_USER=odi                             <-- this is the database schema user
set ODI_SECU_PASS=password                        <-- this is the database schema password
set ODI_SECU_ENCODED_PASS=bVyaGYjRE8ZC64vtB80tmi  <-- encoded password

set ODI_USER=SUPERVISOR                           <-- this is the ODI user
set ODI_PASS=password                             <-- this is the ODI password
set ODI_ENCODED_PASS=fJyHiN1najRnoUCpvffVzAp      <-- encoded password

To get an encoded password, do the following:

cd %ODI_HOME%/bin
agent ENCODE <password>

Applicable Versions

Oracle Data Integrator 10g (10.1.3)

Ahmed Aboulnaga

.com