search

sweenr / odbc2kml

Automatically exported from code.google.com/p/odbc2kml
0 stars 0 forks source link

Main page errors not failing gracefully #76

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Try to open/edit an oracle connection from main.aspx with the TNS
listner error (usually immediately after starting the VM).
2. Main.aspx fails less than gracefully.

Stack trace:
Server Error in '/' Application.
ORA-12514: TNS:listener does not currently know of service requested in
connect descriptor
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.OracleException: ORA-12514:
TNS:listener does not currently know of service requested in connect descriptor

Source Error:

Line 2979:                iTableNBox.DataTextField = "TABLE_NAME";
Line 2980:                iTableNBox.DataValueField = "TABLE_NAME";
Line 2981:                iTableNBox.DataBind();
Line 2982:                iTableFNBox.DataSource = oracleTables_Mapping;
Line 2983:                iTableFNBox.DataTextField = "TABLE_NAME";

Source File: C:\Users\Richard\Documents\School\SE Senior
Design\subversion\hci\HCI\ConnDetails.aspx.cs    Line: 2981

Stack Trace:

[OracleException (0x80131938): ORA-12514: TNS:listener does not currently
know of service requested in connect descriptor
]
   System.Data.OracleClient.OracleException.Check(OciErrorHandle
errorHandle, Int32 rc) +310518

System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String
userName, String password, String serverName, Boolean integratedSecurity,
Boolean unicode, Boolean omitOracleConnectionName) +683

System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString
connectionOptions) +133

System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOp
tions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningObject) +40

System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection
owningConnection, DbConnectionPool pool, DbConnectionOptions options) +29
   System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject) +433
   System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject) +72
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject) +457
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection) +100
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory) +116
   System.Data.OracleClient.OracleConnection.Open() +40
   System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection,
ConnectionState& originalState) +31
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior) +112
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +287
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +92

System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArgume
nts
arguments) +1297
   System.Web.UI.WebControls.ListControl.OnDataBinding(EventArgs e) +95
   System.Web.UI.WebControls.ListControl.PerformSelect() +34
   System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +73
   HCI.ConnDetails.updateTables(Int32 type) in
C:\Users\Richard\Documents\School\SE Senior
Design\subversion\hci\HCI\ConnDetails.aspx.cs:2981
   HCI.ConnDetails.Page_Load(Object sender, EventArgs e) in
C:\Users\Richard\Documents\School\SE Senior
Design\subversion\hci\HCI\ConnDetails.aspx.cs:236
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o,
Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender,
EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

Version Information: Microsoft .NET Framework Version:2.0.50727.4927;
ASP.NET Version:2.0.50727.4927

Original issue reported on code.google.com by sweenr...@gmail.com on 1 Apr 2010 at 1:59

GoogleCodeExporter commented 9 years ago 
The bigger issue is that the main page isn't handling errors gracefully. It is
dumping that stack trace instead of displaying an error message.

Original comment by sweenr...@gmail.com on 1 Apr 2010 at 6:31

GoogleCodeExporter commented 9 years ago 
Fixed in r380.

Original comment by mbbowser@gmail.com on 1 Apr 2010 at 7:55

GoogleCodeExporter commented 9 years ago

Original comment by Spoofed...@gmail.com on 1 Apr 2010 at 8:19

GoogleCodeExporter commented 9 years ago 
This issue was closed by revision r451.

Original comment by mbbowser@gmail.com on 4 Apr 2010 at 10:51

GoogleCodeExporter commented 9 years ago 
This issue is related to issue 104. The updates I made were to ConnDetails.aspx 
(issue 
104), not Main.aspx (this issue 76), so I'm re-opening this issue.

Original comment by mbbowser@gmail.com on 4 Apr 2010 at 10:57

GoogleCodeExporter commented 9 years ago 
This was actually fixed. No related changes have actually been made. The issue 
was 
fixed in r380. Follow steps in test procedure to re-verify, just in case.

Original comment by mbbowser@gmail.com on 4 Apr 2010 at 11:00

GoogleCodeExporter commented 9 years ago 
Verified as showing error popup.

Original comment by sweenr...@gmail.com on 6 Apr 2010 at 6:46