Article ID: 129207, created on Aug 2, 2016, last review on Aug 2, 2016

  • Applies to:
  • Operations Automation 6.0
  • Operations Automation 5.5
  • Operations Automation 5.4

Symptoms

Task Change password of user 'USER_ID' on database servers fails with following last execution output:

There is no such database user, user_id=USER_ID.

Cause

There is a database inconsistency, might be caused by cancelling/deleting or manual interventions.

Resolution

This issue appeares as result of the fact that aforementioned database was not properly created due to the removal of user for this database before database creation was finished.

  1. To resolve this issue add a new user to the affected database using API method pem.createDatabaseUser:

    curl -d"<?xml version='1.0'?><methodCall><methodName>pem.createDatabaseUser</methodName><params><param><value><struct><member><name>db_id</name><value><int>DB_ID</int></value></member><member><name>user</name><value><string>DB_USER_NAME</string></value></member><member><name>password</name><value><string>*****</string></value></member></struct></value></param></params></methodCall>" http://localhost:8440
    

    Replace DB_ID with required database id, DB_USER_NAME with required database user name.

  2. Then reschedule failed task with new value for 'dbo.param.user_id' using API method pem.tasks.rescheduleTask:

    <?xml version='1.0'?>
    <methodCall>
    <methodName>pem.tasks.rescheduleTask</methodName>
    <params>
    <param>
        <value>
        <struct>
            <member>
            <name>task_id</name>
                <value>
                <i4>TASK_ID</i4>
                </value>
                </member>
            <member>
            <name>params</name>
                <value>
                <array>
                <data>
                <value>
                    <struct>
                        <member>
                        <name>name</name>
                            <value>
                            <string>dbo.param.user_id</string>
                            </value>
                            </member>
                        <member>
                        <name>value</name>
                            <value>
                            <string>DB_USER_ID</string>
                            </value>
                            </member>
                        </struct>
                        </value>
                    </data>
                </array>
                </value>
                </member>
                </struct>
            </value>
        </param>
        </params>
    </methodCall>
    

    Replace TASK_ID with required Task id, DB_USER_ID with newly added user id.

  3. This task could fail with the following entries:

    MySQL API error: Duplicate entry 'DB_NAME-DB_USER_NAME' for key 'PRIMARY'
    

    This error was caused by the duplicate entries in MySQL database. These duplicate entries appeard due to the fact that records regarding this user was added into MySQL database when it was added with API method, and OA tried to add same user again during execution of the DB creation task. Please contact Odin Technical Support to resolve this issue.

Search Words

Failed to change MySQL user password at CCP

databases

database

There is no such database user

ac82ce33439a9c1feec4ff4f2f638899 caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 5356b422f65bdad1c3e9edca5d74a1ae 2554725ed606193dd9bbce21365bed4e 956c448bddc7e1f3585373687602379f 6f1456866eed87488c0f02b298a741c0 5b048d9bddf8048a00aba7e0bdadef37

Email subscription for changes to this article
Save as PDF