SAP BODS insert into HANA table times out

[Former Member]

Hi

I am using SAP BODS with a HANA columnar table as the target . I have the queries set and working fine up untill it reach right before the HANA target table, but then it times out and the error message says the db timed out and couldnt load the records.

I tried the scenario with replacing the target table with a template table and it worked fine. I was wondering if its something related to the ACCESS/GRANT to the table.

How can I check if the user has the access to write records into the target table.

Cheers!

[lucas_oliveira]

Hi Josh,

I'd start by checking view EFFECTIVE_PRIVILEGES for that. There's a nice doc on how to

troubleshoot that kind of issue here.

However, I don't think your current scenario points out to an authorization issue to be honest. If there was such issue, you'd probably have it right instead of waiting for a timeout to kick in.  The indexserver traces might have the real root cause of this issue.

BRs,

Lucas de Oliveira