topic Re: Qlik SAP Extracor - where condition with more than one field in Connectivity & Data Prep

Qlik SAP Extracor - where condition with more than one field

afbraga1 — Tue, 28 Dec 2021 20:31:52 GMT

Hello,

I am using SAP Connectors v6.6, for some reason I can't fathom the SAP Extractor Connector won't work with more than one field in the where clause.

[TABLE]:
LOAD
[DOC];
SQL EXTRACTOR TABLE
TFRMETHOD T // Transfer method (T=tRFC)
UPDMODE F // Full extractor
EXTRLANGUAGE system_default // SAP System Default
LOGSYS QTQVCEXTR1
WHERE
CREATEDON I GE 20190101,
ERROR E NE X
;

This is a script code added automatically by Qlikview when you go through the UI, still it doesn't work.

If I remove either the CREATEDON line or the ERROR, the one that remains works, but with both at same time it won't.

I get the error "invalid selection condition in the data request". Does anyone know why is this?

Thank you.

Best regards,

André Braga

Re: Qlik SAP Extracor - where condition with more than one field

Hakan_Ronningberg — Mon, 04 Mar 2019 08:04:12 GMT

Hi,

Does it work if you try the same conditions in transaction RSA3 in SAP?

Regards,

Håkan

Re: Qlik SAP Extracor - where condition with more than one field

afbraga1 — Mon, 04 Mar 2019 13:59:11 GMT

Hello Hakan,

Thank you for your response, but I'm afraid that doesn't apply here. The extraction I'm doing is from a DSO in a SAP BW system, I should have made that more clear in fact.

Best regards,
André Braga

Re: Qlik SAP Extracor - where condition with more than one field

Hakan_Ronningberg — Mon, 04 Mar 2019 14:20:39 GMT

Hi André

IF you want to get the rows where ERROR = 'X', then write:

ERROR I EQ X

Otherwise write:

ERROR I NE X

Regards,

Håkan

Re: Qlik SAP Extracor - where condition with more than one field

afbraga1 — Mon, 04 Mar 2019 14:23:35 GMT

Hello Hakan,

I am aware of that and I know how to do that. The issue here is when the where condition has more that one field restricting the data, i.e., in this case ERROR and CREATEDON fields. If I use one or the other it works, but not with both at the same time.

Best regards,
André Braga

Re: Qlik SAP Extracor - where condition with more than one field

Hakan_Ronningberg — Mon, 04 Mar 2019 14:28:07 GMT

Hi André,

Yes, but I think the problem is that you use Exclude (E) in your condition:

CREATEDON I GE 20190101,
ERROR E NE X

What if you change to either:

CREATEDON I GE 20190101,
ERROR I NE X

CREATEDON I GE 20190101,
ERROR I EQ X

depending on what you want to achieve?

Regards,

Håkan

Re: Qlik SAP Extracor - where condition with more than one field

afbraga1 — Mon, 04 Mar 2019 14:32:42 GMT

Hello Hakan,

Yes I assume it would make more sense that way. Despite that the result at best would be 0 lines or something like that. Instead what happens is an error exception thrown saying "invalid selection condition in the data request". I have tried with your change and it is the same thing. The problem is that Qlikview interprets the syntax as if it was wrong.

Best regards,
André Braga

Re: Qlik SAP Extracor - where condition with more than one field

Hakan_Ronningberg — Mon, 04 Mar 2019 14:41:25 GMT

Hi again,

Have you checked the SAP extraction job log. Prefix the job name from the Extractor connector log with ‘BI’, like BIREQU_QTQVCEXTR1_20160420125150. Check job log for this job name in transaction SM37. Select the job and press the 'Job log' button.

Regards,
Håkan

Re: Qlik SAP Extracor - where condition with more than one field

afbraga1 — Mon, 04 Mar 2019 14:52:44 GMT

Hello,

Yes, I did check that, but there is no relevant information there as far as I know. The job ends successful with 0 sec. It pretty much does nothing.

Best regards,
André Braga

Re: Qlik SAP Extracor - where condition with more than one field

Hakan_Ronningberg — Mon, 04 Mar 2019 15:01:40 GMT

Hi,

And no useful information in the Extractor connector log or in the Extractor Service log?

Regards,
Håkan