cancel
Showing results for 
Search instead for 
Did you mean: 

SYSTEM-COPY -> 'SQL0104N An unexpected token "END-OF-STATEMENT" was found'

Former Member
0 Kudos

Hello,

we try to convert a System to Unicode.

Splitted tables are used and when the procedure tries to load them,

we get the following error:

---

(DB6) ERROR: Could not execute LOAD statement.

(DB6) ERROR: sql code: -104

(DB6) ERROR: message text: SQL0104N  An unexpected token "END-OF-STATEMENT" was found following "C".

Expected tokens may include:  "JOIN <joined_table>".  SQLSTATE=42601

(DB6) ERROR: sql statement: CALL ADMIN_CMD( 'LOAD FROM ( SELECT * FROM "DBERCHZ1_SPLITTED_LOAD_1834243

49" UNION ALL SELECT * FROM "DBERCHZ1_SPLITTED_LOAD_2544874828" UNION ALL SELECT * FROM "DBERCHZ1_SPLI

TTED_LOAD_3176699437" UNION ALL SELECT * FROM "DBERCHZ1_SPLITTED_LOAD_575480923" /* <OPTGUIDELINES ><D

EGREE VALUE=''ANY'' /></OPTGUIDELINES> */  ) OF CURSOR REPLACE INTO "DBERCHZ1" NONRECOVERABLE CPU_PARA

LLELISM 4 FETCH_PARALLELISM YES ' )

(DB) INFO: disconnected from DB

---

There are several questions from my side...

As far as i understand, the statement comes from the Copy-Tools... Is this correct ?

Does that mean, that there is a bug inside the SAP-Tools ?

Can someone explain, which tool is creating the statement ? Migration Monitor ? SAPINST ?

Which process is responsible for it ?

How can we prevent this error ?

Accepted Solutions (1)

Accepted Solutions (1)

Johan_sapbasis
Active Contributor
0 Kudos

Hi,

If not an all proper prepatory steps were taken and followed, I suggest open an OSS to SAPAG to check the logs. And yes sometimes there are bugs in the tools, they are not always perfect.

I would also check note 515968 and 628156 .

Kind Regards,

Former Member
0 Kudos

Hi Nicolaas,

thank you for your hint.

The problem is solved. There was a bug in R3Load again.

Kind regards

Christoph

Answers (0)