Signavio Process Intelligence The field of type BINARY is not supported

[santiagolc]

Hi team,

We are extracting data from S/4 Hana System and some tables cancel the extraction because of this error:

"The field of type BINARY is not supported. Caused by Key -2 is missing in the map."

here more details:

ExtractionJob failed
| source-system: SAP
| cause:
    The field of type BINARY is not supported. Caused by
      Key -2 is missing in the map.
| sql-query: [SELECT "MANDANT" as "mandant", "PRUEFLOS" as "prueflos", "WERK" as "werk", "ART" as "art", "HERKUNFT" as "herkunft", "OBJNR" as "objnr", "OBTYP" as "obtyp", "STSMA" as "stsma", "QMATAUTH" as "qmatauth", "STAT11" as "stat11", "INSMK" as "insmk", "STAT01" as "stat01", "STAT02" as "stat02", "STAT04" as "stat04", "STAT06" as "stat06", "STAT07" as "stat07", "STAT08" as "stat08", "STAT09" as "stat09", "STAT10" as "stat10", "STAT14" as "stat14", "STAT16" as "stat16", "STAT18" as "stat18", "STAT19" as "stat19", "STAT20" as "stat20", "STAT21" as "stat21", "STAT22" as "stat22", "STAT23" as "stat23", "STAT24" as "stat24", "STAT25" as "stat25", "STAT29" as "stat29", "STAT26" as "stat26", "STAT27" as "stat27", "STAT28" as "stat28", "STAT31" as "stat31", "STAT34" as "stat34", "STAT35" as "stat35", "STAT45" as "stat45", "STAT46" as "stat46", "STAT47" as "stat47", "STAT48" as "stat48", "STAT49" as "stat49", "STAT50" as "stat50", "KZSKIPLOT" as "kzskiplot", "DYN" as "dyn", "HPZ" as "hpz", "EIN" as "ein", "ANZSN" as "anzsn", "KZDYNERF" as "kzdynerf", "DYNHEAD" as "dynhead", "STPRVER" as "stprver", "EXTNUM" as "extnum", "STAFO" as "stafo", "STAT30" as "stat30", "QINFSTATUS" as "qinfstatus", "ENSTEHDAT" as "enstehdat", "ENTSTEZEIT" as "entstezeit", "ERSTELLER" as "ersteller", "ERSTELDAT" as "ersteldat", "ERSTELZEIT" as "erstelzeit", "AENDERER" as "aenderer", "AENDERDAT" as "aenderdat", "AENDERZEIT" as "aenderzeit", "CHANGEDDATETIME" as "changeddatetime", "PASTRTERM" as "pastrterm", "PASTRZEIT" as "pastrzeit", "PAENDTERM" as "paendterm", "PAENDZEIT" as "paendzeit", "PLNTY" as "plnty", "PLNNR" as "plnnr", "PPLVERW" as "pplverw", "PLNAL" as "plnal", "ZAEHL" as "zaehl", "ZKRIZ" as "zkriz", "STAT15" as "stat15", "SLWBEZ" as "slwbez", "STAT13" as "stat13", "PPKZTLZU" as "ppkztlzu", "ZAEHL1" as "zaehl1", "PRBNAVERF" as "prbnaverf", "PRBNAVV" as "prbnavv", "STAT12" as "stat12", "SELMATNR" as "selmatnr", "SELREVLV" as "selrevlv", "SELWERK" as "selwerk", "SELLIFNR" as "sellifnr", "STAT17" as "stat17", "SELHERST" as "selherst", "SELKUNNR" as "selkunnr", "SELPPLVERW" as "selpplverw", "GUELTIGAB" as "gueltigab", "AUFNR" as "aufnr", "AUFPL" as "aufpl", "CUOBJ" as "cuobj", "CUOBJ_CH" as "cuobj_ch", "VERID" as "verid", "SA_AUFNR" as "sa_aufnr", "CVP_XBLCK" as "cvp_xblck", "KUNNR" as "kunnr", "LIFNR" as "lifnr", "HERSTELLER" as "hersteller", "EMATNR" as "ematnr", "MATNR" as "matnr", "REVLV" as "revlv", "XCHPF" as "xchpf", "CHARG" as "charg", "LAGORTCHRG" as "lagortchrg", "ZEUGNISBIS" as "zeugnisbis", "VFDAT" as "vfdat", "LICHN" as "lichn", "SOBKZ" as "sobkz", "PS_PSP_PNR" as "ps_psp_pnr", "KDAUF" as "kdauf", "KDPOS" as "kdpos", "EKORG" as "ekorg", "EBELN" as "ebeln", "EBELP" as "ebelp", "ETENR" as "etenr", "BLART" as "blart", "MJAHR" as "mjahr", "MBLNR" as "mblnr", "ZEILE" as "zeile", "BUDAT" as "budat", "BWART" as "bwart", "WERKVORG" as "werkvorg", "LAGORTVORG" as "lagortvorg", "LGNUM" as "lgnum", "LGTYP" as "lgtyp", "LGPLA" as "lgpla", "LS_KDAUF" as "ls_kdauf", "LS_KDPOS" as "ls_kdpos", "LS_VBELN" as "ls_vbeln", "LS_POSNR" as "ls_posnr", "LS_ABRVW" as "ls_abrvw", "LS_ROUTE" as "ls_route", "LS_LLAND" as "ls_lland", "LS_KUNAG" as "ls_kunag", "LS_VKORG" as "ls_vkorg", "LS_KDMAT" as "ls_kdmat", "SPRACHE" as "sprache", "KTEXTLOS" as "ktextlos", "LTEXTKZ" as "ltextkz", "KTEXTMAT" as "ktextmat", "ZUSMKZAEHL" as "zusmkzaehl", "OFFENNLZMK" as "offennlzmk", "OFFEN_LZMK" as "offen_lzmk", "LOSMENGE" as "losmenge", "MENGENEINH" as "mengeneinh", "ANZGEB" as "anzgeb", "GEBEH" as "gebeh", "LVS_STIKZ" as "lvs_stikz", "LVS_STIMG" as "lvs_stimg", "GESSTICHPR" as "gesstichpr", "EINHPROBE" as "einhprobe", "DYNREGEL" as "dynregel", "STAT44" as "stat44", "PRSTUFE" as "prstufe", "PRSCHAERFE" as "prschaerfe", "LMENGE01" as "lmenge01", "LMENGE02" as "lmenge02", "LMENGE03" as "lmenge03", "LMENGE04" as "lmenge04", "LMENGE05" as "lmenge05", "LMENGE06" as "lmenge06", "MATNRNEU" as "matnrneu", "CHARGNEU" as "chargneu", "LMENGE07" as "lmenge07", "LMENGE08" as "lmenge08", "LMENGE09" as "lmenge09", "LMENGEZUB" as "lmengezub", "LMENGELZ" as "lmengelz", "LMENGEPR" as "lmengepr", "LMENGEZER" as "lmengezer", "LMENGEIST" as "lmengeist", "LMENGESCH" as "lmengesch", "LTEXTKZBB" as "ltextkzbb", "ANTEIL" as "anteil", "QKZVERF" as "qkzverf", "STAT03" as "stat03", "QPMATLOS" as "qpmatlos", "AUFNR_CO" as "aufnr_co", "KZVBR" as "kzvbr", "KNTTP" as "knttp", "PSTYP" as "pstyp", "STAT05" as "stat05", "KOSTL" as "kostl", "AUFPS" as "aufps", "ANLN1" as "anln1", "ANLN2" as "anln2", "KONT_PSPNR" as "kont_pspnr", "NPLNR" as "nplnr", "APLZL" as "aplzl", "KONT_KDAUF" as "kont_kdauf", "KONT_KDPOS" as "kont_kdpos", "IMKEY" as "imkey", "DABRZ" as "dabrz", "KSTRG" as "kstrg", "PAOBJNR" as "paobjnr", "PRCTR" as "prctr", "GSBER" as "gsber", "KONTO" as "konto", "KOKRS" as "kokrs", "BUKRS" as "bukrs", "SERNP" as "sernp", "LOS_REF" as "los_ref", "BEARBSTATU" as "bearbstatu", "STAT32" as "stat32", "STAT33" as "stat33", "STAT36" as "stat36", "STAT37" as "stat37", "STAT38" as "stat38", "STAT39" as "stat39", "STAT40" as "stat40", "STAT41" as "stat41", "STAT42" as "stat42", "STAT43" as "stat43", "MENGU" as "mengu", "KZPZADR" as "kzpzadr", "KZPRADR" as "kzpradr", "ZUSCH" as "zusch", "ZUSTD" as "zustd", "KZERSTLIEF" as "kzerstlief", "KZERSTMUST" as "kzerstmust", "ADDON_DUMMY" as "addon_dummy", "WARPL" as "warpl", "WAPOS" as "wapos", "ABNUM" as "abnum", "STRAT" as "strat", "TRIALID" as "trialid", "RESPONSIBLE" as "responsible", "INSP_DOC_NUMBER" as "insp_doc_number", "LOG_SYSTEM" as "log_system", "GESSTICHPR_EXT" as "gesstichpr_ext", "EINHPROBE_EXT" as "einhprobe_ext", "PRIO_PUNKTE" as "prio_punkte", "SIGN_TYPE_RR" as "sign_type_rr", "SIGN_TYPE_UD" as "sign_type_ud", "SIGN_TYPE_SM" as "sign_type_sm", "SIGNSTRAT_RR" as "signstrat_rr", "SIGNSTRAT_UD" as "signstrat_ud", "SIGNSTRAT_SM" as "signstrat_sm", "DUMMY_QALS_INCL_EEW_PS" as "dummy_qals_incl_eew_ps", "LOT_GUID" as "lot_guid", "SETUP_ORIG" as "setup_orig", "EWM_IS_LOCAL" as "ewm_is_local", "CAT_FROM" as "cat_from", "CATLOCN_TO" as "catlocn_to", "PROCESS_STEP" as "process_step", "COO" as "coo", "INSP_GROUP" as "insp_group", "INBOUND_PROC" as "inbound_proc", "IOT_GUID" as "iot_guid", "RLGRP" as "rlgrp", "EXCCODE" as "exccode", "CWMLOSMENGE" as "cwmlosmenge", "CWMMENGENEINH" as "cwmmengeneinh", "CWMLMENGE01" as "cwmlmenge01", "CWMLMENGE02" as "cwmlmenge02", "CWMLMENGE03" as "cwmlmenge03", "CWMLMENGE04" as "cwmlmenge04", "CWMLMENGE05" as "cwmlmenge05", "CWMLMENGE06" as "cwmlmenge06", "CWMLMENGE07" as "cwmlmenge07", "CWMLMENGE08" as "cwmlmenge08", "CWMLMENGE09" as "cwmlmenge09", "CWMLMENGEZUB" as "cwmlmengezub", "CWMLMENGEIST" as "cwmlmengeist" FROM QALS
WHERE ERSTELDAT >= '2022-04-01' AND ERSTELDAT <= '2022-04-30']
| query-params: {}

| anonymize-columns: []

[prateek5609 · Accepted solution]

Hi Santiago,

This issue has been already resolved. Please make sure to use the on Prem extractor version 1.606.0 or newer.

thanks and best regards

[santiagolc · Accepted solution]

Thank you for your reply. I have a question, if I update the Prem extractor do I have to configure again or is it just an update and nothing changes?

Thank you, best regards.

[manuelmeindl]

Hi Santiago,

this link may help you for the topic you asked: https://documentation.signavio.com/suite/en-us/Content/process-intelligence/etl-on-premises-connecto...

Best
Manuel