topic Re: Hanging Extractor Connector Connection although data fully exported in QlikView

Hanging Extractor Connector Connection although data fully exported

tobivogt — Mon, 26 Jan 2026 21:26:37 GMT

Hello to all,

we are facing the following problem with SAP Extractor Connector Version 5.8 SR 1:

To export data out of InfoCubes we've generated Export DataSources and export data via SAP Extractor Connector.

Unfortunately, the trace window shows no progress and the script processing has been stopped.

All relevant Data has been transfered to QV but the script still doesn't proceed until the connection ends with an TimeOut (after 60 Minutes which is the TimeoutData-Setting).

The script has been successfully finished but on BW side:

- the Status in /QTQVC/STATUS remains 'S' so repeating load will fail until changing or modifying status entry

- the User remains logged on and repeating load would result additional entries in list of logged on users

- Extended Memory will still be in use and not be released automatically

The same issues occur after cleaning status table entries with status 'S' and after restart SAP Network Server - Service.

Has anyone an idea how to solve this or hints to possible reasons for this behavior?

Many thanks in advance for any hints.

Regards,

Tobias

======

Re: Hanging Extractor Connector Connection although data fully exported

mats_olin — Thu, 25 Sep 2014 12:36:15 GMT

There are changes to the extractor connector delivered with later SR's so upgrading to SR3 might help/ Mats

Re: Hanging Extractor Connector Connection although data fully exported

tobivogt — Mon, 29 Sep 2014 08:53:32 GMT

Thanks a lot for your quick response.

Unfortunately, we're not able to do an upgrade due to transport stops.

Are there any further hints or recommendations to check before?

We have the same effect on dev and prod. Might a unicode migration in SAP BW cause such problems?

Thanks a lot for any hints

Re: Hanging Extractor Connector Connection although data fully exported

mats_olin — Tue, 30 Sep 2014 08:25:30 GMT

Do you have more than one bw app server?

Re: Hanging Extractor Connector Connection although data fully exported

tobivogt — Tue, 30 Sep 2014 09:12:35 GMT

There are development and production Servers. Each Level has only one server.

Re: Hanging Extractor Connector Connection although data fully exported

Tomas_Sommergyll — Wed, 01 Oct 2014 14:59:33 GMT

Hi Tobias,

Can you attach some log files from both the Extractor Connector and the Qv Network Server (from the folder: C:\ProgramData\QlikTech\Custom Data\QvSAPConnector\Log) ?

Thanks

Re: Re: Hanging Extractor Connector Connection although data fully exported

tobivogt — Thu, 02 Oct 2014 09:48:55 GMT

Hi Thomas,

thanks for your hints.

Find attached the logs. Are these the mentioned files?

Regards,

Tobias

Re: Re: Hanging Extractor Connector Connection although data fully exported

Tomas_Sommergyll — Thu, 02 Oct 2014 10:36:56 GMT

Yes, they are. Thanks!

I noticed you first (at 16:53:12) executed an UPDMODE with 'C' to initiate a delta run. Did you get any data back there?

Did you then do a "delete in transaction /N/QTQVC/DELETE_INIT" (see Extractor Technical Design Specification.pdf or even the posted manual on the forum page) before executing the second UPDMODE with 'C' (or was it on the other SAP system, maybe)?

Are you running more than one Qv Network Server (SrvService.exe) pointing to the same ASHOST?

(You should really try to install the upgraded version of the Qv SAP Connectors + Transports!) 🙂

Thanks,

Tomas

Re: Re: Hanging Extractor Connector Connection although data fully exported

tobivogt — Thu, 02 Oct 2014 11:40:15 GMT

Thanks for your Response.

As I did several tests, there was a combination of extracting in C mode twice, too.

After that, I tried to delete or update the previous records in Status table with mode S to F.

After deleting delta-init with the QV- Delete_init transaktion, I still get the same effects.

Even doing a Full-Load has the same effect:

Data will be exported and transfered, the script will wait until timeout (although data has been transfered), the script will be processed normal.

But the user stays logged on in SAP System, the corresponding Memory has not being released and the Status in Status table remains S.

We are running only one QV Network Server and restarted the Services.

Maybe there's still a way without upgrade?

Thanks a lot for any hints

Re: Hanging Extractor Connector Connection although data fully exported

Tomas_Sommergyll — Thu, 02 Oct 2014 11:52:53 GMT

Ok,

So you mean that all data was delivered, and the log entry below shows the last data package transferred to QV:

2014-09-25 20:45:25 Received: /BIC/QA8ZCCA_C11I001, Rows: 7089, Total Rows: 3641665

Thanks

Re: Hanging Extractor Connector Connection although data fully exported

tobivogt — Thu, 02 Oct 2014 12:14:12 GMT

Yes, thats what I think.

It's the number of records in facts table and the package is smaller than all others before.

So I would expect all data has been read / exported.

Thanks a lot

Re: Hanging Extractor Connector Connection although data fully exported

Tomas_Sommergyll — Thu, 02 Oct 2014 12:43:26 GMT

It certainly looks like all data is received from studying your log files. I can think of a few issues that may cause this, that are handled in the newest version, ver 5.80 SR3 Build 8.

However, if you cannot upgrade to the latest version, I think the only way around it is to manually change the Status Table entries from 'S' to 'F'.

Best regards,

Tomas