topic Re: SAPSQL_ARRAY_INSERT_DUPREC error with BAPI_NETWORK_CONF_ADD in Application Development and Automation Discussions

SAPSQL_ARRAY_INSERT_DUPREC error with BAPI_NETWORK_CONF_ADD

Former Member — Wed, 26 Mar 2014 10:59:22 GMT

Hi,

I am using BAPI_NETWORK_CONF_ADD to confirm network activity.

Issue: If I don't pass actual work and unit of work, the activity status changes to 'CNF'. no issues. But, if I pass these 2 values to BAPI, BAPI does not return any error. But, status of the activity is not changed. And in ST22, it shows following error.

SAPSQL_ARRAY_INSERT_DUPREC :

Termination occurred in the ABAP program "SAPLKAUP" - in "INSERT_TABLES".
The main program was "RSM13000 ".

In the source code you have the termination point in line 464
of the (Include) program "LKAUPF01".
The program "SAPLKAUP" was started in the update system.
The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in
procedure "INSERT_TABLES" "(FORM)", but it was neither handled locally nor
declared
in the RAISING clause of its signature.

The procedure is in program "SAPLKAUP "; its source code begins in line
397 of the (Include program "LKAUPF01 ".

Thanks and Regards,

Sneha Nikam

Re: SAPSQL_ARRAY_INSERT_DUPREC error with BAPI_NETWORK_CONF_ADD

nabheetscn — Wed, 26 Mar 2014 11:19:35 GMT

Hi Sneha

Can you please sahre your sample code how are you calling the BAPI's ..? Do you call it inside loop?

Thanks

Nabheet

Re: SAPSQL_ARRAY_INSERT_DUPREC error with BAPI_NETWORK_CONF_ADD

former_member201275 — Wed, 26 Mar 2014 11:54:59 GMT

Are you doing a COMMIT WORK?

Re: SAPSQL_ARRAY_INSERT_DUPREC error with BAPI_NETWORK_CONF_ADD

Former Member — Wed, 26 Mar 2014 11:58:02 GMT

Hi,

I am not calling it inside any loop.

lwa_confirmations-exec_start_date = actual_start_date.
lwa_confirmations-exec_fin_date = actual_end_date.
lwa_confirmations-act_work = actual_work.
lwa_confirmations-activity = activity_number.
lwa_confirmations-un_act_work = unit_of_work.
lwa_confirmations-FIN_CONF = 'X'.
APPEND lwa_confirmations TO i_confirmations.

CALL FUNCTION 'BAPI_NETWORK_CONF_ADD'
    EXPORTING
      number          = network_number
    IMPORTING
      return          = return
    TABLES
      i_confirmations = i_confirmations
      e_message_table = e_message_table.

READ TABLE e_message_table WITH KEY type = 'A' TRANSPORTING NO FIELDS.
IF sy-subrc NE 0.
    READ TABLE e_message_table WITH KEY type = 'E' TRANSPORTING NO FIELDS.
    IF sy-subrc NE 0.


        CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'.


    ENDIF.
ENDIF.

Note: Also the dump is coming only when I pass actual work and unit of work.Otherwise it is fine.

Re: SAPSQL_ARRAY_INSERT_DUPREC error with BAPI_NETWORK_CONF_ADD

Former Member — Wed, 26 Mar 2014 12:10:48 GMT

Also, to add this error was not there unless my funcational consultant made an entry in KP26 transaction for activity type and cost center. Before this configuration, BAPI was returing error ' A master record for 8100/1000 exists only in 2011'. So, he made the configuration and I started getting dumps.

Regards,

Sneha

Re: SAPSQL_ARRAY_INSERT_DUPREC error with BAPI_NETWORK_CONF_ADD

Former Member — Wed, 26 Mar 2014 16:08:41 GMT

Can you post full short dump information?

Re: SAPSQL_ARRAY_INSERT_DUPREC error with BAPI_NETWORK_CONF_ADD

former_member585060 — Wed, 26 Mar 2014 17:23:11 GMT

Hi Sneha,

First call the Bapi "BAPI_NETWORK_CONF_GETDETAIL" and then populate I_CONFIRMATIONS from the values returned from the above Bapi. Then call the Bapi "BAPI_NETWORK_CONF_ADD", see if the dump occurs again.

Thanks & Regards

Bala Krishna

Re: SAPSQL_ARRAY_INSERT_DUPREC error with BAPI_NETWORK_CONF_ADD

Former Member — Wed, 26 Mar 2014 17:52:50 GMT

Hi,

The problem is not with BAPI, I guess. Because, thorugh transaction CN25 also, I am unable to create confirmation. Getting same error. Something wrong in KP26 configuration.

Regards,

Sneha Nikam

Re: SAPSQL_ARRAY_INSERT_DUPREC error with BAPI_NETWORK_CONF_ADD

Former Member — Thu, 27 Mar 2014 02:16:43 GMT

Then you should ask your functional consultant to check

Re: SAPSQL_ARRAY_INSERT_DUPREC error with BAPI_NETWORK_CONF_ADD

former_member585060 — Thu, 27 Mar 2014 03:45:54 GMT

Hi,

Kepp breakpoint in the Include 'LKAUPF01' line number 464, Execute same process again in Transaction CN25. It will stop at the break point. See the entries in the internal table COBK_INS.

Open SE11 in another session, give the table name 'COBK' and search this table with any same entry which are in internal table COBK.

Thanks & Regards

Bala Krishna

Re: SAPSQL_ARRAY_INSERT_DUPREC error with BAPI_NETWORK_CONF_ADD

Former Member — Thu, 27 Mar 2014 04:06:25 GMT

Hi,

Deleted the configuration from KP26 and maintaining it again solved the issue. Not sure what was wrong with the previous entry.

Thanks,

Sneha

Re: SAPSQL_ARRAY_INSERT_DUPREC error with BAPI_NETWORK_CONF_ADD

RemiKaimal — Thu, 27 Mar 2014 04:59:13 GMT

Hi Sneha,

Which release are you working on?

Please check out : OSS : 634938 - Confirmation BAPI: Unit is not taken into account

Regards,

Remi