Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • Nov 04, 2016 at 07:35 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 27, 2016 at 11:19 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 03, 2016 at 07:44 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 04, 2016 at 09:40 AM

    Hi,

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

    Thanks.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 08, 2016 at 06:50 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 09, 2016 at 01:51 AM

    Hi,

    No. but have a '#' character

    Thanks.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 09, 2016 at 07:24 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 10, 2016 at 04:53 AM

    Thanks.

    Issue is fixed. removed special character and it works.

    Add comment
    10|10000 characters needed characters exceeded