Skip to Content
0
Former Member
Jul 21, 2016 at 07:02 AM

DBSQL_SQL_ERROR Exception "CX_SY_OPEN_SQL_DB"

7869 Views

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