Difference between SAP Report Connector on premise / Cloud

[martinpohl]

Hi guys,

an ideas? We are moving from Qlik on premise to Qlik cloud.

Some datas are from SAP report, so on premise Qlik SAP report connector is used.

Here, syntax Select SAPREPORT (REPORT (ZSD_VA05), VARIANT (DATEN_QLIK), ROWS_PER_RECORD (1), FIELD_AUTO_COLUMNS (6)) is used and it works fine.

So I changed the select to

select
*
from [ZSD_VA05]
WITH (
VARIANT = DATEN_QLIK
ROWS_PER_RECORD = 1
FIELD_AUTO_COLUMNS = 6
)
USING REPORT
; 

in cloud, but message 

Internal error. (Connector error: Status(StatusCode="InvalidArgument", Detail="Parse error:
sap-odp (ParseError): Location (91): REPORT
Syntax error, expected: ODP
sap-sql (ParseError): Location (91): REPORT
Syntax error, expected: SQL
sap-report (NotFound):
No fields found for object 'ZSD_VA05'
sap-infoprovider (NotFound):
No fields found for object 'ZSD_VA05'"))

appears, no data are loaded.

Any ideas?

Regards

[pablolabbe]

I'm not an expert in sap report, but I suggest you to create a new report script to review if there is any changes in the script syntax, may be something slightly changed.

[martinpohl]

Thank you for your suggestion.

The report still is running on premise, so there are no changes.

Regards