Skip to Content
author's profile photo Former Member
Former Member

DBSQL_SQL_ERROR Exception "CX_SY_OPEN_SQL_DB"

Hi,

I am trying to run User Repository Sync Job in my SAP GRC SP5 system in Full or Incremental mode. But aftr around 1900 sec the job fails and throws the run time ST222 dump as attached below.

Error is as {SQL error "SQL code: 12205" occurred while accessing table "GRACUSER"}.

Other details are as below :

System environment

SAP Release..... 740

SAP Basis level 0006

Application server... invlvdb022

Network address...... 153.116.171.122

Operating system... Linux

Release.............. 2.6.32-573.18.1.el6.

Hardware type....... x86_64

Character length..... 16 Bits

Pointer length........ 64 Bits

Work process number... 18

Shortdump setting. full

Database server... invlvdb022

Database type..... SYBASE

Database name..... DA2

Database user ID SAPSR3

Terminal..........

Character set C

SAP kernel....... 742

Created on....... Jun 29 2015 23:01:53

Created at....... Linux GNU SLES-11 x86_64 cc4.3.4 use-pr150508

Database version Sybase ASE 15.7.0.1340

Patch level....... 200

Patch text.......

Database............. 15.7, 16.0

SAP database version. 742

Operating system... Linux 2.6, Linux 3

Memory consumption

Roll.... 0

EM...... 0

Heap.... 10155504

Page.... 40960

MM used. 2724408

MM free. 2260600

User and Transaction

Client................. 010

User.................. NAIKS1

Language key.......... E

Transaction.........

Transaction ID...... 578E1EAA696647B6E10000009974AB7A

EPP whole context ID...... 005056B035BE1ED693CDAF509D20314B

EPP connection ID........ 00000000000000000000000000000000

EPP call counter......... 0

Program.............. CL_GRAC_USER_REP==============CP

Screen.............. SAPMSSY0 1000

Screen line.......... 6

Active debugger..... "none"

Could you please help me with the possible resolution to this issue.

Thanks

Manisha

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 21, 2016 at 07:23 AM

    Hi Manisha,

    Please check SAP Note #2141777 and #2020621.

    This will resolve your issue.

    Regards,

    Shaily

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 21, 2016 at 08:08 AM

    Hi Manisha,

    Kindly check if the below Note helps

    2063384 - Exception CX_SY_OPEN_SQL_DB caught during Role sync or during Repository sync

    Regards,

    Manju

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 21, 2016 at 12:20 PM

    Hello Manisha,

    Check the corresponding work process trace for relevant entries in the timeframe of the shortdump.

    Also you can check the SQL error 12205 with your SYBASE database administrator.

    Regards,

    Zoltan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 26, 2016 at 06:09 AM

    Thanks Every one for your help and comments.

    Now I am not receiving DBSQL Error dump in ST22, but I am getting time out error for the same.

    Could you please suggest me on this please !

    Regards

    Manisha

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Manisha,

      As you have not shared the error screenshot it will be difficult to investigate.

      Kindly check if the below Note helps.


      2193637 - "Time Out" error during execution of user sync




      Regards,

      Manju

  • author's profile photo Former Member
    Former Member
    Posted on Jul 27, 2016 at 06:24 AM

    Hi Manju,

    Thanks for the suggestion you provided!

    Please find below the screen shot of the error we are facing, please let me know if the suggestion will help us to resolve this issue.

    Thanks in Advance!

    Regards

    Manisha


    Error screen 2.jpg (97.1 kB)
    Error screen 1.jpg (141.3 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.