problem during Dual AS -JAVA export

[Former Member]

Hi team

I am getting below error during export of BI system which is dual stack and I am trying to export the java part of it.As soon as the update stats finished and started export.It has created STR files and failed during the R3szchk phase.The log provides below error.Please help.

more R3szchkExport.log

*********************************************************************

• *

• R3szora: WARNING: the sizes of tables and indices will be useless *

• unless the statistics have been updated *

• *

*********************************************************************

INFO: allocate build_partition_list: 8192

INFO: processing SAPSDIC.STR

INFO: processing SAPUSER.STR

INFO: processing SAPAPPL1.STR

INFO: processing SAPAPPL2.STR

INFO: processing SAPAPPL0.STR

INFO: processing SAPDODS.STR

INFO: processing SAPDDIM.STR

INFO: processing SAPDFACT.STR

INFO: processing SAPUSER1.STR

INFO: processing SAPSDOCU.STR

INFO: processing SAPSSRC.STR

INFO: processing SAPSPROT.STR

INFO: processing SAPSSEXC.STR

INFO: processing SAPPOOL.STR

INFO: processing SAPSLOAD.STR

INFO: processing SAPCLUST.STR

INFO: processing SAPSLEXC.STR

INFO: processing SAP0000.STR

ERROR: ExeModify for write_ddloadd failed in row 66853

(rc = 26)

objectname = /BIC/E100004~050

objecttype = INDEX DFACT

tabart = DFACT

rowcount = 229

error message returned by DbSl:

ORA-00001: unique constraint (SAPBIW.DDLOADD~0) violated

[markus_doehr2 · Accepted solution]

Do you export them separately (ABAP + Java)?

Did you execute SMIGR_CREATE_DDL?

It seems that the index to be exported is not valid.

Markus

[Former Member · Accepted solution]

Dear Markus,

I am facing the same issue now, can you please advice me the solution.

Many thanks.

Vineeth

INFO: allocate build_partition_list: 8192

INFO: processing D010TAB.STR

INFO: processing DD03L.STR

INFO: processing DOKCLU.STR

INFO: processing DWTREE.STR

INFO: processing DYNPSOURCE.STR

INFO: processing FPCONTEXT.STR

INFO: processing FPLAYOUTT.STR

INFO: processing REPOSRC.STR

INFO: processing SAP0000.STR

INFO: processing SAPAPPL0.STR

INFO: processing SAPAPPL0_1.STR

INFO: processing SAPAPPL0_2.STR

INFO: processing SAPAPPL0_3.STR

INFO: processing SAPAPPL0_4.STR

INFO: processing SAPAPPL1.STR

INFO: processing SAPAPPL1_1.STR

INFO: processing SAPAPPL1_2.STR

INFO: processing SAPAPPL1_3.STR

INFO: processing SAPAPPL2.STR

INFO: processing SAPAPPL2_1.STR

INFO: processing SAPAPPL2_2.STR

INFO: processing SAPAPPL2_3.STR

INFO: processing SAPAPPL2_4.STR

INFO: processing SAPAPPL2_5.STR

INFO: processing SAPAPPL2_6.STR

INFO: processing SAPCLUST.STR

INFO: processing SAPDDIM.STR

INFO: processing SAPDFACT.STR

INFO: processing SAPDODS.STR

INFO: processing SAPNTAB.STR

INFO: processing SAPPOOL.STR

INFO: processing SAPSDIC.STR

INFO: processing SAPSDOCU.STR

INFO: processing SAPSLEXC.STR

INFO: processing SAPSLOAD.STR

INFO: processing SAPSPROT.STR

INFO: processing SAPSSEXC.STR

INFO: processing SAPSSEXC_1.STR

INFO: processing SAPSSEXC_2.STR

INFO: processing SAPSSEXC_3.STR

INFO: processing SAPSSEXC_4.STR

INFO: processing SAPSSEXC_5.STR

INFO: processing SAPSSEXC_6.STR

INFO: processing SAPSSEXC_7.STR

INFO: processing SAPSSEXC_8.STR

INFO: processing SAPSSRC.STR

INFO: processing SAPUSER.STR

INFO: processing SAPUSER1.STR

ERROR: ExeModify for write_ddloadd failed in row 45410

(rc = 26)

objectname = /1CN/STXSAPRBR11

objecttype = TABLE APPL0 X

tabart = APPL0 X

rowcount = 0

error message returned by DbSl:

ORA-00001: unique constraint (SAPSR3.DDLOADD~0) violated

[former_member189725 · Accepted solution]

Hi ,

The table DDLOADD is used to store the results of the table/index size calculation.

Hence when you run R3szchk , the table is populated. The index in question has violated the unique index of DDLOADD.

One way to overcome the problem is to delete the index entry from ddloadd table of the violated index as the OBJECTNAME is the only column of the unique constraint . Then restart the failed operation.

Regrads

Ratnajit

Edited by: Ratnajit Dey on Aug 22, 2010 6:41 PM