SAPSQL_ARRAY_INSERT_DUPREC error with BAPI_NETWORK_CONF_ADD

[Former Member]

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

[Former Member]

Issue resolved. There was no entry maintained in KP26 for cost center.

[Former Member]

To add to this,

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

[former_member214674]

Are you getting this error for all the networks or only for one network?

This is a runtime error and generally, this type of dump occurs due to inconsistency in data base tables while creating activities, components or changing the system status by any means. There are a few OSS correction notes in market place and can be explored.