SAP Knowledge Base Article - Preview

2530808 - SAPSQL_PARSE_ERROR dump occurs when "Store Business Document" GOS service is used

Symptom

When using "Store Business Document" service via GOS (Services for Object) in an application, following dump occurs:

Category               ABAP programming error
Runtime Errors         SAPSQL_PARSE_ERROR
Except.                CX_SY_DYNAMIC_OSQL_SEMANTICS
ABAP Program           CL_ALINK_CONNECTION===========CP
Application Component  BC-SRV-ARL
Date and Time          07.09.2017 13:12:33 

Short Text
    An error has occurred while parsing a dynamic entry.

Error analysis
    The current ABAP program attempted to execute an Open SQL statement
    containing a dynamic entry. The parser returned the following error:

    "Unknown column name "MANDT". until runtime, you cannot specify a field list."

Information on where terminated
    In the source code, the termination point is in line 252 of  program or
    include "CL_ALINK_CONNECTION===========CM00A".
    The termination is due to exception "CX_SY_DYNAMIC_OSQL_SEMANTICS" occurring
     in procedure "FIND" "(METHOD)".

Source Code Extract
  246     if l_toaco is initial.
  247       call function 'ARCHIVELNK_READ_ALL_OBJECTS'
  248         tables
  249           connections       = l_archived_connections.
  250     else.
  251 *     start database selection
>>>>>       open cursor with hold l_cursor for
  253         select * from (l_toaco-connection)
  254                  client specified
  255                  where (l_condition)
  256                  and mandt in l_ra_mandt
  257                  and sap_object in l_ra_sap_object
  258                  and object_id in l_ra_object_id
  259                  and archiv_id in l_ra_archiv_id
  260                  and arc_doc_id in l_ra_arc_doc_id
  261                  and ar_object in l_ra_ar_object
  262                  and ar_date in l_ra_ar_date
  263                  and del_date in l_ra_del_date
  264                  and reserve in l_ra_reserve.

Active Calls/Events
 METHOD       CL_ALINK_CONNECTION===========CP     CL_ALINK_CONNECTION===========CM00A
 CL_ALINK_CONNECTION=>FIND
 FUNCTION     SAPLOPTB                                                      LOPTBU22
 ARCHIV_GET_CONNECTIONS_INT
 FUNCTION     SAPLOPTB                                                      LOPTBU35
 ARCHIV_GET_CONNECTIONS
 METHOD       CL_ARL_SRV_LINK===============CP    CL_ARL_SRV_LINK===============CM002
 CL_ARL_SRV_LINK=>EXECUTE


Read more...

Environment

  • SAP Netweaver Basis Release independent
  • Services for Object (GOS)
  • ArchiveLink is configured for the used business object type (as mentioned in wiki page, Point 5)
  • Service "Store Business Document"

Product

SAP ERP 6.0 ; SAP NetWeaver all versions

Keywords

Generic Object Services, Generische Objektdienste, TOADL, OAD3, TOAV0, link table, Verknüpfungstabelle , KBA , BC-SRV-ARL , ArchiveLink , BC-SRV-GBT-GOS , Generic Object Services , Problem

About this page

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

Search for additional results

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