Hallo,
ich habe ein Problem bei Export der Lieferscheindaten. Wenn ich dein Lieferschein ausdrucken will kommt die Fehlermeldung:
Während der Lieferschein-Export ist ein Fehler aufgetreten. Näheres dazu finden Sie im SQL-Log.
Unter allgemeinen Einstellungen habe ich bei den Lieferarten bei dem Versandunternehmen unter Exporteinstellungen die Felder wie z.B. Anrede, Name, Strasse u.s.w hinzugefügt.
Warum klappt der Export nicht.
Hier der SQL Log (müsste an 4ter Stelle kommen:
12.09.13 14:58:08:495
SQL:select * from REGISTRY
where MAINKEY='MAIN' and NAME='LAND'
RES:OK.
12.09.13 14:58:08:540
SQL:select * from REGISTRY
where MAINKEY='MAIN\\REPORT' and NAME='ZAHLUNGSZIEL2_TEXT'
RES:OK.
12.09.13 14:58:08:584
SQL:select * from REGISTRY
where MAINKEY='MAIN\\ADRESSEN\\FORMAT' and NAME='FORMAT_005'
RES:OK.
12.09.13 14:58:08:696
SQL:select AD.*,L.NAME as LAND_LANG, L.FORMAT
from ADRESSEN AD
left outer JOIN LAND L on L.ID=AD.LAND
where AD.REC_ID = 13465
limit 0,10
RES:OK.
12.09.13 14:58:08:770
SQL:select AL.ANREDE,AL.NAME1,AL.NAME2,AL.NAME3,AL.ABTEILUNG,AL.STRASSE,IFNULL(L.POST_CODE,AL.LAND) as LAND,AL.PLZ,AL.ORT,L.NAME as LAND_LANG,L.FORMAT from ADRESSEN_LIEF AL left outer JOIN LAND L on L.ID=AL.LAND where AL.REC_ID=-1
RES:OK.
12.09.13 14:58:08:819
SQL:select * from REGISTRY
where MAINKEY='MAIN' and NAME='LAND'
RES:OK.
12.09.13 14:58:08:861
SQL:select * from REGISTRY
where MAINKEY='MAIN\\REPORT' and NAME='ZAHLUNGSZIEL2_TEXT'
RES:OK.
12.09.13 14:58:08:904
SQL:select * from REGISTRY
where MAINKEY='MAIN\\ADRESSEN\\FORMAT' and NAME='FORMAT_005'
RES:OK.
12.09.13 14:58:09:061
SQL:select AD.*,L.NAME as LAND_LANG, L.FORMAT
from ADRESSEN AD
left outer JOIN LAND L on L.ID=AD.LAND
where AD.REC_ID = 13465
limit 0,10
RES:OK.
12.09.13 14:58:09:137
SQL:select AL.ANREDE,AL.NAME1,AL.NAME2,AL.NAME3,AL.ABTEILUNG,AL.STRASSE,IFNULL(L.POST_CODE,AL.LAND) as LAND,AL.PLZ,AL.ORT,L.NAME as LAND_LANG,L.FORMAT from ADRESSEN_LIEF AL left outer JOIN LAND L on L.ID=AL.LAND where AL.REC_ID=-1
RES:OK.
12.09.13 14:58:09:186
SQL:select * from REGISTRY
where MAINKEY='MAIN' and NAME='LAND'
RES:OK.
12.09.13 14:58:09:228
SQL:select * from REGISTRY
where MAINKEY='MAIN\\REPORT' and NAME='ZAHLUNGSZIEL2_TEXT'
RES:OK.
12.09.13 14:58:09:265
SQL:select * from REGISTRY
where MAINKEY='MAIN\\ADRESSEN\\FORMAT' and NAME='FORMAT_005'
RES:OK.
12.09.13 14:58:09:299
SQL:UPDATE JOURNAL SET PRINT_FLAG="Y" WHERE REC_ID=18003
RES:OK.
12.09.13 14:58:09:355
SQL:select AUTOZAHL_FLAG as FLAG from ZAHLUNGSARTEN where AUTOZAHL_FLAG="Y" and REC_ID = 0
RES:OK.
12.09.13 14:58:09:394
SQL:select count(*) as ANZ from JOURNAL where QUELLE = 13 and QUELLE_SUB<>2
RES:OK.
12.09.13 14:58:09:444
SQL:select J.*,IF(SUM(ISNULL(LP.REC_ID))=0,"A",IF(SUM(ISNULL(LP.REC_ID))=SUM(IF(JP.ARTIKELTYP="L",0,A.MENGE_AKT)>=IF(JP.ARTIKELTYP="L",0,JP.MENGE) and ISNULL(LP.REC_ID)),"V",IF(SUM(IF(JP.ARTIKELTYP="L",0,A.MENGE_AKT)>=IF(JP.ARTIKELTYP="L",0,JP.MENGE) and ISNULL(LP.REC_ID))>0,"T","N"))) as LIEFER_STATUS, TRIM(CONCAT_WS(" ",KUN_NAME1,KUN_NAME2,KUN_NAME3)) as KUN_NAME,J.VERSNR, TRIM(CONCAT_WS(" ",J.KUN_STRASSE,"-",J.KUN_LAND,J.KUN_PLZ,J.KUN_ORT)) as KUN_ADRESSE FROM JOURNAL J left outer JOIN JOURNALPOS JP on J.REC_ID=JP.JOURNAL_ID and JP.ARTIKELTYP IN("N","X","L") and JP.MENGE!=0 left outer JOIN ARTIKEL A on JP.ARTIKEL_ID=A.REC_ID left outer join LIEFERSCHEIN_POS LP on LP.RECHPOS_ID=JP.REC_ID where J.QUELLE=13 and J.QUELLE_SUB<>2 group by J.REC_ID order by length(J.VRENUM),J.VRENUM,J.RDATUM limit 0,999999
RES:OK.
12.09.13 14:58:09:546
SQL:select ANREDE, NAME, VORNAME from ADRESSEN_ASP WHERE ADDR_ID=0
RES:OK.
12.09.13 14:58:09:575
SQL:select * from ADRESSEN_LIEF where REC_ID=0
RES:OK.
12.09.13 14:58:09:602
SQL:select REC_ID, INFO as ADR_INFO
from ADRESSEN
where REC_ID=0
RES:OK.
12.09.13 14:58:09:648
SQL:select * from VERTRETER
order by VERTR_NUMMER
RES:OK.
12.09.13 14:58:09:711
SQL:select A.REC_ID,A.EK_PREIS,A.VK1,A.VK2,A.VK3,A.VK4,A.VK5,A.VK1B,A.VK2B,A.VK3B,A.VK4B,A.VK5B, AP.PREIS,AP.MENGE2,AP.PREIS2,AP.MENGE3,AP.PREIS3,AP.MENGE4,AP.PREIS4, AP.MENGE5,AP.PREIS5,A.MENGE_AKT,AB_EKBEST.SUM_MENGE as MENGE_BESTELLT, A.RABGRP_ID,SUM(AB_VKRE_EDI.SUM_MENGE) as MENGE_RESERVIERT, SUM(AB_VKRE_EDI.SUM_MENGE)+SUM(AB_VKRE_EDI.SUM_AU_MENGE) as MENGE_RESERVIERT_TOTAL,A.ALTTEIL_FLAG,A.NO_RABATT_FLAG,A.NO_PROVISION_FLAG,A.NO_BEZEDIT_FLAG,A.NO_VK_FLAG,A.NO_EK_FLAG,A.SN_FLAG,A.PROVIS_PROZ,A.STEUER_CODE,A.ERLOES_KTO,A.AUFW_KTO,A.ARTNUM,A.ERSATZ_ARTNUM,A.MATCHCODE,A.WARENGRUPPE,A.BARCODE,A.ARTIKELTYP,A.KAS_NAME,ME.BEZEICHNUNG as ME_EINHEIT,A.PR_EINHEIT,A.VPE,A.LAENGE,A.BREITE,A.HOEHE,A.GROESSE,A.DIMENSION,A.GEWICHT,A.INFO,KURZNAME,LANGNAME,AP.PREIS_TYP,AP.ADRESS_ID,AP.BESTNUM ,LIEFPOS.MENGE as MENGE_LIEF, JP1.MENGE as MENGE_SOLL, JP1.REC_ID as JID from JOURNALPOS JP1 inner join ARTIKEL A on JP1.ARTIKEL_ID=A.REC_ID left outer join ARTIKEL_PREIS AP on AP.ARTIKEL_ID=A.REC_ID left outer join LIEFERSCHEIN_POS LIEFPOS on LIEFPOS.REC_ID=JP1.QUELLE_SRC left outer join ARTIKEL_BDATEN AB_EKBEST on AB_EKBEST.ARTIKEL_ID=A.REC_ID and AB_EKBEST.QUELLE=26 left outer join ARTIKEL_BDATEN AB_VKRE_EDI on AB_VKRE_EDI.ARTIKEL_ID=A.REC_ID and AB_VKRE_EDI.QUELLE in(19) left outer JOIN MENGENEINHEIT ME on ME.REC_ID=A.ME_ID where (JP1.JOURNAL_ID=0) and (JP1.QUELLE=13) group by A.REC_ID, AP.PREIS_TYP, AP.ADRESS_ID, JP1.REC_ID
RES:OK.
12.09.13 14:58:09:876
SQL:select JP.*,L.VLSNUM,L.LDATUM,LP.REC_ID as LP_REC_ID, A.INFO as ART_INFO
from JOURNALPOS JP
left outer JOIN LIEFERSCHEIN_POS LP ON LP.RECHPOS_ID=JP.REC_ID
left outer join LIEFERSCHEIN L on LP.LIEFERSCHEIN_ID=L.REC_ID
left outer join ARTIKEL A on A.REC_ID=JP.ARTIKEL_ID
where JP.JOURNAL_ID=0 and JP.TOP_POS_ID=-1
group by JP.REC_ID
order by JP.POSITION,JP.REC_ID
RES:OK.
12.09.13 14:58:09:957
SQL:select
REC_ID
from ARTIKEL_STUECKLIST
where (REC_ID= 0) and ARTIKEL_ART ='ZUB'
RES:OK.
12.09.13 14:58:10:002
SQL:select
REC_ID
from ARTIKEL_STUECKLIST
where (REC_ID= 0) and ARTIKEL_ART ='ERS'
RES:OK.
12.09.13 14:58:10:050
SQL:select JP.*,L.VLSNUM,L.LDATUM,LP.REC_ID as LP_REC_ID, A.INFO as ART_INFO
from JOURNALPOS JP
left outer JOIN LIEFERSCHEIN_POS LP ON LP.RECHPOS_ID=JP.REC_ID
left outer join LIEFERSCHEIN L on LP.LIEFERSCHEIN_ID=L.REC_ID
left outer join ARTIKEL A on A.REC_ID=JP.ARTIKEL_ID
where JP.JOURNAL_ID=0 and JP.TOP_POS_ID=-1
group by JP.REC_ID
order by JP.POSITION,JP.REC_ID
RES:OK.
12.09.13 14:58:10:116
SQL:select * from ADRESSEN_LIEF where REC_ID=0
RES:OK.
12.09.13 14:58:10:147
SQL:select ANREDE, NAME, VORNAME from ADRESSEN_ASP WHERE ADDR_ID=0
RES:OK.
12.09.13 14:58:10:177
SQL:SELECT RELEASE_LOCK("cao_svital_MOD_2040_RECID_0") as LOCKVAR
RES:OK.
12.09.13 14:58:10:210
SQL:select J.*,IF(SUM(ISNULL(LP.REC_ID))=0,"A",IF(SUM(ISNULL(LP.REC_ID))=SUM(IF(JP.ARTIKELTYP="L",0,A.MENGE_AKT)>=IF(JP.ARTIKELTYP="L",0,JP.MENGE) and ISNULL(LP.REC_ID)),"V",IF(SUM(IF(JP.ARTIKELTYP="L",0,A.MENGE_AKT)>=IF(JP.ARTIKELTYP="L",0,JP.MENGE) and ISNULL(LP.REC_ID))>0,"T","N"))) as LIEFER_STATUS, TRIM(CONCAT_WS(" ",KUN_NAME1,KUN_NAME2,KUN_NAME3)) as KUN_NAME,J.VERSNR, TRIM(CONCAT_WS(" ",J.KUN_STRASSE,"-",J.KUN_LAND,J.KUN_PLZ,J.KUN_ORT)) as KUN_ADRESSE FROM JOURNAL J left outer JOIN JOURNALPOS JP on J.REC_ID=JP.JOURNAL_ID and JP.ARTIKELTYP IN("N","X","L") and JP.MENGE!=0 left outer JOIN ARTIKEL A on JP.ARTIKEL_ID=A.REC_ID left outer join LIEFERSCHEIN_POS LP on LP.RECHPOS_ID=JP.REC_ID where J.QUELLE=13 and J.QUELLE_SUB<>2 group by J.REC_ID order by length(J.VRENUM),J.VRENUM,J.RDATUM limit 0,999999
RES:OK.
12.09.13 14:58:10:297
SQL:SELECT RELEASE_LOCK("cao_svital_MOD_2040_RECID_0") as LOCKVAR
RES:OK.
12.09.13 14:58:10:334
SQL:select J.*,IF(SUM(ISNULL(LP.REC_ID))=0,"A",IF(SUM(ISNULL(LP.REC_ID))=SUM(IF(JP.ARTIKELTYP="L",0,A.MENGE_AKT)>=IF(JP.ARTIKELTYP="L",0,JP.MENGE) and ISNULL(LP.REC_ID)),"V",IF(SUM(IF(JP.ARTIKELTYP="L",0,A.MENGE_AKT)>=IF(JP.ARTIKELTYP="L",0,JP.MENGE) and ISNULL(LP.REC_ID))>0,"T","N"))) as LIEFER_STATUS, TRIM(CONCAT_WS(" ",KUN_NAME1,KUN_NAME2,KUN_NAME3)) as KUN_NAME,J.VERSNR, TRIM(CONCAT_WS(" ",J.KUN_STRASSE,"-",J.KUN_LAND,J.KUN_PLZ,J.KUN_ORT)) as KUN_ADRESSE FROM JOURNAL J left outer JOIN JOURNALPOS JP on J.REC_ID=JP.JOURNAL_ID and JP.ARTIKELTYP IN("N","X","L") and JP.MENGE!=0 left outer JOIN ARTIKEL A on JP.ARTIKEL_ID=A.REC_ID left outer join LIEFERSCHEIN_POS LP on LP.RECHPOS_ID=JP.REC_ID where J.QUELLE=13 and J.QUELLE_SUB<>2 group by J.REC_ID order by length(J.VRENUM),J.VRENUM,J.RDATUM limit 0,999999
RES:OK.
12.09.13 14:58:10:432
SQL:select VAL_INT as ORDERSTATUS_ID,NAME as LANGBEZ from REGISTRY where MAINKEY="SHOP\\ORDERSTATUS" order by ORDERSTATUS_ID
RES:OK.
12.09.13 14:58:10:475
SQL:select * from REGISTRY
where MAINKEY='USERSETTINGS\\Dörsam' and NAME='PRTMSGREQ'
RES:OK.
12.09.13 14:58:10:516
SQL:select * from REGISTRY
where MAINKEY='MAIN\\BELEGE' and NAME='SHOWPOPUP'
RES:OK.
12.09.13 14:58:10:558
SQL:select * from REGISTRY
where MAINKEY='MAIN\\BELEGE' and NAME='PROFIT'
RES:OK.
12.09.13 14:58:10:600
SQL:select * from REGISTRY
where MAINKEY='MAIN\\BELEGE' and NAME='XPTIMER'
RES:OK.
12.09.13 14:58:10:642
SQL:select * from REGISTRY
where MAINKEY='MAIN\\BELEGE' and NAME='AUTOPAY_TO_INVOICE'
RES:OK.
12.09.13 14:58:10:684
SQL:select * from REGISTRY
where MAINKEY='MAIN\\ARTIKEL' and NAME='CALCSTK'
RES:OK.
12.09.13 14:58:10:728
SQL:select REC_ID, INFO as ADR_INFO
from ADRESSEN
where REC_ID=0
RES:OK.