Hello everybody,
I am really needing your help regarding an issue we got for more than a week now.
We are trying to import data from a SQL database (ERP) to SAP Hana using BODS 4.2 sp 9.
We imported most of the table without any issues, but the last big three tables are failing with this generic error:
ODBC data source <CELONISHANA> error message for operation <SQLExecute>: <[SAP AG][LIBODBCHDB DLL][HDBODBC] General error;-10108 Session has been reconnected.>.
Execution of <Regular Load Operations> for target <BSEG> failed. Possible causes: (1) Error in the SQL syntax; (2) Database connection is broken; (3) Database related errors such as transaction log is full, etc.; (4) The user defined in the datastore has insufficient privileges to execute the SQL. If the error is for preload or postload operation, or if it is for regular load operation and load triggers are defined, check the SQL. Otherwise, for (3) and (4), contact your local DBA.
ODBC data source <CELONISHANA> error message for operation <SQLExecute>: <[SAP AG][LIBODBCHDB DLL][HDBODBC] General error;-10108 Session has been reconnected.>.|<Regular Load Operations>|<BSEG>&#8203;&#8203;Moreover, it seems to fail after a specific number of row imported (not read).
We tried
[list]to change Raw per comit with a lower value (500 - 200 - 100)
to change delimiter in datastore from TAB to /27
to remove most of the fields and keep only a few of them. The import crash after the same number of imported rows
as we got some issues on some date in logs, we tried to cast all of them
We enabled more traces on hana and we are currently running new job with those settings, but we are not sure about which trace to enabled[/list]
I am really open to any suggestions or ideas that may help us to troubleshoot this!
In advance, thanks to all!
semias (BOB member since 2017-11-16)