Errors & Exceptions

Question

Having downloaded the beta version from Microsoft connect and had it all working nicely, I was excited to see the next release. I quickly downloaded and installed it.

The first few installs had issues. I blew away all site collections and web applications from my test environment (a virtual machine) and built it from the ground up.

The ECTS installed fine, I add the configuration utility to a web part page but when I try and update the configuration parameters it creates the following exception:

Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 04/03/2008 01:01:00
Event time (UTC): 04/03/2008 01:01:00
Event ID: bbcd5f55865a4b449a5b6ab0d15d2343
Event sequence: 3
Event occurrence: 1
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/1047597790/Root-3-128490660024770946
    Trust level: WSS_Minimal
    Application Virtual Path: /
    Application Path: C:\Inetpub\wwwroot\wss\VirtualDirectories\ectsportal80\
    Machine name: ECTS
 
Process information:
    Process ID: 496
    Process name: w3wp.exe
    Account name: CAPGEMINI\svc-moss-app
 
Exception information:
    Exception type: InvalidOperationException
    Exception message: ExecuteNonQuery: Connection property has not been initialized.
 
Request information:
    Request URL: http://ectsportal/ectsmgmt/Pages/config.aspx
    Request path: /ectsmgmt/Pages/config.aspx
    User host address: 192.168.111.20
    User: CAPGEMINI\moss-site-admin
    Is authenticated: True
    Authentication Type: NTLM
    Thread account name: CAPGEMINI\svc-moss-app
 
Thread information:
    Thread ID: 10
    Thread account name: CAPGEMINI\svc-moss-app
    Is impersonating: False
    Stack trace:    at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at EAT.Common.SqlManager.SetEntry(String DbName, String Column, String SetValue, String Name, String Value)
   at EAT.Common.SqlManager.SetEntry(String DbName, String Column, String SetValue)
   at EAT.ConfigurationUtility.ConfigurationUtility.UpdateDB_Click(Object sender, EventArgs e)
   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)
 
 
Custom event details:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.



Similarly, when I attempt to add any of the other web parts to the page it throws this exception:


Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 04/03/2008 01:10:01
Event time (UTC): 04/03/2008 01:10:01
Event ID: c835933e8fdb452f9309bd3503d1d1c1
Event sequence: 4
Event occurrence: 1
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/1047597790/Root-1-128490665018472006
    Trust level: WSS_Minimal
    Application Virtual Path: /
    Application Path: C:\Inetpub\wwwroot\wss\VirtualDirectories\ectsportal80\
    Machine name: ECTS
 
Process information:
    Process ID: 3816
    Process name: w3wp.exe
    Account name: CAPGEMINI\svc-moss-app
 
Exception information:
    Exception type: InvalidOperationException
    Exception message: ExecuteNonQuery: Connection property has not been initialized.
 
Request information:
    Request URL: http://ectsportal/ectsmgmt/Pages/config.aspx
    Request path: /ectsmgmt/Pages/config.aspx
    User host address: 192.168.111.20
    User: CAPGEMINI\moss-site-admin
    Is authenticated: True
    Authentication Type: NTLM
    Thread account name: CAPGEMINI\svc-moss-app
 
Thread information:
    Thread ID: 1
    Thread account name: CAPGEMINI\svc-moss-app
    Is impersonating: False
    Stack trace:    at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at EAT.Common.SqlManager.SetEntry(String DbName, String Column, String SetValue, String Name, String Value)
   at EAT.Common.SqlManager.SetEntry(String DbName, String Column, String SetValue)
   at EAT.ConfigurationUtility.ConfigurationUtility.UpdateDB_Click(Object sender, EventArgs e)
   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)
 
 
Custom event details:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


I have manually uninstalled the beta version of ECTS from this test environment, could this be causing me an issue? Are the events indicative of what is wrong?

Any help would be greatly appreciated - it's a great kit, I'd hate to have to stop using it through it being too buggy.

Keep up the good work guys!

Regards,

Jason Dunbar

