ORA-03135: connection lost contact Either your server connection was terminated unexpectedly or your server timed out the connection.
Check if the SQLNET.INBOUND_CONNECT_TIMEOUT in sqlnet.ora is not set too low.
If this is not a problem, check if you have firewall issues. Some routers are set up to clean up idle TCP connections.
 Forum Messages
Hi frenz,
I have installed informatica version 7.1.4 and DAC version 7.9.3.
While configuring DAC it is giving the following error frequently while performing any operation like saving a record, synchronize the tasks etc..
Error while verifying existence of record with the same unique id.
MESSAGE:::java.sql.SQLException: ORA-03135: connection lost contact
EXCEPTION CLASS::: com.siebel.etl.database.IllegalSQLQueryException
com.siebel.etl.database.DBUtils.executeQuery(DBUtils.java:507)
com.siebel.etl.database.WeakDBUtils.executeQuery(WeakDBUtils.java:268)
com.siebel.analytics.etl.client.data.dataobject.UpdatableDataObject.verifyNoRecordWithKeyCombination(UpdatableDataObject.java:327)
com.siebel.analytics.etl.client.data.dataobject.UpdatableDataObject.verifyNoRecordWithKeyCombination(UpdatableDataObject.java:298)
com.siebel.analytics.etl.client.data.dataobject.UpdatableDataObject.verifyNoRecordWithKeyColumns(UpdatableDataObject.java:153)
com.siebel.analytics.etl.client.data.dataobject.BaseDACObject.verifyNoRecordWithKeyColumns(BaseDACObject.java:160)
com.siebel.analytics.etl.client.data.dataobject.UpdatableDataObject.canBeCreated(UpdatableDataObject.java:146)
com.siebel.analytics.etl.client.data.dataobject.BaseDACObject.canBeCreated(BaseDACObject.java:139)
com.siebel.analytics.etl.client.data.dataobject.BaseDACObject.create(BaseDACObject.java:532)
com.siebel.analytics.etl.client.data.dataobject.UpdatableDataObject.createUpdate(UpdatableDataObject.java:210
Thanks & Regards,
Madhavi.P |
| : -> 05-FEB-2008 10:49:24 | Possible causes | DbMotive | Reply |
This might be a version problem.
What version of the Oracle client are you using. Does this match the database version?
It can also be a problem when your database is configured to run in UTF8 mode, but your client character set is not compatible.
Most of the time this can be noiced when using varchar2(4000) columns |
Records remaining: 7332
Importing PAY_DEDUCTION
Import PAY_DEDUCTION 0
Updating statistics for PAY_DEDUCTION
Records remaining: 7331
Importing PAY_DEDUCTION
File: Data MoverSQL error. Stmt #: 0 Error Position: 0 Return: 3135 - ORA-03135: connection lost contact
Failed SQL stmt:INSERT INTO PS_PAY_DEDUCTION (COMPANY, PAYGROUP, PAY_END_DT, OFF_CYCLE, PAGE_NUM, LINE_NUM, SEPCHK, BENEFIT_RCD_NBR, PLAN_TYPE, BENEFIT_PLAN, DEDCD, DED_CLASS, DED_SLSTX_CLASS, DED_CUR, DED_CUR_PAYBK, DED_CUR_REFUND, DED_NOT_TAKEN, REASON_NOT_TAKEN, CALCULATED_BASE, ESPP_PROCESS_FLAG, AP_STATUS, GVT_SCHEDULE_NO, GVT_PAY_ID_LINE_1, GVT_PAY_ID_LINE_2, GVT_ECS_LTD_INDIC, GVT_ECS_OFF_ACCT, GVT_RITS_DT, GVT_TSP_SEQ_YR, GVT_TSP_SEQ_NO, DISBURSE_STATUS, DISBURSE_DT) VALUES (:1, :2, TO_DATE(:3,'YYYY-MM-DD'), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, TO_DATE(:27,'YYYY-MM-DD'), :28, :29, :30, TO_DATE(:31,'YYYY-MM-DD'))
Error: Unable to insert row 839
Error: SQL execute error for PAY_DEDUCTION
Ended: Fri Jul 11 20:52:08 2008
Unsuccessful completion
can you plz gude me how to resolve the this |
when i am trying to instal the texedo for an peoplesoft application ..if is displaying the eror like "..REGESTERKY \9.1\ENVIRONMENT\TEXEDO IS EMPTY..."
|
Add your message for ORA-03135
|
Home