Facing ORA-03114: not connected to ORACLE when accessing data from source table

[former_member434646]

Hi All Experts,

My source database is oracle 11g. I am able to created data store using same database.

also able to import table from oracle database but when i am right click on that source table and select option "view Data" it will shown data first time but when I am trying same process for second time it will give error i.e. ORA-03114: not connected to ORACLE.

When I closed Designer and re-login it. same thing happened which i mention above.

System/Tools Configuration:

SAP Data Services 4.2 SP8 - Installed on platform: SUSE Linux Enterprise Server 12.2 (SP2). Linux Kernel Version: 4.4.21-69-default

Source Database: Oracle 11g

Target Database: Sybase ASE 16.0

SAP Data Services Designer install on Windows Server 2008 R2 Standard

I have already checked below forum links:

http://www.forumtopics.com/busobj/viewtopic.php?p=979550

https://archive.sap.com/discussions/thread/241091

http://www.forumtopics.com/busobj/viewtopic.php?t=37406

Thanks in advance for valuable inputs.

Dhanraj

[former_member434646]

Hello All Experts,

I have analysis of above error and conclusion are as below:

My source database connection is staying with BODS for 20 second only after that it is disconnected and getting above error.

What is problem behind it. please give me solution on it if anyone knows.

Regards,

Dhanraj