Answer 1

It looks from the information you provided that you are running MOSS.  If this is correct, then you need to make sure that you give the MOSS service account read/write permissions to the ECTS database in SQL.  In your trace above, it appears this account is CAPGEMINI\svc-moss-app.  We've created a small script to help set up these permissions called grant_sql_perms.vbs.  Please see Appendix A of the Deployment and Operations Guide for more information on what special steps you have to take in this environment.

 

You may also want to check you web.config files to see the that connection string for the database is correct. 

 

Finally, if things are really dicey, you might want to go back to "bare metal" and run the setup again from scratch.  This would mean doing the following:

 

1) Delete ADAM instance (from add/remove programs)

2) Delete ECTS SQL database (SQL Management Studio comes in handy here)

3) Undeploy the ECTS solution using undeploysolution.cmd

4) Remove web application from Central Administration, including removing the site collection

 

Then you will be in a position to create a new web applicaiton, extend it, create the site collection, configure the authentication provider, then run the setup wizard.

 

Good luck and let me know how it goes...

 

Bill 

 

 

Answer 2

Hi Bill,

Thanks for your response.

I am indeed running MOSS; MOSS 2007 in a VMWare Virtual Machine environment with a seperate virtual machine acting as my domain controller, DNS Server and SMTP Server.

OK so here's what I've done since your response:

1) I completely tore down my Site Collection and both web applications (One Primary Web Application and another Web Application as an extension of the first)

2) Uninstalled my ADAM Instance

3) Reinstalled ECTS, installing only the ADAM and SQL components, completed fine, no issues.

4) Setup an SSL Certificate for use with ADAM

- Issued certificate from CA installed on domain controller
- Installed certificate onto the server
- I ran mmc and copied the certificate from the "My Account > Local Machine" store to the certificates folder for the ADAM Service account - as detailed here: http://erlend.oftedal.no/blog/?blogid=7

5) I then ran the ECTS SQL Permissions script as detailed in the ECTS deployment guide, that completed find, no issues.

6) I modified the ADAM service and set the identity to run as to be a domain user and then added that domain user to the administrators group to enable access to the ADAM data files. Then I restarted the ADAM Instance.

7) Finally I went to run the ECTS installation again, this time installing only the SharePoint component(s)

To my disbelief it all worked! I created web part pages and threw on the configuration web part, the user manager web part etc.

I updated the configuration web part with the necessary details and then went to add an external user via the Site Settings link.

No sooner had I added an external user and approved the user, the External User Manager web part started experiencing issues and reporting the following error:

"The "UserManager" Web Part appears to be causing a problem. Negating the minimum value of a twos complement number is invalid."

I then enable debugging features in the web.config and receive the following:

Negating the minimum value of a twos complement number is invalid.
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.OverflowException: Negating the minimum value of a twos complement number is invalid.

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:


[OverflowException: Negating the minimum value of a twos complement number is invalid.]
   System.Math.AbsHelper(Int64 value) +2521690
   System.Math.Abs(Int64 value) +33
   EAT.Common.cUserManager.PasswordLifetime() +333
   EAT.Common.cUserManager.DaysUntilPasswordExpires(MembershipUser u) +64
   EAT.Common.cUserManager.PasswordExpired(MembershipUser U) +5
   EAT.UserManager.UserManager.Render(HtmlTextWriter writer) +2001
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
   Microsoft.SharePoint.WebPartPages.SPChrome.RenderPartContents(HtmlTextWriter output, WebPart part) +52

 
I then headed over to the external url to see if I could log in with my new external user, low and behold, I'm hit with the exact same issue as explained here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2827728&SiteID=1

