ODSLaborRollup.bat + ORA-01017: invalid username/password; logon denied

[former_member202208]

Hi,

On executing ODSLaborRollup.bat script, it fails with

'javax.ejb.EJBException: nested exception is: java.sql.SQLException: ORA-01017: invalid username/password; logon denied' message

Version:

ME : 15.1

Where do we need to maintain the user details?

Thanks in advance,

Thanks,

cusersa571741desktopodslaborrollup-error.txt

[stuarta1]

Do any of the ODS scripts work? Like ODSShopOrder.bat.

[former_member202208]

Thanks.

Issue is fixed. removed special character and it works.

[stuarta1]

Then I'd recommend you change that and only use alphanumeric characters. Other characters can be mis-interpreted in the conenction string.

[former_member202208]

Hi,

No. but have a '#' character

Thanks.

[stuarta1]

Do you have any odd ASCII characters in the DB credentials like "@" for example?

[former_member202208]

Hi,

I tried with couple of other scripts, they fail with same message.

Thanks.

[Former Member]

Hi Stuart,

Thanks for your reply.

I did re-run LMAuto tool and execute the script giving correct username password. All the steps executed OK.

I can connect to WIP and ODS with credentials given with sqlplus utility & sqldeveloper.

Anything else to check?

Thanks in advance

Shridhar

[stuarta1]

This is set when you install the scripts (section 4.2 of the install guide). It is encrypted, so if you got the database credentials wrong then re-install the scripts.

Stuart