Login issue - SQL connected?

[TheScarfedOne]

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(EventArgs e)

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

at System.Web.UI.WebControls.LinkButton.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)

 

 

 

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(EventArgs e)

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

at System.Web.UI.WebControls.LinkButton.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)

 

 

Custom event details:

 

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

 

 

Any ideas?

[theriver]

In your connection string - is the space inbetween U and ser a copy/paste error?

[TheScarfedOne]

It's supposed to have a space according to SQL docs.... At least, that's what says.....

[Jamo]

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!

[TheScarfedOne]

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?

[nickbro]

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.