Background Job cancelled while project creation in Solution Manager

[Former Member]

All background jobs which automaticaly gets created during project creation in SD4 are getting cancelled after running a significant amount of time ( few thousand seconds).

The job gets cancelled with the message

Job started

Step 001 started (program SOLAR_REFSTRUCT_GENERATE_BATCH, variant &0000000000007, user ID TBANDYOP

No data found for info object SOLARGEN 6348FB427E472E11E10000000A114AB6 .

No data found for info object SOLARGEN FA29FB42F7172D11E10000000A114AB6 .

No data found for info object SOLARGEN 94337B43DDDDE76DE10000000A114AB6 .

No data found for info object SOLARGEN 391FD54281E56F19E10000000A114AB6 .

ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC

Job cancelled

Please let me know what might be the cause of the job getting cancelled.

Warm Regards

Mazdul

[raguraman_c]

Hi,

Please provide the ABAP dump Error from ST22. I feel it can be solved. Feel free to revert back.

--Ragu

[Former Member]

Runtime Errors SAPSQL_ARRAY_INSERT_DUPREC

Exception CX_SY_OPEN_SQL_DB

Date and Time 17.04.2007 09:27:34

Short text

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

What happened?

Error in the ABAP Application Program

The current ABAP program "SAPLSOLAR_APPL_00" had to be terminated

has

come across a statement that unfortunately cannot be executed.

What can you do?

Note down which actions and inputs caused the error.

To process the problem further, contact you SAP system

administrator.

Using Transaction ST22 for ABAP Dump Analysis, you can look

at and manage termination messages, and you can also

keep them for a long time.

Error analysis

An exception occurred that is explained in detail below.

The exception, which is assigned to class 'CX_SY_OPEN_SQ

in

procedure "SOLAR_APPL_UPDATE_SCOPE" "(FUNCTION)", nor wa

RAISING clause.

Since the caller of the procedure could not have anticip

exception would occur, the current program is terminated

The reason for the exception is:

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

the database and that record already exists with the sam

this results in a termination.

(With an ABAP/4 Open SQL single record insert in the sam

situation, processing does not terminate, but SY-SUBRC i

to correct the error

Use an ABAP/4 Open SQL array insert only if you are sure

the records passed already exists in the database.

If the error occures in a non-modified SAP program, you

find an interim solution in an SAP Note.

If you have access to SAP Notes, carry out a search with

keywords:

"SAPSQL_ARRAY_INSERT_DUPREC" "CX_SY_OPEN_SQL_DB"

"SAPLSOLAR_APPL_00" or "LSOLAR_APPL_00U06"

"SOLAR_APPL_UPDATE_SCOPE"

[raguraman_c]

Hi,

did you try searching notes with the suggested keyword.

867473

948940

Check these.

Feel free to revert back.

--Ragu

[Former Member]

Hi Mazdul,

is your problem fixed ?

I am getting the same one . Please provide solution if it is resolved .

Thanks

Pramod