Issue with full load from SAP tables after upgrading to SAP SQL connector version 8.1

[Apoorva_sd]

Hello,

We recently upgraded our Qlik SAP SQL connector to 8.1 version and have been facing issues doing full load from some of the big tables in SAP. This full load (*) was working fine without any issues with the earlier version of the connector.

The reload job simply runs for 2+ hours and then failes after that. We have checked all the config and settings in SAP and they all look good.

I am currently working on splitting the data and load only the fields that we are using in our dashboards. There are like 250-300 fields in these tables and it would take few days to weeks to come up with a right method for this. The reports that use the data from these tables are very important ones. So, wanted to post the question here and see if there are any suggestions that I could try.

Main error message from the log file is "Error : RfcAbapException:JOB_CANCELLED

Job aborted, check log for job /QTQVC/READ_DATA in Job Overview (transaction SM37)"

Is there anything that I can change in the connection string?

We are using the ConvRoutine in the connection string and that definitely causes performance issue and when I uncheck that option and run the app, it completes in like 9 mins or so. But that gives unformatted data in Qlik which we would not want to deal with. All of this started after the upgrade of the connector.

Any help/suggestions on this is greatly appreciated!

Thank you,

Apoorva

[JandreKillianRIC]

Hi @Apoorva_sd 

The RFC - Job Cancelled is due to a time out. 

https://community.sap.com/t5/application-development-discussions/rfc-connection-failed-during-batch-...

Perhaps have a look if you can increase the timeout? 

Regards Jandre

[Apoorva_sd]

Hi @JandreKillianRIC ,

Thank you so much for the response!

We have the exact same settings in our connection string, do you know which one to increase and how much it can be increased?

Thank you,

Apoorva

[JandreKillianRIC]

Hi @Apoorva_sd 

No idea. I would most probably just save some of those setting in a text file. (Just as a backup) I would change the timeoutstartbatch first. And if those dont work try the other ones that are related to timeout. Perhaps check out the SAP netwaever Qlik documentation. 

Regards Jandre

[Apoorva_sd]

I will try that! Thank you for the suggestions. Appreciate it!