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 ONE Support launchpad (Login required).

Search for additional results

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