Current Position:Home > Database Connection Lost Error

Database Connection Lost Error

Update:10-11Source: network consolidation
Advertisement
Hi,
MyScenario is :
We send a query to database A collect resultset in java mapping and transform it to three more Select queries and send them to Database B So two chanels are there:
Sender JDBC channel, Receiver JDBC Channel.
Now the Output of Database B is converted to IDOC and sent to R/3 System.
This is working fine, but sometime it stuck at Database B saying error "connection Lost". And works fine afterwards.But in that case we miss the records which could not be processed.
What can be the reason for this ? Please suggest the solution at teh earliest. Can overloading be the reason for losing connection. Please suggest...
Thanks & Regards,
Priyanka

The Best Answer

Advertisement
Hi Priyanka,
You have to close the connection afte accessing the JDBC  "A".
So that it could be accesed by others.
Try to implement the suggetion given by sarvesh.
If it still does not work then i would say you go for JDBC look ups.
It will improve the performance as well.
Thanks
Sunil Singh
  • Database Connection Lost Error Update:10-11

    Hi, MyScenario is : We send a query to database A collect resultset in java mapping and transform it to three more Select queries and send them to Database B So two chanels are there: Sender JDBC channel, Receiver JDBC Channel. Now the Output of Data

  • Workspace- Database Connection Manager error while connectiong to HFM Update:11-30

    We are on 9.3.1.using only FR and WA. I am using admin id to login to the workspace. Open Tools -> Database Connection Manager -> New-> Properties Box opens and input all the info. right and can see the appropriate HFM application. But when i cli

  • Workspace Database Connection Manager error 8001 Update:11-30

    In workspace, when I use the database connection manager to add a new connection I get the following error: *8001: The Database Connection could not be found: 6c1c06bf_129b3ad1455_-7ee9* Since this is a reinstallation over a previous installation, th

  • HFM Database Connection Manager error in Workspace Update:11-30

    We are on 9.3.1.using only FR and HFM. I am using admin id to login to the workspace. Open Tools -> Database Connection Manager -> New-> Properties Box opens and input all the info. right and can see the appropriate HFM applications. But when i c

  • Database Connection: Http Error 405 Method Not Allowed Update:11-30

    Hi, I am new to this forum, but I am having an issue I hope you can help with.  I have a database on my MS SQL Server 2008.  I am trying to access it with my DW8 page, and while I can code a connection successfully, I can't use the Database or Bindin

  • Database connectivity toolkit: Error -2147217887 Update:11-30

    I have no problem to connect to a non-password protected SQL server compact edition 3.5 database. However, when the same database was password protected, an error happend. Any idea. HPangI've looked at this website before and tried to use the string

  • FIM 2010 Sync Error : stopped-database-connection-lost Update:11-30

    Hello everyone, a weird thing just happened to me, i'm synchronizing my MA and suddently i get the "stopped-database-connection-lost" error i have 5 Galsync MAs working perfectly and this sixth one just failing ... (since like today) which makes

  • Issue in creating Database Connection to HFM Applicaion through workspace Update:10-11

    Hi, This is a fresh installation. We are trying to create a new database connection in workspace for HFM Application. When i click on the Application selection icon, it gives me the below error message, *"Error connecting to database connection nasby

  • Issue in creating Database Connection to HFM Application through workspace Update:10-11

    Hi, This is a fresh installation. We are trying to create a new database connection in workspace for HFM Application. When i click on the Application selection icon, it gives me the below error message, *"Error connecting to database connection nasby

  • P6 8.3 Professional - how to backup database connections? Update:11-30

    Is there a way?Hello Daniel, this is how my Path=E:\instantclient_11_2;...... variable looks like. I have put tnsnames.ora and sqlnet.ora in E:\instantclient_11_2 and this is how TNS_ADMIN=E:\instantclient_11_2 looks like. Contents of tnsnames.ora #