Skip to Content
author's profile photo
Gejo John

SQL error "SQL code: 10" occurred while accessing table "DDFTX"

Mar 02, 2017 at 05:51 PM | 4k Views

Hey All,

We have recently installed SAP S/4 HANA On Premise 1511 system and getting the error "SQL error "SQL code: 10" occurred while accessing table "DDFTX"" in many place (Explained below ) in the system.

1. SPRO -- > IMG-- > Controlling --- > Cost center accounting ---> Enterprise organization -- > execute "enter setting for Enterprise organization"

2.Having same issue while executing SM61 transaction code.

3.And also getting it while defining the MIME types (SMW0 transaction code).

I see the authentication error in system log for SAPSYS user. and not sure how to rectify it, Any help is highly appreciated.

Thanks,

Gejo john

SAP S/4HANA
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Gejo John
    Mar 02, 2017 at 07:02 PM

    This issue has been solved.

    Solution: I have changed the credential of SAPHANADB User from HANA Studio and that was the whole reason,

    S/4 Application was trying to call HANA database using SAPHANADB user, and since the stored password in S/4 application is different it was giving me Authorization error. In order to correct the issue i went back to HANA studio and changed the password again to what i was and all worked fine,

    The alternative can be to update the password in S/4 application using dbacockpit transaction code.

    I was able to solve it after reading the system log (SM21) i has all information and can be used to solve similar issues.

    Thanks

    Gejo john

    Add comment
    10|10000 characters needed characters exceeded