jyothsna1803
asked on
ORA-12537: TNS:connection closed exception with ASP.NET
i am getting this weired error, I am using SQLDataSource. I am getting this error somertimes only.
ORA-12537: TNS:connection closed
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OracleClient.O racleExcep tion: ORA-12537: TNS:connection closed
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[OracleException (0x80131938): ORA-12537: TNS:connection closed
]
System.Data.OracleClient.O racleConne ction.Chec kError(Oci ErrorHandl e errorHandle, Int32 rc) +190
System.Data.OracleClient.O racleComma nd.Execute (OciStatem entHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals) +988
System.Data.OracleClient.O racleComma nd.Execute (OciStatem entHandle statementHandle, CommandBehavior behavior, ArrayList& resultParameterOrdinals) +25
System.Data.OracleClient.O racleComma nd.Execute Reader(Com mandBehavi or behavior) +138
System.Data.OracleClient.O racleComma nd.Execute DbDataRead er(Command Behavior behavior) +4
System.Data.Common.DbComma nd.System. Data.IDbCo mmand.Exec uteReader( CommandBeh avior behavior) +10
System.Data.Common.DbDataA dapter.Fil lInternal( DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +130
System.Data.Common.DbDataA dapter.Fil l(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +287
System.Data.Common.DbDataA dapter.Fil l(DataSet dataSet, String srcTable) +92
System.Web.UI.WebControls. SqlDataSou rceView.Ex ecuteSelec t(DataSour ceSelectAr guments arguments) +1297
System.Web.UI.DataSourceVi ew.Select( DataSource SelectArgu ments arguments, DataSourceViewSelectCallba ck callback) +19
DevExpress.Web.ASPxClasses .Internal. DataHelper .PerformSe lect() +149
DevExpress.Web.ASPxGridVie w.GridView DataHelper .PerformSe lect() +119
DevExpress.Web.ASPxClasses .Internal. DataContai ner.Perfor mSelect() +112
DevExpress.Web.ASPxClasses .ASPxDataW ebControlB ase.DataBi ndCore() +15
DevExpress.Web.ASPxClasses .ASPxDataW ebControlB ase.DataBi nd() +104
DevExpress.Web.ASPxGridVie w.ASPxGrid View.DataB ind() +248
DevExpress.Web.ASPxClasses .Internal. DataHelper Base.Ensur eDataBound (Boolean ensureChildControls) +89
DevExpress.Web.ASPxClasses .Internal. DataContai ner.Ensure DataBound( ) +120
DevExpress.Web.ASPxClasses .ASPxDataW ebControlB ase.OnPreR ender(Even tArgs e) +22
System.Web.UI.Control.PreR enderRecur siveIntern al() +80
System.Web.UI.Control.PreR enderRecur siveIntern al() +171
System.Web.UI.Control.PreR enderRecur siveIntern al() +171
System.Web.UI.Control.PreR enderRecur siveIntern al() +171
System.Web.UI.Control.PreR enderRecur siveIntern al() +171
System.Web.UI.Control.PreR enderRecur siveIntern al() +171
System.Web.UI.Control.PreR enderRecur siveIntern al() +171
System.Web.UI.Page.Process RequestMai n(Boolean includeStagesBeforeAsyncPo int, Boolean includeStagesAfterAsyncPoi nt) +842
Why it is failing sometimes only.
ORA-12537: TNS:connection closed
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OracleClient.O
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[OracleException (0x80131938): ORA-12537: TNS:connection closed
]
System.Data.OracleClient.O
System.Data.OracleClient.O
System.Data.OracleClient.O
System.Data.OracleClient.O
System.Data.OracleClient.O
System.Data.Common.DbComma
System.Data.Common.DbDataA
System.Data.Common.DbDataA
System.Data.Common.DbDataA
System.Web.UI.WebControls.
System.Web.UI.DataSourceVi
DevExpress.Web.ASPxClasses
DevExpress.Web.ASPxGridVie
DevExpress.Web.ASPxClasses
DevExpress.Web.ASPxClasses
DevExpress.Web.ASPxClasses
DevExpress.Web.ASPxGridVie
DevExpress.Web.ASPxClasses
DevExpress.Web.ASPxClasses
DevExpress.Web.ASPxClasses
System.Web.UI.Control.PreR
System.Web.UI.Control.PreR
System.Web.UI.Control.PreR
System.Web.UI.Control.PreR
System.Web.UI.Control.PreR
System.Web.UI.Control.PreR
System.Web.UI.Control.PreR
System.Web.UI.Page.Process
Why it is failing sometimes only.
Please check this also...Is it happening from the same client machine or different machines???
http://momendba.blogspot.com/2007/11/ora-12537-tns-connection-closed.html
http://momendba.blogspot.com/2007/11/ora-12537-tns-connection-closed.html
ASKER
it is happening with few pages only. So i am not sure exactly what is the problem.
That to it is happening sporadically. Seems it is happening with DEVX Grid, not sure.. It is happening on the server and i don't see this issue in Development.
That to it is happening sporadically. Seems it is happening with DEVX Grid, not sure.. It is happening on the server and i don't see this issue in Development.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This is a server issue.
Do check the below link and see whether any of the reasons is related to your case..
http://www.oradev.com/ORA-12537_TNS_connection_closed.jsp