Post reply

Oracle link problem

  • January 11, 2007 at 3:05 pm

    #171754

    We have a web application which runs on IIS\sql server 2005 today we get this error, this error has happened once before and restarting the server seemed to right it until today now restart does nothing.

    application is called Loans

    All the oracle client installation is aok.

    Event code: 3005

    Event message: An unhandled exception has occurred.

    Event time: 12/01/2007 9:21:34 a.m.

    Event time (UTC): 11/01/2007 8:21:34 p.m.

    Event ID: c95ea58bceb947099bd90c9b444c174d

    Event sequence: 8

    Event occurrence: 1

    Event detail code: 0

     

    Application information:

        Application domain: /LM/W3SVC/1548204339/Root-1-128130204272812500

        Trust level: Full

        Application Virtual Path: /

        Application Path: C:\Inetpub\loans\

        Machine name: SQLDEV2

     

    Process information:

        Process ID: 3092

        Process name: w3wp.exe

        Account name: NT AUTHORITY\NETWORK SERVICE

     

    Exception information:

        Exception type: SqlException

        Exception message: Cannot initialize the data source object of OLE DB provider "MSDAORA" for linked server "GHWPRD".

     

    Request information:

        Request URL: http://sqldev2/MemberPages/Search.aspx 

        Request path: /MemberPages/Search.aspx

        User host address: 172.30.1.100

        User: user1

        Is authenticated: True

        Authentication Type: Forms

        Thread account name: NT AUTHORITY\NETWORK SERVICE

     

    Thread information:

        Thread ID: 6

        Thread account name: NT AUTHORITY\NETWORK SERVICE

        Is impersonating: False

        Stack trace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

       at System.Data.SqlClient.SqlDataReader.get_MetaData()

       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)

       at Search.Button1_Click(Object sender, EventArgs e) in C:\Inetpub\loans\MemberPages\Search.aspx.vb:line 62

       at System.Web.UI.WebControls.Button.OnClick(EventArgs e)

       at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)

       at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)

       at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)

       at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)

       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

  • January 15, 2007 at 8:00 am

    This was removed by the editor as SPAM

  • January 19, 2007 at 3:58 am

    #684230

    Hi,

    are you sure you always took care to close all your database connections you opened in eth application?

    I remember seeing similar effects in one off my projects when some were left open and caused such indeterministic problems.

    Michael

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply