SAP Knowledge Base Article - Preview

2233164 - DBIF_DSQL2_SQL_ERROR -28534 POS(1) Package must be recreated:

Symptom

SAP liveCache procedure call fails with DBIF_DSQL2_SQL_ERROR runtime error.
(To check complete runtime error use transaction ST22)

Runtime Errors         DBIF_DSQL2_SQL_ERROR
Exception              CX_SY_NATIVE_SQL_ERROR

Date and Time          20.10.2015 14:43:49

----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------

|Short text                                                                                        |

|    An SQL error occurred when executing Native SQL.                                              |

----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------

|What happened?                                                                                    |

|    The error "-28534" occurred in the current database connection "LCA".                         |

----------------------------------------------------------------------------------------------------
...
----------------------------------------------------------------------------------------------------

|How to correct the error                                                                          |

|    Database error text........: "POS(1) Package must be                                          |

|     recreated:SIM_SIMSESSION_CONTROL,"                                                           |

|    Database error code........: "-28534"                                                         |

|    Triggering SQL statement...: "EXECUTE PROCEDURE "SIM_SIMSESSION_CONTROL""                     |

|    Internal call code.........: "[DBDS/NEW DSQL]"                                                |

|    Please check the entries in the system log (Transaction SM21).                                |
...
----------------------------------------------------------------------------------------------------
|System environment
|   SAP Release..... 750
|   SAP Basis level 0007
|   Application server... appserver100
|   Network address...... 192.168.0.100
|   Operating system... Linux
|   Release.............. 2.6.32-696.18.7.el6.
|   Hardware type....... x86_64
|   Character length..... 16 Bits
|   Pointer length........ 64 Bits
|   Work process number... 6
|   Shortdump setting. full
 

 

Corresponding work process trace dev_w6 of affected application server::

C Tue Oct 20 14:43:49 2015

C  *** ERROR =>   execute() of C_0374, #rec=0, rc=1, rcSQL=-28534 (POS(1) Package must be recreated:SIM_SIMSESSION_CONTROL,)
 
[dbsdbsql.cpp 2723]

C  {root-id=FA94237FEFCC1ED59DE310CDECBB0102}_{conn-id=00000000000000000000000000000000}_0

C  *** ERROR => EXECUTE on connection 1, rc=-28534 (POS(1) Package must be recreated:SIM_SIMSESSION_CONTROL,)
 
[dbslsdb.cpp  9254]

C  {root-id=FA94237FEFCC1ED59DE310CDECBB0102}_{conn-id=00000000000000000000000000000000}_0

C  sc_p=6000000005b2bcb0,no=374,idc_p=(nil),con=1,act=1,slen=115,smax=256,#vars=16,stmt=600000000471fb50,table="SIM_SIMSESSION_CONTR

C  CALL  "SIM_SIMSESSION_CONTROL"  (  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  \

C  ? ,  ? ,  ?  ) ;

B  ***LOG BY2=> sql error -28534 performing EXE [dbds         295]

B  ***LOG BY0=> POS(1) Package must be recreated:SIM_SIMSESSION_CONTROL, [dbds         295]

A  TH VERBOSE LEVEL FULL

 

 

LiveCache Kernel Message trace (KnlMsg):
(transaction LC10 > LCA > Diagnostics > Messages > Kernel Message > Current Messages tab)

Thread       0x33 Task    155  2015-10-20 14:43:49 ERR DCOM       11262:  dispGetClassObject - HRESULT: -2147220711, Context: INPROC

Thread       0x33 Task    155  2015-10-20 14:43:49 ERR DCOM       11263:  COCLSID: {40BE0C95-EDDD-4B9B-92B3-159A98857508}

Thread       0x33 Task    155  2015-10-20 14:43:49 ERR HRESULT    51260:  80040319 package_out_of_dat

Thread       0x33 Task    155  2015-10-20 14:43:49 ERR DCOM       11262:  dispGetClassObject - HRESULT: -2147220711, Context: INPROC

Thread       0x33 Task    155  2015-10-20 14:43:49 ERR DCOM       11263:  COCLSID: {3E51F8E4-549D-11D3-87F9-00104BB4099E}

Thread       0x33 Task    155  2015-10-20 14:43:49 ERR HRESULT    51260:  80040319 package_out_of_dat

 

 

In this example the runtime error DBIF_DSQL2_SQL_ERROR occurred during the execution of the liveCache procedure SIM_SIMSESSION_CONTROL.


Read more...

Keywords

KBA , BC-DB-LCA , liveCache Applications , BC-DB-LVC , liveCache , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.