I have a stored procedure that uses Add_workdays and Workdays_between. When I run this stored procedure from within SAP HANA Studio it runs without a hitch, but when I try and run it through ODBC driver for a Crystal Reports report that I wish to develop, I get the following error
"Database Connector Error: 'S1000:[SAP AG][LIBODBCHDB32 DLL]pHDBODBC32] General error;2048 column store error: "_SYS_BIC"."aklc/ZSP_PNC001_PROCESSING_SUMMARY": line 7 col 1 {at pos 237): column store error: [70000000] could not read working days information from table TFACS "R001813"."TFACS" - invalid table name: Could not find table/view TFACS in schema R001813: line 1 col 134 (at pos 133) at /sapmnt/Id7272/a/HDB/Jenkins_prod/workspace/HANA_FA_CO_LIN64 GCC48HAPPY_rel_fa~hana1sp12/s/ptime/query/catalog/catalog.cc:598 5 [Database Vendor Code: 2048 ]".
The gist of the error seems to be that when executing the stored procedure through the ODBC it thinks it needs to be looking in my personal catalogue not the default catalogue I identified when activating the stored procedure. I am unsure why it should do this. How do I change this so it correctly looks in the correct catalogue, which in my case is SAPAD1, and the table TFACS does exist in this catalogue?
Thanks
Stephen