Error during System Export

[Former Member]

HI Frds,

I am trying to export the system with the table splitting option , In the splittable.txt i pass the below entry

MARA%4

MSEG%5

and it has created the .WHR file ...

Now i started the Export and during export i got the Error which is in MARA-2.log

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

D:\usr\sap\DEV\DVEBMGS00\exe\R3load.exe: START OF LOG: 20151129224533

D:\usr\sap\DEV\DVEBMGS00\exe\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#3 $ SAP

D:\usr\sap\DEV\DVEBMGS00\exe\R3load.exe: version R7.20/V1.4 [UNICODE]

Compiled May  7 2010 03:19:51

D:\usr\sap\DEV\DVEBMGS00\exe\R3load.exe -ctf E D:\exp\ABAP\DATA\MARA.STR D:\exp\ABAP\DB\DDLORA_LRG.TPL MARA-2.TSK ORA -where D:\exp\ABAP\DATA\MARA-2.WHR -l MARA-2.log

(RTF) ########## WARNING ###########

  Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

D:\usr\sap\DEV\DVEBMGS00\exe\R3load.exe: job completed

D:\usr\sap\DEV\DVEBMGS00\exe\R3load.exe: END OF LOG: 20151129224533

D:\usr\sap\DEV\DVEBMGS00\exe\R3load.exe: START OF LOG: 20151129224533

D:\usr\sap\DEV\DVEBMGS00\exe\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#3 $ SAP

D:\usr\sap\DEV\DVEBMGS00\exe\R3load.exe: version R7.20/V1.4 [UNICODE]

Compiled May  7 2010 03:19:51

D:\usr\sap\DEV\DVEBMGS00\exe\R3load.exe -e MARA-2.cmd -datacodepage 4103 -l MARA-2.log -stop_on_error

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(DB) INFO: Read hintfile: D:\exp\ABAP\DATA\MARA-2.WHR

(GSI) INFO: dbname   = "DEV20151128011133                                                                                                               "

(GSI) INFO: vname    = "ORACLE                          "

(GSI) INFO: hostname = "MMSRTEST                                                        "

(GSI) INFO: sysname  = "Windows NT"

(GSI) INFO: nodename = "MMSRTEST"

(GSI) INFO: release  = "5.2"

(GSI) INFO: version  = "3790 Service Pack 2"

(GSI) INFO: machine  = "AMD64 Level 6 (Mod 60 Step 3)"

(INO) INFO: can't use SAPLIKEY, trying SlicGetInstallationNo()

(GSI) INFO: instno   = "INITIAL   "

(RTF) ########## WARNING ###########

  Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

DbSl Trace: Error 936 in stmt_fetch() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-00936 occurred when executing SQL stmt (parse error offset=2325)

(EXP) ERROR: DbSlExeRead failed

  rc = 99, table "MARA"

  (SQL error 936)

  error message returned by DbSl:

ORA-00936: missing expression

(DB) INFO: disconnected from DB

D:\usr\sap\DEV\DVEBMGS00\exe\R3load.exe: job finished with 1 error(s)

D:\usr\sap\DEV\DVEBMGS00\exe\R3load.exe: END OF LOG: 20151129224533

D:\usr\sap\DEV\DVEBMGS00\exe\R3load.exe: START OF LOG: 20151130141048

D:\usr\sap\DEV\DVEBMGS00\exe\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#3 $ SAP

D:\usr\sap\DEV\DVEBMGS00\exe\R3load.exe: version R7.20/V1.4 [UNICODE]

Compiled May  7 2010 03:19:51

D:\usr\sap\DEV\DVEBMGS00\exe\R3load.exe -e MARA-2.cmd -datacodepage 4103 -l MARA-2.log -stop_on_error

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(DB) INFO: Read hintfile: D:\exp\ABAP\DATA\MARA-2.WHR

(GSI) INFO: dbname   = "DEV20151128011133                                                                                                               "

(GSI) INFO: vname    = "ORACLE                          "

(GSI) INFO: hostname = "MMSRTEST                                                        "

(GSI) INFO: sysname  = "Windows NT"