I was assuming this issue had been fixed with the latest release - I guess not :-(

Once again - any help and/or guidance you can provide is very much appreciated.

Many Thanks,

Jason

Answer 3

Jason,

 

First, I want to confirm that you are running the version that came off the Download Center.  Second, have you set the "Days of warning for an impending password change" to a number?  If you haven't, please set it to 0.  Let me know if this helps.

 

Bill

Answer 4

Bill,

I am indeed running the version from the Download Centre.

I had originally set the "Days of warning for an impending password change" to a number, originally 5 days. Setting this value to 0 and then updating the database didn't seem to make any difference.

I spent some time playing around with it and everything seems to work except the User Manager web part.

I seem to be able to break the User Manager web part on demand. At the moment I have a Web Part Page with the User Manager web part added to it. If I edit the ECTS configuration via the Configuration web part and remove any value in the External User Management Group Name field and update the database then the User Manager web part works just fine although it tells me I am not a member of the SharePoint group that is allowed to access the web part - fair enough. That's expected since I haven't made the ECTS configuration aware of a user manager SharePoint group.

I can add the name of a fictitious SharePoint group to the External User Management Group Name, update the database and the User Manager web part still works and behaves as detailed above.

However, when I input the name of an actual SharePoint group and update the database, this is when I receive the error detailed in my previous post:

Negating the minimum value of a twos complement number is invalid.
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.OverflowException: Negating the minimum value of a twos complement number is invalid.

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:


[OverflowException: Negating the minimum value of a twos complement number is invalid.]
   System.Math.AbsHelper(Int64 value) +2521690
   System.Math.Abs(Int64 value) +33
   EAT.Common.cUserManager.PasswordLifetime() +333
   EAT.Common.cUserManager.DaysUntilPasswordExpires(MembershipUser u) +64
   EAT.Common.cUserManager.PasswordExpired(MembershipUser U) +5
   EAT.UserManager.UserManager.Render(HtmlTextWriter writer) +1991
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
   Microsoft.SharePoint.WebPartPages.SPChrome.RenderPartContents(HtmlTextWriter output, WebPart part) +52

[WebPartException: Negating the minimum value of a twos complement number is invalid.]
   Microsoft.SharePoint.WebPartPages.SPChrome.RenderPartContents(HtmlTextWriter output, WebPart part) +126
   Microsoft.SharePoint.WebPartPages.SPChrome.RenderWebPart(HtmlTextWriter output, WebPart part) +54
   Microsoft.SharePoint.WebPartPages.WebPartZone.RenderZoneCell(HtmlTextWriter output, Boolean bMoreParts, WebPart part) +121
   Microsoft.SharePoint.WebPartPages.WebPartZone.RenderWebParts(HtmlTextWriter output, ArrayList webParts) +450
   Microsoft.SharePoint.WebPartPages.WebPartZone.Render(HtmlTextWriter output) +791
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +130
   System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +24
   System.Web.UI.Control.Render(HtmlTextWriter writer) +7
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +130
   System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +24
   System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) +29
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +130
   System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +24
   System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) +59
   System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) +68
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
   System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) +37
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +130
   System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +24
   System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) +29
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +130
   System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +24
   System.Web.UI.Control.Render(HtmlTextWriter writer) +7
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +130
   System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +24
   System.Web.UI.Page.Render(HtmlTextWriter writer) +26
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1896

 


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42



... Any further suggestions? :-)

Cheers,

Jason

Answer 5

Jason,

 

Can you tell me a bit about the group that you are using?  Are there users in it?  Do you get this error only when you got to the page with a user from User Manager group?

 

Also, can you tell me if user creation and approval is working?  This would tell us that things are generally configured correctly...

 

Finally, please let me what your environment is set up.  Is a single server running WSS, or are you spread across several systems?

 

I am certain we can get this figured out...

 

Bill

Answer 6

Hi Bill,

The group I was using for the user approvers, I tried it with users, without users. The External User Manager web part threw an exception no matter who I was logged in as.

There was never a problem with user creation or approvals. It was only that one web part, External User Manager, that had an issue.

Anyhow, the good news is, having tried tinkering with many many things I sat back and thought for a moment. I came to the following conclusions:-

1) When a User Manager SharePoint group name WASN'T input into the Configuration web part, the External User Manager web part worked as you'd expect it to and told me I did not have access to the web part.

