Short Dump for Data loading - CX_SY_OPEN_SQL_DB

[Former Member]

Hi,

I am getting the short while loading data from the DSO to DSO.

Runtime Errors	DBIF_RSQL_SQL_ERROR
Exception	CX_SY_OPEN_SQL_DB

Internal call code.........: "[RSQL/FTCH//BI0/PCOMP_CODE ]"

Please check the entries in the system log (Transaction SM21).

If the error occures in a non-modified SAP program, you may be able to

find an interim solution in an SAP Note.

If you have access to SAP Notes, carry out a search with the following

keywords:

"DBIF_RSQL_SQL_ERROR" "CX_SY_OPEN_SQL_DB"

"CL_RSDMD_LOOKUP_MASTER_DATA===CP" or "CL_RSDMD_LOOKUP_MASTER_DATA===CCIMP"

"SELECT_FOR_ALL_ENTRIES"

This dump points to the P table of the COMP_CODE.

I have cross checked the Info Object , it active and loaded.  The DSO are active . This is happening in the Quality System. Rechecked in the Development system, everything works fine in the Dev system .

The Source Code termination points at Method

   method SELECT_FOR_ALL_ENTRIES.

     if p_bypass_buffer IS INITIAL.

       select (p_t_fieldlist)

         from (p_tabname)

         into corresponding fields of table e_t_data

         for all entries in i_t_keys

         where (p_t_where_multi).

  >>>>>>>   else.

       select (p_t_fieldlist)

         from (p_tabname)

         bypassing buffer

         into corresponding fields of table e_t_data

         for all entries in i_t_keys

         where (p_t_where_multi).

     endif.

     if sy-subrc <> 0.

       raise no_data_found.

      endif.

All the objects are active in the quality, but still getting the Dumps to load the data.

Your inputs are really appreciated to resolve this.

Thanks,

Adhvi

[Former Member]

Not Resolved...

[oliver_uy2]

Try executing different combinations in RSRV for the DSO and the Infoobject. this might fix the error.

also check the error in sm21 maybe there is a DBA error in the backend.