(GSI) INFO: nodename = "MMSRTEST"

(GSI) INFO: release  = "5.2"

(GSI) INFO: version  = "3790 Service Pack 2"

(GSI) INFO: machine  = "AMD64 Level 6 (Mod 60 Step 3)"

(INO) INFO: can't use SAPLIKEY, trying SlicGetInstallationNo()

(GSI) INFO: instno   = "INITIAL   "

(RTF) ########## WARNING ###########

  Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

DbSl Trace: Error 936 in stmt_fetch() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-00936 occurred when executing SQL stmt (parse error offset=2325)

(EXP) ERROR: DbSlExeRead failed

  rc = 99, table "MARA"

  (SQL error 936)

  error message returned by DbSl:

ORA-00936: missing expression

(DB) INFO: disconnected from DB

D:\usr\sap\DEV\DVEBMGS00\exe\R3load.exe: job finished with 1 error(s)

D:\usr\sap\DEV\DVEBMGS00\exe\R3load.exe: END OF LOG: 20151130141048

D:\usr\sap\DEV\DVEBMGS00\exe\R3load.exe: START OF LOG: 20151130141542

D:\usr\sap\DEV\DVEBMGS00\exe\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#3 $ SAP

D:\usr\sap\DEV\DVEBMGS00\exe\R3load.exe: version R7.20/V1.4 [UNICODE]

Compiled May  7 2010 03:19:51

D:\usr\sap\DEV\DVEBMGS00\exe\R3load.exe -e MARA-2.cmd -datacodepage 4103 -l MARA-2.log -stop_on_error

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(DB) INFO: Read hintfile: D:\exp\ABAP\DATA\MARA-2.WHR

(GSI) INFO: dbname   = "DEV20151128011133                                                                                                               "

(GSI) INFO: vname    = "ORACLE                          "

(GSI) INFO: hostname = "MMSRTEST                                                        "

(GSI) INFO: sysname  = "Windows NT"

(GSI) INFO: nodename = "MMSRTEST"

(GSI) INFO: release  = "5.2"

(GSI) INFO: version  = "3790 Service Pack 2"

(GSI) INFO: machine  = "AMD64 Level 6 (Mod 60 Step 3)"

(INO) INFO: can't use SAPLIKEY, trying SlicGetInstallationNo()

(GSI) INFO: instno   = "INITIAL   "

(RTF) ########## WARNING ###########

  Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

DbSl Trace: Error 936 in stmt_fetch() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-00936 occurred when executing SQL stmt (parse error offset=2325)

(EXP) ERROR: DbSlExeRead failed

  rc = 99, table "MARA"

  (SQL error 936)

  error message returned by DbSl:

ORA-00936: missing expression

(DB) INFO: disconnected from DB

D:\usr\sap\DEV\DVEBMGS00\exe\R3load.exe: job finished with 1 error(s)

D:\usr\sap\DEV\DVEBMGS00\exe\R3load.exe: END OF LOG: 20151130141543

D:\usr\sap\DEV\DVEBMGS00\exe\R3load.exe: START OF LOG: 20151201000546

D:\usr\sap\DEV\DVEBMGS00\exe\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#3 $ SAP

D:\usr\sap\DEV\DVEBMGS00\exe\R3load.exe: version R7.20/V1.4 [UNICODE]

Compiled May  7 2010 03:19:51

D:\usr\sap\DEV\DVEBMGS00\exe\R3load.exe -e MARA-2.cmd -datacodepage 4103 -l MARA-2.log -stop_on_error

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(DB) INFO: Read hintfile: D:\exp\ABAP\DATA\MARA-2.WHR

(GSI) INFO: dbname   = "DEV20151128011133                                                                                                               "

(GSI) INFO: vname    = "ORACLE                          "

(GSI) INFO: hostname = "MMSRTEST                                                        "

(GSI) INFO: sysname  = "Windows NT"

(GSI) INFO: nodename = "MMSRTEST"

(GSI) INFO: release  = "5.2"

(GSI) INFO: version  = "3790 Service Pack 2"

(GSI) INFO: machine  = "AMD64 Level 6 (Mod 60 Step 3)"

