problem in CNS0

[Former Member]

dear all,

i m facing a problem in project delivery (cns0). when I try to save after entering all entry program terminated error is coming.

the errors short description is as foliows:

Runtime Errors SAPSQL_ARRAY_INSERT_DUPREC

Exceptn CX_SY_OPEN_SQL_DB

Date and Time 19.02.2008 12:01:42

Short dump has not been completely stored (too big)

ShrtText

The ABAP/4 Open SQL array insert results in duplicate database records.

What happened?

Error in ABAP application program.

The current ABAP program "SAPLV05I" had to be terrminated because one of the statements could not be executed.

This is probably due to an error in the ABAP program.

Error analysis

An exception occurred. This exception is dealt with in more detail below

. The exception, which is assigned to the class 'CX_SY_OPEN_SQL_DB', was

neither

caught nor passed along using a RAISING clause, in the procedure

"SD_PARTNER_UPDATE" "(FUNCTION)"

.

Since the caller of the procedure could not have expected this exception

to occur, the running program was terminated.

The reason for the exception is:

If you use an ABAP/4 Open SQL array insert to insert a record in

the database and that record already exists with the same key,

please suggest me....

what to do?????

[Former Member]

Hi AKhilesh,

This dump error is because of duplication of records. Whenever you try to save it is giving this error, it means that already some data exists in the present document number. But the system cannot overwrite the existing data. So it says that the data is duplicating. It is better to write to SAP about this issue rather than do it by trial and error on your own.

regards

Pratap.V

[Former Member]

thanks for your suggestion. I will try to do same..

[Former Member]

Hello,

If you have upgraded from older SAP version to 4.7 or higher, please check for OSS notes.

Also check which all notes have been implemented in the system in the recent past - if the problem was not there before.

I am sure, you will get the solution.

Thanks,

Sourabh

[Former Member]

boss no upgradation done here. cns0 was properly working before last 10 days.now this problem is coming..

[Former Member]

Hello,

Please check which all transports containing any OSS notes have been implemented in the system in the recent past.

I suspect that some transport from SD or other module has moved through your system landscape that has caused this problem.

Thanks,

Sourabh

[Former Member]

Dear ,

I searched all this but not getting any solution..

plz suggest me other possibilities..