Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Mar 14 at 09:37 AM

    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

    Add comment
    10|10000 characters needed characters exceeded