BODS job sometimes get fail due to COn-120307 error.

dataservices job design
1

BODS job sometimes get fail due to COn-120307 error. When it is rerun it gets successful. Kindly help to remove this error permanently.
Below is the error:-
(14.2) 06-13-17 06:21:57 (E) (27274:1216980768) CON-120307: |Session JB_HANA_TRAIN_TRACK ODBC call to connect database <> failed with error: <[SAP AG][LIBODBCHDB SO][HDBODBC] Communication link failure;-10709 Connection failed (RTE:[89006] System call ‘recv’ failed, rc=104:Connection reset by peer)>. Use the ODBCDriverSelector (Windows) or DSConnectionManager.sh (UNIX) utility in LINK_DIR/bin to configure the correct version of the driver. If the problem still exists after selecting the correct version of the driver, notify Customer Support.

priyankagupta (BOB member since 2017-07-05)

2

Hi Priyanka,

There is an issue with database connection from ETL machine.

Please try to check from your database client to check are you able to connect to SAP HANA DB server or not?

Through client you are not able to connect means you have to check environment variables depending on your source database.

Thanks & Regards,
Ramana.

Ramana :india: (BOB member since 2009-04-30)