QlikView SAP Extractor Connector Issue

[#1]

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

[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-...

Follow the steps under:

Canceling a job from the Extractor connector

BR,

Tomas

[#3]

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

[#4]

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.

[#5]

Í´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"

[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-...

Check step 5.

BR,

Tomas

[#7]

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>

[Tomas_Sommergyll]

Did you try this step in Qlik Help:

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

[#9]

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     |

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

[#10]

Additional information, on SAP Transaction SM58 we found an  error "Illegal destination type 'G'".