Skip to Content
0

Reconnect to DI API

Nov 22, 2016 at 09:23 AM

73

avatar image

The service is running permanently as a interface for a webshop, but loses connection to DI API from time to time.

So I try to reconnect after the connection is lost. It tells me that the connection is ok(oCompany != null && oCompany.Connected) but after a Recordset it always gives this error:

System.Runtime.InteropServices.COMException (0xFFFFF830): 1). [SAP AG][LIBODBCHDB32 DLL][HDBODBC32] Base table or view not found;259 invalid table name: Could not find table/view OCRD in
bei SAPbobsCOM.IRecordset.DoQuery(String QueryStr)

The reconnection is done the same way as the first connection. Even to disconnect the Connection and set oCompany to null did not help to solve this issue.

If anyone has a solution to this I would highly appreciate it.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Pedro Magueija Nov 23, 2016 at 12:24 PM
0

Hi Thomas,

The HANA library has some issues (such as some unsupported features, etc...).

You can try to run a query to set the schema (user "name_of_schema";). But note that this has to be done by itself (not together with your other query).

If it still doesn't work, I'd open a ticket with SAP.

Pedro Magueija

LinkedIn | Twitter | Blog

Share
10 |10000 characters needed characters left characters exceeded
Thomas Thutewohl Nov 23, 2016 at 01:29 PM
0

Hi Pedro,

thank you for your answere I will try this.

Still I find it strange that it works fine on the first connection.

Best Regards,

Thomas Thutewohl

Share
10 |10000 characters needed characters left characters exceeded