(INO) INFO: can't use SAPLIKEY, trying SlicGetInstallationNo()

(GSI) INFO: instno   = "INITIAL   "

(RTF) ########## WARNING ###########

  Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

DbSl Trace: Error 936 in stmt_fetch() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-00936 occurred when executing SQL stmt (parse error offset=2325)

(EXP) ERROR: DbSlExeRead failed

  rc = 99, table "MARA"

  (SQL error 936)

  error message returned by DbSl:

ORA-00936: missing expression

(DB) INFO: disconnected from DB

D:\usr\sap\DEV\DVEBMGS00\exe\R3load.exe: job finished with 1 error(s)

D:\usr\sap\DEV\DVEBMGS00\exe\R3load.exe: END OF LOG: 20151201000547

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

How to resolve the issue ,Please suggest .

Regards

Rableen

[Former Member]

Hi Frd,

I tried again after upgrade of R3load, DBSL patch and kernal also...But still the same issue persist.

Please help.

Regards

Rableen

[Former Member]

Hello Rableen,

Please upload your MARA-2.WHR file.

The syntax error is coming from this file and I'd be tempted to guess that it's possibly unbalanced quotes.

Did you just restart after updating the libdbsl and R3* tools. I assume you didn't run the splitting step again after the tools update.

Anyway, upload the file and we'll see. I'd also suggest starting your export from scratch with the up to date tools in place first.

KR,

Amerjit

[Former Member]

Hi Amerjit,

I pass the splitTable.txt and inside content is as below.

MARA%4

MSEG%5

and its generated MARA-1.WHR and MARA-2.WHR with the inside content as below.

tab: MARA

WHERE

Please suggest this looks fine or not ?

Regards

Rableen

[Sriram2009]

Hi Rableen

Could you pls update the latest log as attachment after upgraded the kernel & DBSL patch?

Regards

SS

[Former Member]

Hello Rableen,

Just to be 100% sure that what you have posted is the complete contents of MARA-1.WHR and MARA-2.WHR.

tab: MARA
WHERE

If what you have posted is indeed the content then it is wrong and hence your error. The WHERE should contain a condition and in your case there is nothing. Normally you should have a key field and a upper/lower limit for the select. I've seen this problem in the past and it was due to a bug in the libdbsl.

eg;

tab: MARA

WHERE ("MATNR" < 'XXXX')

As I mentioned in a previous reply, you should always start with the latest patch levels of R3* and libdbsl.

So for you (as it's just a test) you could either run your splitting again (create WHR files again) and then try to continue or if you want it to be 100% clean for the purposes of creating a decent procedure, I'd start completely afresh with the update tool versions.

Just as a side note, why have you considered splitting MARA ? It's just material masters and I can't imagine that the table is that huge.

Additionally, please use the Oracle splitter from OSS #1043380 as I have already suggested. It's much faster than R3ta.

ps: Have a look at your other WHR files where you may see the correct syntax (assuming that they have been correctly generated).

Kindest Regards,

Amerjit

[Privete_member__1337190]

Hi Rableen,

i had the same issue.

The reason for this was that the tables were all empty... ... nothing to split!

Regards Thomas

[Former Member]

Hello Rableen,

SS has already asked for the kernel/dbsl versions but I can see that your R3load is *very* old (May 7 2010).

As a general rule you should always use the latest R3* tools (R3load/R3ldctl/R3szchk/R3ta) when doing migrations and where possible also update your libdbsl. In your case I would have a suspicion it's coming from the libdbsl.

I see you are using R3ta based splitting and I would strongly suggest that you use the Oracle splitter from OSS #1043380.

Kindest Regards,

Amerjit

[Sriram2009]

Hi Rableen

1. Could you share the kernel & Dbsl patch level? if it is low apply latest and then retry the same phase.

2.  Kindly refer the SAP Notes for the error message " DbSl Trace: ORA-00936 occurred when executing SQL stmt "

1960468 - ORA-03001/ORA-00936, EXPLAIN PLAN, reconnect

1848921 - Errors caused by report RSDB2DAL after applying support packages

Regards

SS