Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jamesehunt
New Contributor III

ODBC - Error

Hi All,

I get the following Error message "

Started loading data
 
Connecting to LFS - EMEA
Connected
Item Master << PBFSTSS
Lines fetched: 715
Connecting to LFS - EMEA
Connected
Open Preadvice << PBESTSS
Lines fetched: 1.443
Connecting to LFS - EMEA
Connected
 
The following error occurred:
Connector reply error: SQL##f - SqlState: 37000, ErrorCode: 4294967192, ErrorMsg: [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0104 - Token . was not valid. Valid tokens: , FROM INTO.
 
The error occurred here:
SQL SELECT
TPKONZ,
    TPFIRM,
    TPPALN,
    TPZUNV,
    TPTTYP,
    TPVSST,
    TPNBER,
    TPNREG,
    TPNHOR,
    TPNVER,
    TPIDEN,
    TPWENR,
    TPBMEN,
    TPQKZ,
    TPLM,
    TPDTA,
    TPTIA,
    TPAUSR,
FROM Z617D7F2.HE2DATV6.PBESTTP WHERE TPKONZ ='RTM' and TPFIRM ='110'
 
Data has not been loaded. Please correct the error and try loading again.

" when trying to load the following script.

 

SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='#.##0,00 €;-#.##0,00 €';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD.MM.YYYY';
SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]';
SET FirstWeekDay=0;
SET BrokenWeeks=0;
SET ReferenceDay=4;
SET FirstMonthOfYear=1;
SET CollationLocale='de-DE';
SET CreateSearchIndexOnReload=1;
SET MonthNames='Jan.;Feb.;März;Apr.;Mai;Juni;Juli;Aug.;Sep.;Okt.;Nov.;Dez.';
SET LongMonthNames='Januar;Februar;März;April;Mai;Juni;Juli;August;September;Oktober;November;Dezember';
SET DayNames='Mo.;Di.;Mi.;Do.;Fr.;Sa.;So.';
SET LongDayNames='Montag;Dienstag;Mittwoch;Donnerstag;Freitag;Samstag;Sonntag';
SET NumericalAbbreviation='3:k;6:M;9:G;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:μ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y';


// Item Master
LIB CONNECT TO 'LFS - EMEA';
[Item Master]:
LOAD
 TZKONZ,
    TZFIRM,
    TZIDEN,
    TZBRUT,
    TZVLL,
    TZVLB,
    TZVLH,
    DATE(DATE#(TZDTM,'YYYYMMDD')) as TZDTM, // formating LFS Date in Qlik Date
    TIME(TIME#(TZTIM, If(len(Trim(TZTIM))=5,'hmmss','hhmmss'))) as TZTIM;// formating LFS Time in Qlik Time
SQL SELECT
 TZKONZ,
    TZFIRM,
    TZIDEN,
    TZBRUT,
    TZVLL,
    TZVLB,
    TZVLH,
    TZDTM,
    TZTIM
FROM Z617D7F2.HE2DATV6.PBFSTSS WHERE TZKONZ = 'RTM' and TZFIRM = '110';

// Open Preadvice

LIB CONNECT TO 'LFS - EMEA';
[Open Preadvice]:
LOAD
 SSKONZ,
    SSFIRM,
    SSSST,
    SSIDEN,
    SSZUNV,
    SSWENR,
    SSBMEN,
    SSLM,
    DATE(DATE#(SSDTBU,'YYYYMMDD')) as SSDTBU,// formating LFS Date in Qlik Date
    SSQKZ;
SQL SELECT
 SSKONZ,
    SSFIRM,
    SSSST,
    SSIDEN,
    SSZUNV,
    SSWENR,
    SSBMEN,
    SSLM,
    SSDTBU,
    SSQKZ
FROM Z617D7F2.HE2DATV6.PBESTSS WHERE SSKONZ ='RTM' and SSFIRM ='110';

// Inbound Booking

LIB CONNECT TO 'LFS - EMEA';
[Inbound Booking]:
LOAD
 TPKONZ,
    TPFIRM,
    TPPALN,
    TPZUNV,
    TPTTYP,
    TPVSST,
    TPNBER,
    TPNREG,
    TPNHOR,
    TPNVER,
    TPIDEN,
    TPWENR,
    TPBMEN,
    TPQKZ,
    TPLM,
    DATE(DATE#(TPDTA,'YYYYMMDD')) as "TPDTA",// formating LFS Date in Qlik Date,
    TIME(TIME#(TPTIA, If(len(Trim(TPTIA))=5,'hmmss','hhmmss'))) as "TPTIA",// formating LFS Time in Qlik Time,
    TPAUSR;
SQL SELECT
 TPKONZ,
    TPFIRM,
    TPPALN,
    TPZUNV,
    TPTTYP,
    TPVSST,
    TPNBER,
    TPNREG,
    TPNHOR,
    TPNVER,
    TPIDEN,
    TPWENR,
    TPBMEN,
    TPQKZ,
    TPLM,
    TPDTA,
    TPTIA,
    TPAUSR,
FROM Z617D7F2.HE2DATV6.PBESTTP WHERE TPKONZ ='RTM' and TPFIRM ='110';

// Put Away

LIB CONNECT TO 'LFS - EMEA';
[Put Away]:
LOAD
 TPKONZ,
    TPFIRM,
    TPPALN,
    TPTTYP,
    TPNBER,
    TPNREG,
    TPNHOR,
    TPNVER,
    DATE(DATE#(TPDTPP,'YYYYMMDD')) as "TPDTPP",// formating LFS Date in Qlik Date,
    TIME(TIME#(TPTIPP, If(len(Trim(TPTIPP))=5,'hmmss','hhmmss'))) as "TPTIPP",// formating LFS Time in Qlik Time,
    TPIDEN ,
    TPBMEN,
    TPLM,
    TPUSER,
    DATE(DATE#(TPDTTS,'YYYYMMDD')) as "TPDTTS",// formating LFS Date in Qlik Date,
    TIME(TIME#(TPTITS, If(len(Trim(TPTITS))=5,'hmmss','hhmmss'))) as "TPTITS";// formating LFS Time in Qlik Time,
SQL SELECT
 TPKONZ,
    TPFIRM,
    TPPALN,
    TPTTYP,
    TPNBER,
    TPNREG,
    TPNHOR,
    TPNVER,
    TPDTPP,
    TPTIPP,
    TPIDEN,
    TPBMEN,
    TPLM,
    TPUSER,
    TPDTTS,
    TPTITS
FROM Z617D7F2.HE2DATV6.PHISTTP WHERE TPKONZ ='RTM' and TPFIRM ='110';

What I can not understand, if if load only

//Inbound booking or

// Put Away

it works fine, but both togehter doesn't work???

Much Obliged

Labels (2)