Error loading from OHD into HANA

[msshortza]

Hi

I successfully managed to executethe extract from the OHD on BW, however before loading into HANA it tries to do the following sql:

ALTER TABLE "VENDAVO_PRC_SC"."TX_RAW" DISABLE PERSISTENT MERGE.

I am getting this error:

4524	9288	DBS-070404	4/11/2013 8:32:11 AM	SQL submitted to ODBC data source <SIGMA_HANA_AMZN> resulted in error <[SAP AG][LIBODBCHDB DLL][HDB] General error;-10108
4524	9288	DBS-070404	4/11/2013 8:32:11 AM	Session has been reconnected.>. The SQL submitted is <ALTER TABLE  "VENDAVO_PRC_SC"."TXN_RAW" DISABLE PERSISTENT MERGE>.
4524	9288	RUN-051005	4/11/2013 8:32:11 AM	|Data flow TXN_RAW|Loader MAP_BW_TO_TXN_RAW_TXN_RAW
4524	9288	RUN-051005	4/11/2013 8:32:11 AM	Execution of <ALTER TABLE  "VENDAVO_PRC_SC"."TXN_RAW" DISABLE PERSISTENT MERGE> for target <TXN_RAW> failed. Possible causes:
4524	9288	RUN-051005	4/11/2013 8:32:11 AM	(1) Error in the SQL syntax; (2) Database connection is broken; (3) Database related errors such as transaction log is full,
4524	9288	RUN-051005	4/11/2013 8:32:11 AM	etc.; (4) The user defined in the datastore has insufficient privileges to execute the SQL. If the error is for preload or
4524	9288	RUN-051005	4/11/2013 8:32:11 AM	postload operation, or if it is for regular load operation and load triggers are defined, check the SQL. Otherwise, for (3) and
4524	9288	RUN-051005	4/11/2013 8:32:11 AM	(4), contact your local DBA.
0	0	BIW-230303	4/11/2013 8:32:12 AM	(14.1) 04-11-13 08:32:12 (4524:9684) BIW-230303: (14.1) 04-11-13 08:32:12 (4524:0464) BIW-230303: |Data flow TXN_RAW|Reader BOUVW_HN

I have double checked and the user it is using definitely has permission to execute this SQL statement.  Any advice?

[p1024029]

Hi,

Can check the Insert permissions for your schema?. If INSERT permission is not given then please do and try again.

Hope it works.

Regards,

Naresh

[Former Member]

Hi,

we are using informatica to load data in SAP HANA. the informatica workflow is not failing for below error but the data is getting dropped. Please let me know how can we fix this.

WRT_8229

Database errors occurred:

FnName: Execute -- [SAP AG][LIBODBCHDB SO][HDBODBC] General error;-10108 Session has been reconnected.

FnName: Execute -- [SAP AG][LIBODBCHDB SO][HDBODBC] General error;-10108 Session has been reconnected.

FnName: Execute -- [SAP AG][LIBODBCHDB SO][HDBODBC] General error;-10512 Row not processed due to previous error

FnName: Execute -- [SAP AG][LIBODBCHDB SO][HDBODBC] General error;-10512 Row not processed due to previous error

[Former Member]

Hi,

Did you find any solution to the problem? I have the same error.

Regards,

Rohit Jain

[Former Member]

Same Error from Informatica PowerCenter Loading mutlple sessions from cloud : everything is fine until all sessions breaks.

I Suspect network timeout or merge operation that lead to lock...
May be it is possible to increase timeout parameter somewhere ? ODBC client side or better server side ? but where ?

Severity Timestamp Node Thread Message Code Message

ERROR 11/4/2014 1:13:45 PM node01_WIN-QSJVESA2DJJ WRITER_1_*_3 WRT_8229 Database errors occurred:

FnName: Execute -- [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;-10821 Session not connected

FnName: Execute -- [Microsoft][ODBC Driver Manager] Function sequence error

Before this error I got the following error :

FnName: Execute -- [SAP AG][LIBODBCHDB DLL][HDBODBC] Connection not open;-10807 System call 'recv' failed, rc=10060:A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected h

[Former Member]

Hi, Did anyone find a resolution to this error? I'm facing exactly the same issue as Dan.

[gilles_breton]

Is an update about it???

[Former Member]

Hi,

I am getting similar error....Have been struggling for last 2months...Any idea on this???

(14.0) 06-20-13 13:09:12 (E) (5472:13388) DBS-070401: |Data flow DF_InventoryValuatnStageTTL_SAP|Loader INVENTORY_VALUATN_STAGE_1_INVENTORY_VALUATN_STAGE

                                                      ODBC data source <AWS> error message for operation <SQLExecute>: <[SAP AG][LIBODBCHDB DLL][HDB] General error;-10108

                                                      Session has been reconnected.>.

(14.0) 06-20-13 13:09:12 (E) (5472:13388) RUN-051005: |Data flow DF_InventoryValuatnStageTTL_SAP|Loader INVENTORY_VALUATN_STAGE_1_INVENTORY_VALUATN_STAGE

                                                      Execution of <Regular Load Operations> for target <INVENTORY_VALUATN_STAGE> 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.

(14.0) 06-20-13 13:09:32 (E) (4632:15112) DBS-070401: |Data flow DF_InventoryValuatnStageTTL_SAP|Loader INVENTORY_VALUATN_STAGE_1_INVENTORY_VALUATN_STAGE

                                                      ODBC data source <AWS> error message for operation <SQLExecute>: <[SAP AG][LIBODBCHDB DLL][HDB] General error;-10108

                                                      Session has been reconnected.>.|<Regular Load Operations>|<INVENTORY_VALUATN_STAGE>

Regards,

Balaji

[Former Member]

Curious if anyone had an update on this issue. 

I'm running into the same "inconsistent" problem with loading data into HANA via DataServices.

ODBC data source <ip address> error message for operation <SQLExecute>: [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;-10108 Session has been reconnected.

[Former Member]

Hi Dan,

We are facing this issue, can you please let me know if it resolved. Appreciate your help.