SAP B1 HANA Stored Procedure call in crystal report.

[owaisk]

Hello Community,

I have created a stored procedure in HANA, it is working fine. When calling it in crystal rpeort. im getting attached error. What is the solutionfor this ?

SP is also shared.

Regards,

Owais.

[JWiseman]

Hi Owais Khalid, the 258 error code is an insufficient privilege as per here. What is the result in the HC DB Explorer for the same user?

Also, how are you calling your stored proc in your report? i.e. Is it a direct connection to the proc in the DB Expert or are you calling it inside a Command object in your report? The reason I ask is that in HANA (and other DBs) if you call a stored proc directly in the DB expert then the proc will be called twice when you're running it...once to verify the column set and the second time to return the results.

[owaisk]

I have solved the SP issue, but now on previewing this report in SAP. I'm getting the attached issue.

and this issue only appears when i place fields in the detail section. Otherwise the report is working fine.