Skip to Content
0

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

Oct 26, 2016 at 09:14 AM

95

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

8 Answers

Stuart Allison Nov 04, 2016 at 07:35 AM
1

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

Share
10 |10000 characters needed characters left characters exceeded
Stuart Allison Oct 27, 2016 at 11:19 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 03, 2016 at 07:44 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Shridhar N Nov 04, 2016 at 09:40 AM
0

Hi,

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

Thanks.

Share
10 |10000 characters needed characters left characters exceeded
Stuart Allison Nov 08, 2016 at 06:50 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Shridhar N Nov 09, 2016 at 01:51 AM
0

Hi,

No. but have a '#' character

Thanks.

Share
10 |10000 characters needed characters left characters exceeded
Stuart Allison Nov 09, 2016 at 07:24 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Shridhar N Nov 10, 2016 at 04:53 AM
0

Thanks.

Issue is fixed. removed special character and it works.

Share
10 |10000 characters needed characters left characters exceeded