11 Replies Latest reply: Feb 2, 2016 12:29 PM by Pablo del Cerro RSS

    QlikView SAP Extractor Connector Issue

    Pablo del Cerro

      Hi Everyone, I´m needing help!!

       

      Currently trying to get data from SAP Exctractor 0HR_PY_1 in order to get Payroll Data.

       

      Followed all the instructions on the SAP Connector Manual, and checked all the troubleshooting but still having the following error:

      2016-01-27 11:47:48 Connector: C:\Program Files\Common Files\QlikTech\Custom Data\QvSAPConnector\QvSAPEXTRConnector.dll Ver: 6.00 IR, Build: 00124

      2016-01-27 11:47:48 Using Server Host: 10.100.3.60 , Port: 8680

      2016-01-27 11:47:48 Host address is: IP number

      2016-01-27 11:47:48 Connected to SAP (ASHOST): SAPDES

      2016-01-27 11:47:48 Making new SAP Request

      2016-01-27 11:47:48 EXTRACTOR = 0HR_PY_1

      2016-01-27 11:47:48 TFRMETHOD = I

      2016-01-27 11:47:48 UPDMODE = F

      2016-01-27 11:47:48 EXTRLANGUAGE = E

      2016-01-27 11:47:48 LOGSYS = QTQVCEXTR1

      2016-01-27 11:47:48 EXTRACTOR 0HR_PY_1#TFRMETHOD I#UPDMODE F#EXTRLANGUAGE E#LOGSYS QTQVCEXTR1#

      2016-01-27 11:47:48 TimeoutSAP :14400

      2016-01-27 11:47:48 TimeoutInit :900

      2016-01-27 11:47:48 TimeoutActivity :7200

      2016-01-27 11:47:48 TimeoutData :3600

      2016-01-27 11:47:49 Received Meta Data, No of Fields: 19

      2016-01-27 11:47:49 Err FAILED 0HR_PY_1 Error: Job already running

      2016-01-27 11:47:51 Disconnected

       

      I have already tried with TFRMETHOD = I (default option set by the wizard) and TFRMETHOD = T, and both jobs gets errors.

       

      Your help will by very appreciated!!!

       

      Thanks

      Pablo

        • Re: QlikView SAP Extractor Connector Issue
          Tomas Sommergyll

          Hi Pablo,

           

          A flag in the status table is set when a new job is started. If the error "Job already running" is returned it means the flag has not been cleared from a previous job. See the link below how to fix it:

           

          https://help.qlik.com/Connectors/en-us/connectors/#../Subsystems/SAP_Connectors_Help/Content/6.1/QV-connection/SAP-Extractor-connection-error-handling.htm

           

          Follow the steps under:

          Canceling a job from the Extractor connector

           

          BR,

          Tomas

            • Re: QlikView SAP Extractor Connector Issue
              Pablo del Cerro

              Tomas,

               

              Thanks for your help!!

               

              Now we get the following error:

              2016-01-28 17:08:34     Connector: C:\Program Files\Common Files\QlikTech\Custom Data\QvSAPConnector\QvSAPEXTRConnector.dll Ver: 6.00 IR, Build: 00124

              2016-01-28 17:08:34     Using Server Host: 10.100.3.60 , Port: 8680

              2016-01-28 17:08:34     Host address is: IP number

              2016-01-28 17:08:34     Connected to SAP (ASHOST): SAPDES

              2016-01-28 17:08:34     Making new SAP Request

              2016-01-28 17:08:34     EXTRACTOR = 0HR_PY_1

              2016-01-28 17:08:34     TFRMETHOD = I

              2016-01-28 17:08:34     UPDMODE = C

              2016-01-28 17:08:34     EXTRLANGUAGE = S

              2016-01-28 17:08:34     LOGSYS = QTQVCEXTR1

              2016-01-28 17:08:34     EXTRACTOR 0HR_PY_1#TFRMETHOD I#UPDMODE C#EXTRLANGUAGE S#LOGSYS QTQVCEXTR1#

              2016-01-28 17:08:34     TimeoutSAP      :14400

              2016-01-28 17:08:34     TimeoutInit     :900

              2016-01-28 17:08:34     TimeoutActivity :7200

              2016-01-28 17:08:34     TimeoutData     :3600

              2016-01-28 17:08:34     Received Meta Data, No of Fields: 19

              2016-01-28 17:08:35 Err FAILED 0HR_PY_1 Error: ID:00 Type:E Number:001 Init already done - delete in transaction /N/QTQVC/DELETE_INIT

              2016-01-28 17:08:37     Disconnected

               

              But when on SAP we execute /N/QTQVC/DELETE_INIT it seem to be empty already.

               

              Any guidance will be really appreaciated!

               

              Thanks!

              Pablo

                • Re: QlikView SAP Extractor Connector Issue
                  Pablo del Cerro

                  Additional information, on the App log i find the following error message:

                  QVX_UNEXPECTED_END_OF_DATA: FAILED 0HR_PY_1 Error:

                  ERROR       illegal parameter value ( function=SAP_CMACCPTP /

                  parameter=handle / value=456 )

                   

                  Full log as follows:

                  28/01/2016  5:13:59 PM:      Ejecución iniciada.

                  28/01/2016  5:13:59 PM:      QlikView Version:11.20.12904.0

                  28/01/2016  5:13:59 PM:      CPU Target                    x64

                  28/01/2016  5:13:59 PM:      Operating System              Windows Server 2012 R2 Standard  (64 bit edition)

                  28/01/2016  5:13:59 PM:      Wow64 mode                    Not using Wow64

                  28/01/2016  5:13:59 PM:      MDAC Version                  6.3.9600.16384

                  28/01/2016  5:13:59 PM:      MDAC Full Install Version     6.3.9600.16384

                  28/01/2016  5:13:59 PM:      PreferredCompression          2

                  28/01/2016  5:13:59 PM:      EnableParallelReload          1

                  28/01/2016  5:13:59 PM:      ParallelizeQvdLoads           1

                  28/01/2016  5:13:59 PM:      AutoSaveAfterReload           0

                  28/01/2016  5:13:59 PM:      BackupBeforeReload            0

                  28/01/2016  5:13:59 PM:      EnableFlushLog                0

                  28/01/2016  5:13:59 PM:      SaveInfoWhenSavingFile        0

                  28/01/2016  5:13:59 PM:      UserLogfileCharset            1200

                  28/01/2016  5:13:59 PM:      OdbcLoginTimeout              -1

                  28/01/2016  5:13:59 PM:      OdbcConnectionTimeout         -1

                  28/01/2016  5:13:59 PM:      ScriptWantsDbWrite            false

                  28/01/2016  5:13:59 PM:      ScriptWantsExe                false

                  28/01/2016  5:13:59 PM:      LogFile CodePage Used:        1200

                  28/01/2016  5:13:59 PM:       Reload Executed By TRANSENER_NT\ext_asaraceno

                  28/01/2016  5:13:59 PM:       Process Executing: QlikView Desktop

                  28/01/2016  5:13:59 PM:       Process ID: 6868

                  28/01/2016  5:13:59 PM: 0002  SET ThousandSep='.'

                  28/01/2016  5:13:59 PM: 0003  SET DecimalSep=','

                  28/01/2016  5:13:59 PM: 0004  SET MoneyThousandSep='.'

                  28/01/2016  5:13:59 PM: 0005  SET MoneyDecimalSep=','

                  28/01/2016  5:13:59 PM: 0006  SET MoneyFormat='$ #.##0,00;$-#.##0,00'

                  28/01/2016  5:13:59 PM: 0007  SET TimeFormat='hh:mm:ss TT'

                  28/01/2016  5:13:59 PM: 0008  SET DateFormat='DD/MM/YYYY'

                  28/01/2016  5:13:59 PM: 0009  SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff] TT'

                  28/01/2016  5:13:59 PM: 0010  SET MonthNames='ene;feb;mar;abr;may;jun;jul;ago;sep;oct;nov;dic'

                  28/01/2016  5:13:59 PM: 0011  SET DayNames='lun;mar;mié;jue;vie;sáb;dom'

                  28/01/2016  5:13:59 PM: 0013  CUSTOM CONNECT*Provider*QvSAPEXTRConnector.dll*XUserId*XPassword*

                  28/01/2016  5:13:59 PM: 0017  [0HR_PY_1]:

                  28/01/2016  5:13:59 PM: 0018  LOAD

                  28/01/2016  5:13:59 PM: 0019   [ANZHL] as [ANZHL.Nómina de personal: Cantidad],

                  28/01/2016  5:13:59 PM: 0020   [BETRG] as [BETRG.Nómina de personal: Importe],

                  28/01/2016  5:13:59 PM: 0021   [BIWMONTH] as [BIWMONTH.Año natural/Mes],

                  28/01/2016  5:13:59 PM: 0022   [BUS_AREA_WP] as [BUS_AREA_WP.División],

                  28/01/2016  5:13:59 PM: 0023   [CO_AREA_WP] as [CO_AREA_WP.Sociedad CO del centor de coste maestro],

                  28/01/2016  5:13:59 PM: 0024   [COMP_CODE_WP] as [COMP_CODE_WP.Sociedad],

                  28/01/2016  5:13:59 PM: 0025   [COSTCENTER_WP] as [COSTCENTER_WP.Centro de coste maestro],

                  28/01/2016  5:13:59 PM: 0026   [EMPL_GROUP_WP] as [EMPL_GROUP_WP.Grupo de personal],

                  28/01/2016  5:13:59 PM: 0027   [EMPL_SUBGROUP_WP] as [EMPL_SUBGROUP_WP.Área de personal],

                  28/01/2016  5:13:59 PM: 0028   [JOB_WP] as [JOB_WP.Función],

                  28/01/2016  5:13:59 PM: 0029   [LGART] as [LGART.CC-nómina],

                  28/01/2016  5:13:59 PM: 0030   [MOLGA] as [MOLGA.Agrupación de países],

                  28/01/2016  5:13:59 PM: 0031   [ORG_UNIT_WP] as [ORG_UNIT_WP.Unidad organizativa],

                  28/01/2016  5:13:59 PM: 0032   [PERNR] as [PERNR.Número de personal],

                  28/01/2016  5:13:59 PM: 0033   [PERS_AREA_WP] as [PERS_AREA_WP.División de personal],

                  28/01/2016  5:13:59 PM: 0034   [PERS_SUBAREA_WP] as [PERS_SUBAREA_WP.Subdivisión de personal],

                  28/01/2016  5:13:59 PM: 0035   [POSITION_WP] as [POSITION_WP.Posición],

                  28/01/2016  5:13:59 PM: 0036   [TIME_STATUS_WP] as [TIME_STATUS_WP.Status empleado para Gestión tiempos personal],

                  28/01/2016  5:13:59 PM: 0037   [WAERS] as [WAERS.Clave de moneda]

                  28/01/2016  5:13:59 PM: 0038  SQL EXTRACTOR 0HR_PY_1

                  28/01/2016  5:13:59 PM: 0039  TFRMETHOD I  

                  28/01/2016  5:13:59 PM: 0040 

                  28/01/2016  5:13:59 PM: 0041 

                  28/01/2016  5:13:59 PM: 0042  UPDMODE D  

                  28/01/2016  5:13:59 PM: 0043 

                  28/01/2016  5:13:59 PM: 0044 

                  28/01/2016  5:13:59 PM: 0045  EXTRLANGUAGE S

                  28/01/2016  5:13:59 PM: 0046  LOGSYS QTQVCEXTR1

                   

                   

                  28/01/2016  5:14:34 PM:       19 campos encontrados: ANZHL.Nómina de personal: Cantidad, BETRG.Nómina de personal: Importe, BIWMONTH.Año natural/Mes, BUS_AREA_WP.División, CO_AREA_WP.Sociedad CO del centor de coste maestro, COMP_CODE_WP.Sociedad, COSTCENTER_WP.Centro de coste maestro, EMPL_GROUP_WP.Grupo de personal, EMPL_SUBGROUP_WP.Área de personal, JOB_WP.Función, LGART.CC-nómina, MOLGA.Agrupación de países, ORG_UNIT_WP.Unidad organizativa, PERNR.Número de personal, PERS_AREA_WP.División de personal, PERS_SUBAREA_WP.Subdivisión de personal, POSITION_WP.Posición, TIME_STATUS_WP.Status empleado para Gestión tiempos personal, WAERS.Clave de moneda,

                  28/01/2016  5:14:34 PM:       QVX_UNEXPECTED_END_OF_DATA: FAILED 0HR_PY_1 Error:

                  28/01/2016  5:14:34 PM:       ERROR       illegal parameter value ( function=SAP_CMACCPTP /

                  28/01/2016  5:14:34 PM:                   parameter=handle / value=456 )

                  28/01/2016  5:14:34 PM:       TIME        Thu Jan 28 17:14:00 2016

                  28/01/2016  5:14:34 PM:       RELEASE     720

                  28/01/2016  5:14:34 PM:       COMPONENT   CPIC (TCP/IP) with Unicode

                  28/01/2016  5:14:34 PM:       VERSION     3

                  28/01/2016  5:14:34 PM:       RC          769

                  28/01/2016  5:14:34 PM:       MODULE      r3cpic.c

                  28/01/2016  5:14:34 PM:       LINE        13369

                  28/01/2016  5:14:34 PM:       COUNTER     2

                   

                   

                  28/01/2016  5:14:34 PM:       Error: Error en la lectura personalizada

                  28/01/2016  5:14:56 PM:      Ejecución finalizada.

                    • Re: QlikView SAP Extractor Connector Issue
                      Pablo del Cerro

                      Í´ve founf a fix on post QV SAP Extractor [illegal parameter value ( function=SAP_CMACCPTP /parameter=handle / value=xxx”).

                       

                      But i´m still getting the "Err FAILED 0HR_PY_1 Error: ID:00 Type:E Number:001 Init already done - delete in transaction /N/QTQVC/DELETE_INIT"

                        • Re: QlikView SAP Extractor Connector Issue
                          Tomas Sommergyll

                          Hi Pablo,

                           

                          I noticed you had tried using both idoc and trfc methods: there are additional steps to perform when doing this, see link below:

                           

                          https://help.qlik.com/Connectors/en-us/connectors/#../Subsystems/SAP_Connectors_Help/Content/6.1/QV-connection/SAP-Extra…

                           

                          Check step 5.

                           

                          BR,

                          Tomas

                            • Re: QlikView SAP Extractor Connector Issue
                              Pablo del Cerro

                              Tomas,

                              When we execute DELETE_INIT it seems to be empty.

                              *Ive already tried deleting everything and then running extractor with

                              IDocs method (default) and still get the same message. *

                               

                              Any ideas?

                              El Friday, January 29, 2016, Tomas Sommergyll <qcwebmaster@qlikview.com>

                              escribió:

                               

                              Qlik Community <https://community.qlik.com/?et=watches.email.thread>

                              QlikView SAP Extractor Connector Issue

                               

                              respuesta de Tomas Sommergyll

                              <https://community.qlik.com/people/tsy?et=watches.email.thread> en *QlikView

                              Connector for SAP* - Ver la discusión completa

                              <https://community.qlik.com/message/963314?et=watches.email.thread#963314>

                               

                                • Re: QlikView SAP Extractor Connector Issue
                                  Tomas Sommergyll

                                  Did you try this step in Qlik Help:

                                   

                                  "Deactivate (/N/QTQVC/DEACTIVATE) the source and then activate (/N/QTQVC/ACTIVATE) it again."

                                    • Re: QlikView SAP Extractor Connector Issue
                                      Pablo del Cerro

                                      Tomas,

                                       

                                      We seem to be getting better!

                                       

                                      I run the extractor but get no answer on QV.

                                       

                                      The job status after 30min says Status = 'S'.

                                       

                                      Log:

                                      2016-01-29 10:21:05    Connector: C:\Program Files\Common Files\QlikTech\Custom Data\QvSAPConnector\QvSAPEXTRConnector.dll Ver: 6.00 IR, Build: 00124

                                      2016-01-29 10:21:05    Using Server Host: 10.100.3.60 , Port: 8680

                                      2016-01-29 10:21:05    Host address is: IP number

                                      2016-01-29 10:21:05    Connected to SAP (ASHOST): SAPDES

                                      2016-01-29 10:21:05    Making new SAP Request

                                      2016-01-29 10:21:05    EXTRACTOR = 0HR_PY_1

                                      2016-01-29 10:21:05    TFRMETHOD = T

                                      2016-01-29 10:21:05    UPDMODE = C

                                      2016-01-29 10:21:05    EXTRLANGUAGE = S

                                      2016-01-29 10:21:05    LOGSYS = QTQVCEXTR1

                                      2016-01-29 10:21:05    EXTRACTOR 0HR_PY_1#TFRMETHOD T#UPDMODE C#EXTRLANGUAGE S#LOGSYS QTQVCEXTR1#

                                      2016-01-29 10:21:05    TimeoutSAP      :14400

                                      2016-01-29 10:21:05    TimeoutInit    :900

                                      2016-01-29 10:21:05    TimeoutActivity :7200

                                      2016-01-29 10:21:05    TimeoutData    :3600

                                      2016-01-29 10:21:06    Received Meta Data, No of Fields: 19

                                      2016-01-29 10:21:08    Information from server: INFOMSG : Started job: REQU_QTQVCEXTR1_20160129102106

                                       

                                      I have cancelled the job with the Display Status Table, and then i´ve tried a Delta extraction and again same result: No answer in QV.


                                      New Log:

                                      2016-01-29 11:43:49     Connector: C:\Program Files\Common Files\QlikTech\Custom Data\QvSAPConnector\QvSAPEXTRConnector.dll Ver: 6.00 IR, Build: 00124

                                      2016-01-29 11:43:49     Using Server Host: 10.100.3.60 , Port: 8680

                                      2016-01-29 11:43:49     Host address is: IP number

                                      2016-01-29 11:43:49     Connected to SAP (ASHOST): SAPDES

                                      2016-01-29 11:43:49     Making new SAP Request

                                      2016-01-29 11:43:49     EXTRACTOR = 0HR_PY_1

                                      2016-01-29 11:43:49     TFRMETHOD = T

                                      2016-01-29 11:43:49     UPDMODE = D

                                      2016-01-29 11:43:49     EXTRLANGUAGE = S

                                      2016-01-29 11:43:49     LOGSYS = QTQVCEXTR1

                                      2016-01-29 11:43:49     EXTRACTOR 0HR_PY_1#TFRMETHOD T#UPDMODE D#EXTRLANGUAGE S#LOGSYS QTQVCEXTR1#

                                      2016-01-29 11:43:49     TimeoutSAP      :14400

                                      2016-01-29 11:43:49     TimeoutInit     :900

                                      2016-01-29 11:43:49     TimeoutActivity :7200

                                      2016-01-29 11:43:49     TimeoutData     :3600

                                      2016-01-29 11:43:50     Received Meta Data, No of Fields: 19

                                      2016-01-29 11:43:50     Information from server: INFOMSG : Started job: REQU_QTQVCEXTR1_20160129114349

                                       

                                      We talked with SAP Administrators and the log on SM50 says "Job Terminated".

                                       

                                      Detailed log from SAP (im sorry its in Spanish):

                                      Resumen log job para job     BIREQU_QTQVCEXTR1_20160129102106 / 10210700

                                       

                                       

                                      -----------------------------------------------------------------------------------------------------------------------------------------

                                      |Fecha     |Hora    |Texto mensaje                                                                     |Cl.mensaje|Nº mensaje|Tp.mensaje|

                                      -----------------------------------------------------------------------------------------------------------------------------------------

                                      |29.01.2016|10:21:07|El job ha sido lanzado.                                                           |    00    |   516    |    S     |

                                      |29.01.2016|10:21:07|Paso 001 iniciado (programa SBIE0001, variante &0000000000008, usuario USER_QLIK) |    00    |   550    |    S     |

                                      |29.01.2016|10:21:07|Envío asincrónico de InfoIDOC 2 en tarea 0001 (0 tareas paralelas)                |    R3    |   413    |    S     |

                                      |29.01.2016|10:21:07|DATASOURCE = 0HR_PY_1                                                             |    R3    |   299    |    S     |

                                      |29.01.2016|10:21:07|RLOGSYS    = QTQVCEXTR1                                                           |    R3    |   299    |    S     |

                                      |29.01.2016|10:21:07|REQUNR     = REQU_QTQVCEXTR1_20160129102106                                       |    R3    |   299    |    S     |

                                      |29.01.2016|10:21:07|UPDMODE    = C                                                                    |    R3    |   299    |    S     |

                                      |29.01.2016|10:21:07|LANGUAGES  = *                                                                    |    R3    |   299    |    S     |

                                      |29.01.2016|10:21:07|*************************************************************************         |    R8    |   048    |    S     |

                                      |29.01.2016|10:21:07|*           Valores actuales parámetro perfil seleccionado              *         |    R8    |   049    |    S     |

                                      |29.01.2016|10:21:07|*************************************************************************         |    R8    |   048    |    S     |

                                      |29.01.2016|10:21:07|* abap/heap_area_nondia......... 0                                       *        |    R8    |   050    |    S     |

                                      |29.01.2016|10:21:07|* abap/heap_area_total.......... 10485760000                             *        |    R8    |   050    |    S     |

                                      |29.01.2016|10:21:07|* abap/heaplimit................ 40000000                                *        |    R8    |   050    |    S     |

                                      |29.01.2016|10:21:07|* zcsa/installed_languages...... DESP                                    *        |    R8    |   050    |    S     |

                                      |29.01.2016|10:21:07|* zcsa/system_language.......... S                                       *        |    R8    |   050    |    S     |

                                      |29.01.2016|10:21:07|* ztta/max_memreq_MB............ 2047                                    *        |    R8    |   050    |    S     |

                                      |29.01.2016|10:21:08|El módulo de funciones /BI0/QI0HR_PY_10001 aún no existe.                         |    FL    |   110    |    S     |

                                      |29.01.2016|10:21:09|Función de grabación ejecutada.                                                   |    FL    |   060    |    S     |

                                      |29.01.2016|10:21:10|Llamada de ampliación de clientes BW_BTE_CALL_BW204010_E (BTE) con 28 registros   |    R3    |   407    |    S     |

                                      |29.01.2016|10:21:10|Resultado de ampliación de cliente: 28 registros                                  |    R3    |   408    |    S     |

                                      |29.01.2016|10:21:10|Llamada de ampliación de clientes EXIT_SAPLRSAP_001 (CMOD) con 28 registros       |    R3    |   407    |    S     |

                                      |29.01.2016|10:21:10|Resultado de ampliación de cliente: 28 registros                                  |    R3    |   408    |    S     |

                                      |29.01.2016|10:21:10|PSA=0 USING & STARTING SAPI SCHEDULER                                             |    R3    |   299    |    S     |

                                      |29.01.2016|10:21:10|Envío asincrónico de paquete datos 1 en tarea 0002 (1 tareas paralelas)           |    R3    |   409    |    S     |

                                      |29.01.2016|10:21:10|IDOC: InfoIDOC 2, Nº IDOC 198055, dur.00:00:01                                    |    R3    |   088    |    S     |

                                      |29.01.2016|10:21:10|IDOC: Inicio 29.01.2016 10:21:07, fin 29.01.2016 10:21:08                         |    R3    |   089    |    S     |

                                      |29.01.2016|10:21:11|tRFC: Paq.dat.1, TID = 0A640313A7D456AB674601B9, dur.00:00:01, ARFCSTATE = CPICERR|    R3    |   038    |    S     |

                                      |29.01.2016|10:21:11|tRFC: Inicio 29.01.2016 10:21:10, fin 29.01.2016 10:21:11                         |    R3    |   039    |    S     |

                                      |29.01.2016|10:21:11|Envío asincrónico de InfoIDOC 3 en tarea 0003 (0 tareas paralelas)                |    R3    |   413    |    S     |

                                      |29.01.2016|10:21:11|IDOC: InfoIDOC 3, Nº IDOC 198056, dur.00:00:00                                    |    R3    |   088    |    S     |

                                      |29.01.2016|10:21:11|IDOC: Inicio 29.01.2016 10:21:11, fin 29.01.2016 10:21:11                         |    R3    |   089    |    S     |

                                      |29.01.2016|10:21:11|Envío sincrónico de InfoIDOC 4 (0 tareas paralelas)                               |    R3    |   414    |    S     |

                                      |29.01.2016|10:21:11|IDOC: InfoIDOC 4, Nº IDOC 198057, dur.00:00:00                                    |    R3    |   088    |    S     |

                                      |29.01.2016|10:21:11|IDOC: Inicio 29.01.2016 10:21:11, fin 29.01.2016 10:21:11                         |    R3    |   089    |    S     |

                                      |29.01.2016|10:21:11|El job ha sido terminado.                                                         |    00    |   517    |    S     |

                                      -----------------------------------------------------------------------------------------------------------------------------------------