+ Post New Thread
Results 1 to 6 of 6
Home Access Plus+ Thread, Login issue - SQL connected? in Projects:; Im changing the log style from XML to SQL, and now I get the following in the event log on ...
  1. #1
    TheScarfedOne's Avatar
    Join Date
    Apr 2007
    Location
    Plymouth, Devon
    Posts
    1,074
    Thank Post
    520
    Thanked 146 Times in 132 Posts
    Blog Entries
    78
    Rep Power
    78

    Login issue - SQL connected?

    Im changing the log style from XML to SQL, and now I get the following in the event log on the server and not able to login.

    Event code: 3005
    Event message: An unhandled exception has occurred.
    Event time: 25/11/2013 12:41:12
    Event time (UTC): 25/11/2013 12:41:12
    Event ID: ca717782c92d4d55b614a8321d9e61a7
    Event sequence: 12
    Event occurrence: 1
    Event detail code: 0

    Application information:
    Application domain: /LM/W3SVC/1/ROOT/HAP-6-130298568647242583
    Trust level: Full
    Application Virtual Path: /HAP
    Application Path: D:\Program Files\HAP\
    Machine name: MAP-WEBS-01

    Process information:
    Process ID: 7364
    Process name: w3wp.exe
    Account name: MAP\HAP

    Exception information:
    Exception type: NullReferenceException
    Exception message: Object reference not set to an instance of an object.
    at HAP.Data.SQL.WebEvents.Log(WebTrackerEvent Event)
    at HAP.Data.SQL.WebEvents.Log(DateTime datetime, String type, String Username, String IP, String OS, String Browser, String ComputerName, String Details)
    at HAP.Web.Login.login_Click(Object sender, EventArgs e)
    at System.Web.UI.WebControls.LinkButton.OnClick(Event Args e)
    at System.Web.UI.WebControls.LinkButton.RaisePostBack Event(String eventArgument)
    at System.Web.UI.WebControls.LinkButton.System.Web.UI .IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
    at System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument)
    at System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData)
    at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)



    Request information:
    Request URL: https://MAP-WEBS-01:444/HAP/login.aspx?ReturnUrl=/HAP/
    Request path: /HAP/login.aspx
    User host address: 172.16.10.2
    User:
    Is authenticated: False
    Authentication Type:
    Thread account name: MAP\HAP

    Thread information:
    Thread ID: 10
    Thread account name: MAP\HAP
    Is impersonating: False
    Stack trace: at HAP.Data.SQL.WebEvents.Log(WebTrackerEvent Event)
    at HAP.Data.SQL.WebEvents.Log(DateTime datetime, String type, String Username, String IP, String OS, String Browser, String ComputerName, String Details)
    at HAP.Web.Login.login_Click(Object sender, EventArgs e)
    at System.Web.UI.WebControls.LinkButton.OnClick(Event Args e)
    at System.Web.UI.WebControls.LinkButton.RaisePostBack Event(String eventArgument)
    at System.Web.UI.WebControls.LinkButton.System.Web.UI .IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
    at System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument)
    at System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData)
    at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


    Custom event details:

    The DB is created, and the entry in the WebConfig is as follows

    <connectionStrings>
    <add name="SQLConnectionString" connectionString="Server=SQLCLUSTER;Database=HAP;U ser Id=usernameremoved;Password=passwordremoved;"/>
    </connectionStrings>

    Any ideas?

  2. #2

    Join Date
    Apr 2006
    Posts
    382
    Thank Post
    23
    Thanked 95 Times in 61 Posts
    Rep Power
    44
    In your connection string - is the space inbetween U and ser a copy/paste error?

  3. #3
    TheScarfedOne's Avatar
    Join Date
    Apr 2007
    Location
    Plymouth, Devon
    Posts
    1,074
    Thank Post
    520
    Thanked 146 Times in 132 Posts
    Blog Entries
    78
    Rep Power
    78
    It's supposed to have a space according to SQL docs.... At least, that's what says.....

  4. #4
    Jamo's Avatar
    Join Date
    Jan 2009
    Posts
    1,346
    Thank Post
    66
    Thanked 174 Times in 146 Posts
    Rep Power
    59
    Quote Originally Posted by TheScarfedOne View Post
    It's supposed to have a space according to SQL docs.... At least, that's what says.....
    If pasted into some forums you sometimes get weird copy paste issues such as this. Try without a space, it would certainly make more sense from a readability pov!

  5. #5
    TheScarfedOne's Avatar
    Join Date
    Apr 2007
    Location
    Plymouth, Devon
    Posts
    1,074
    Thank Post
    520
    Thanked 146 Times in 132 Posts
    Blog Entries
    78
    Rep Power
    78
    Nope, no change. Tried a number of varients - space, no space, spaces and no spaces between commas as well. The thing is, I know I had this working...not sure why I turned it off. Also, got the missing charts issue on the tracker pages when using XML. Hmmm... @nickbro?

  6. #6
    nickbro's Avatar
    Join Date
    Jul 2010
    Location
    Gilwern, Wales
    Posts
    3,351
    Thank Post
    36
    Thanked 465 Times in 397 Posts
    Rep Power
    105
    The charts are rendered via javascript, look for any JSON errors.

    Have you run the SQL script to generate the database tables?

    If you can, download the source files, set the build mode to debug, compile the HAP.web folder, and copy the dlls into your bin folder, it will turn the debug lines on, showing exactly which line is causing an issue.

SHARE:
+ Post New Thread

Similar Threads

  1. Login issues with domain trusts
    By Stuart_C in forum Windows
    Replies: 18
    Last Post: 9th December 2008, 05:27 PM
  2. Replies: 2
    Last Post: 8th September 2008, 02:54 PM
  3. iTALC issues with connectivity
    By poatos in forum Network and Classroom Management
    Replies: 2
    Last Post: 8th May 2008, 11:18 AM
  4. Strange Login Issues
    By jsnetman in forum MIS Systems
    Replies: 0
    Last Post: 3rd April 2008, 09:18 AM
  5. Login bottleneck on Connect 2.4
    By iking in forum Wireless Networks
    Replies: 6
    Last Post: 15th June 2006, 07:54 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •