topic Re: QlikView SAP Extractor Connector Issue in QlikView

QlikView SAP Extractor Connector Issue

Mon, 26 Jan 2026 21:26:37 GMT

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 — Thu, 28 Jan 2016 15:11:04 GMT

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

Thu, 28 Jan 2016 20:14:52 GMT

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

Thu, 28 Jan 2016 20:19:16 GMT

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

Thu, 28 Jan 2016 20:39:51 GMT

Í´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 — Fri, 29 Jan 2016 08:34:48 GMT

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

Fri, 29 Jan 2016 11:03:28 GMT

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 — Fri, 29 Jan 2016 12:11:43 GMT

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

Fri, 29 Jan 2016 14:51:10 GMT

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

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

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

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

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

Re: QlikView SAP Extractor Connector Issue

Fri, 29 Jan 2016 15:45:39 GMT

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

Re: QlikView SAP Extractor Connector Issue

Tue, 02 Feb 2016 17:29:53 GMT

Hey there! I´m glad to tell you that basis redid the steps from the manual and now it works fine.

Seems that they have done something wrong the first time!

Best Regards

Pablo