I have attached the loader log file. Thanks
David Hi Hans-Georg, I am not a SAP customer so I don't believe I can raise this issue on service.sap.com. I am analysing data extracted from a decommisioned SAP system which has been provided in a fixed field format. I will post the loader file. Thanks David On Tue Sep 12 13:03 , "Bumes, Hans-Georg" sent: please open a message in the "sap support portal" service.sap.com to analyze the error one needs the loader logfile. thanks hgb -----Original Message----- From: [EMAIL PROTECTED] [EMAIL PROTECTED]','','','')">[EMAIL PROTECTED] Sent: Dienstag, 12. September 2006 12:47 To: maxdb@lists.mysql.com Subject: Error with Loadercli: SQL error -1105 (too complicated SQL statement) I am trying to load the table REGUP from R/3 4.6 into maxdb 7.6.00.32 using loadercli but receive the following error message: Error during execution -->-25010 SQL error -1105 = Too complicated SQL statement (too much data) (error position: 1645) Maxdb parameters: _PACKET_SIZE 131072 _MBLOCK_DATA_SIZE 32768 File extract: IMPORT TABLE REGUP DATA INSTREAM FILE 'F:\REGUP.txt' FORMATTED MANDT 1-3 CHAR LAUFD 4-11 CHAR LAUFI 12-17 CHAR XVORL 18-18 CHAR ZBUKR 19-22 CHAR LIFNR 23-32 CHAR KUNNR 33-42 CHAR EMPFG 43-58 CHAR VBLNR 59-68 CHAR BUKRS 69-72 CHAR BELNR 73-82 CHAR GJAHR 83-86 CHAR BUZEI 87-89 CHAR FILKD 90-99 CHAR ZLSCH 100-100 CHAR Does anyone know why this is happening? Thanks David -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
// M Loader 7.6.00 Build 032-123-130-190 // * // M Module: c:\program files\sdb\programs\pgm\lserver.exe // * // M Loader instance started at PC923321982856 // * // M Starting protocol at 2006090600223009 // * // M START 20060906 00223009 // * set // * // M START 20060906 00223009 // * USE USER "DBADMIN" * SCHEMA DBADMIN SERVERDB "MAXDB2" // * // M USER: 'DBADMIN' on DB: 'MAXDB2' ISOLATION LEVEL: 3 // * // M START 20060906 00223009 // * IMPORT TABLE REGUP DATA INSTREAM FILE 'C:\REGUP.txt' FORMATTED MANDT 1-3 LAUFD 4-11 LAUFI 12-17 XVORL 18-18 ZBUKR 19-22 LIFNR 23-32 KUNNR 33-42 EMPFG 43-58 VBLNR 59-68 BUKRS 69-72 BELNR 73-82 GJAHR 83-86 BUZEI 87-89 FILKD 90-99 ZLSCH 100-100 WAERS 101-105 HBKID 106-110 BVTYP 111-114 POKEN 115-117 XBLNR 118-133 BLART 134-135 BUDAT 136-143 BLDAT 144-151 KOART 152-152 BSCHL 153-154 HKONT 155-164 SAKNR 165-174 UMSKZ 175-175 UMSKS 176-176 ZUMSK 177-177 SHKZG 178-178 DMBTR 179-191 WRBTR 192-204 BDIFF 205-217 GSBER 218-221 MWSKZ 222-223 MWSTS 224-236 WMWST 237-249 MWSK1 250-251 DMBT1 252-264 WRBT1 265-277 MWSK2 278-279 DMBT2 280-292 WRBT2 293-305 MWSK3 306-307 DMBT3 308-320 WRBT3 321-333 SGTXT 334-383 ZFBDT 384-391 ZTERM 392-395 ZBD1T 396-398 ZBD2T 399-401 ZBD3T 402-404 ZBD1P 405-409 ZBD2P 410-414 SKFBT 415-427 SKNTO 428-440 WSKTO 441-453 ZBFIX 454-454 ZLSPR 455-455 SPLEV 456-456 XREBZ 457-457 ZOLLT 458-465 ZOLLD 466-473 LZBKZ 474-476 LANDL 477-479 DIEKZ 480-480 QSSKZ 481-482 QSSHB 483-495 QBSHB 496-508 QBSHH 509-521 ESRNR 522-532 ESRRE 533-559 ESRPZ 560-561 ZBDXT 562-564 ZBDXP 565-569 MSHBT 570-582 MSFBT 583-595 PROJN 596-611 AUFNR 612-623 ANLN1 624-635 ANLN2 636-639 EBELN 640-649 EBELP 650-654 XANET 655-655 XNETB 656-656 XNACH 657-657 ZWELS 658-667 VBUND 668-673 STCEG 674-693 EGBLD 694-696 EGLLD 697-699 QSZNR 700-709 BDIF2 710-722 DSKVH 723-735 POKLA 736-736 FIPOS 737-750 PROJK 751-758 NPLNR 759-770 AUFPL 771-780 APLZL 781-788 XEGDR 789-789 BDIF3 790-802 DMBE2 803-815 DMBE3 816-828 MWST2 829-841 SKNT2 842-854 SKNT3 855-867 QBSH2 868-880 QBSH3 881-893 DMB21 894-906 DMB22 907-919 DMB23 920-932 DMB31 933-945 DMB32 946-958 DMB33 959-971 UZAWE 972-973 MWST3 974-986 ZUONR 987-1004 OSKTO 1005-1017 VERTN 1018-1030 IMKEY 1031-1038 REBZT 1039-1039 REBZG 1040-1049 REBZJ 1050-1053 REBZZ 1054-1056 KOSTL 1057-1066 XINVE 1067-1067 VBEL2 1068-1077 VPOS2 1078-1083 ZEKKN 1084-1085 POSN2 1086-1091 ETEN2 1092-1095 FISTL 1096-1111 GEBER 1112-1121 DABRZ 1122-1129 KKBER 1130-1133 EMPFB 1134-1143 PRCTR 1144-1153 XREF1 1154-1165 XREF2 1166-1177 XREF3 1178-1197 ZINKZ 1198-1199 DTWS1 1200-1201 DTWS2 1202-1203 DTWS3 1204-1205 DTWS4 1206-1207 KEYNO 1208-1217 PAMTF 1218-1230 MANSP 1231-1231 KIDNO 1232-1261 XCPDD 1262-1262 VERTT 1263-1263 VBEWA 1264-1267 AGZEI 1268-1272 PSWSL 1273-1277 PSWBT 1278-1290 PSSKT 1291-1303 XPYAM 1304-1304 GDIFF 1305-1317 GDIF2 1318-1330 GDIF3 1331-1343 BUPLA 1344-1347 SECCO 1348-1351 XSAEN 1352-1352 KBLNR 1353-1362 KBLPOS 1363-1365 ORIGIN 1366-1373 PENLC1 1374-1386 PENLC2 1387-1399 PENLC3 1400-1412 PENFC 1413-1425 PENDAYS 1426-1435 PPRCT 1436-1445 GRANT_NBR 1446-1465 FKBER 1466-1481 // * // M Import PACKAGE x'01000000E1CE0FFB74080000480E00008F7D1E41E2593388' // * // M Execute PACKAGE to transform DATA // * // M Number of TABLES to transform: 0 // * // E -25010: SQL error -1105 = Too complicated SQL statement (too much data) (error position: 1645) // M Releasing user connection (USER: 'DBADMIN'). // *
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
