on 05-25-2016 8:09 AM
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 ?
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.