Skip to Content

Check DB Job Failing. Invalid System ID

Hi All,

We are facing an issue with our DB13 Planning Calendar Job with the below error message

"Invalid system ID"

Now for Update Statistics Job we are getting the below message

As an attempt for the Resolution we have done the following steps

1. Assign the SQLDBA role to BRT$ADM user and executed the Script.

2. Reset the SYSTEM User password which was initially not working

3. Tried to re execute the SSFS Authentication Steps for BRT$ADM user from Database Server level. It got messed up and I reverted back the rsecssfs folders again

4. R3trans -d currently 0000 at the moment.

We have our System upgrade scheduled to be starting from 11.07.2017. So will this scenario be a blocker ?

In the mean time as a work around I executed the update statistics with SYSTEM user and the new password from the back end database.

Now I am trying to find the root cause behind why the System ID is showing invalid and picking up the Production SID. How can I troubleshoot this issue and which configuration do I need to check.

Also the RFC Destination is failing with the below error message

SAPXPG_DBDEST_UNXA0579
ERROR: hostname 'unxa0579' unknown

Thanks and Regard
Anurag Das

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jul 11, 2017 at 01:08 PM

    Hi Anurag,

    Was any refresh activity performed recently? If so, did you perform post-refresh steps?

    Check the below mentioned tables to see if the data in the table correspond to the correct system.

    SDBAH

    SDBAD

    SDBAP

    SDBAR


    Regards,

    Prithviraj

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 10, 2017 at 08:59 PM

    ERROR: hostname 'unxa0579' unknown

    Is it a right hostname, if yes why it is not accessible ? Check if you can access it using it's IP address.

    Regards,

    Harish Karra

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 12, 2017 at 10:24 AM

    Did you check the hostname settings of the RFC SAPXPG_DBDEST_UNXA0579?

    Is unxa0579 the hostname of the server where this instance is running?

    If this system was refreshed recently then update Oracle Back-end Configuration in DBACOCKPIT

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 17, 2017 at 12:50 PM

    Hi Anurag,

    Update Statistics Job shows that SXPG_COMMAND_EXECUTE failed.
    This is normally related to wrong configuration on RFC Destination "SAPXPG_DBDEST_DBDEST". In your case, RFC Destination "SAPXPG_DBDEST_UNXA0579" is failing with error:
    ERROR: hostname 'unxa0579' unknown

    Does that hostname 'unxa0579' correspond to DBhost? Is there a Standalone GW running on that DBhost?
    You should ensure that hostname 'unxa0579' can be correctly resolved.

    Regards,
    Raquel

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Anurag,

      As you correctly found, return code 676 refers to lack of authorization on secinfo file.
      And the Notes you pointed out:
      2145145 - User is not authorized to start an external program [VIDEO]
      446172 - SXPG_COMMAND_EXECUTE (program_start_error) in DB13
      also describe this situation.

      Check on SM59 settings, which Gateway was been specified. Is the application sevrer GW? Ot the standalone gateway installed on DB host?
      In that case, is the secinfo file from that remote GW the one that you need to adjust.
      Let me know if RFC still fails after editing it.

      Regards,
      Raquel