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

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.

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