on 05-09-2017 10:40 AM
Hi,
We are using SAP Data services for customising a job to pull data from Teradata machines to SAP BFC.
When we check the views in Data services for Teradata, we can see the data, however when I run the job, below error is displayed.
Request if someone can help explain the error or parameters that need to be checked on SAP side.
Trace Log:
(14.2) 05-09-17 11:04:36 (10944:8368) DATAFLOW: Data flow <DF_EXPORT_ORM_D2P> is started.
(14.2) 05-09-17 11:04:36 (10944:8368) DATAFLOW: Data flow <DF_EXPORT_ORM_D2P> using PAGEABLE Cache with <3518 MB> buffer pool.
(14.2) 05-09-17 11:04:41 (10944:8368) DATAFLOW: Data flow <DF_EXPORT_ORM_D2P> is terminated due to error <120307>.
(14.2) 05-09-17 11:04:41 (10944:8368) DATAFLOW: Process to execute data flow <DF_EXPORT_ORM_D2P> is completed.
(14.2) 05-09-17 11:04:41 (10188:3700) JOB: Job <ORM_D2P> is terminated due to error <50316>.
Error Log:
(14.2) 05-09-17 11:04:41 (E) (10944:8368) CON-120307: |Data flow DF_EXPORT_ORM_D2P
ODBC call <SQLDriverConnect> to connect database <a_WExp> failed with error: <[WSock32 DLL] 10065 WSA E HostUnreach: The
Teradata server can't currently be reached over this network>. 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.
(14.2) 05-09-17 11:04:41 (E) (10944:8368) CON-120307: |Data flow DF_EXPORT_ORM_D2P
ODBC call <*****> to connect database <a_WExp> failed with error: <*****>. 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. This message contains some internal system
details which have been hidden for security. If you need to see the full contents of the original message, ask your
administrator to assign additional privileges to your account.
Thanks,
MU
Is this your first Teradata extraction job? And are your client and server 2 different machines?
Then make sure to properly configure the Teradata client tools on the server, too.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.