2) When a User Manager SharePoint group name WAS input into the Configuration web part, the External User Manager web part threw the exception that I included in previous posts.

- Take the first few lines of the stack-trace:

[OverflowException: Negating the minimum value of a twos complement number is invalid.]
   System.Math.AbsHelper(Int64 value) +2521690
   System.Math.Abs(Int64 value) +33
   EAT.Common.cUserManager.PasswordLifetime() +333
   EAT.Common.cUserManager.DaysUntilPasswordExpires(MembershipUser u) +64

Notice how the exception relates to Password Policy...

Anyhow, my second point got my thinking around password policies - I can't believe this wasn't more obvious.

I decided I'd set about trying to alter the password policy in ADAM in an attempt to change values for Password Lifetime and Password Minimum Lifetime and Warning Before Password Expires (Days) etc. etc. I couldn't find where to configure these within ADAM. I then remembered... When installed on a computer that is part of a domain, ADAM adopts the domain password policy set by group policy.

I have two Virtual Machines in my setup, one running Active Directory, DNS, SMTP & POP3. The other is running SQL Server 2005, MOSS 2007 and ADAM.

Normally, when developing, testing and proving concepts in virtual machines, I disable all password policy for the domain. I re-enabled password policy by setting the following values:

Enforce Password History = 4 days (previously disabled)
Maximum Password Age = 30 days (previously disabled)
Minimum Password Age = 0 days (previously disabled)
Minimum Password Length = 5 characters (previously disabled)

I then ran gpupdate /force on my MOSS 2007 server and called up the page with the External User Manager web part on. Alas! It worked!

So it seems that if you have no password policy, it breaks ECTS. Is this intentional? If so - perhaps we could receive an exception that is a little more friendly and lets us know what's gone wrong. If not, then maybe we need to take out the dependency on that password policy data.

Either way, thanks for all your help in resolving this - your suggestions have prompted me to try all kinds of things, eliminating possibilities along the way.

Jason

Answer 7

Jason,

 

I'm glad you figured it out in the end.  I hope that you can live with having the password policy on.

 

I'll refer this thread to others on the team for their thoughts...

 

Bill

Answer 8

I am having the same problem and I followed the directions that you did with editing the local secrurity policy and changing the password policy but I am still getting the same issues.  Does anybody have any ideas?  Please help.

 

Answer 9

I have the same problem as well.  Did you get this resolved?

Answer 10

Same here.  Previously the password max/min was set to 0/0.   Set to 999/0 and still having the same issue.  Any further updates?

Edit: Realized its an SBS server, and the Small business server domain password policy was at the top of the link tree.  From another post someone mentioned ECTS looks to the first GPO listed.   In short, changed both and now it works.

Answer 11

Hi Jason,

I'm having the exact same problem, but I'm also having problems altering the password policy. Could you please elaborate on how you were able to change the password policy? I tried the policy editor, but all options are greyed out. It seems the policy is being inherited by the default domain policy and I'm not able to change that unfortunately. Is there some way to force ADAM to use it's own policy, or to turn off the inheritance?

Thanks in advance,

Jasper

---

MCTS in Web Application Development in .NET 2.0

Answer 12

Hi Jasper,

As far as I know, there's no way to break the Password Policy inheritance if ADAM is installed within a domain. This appears to be by design. The password policy that I modified in my dev environment was indeed the Password Policy of the domain (set at Active Directory level).

Whilst this may not be the answer you're looking for I hope it helps.

Jason

Answer 13

Thanks for your reply, although it's not the answer I was looking for :) I found the code which causes the error, but unfortunately I'm unable to compile the dll to the same publickeytoken so I can't replace the one which comes with the ECTS kit. The developers who made this seem to be lost or something, at least I can't find any support anywhere. If you might have a clue how to fix this problem, please check out http://cks.codeplex.com/Thread/View.aspx?ThreadId=53465

---

MCTS in Web Application Development in .NET 2.0