Skip to Content
0
Former Member
May 25, 2016 at 07:09 AM

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

641 Views

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 ?