Thanks Eric, i will give that a try. I had tried publishing the site but that was from the desktop application which may not have the same affect. I will try to launch through the app then publish.

Troy Cantrell
Director Information Technology
California Travel and Tourism Commission

Have you tried recycling the worker process or restarting IIS on the application server?

Thank Eric, but after digging on here more yesterday, I think my error is related to the Guest account.  UserMain contains the Guest record, but Users does not.  When I ran a trace and tried to open the web page, the last query (the one that joins users and usermain) returned no rows and then I get the error.

That's expected. Users should not contain GUEST -- Users only contains Full and Casual users, and GUEST is a public user. You might make sure GUEST is not marked as disabled or expired (check the values in UserMain if you can't get to it via Desktop).

Can you post the full error with stack trace? It should be in the Windows Application Event Log on the appserver, and/or the Asi.Webroot.log file.

Guest is marked as a public users and is not disabled.  Expiration date is null. 

In event viewer there is first a warning and then the error.  Here are both:

Warning:

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 6/3/2009
Time: 12:57:28 PM
User: N/A
Computer: GISERV1
Description:
Event code: 3005 Event message: An unhandled exception has occurred. Event time: 6/3/2009 12:57:28 PM Event time (UTC): 6/3/2009 6:57:28 PM Event ID: 1c406fe14ae947509d00701b1090c0fb Event sequence: 489 Event occurrence: 5 Event detail code: 0 Application information: Application domain: /LM/W3SVC/29923/Root/iMIS15-4-128885107984531250 Trust level: Full Application Virtual Path: /iMIS15 Application Path: D:\Program Files\asi\imis15\Net\ Machine name: GISERV1 Process information: Process ID: 5920 Process name: w3wp.exe Account name: NT AUTHORITY\NETWORK SERVICE Exception information: Exception type: ArgumentException Exception message: Could not find the sitemap node with URL '/imis15/Admin/?hkey=6edd071c-aeca-42f5-847e-3e7aabea2a6b'. Request information: Request URL: http://imis.ncsl-hq.com/iMIS15/AsiCommon/Controls/Shared/FormsAuthentica... unhandled exception has occurred.fimis15An unhandled exception has occurred.fDefault.aspx&WebsiteKey=d30229f1-d53b-48d7-99ae-d0ce9fea621d&LoginMessage=You+must+log+in+to+access+this+content. Request path: /iMIS15/AsiCommon/Controls/Shared/FormsAuthentication/Login.aspx User host address: 65.38.167.213 User: GUEST Is authenticated: False Authentication Type: Application Thread account name: NT AUTHORITY\NETWORK SERVICE Thread information: Thread ID: 7 Thread account name: NT AUTHORITY\NETWORK SERVICE Is impersonating: False Stack trace: at System.Web.UI.WebControls.SiteMapDataSource.GetNodes()
at System.Web.UI.WebControls.SiteMapDataSource.GetTreeView(String viewPath)
at System.Web.UI.WebControls.SiteMapDataSource.GetHierarchicalView(String viewPath)
at System.Web.UI.HierarchicalDataSourceControl.System.Web.UI.IHierarchicalDataSource.GetHierarchicalView(String viewPath)
at System.Web.UI.WebControls.HierarchicalDataBoundControl.GetData(String viewPath)
at System.Web.UI.WebControls.Menu.DataBindItem(MenuItem item)
at System.Web.UI.WebControls.Menu.PerformDataBinding()
at System.Web.UI.WebControls.HierarchicalDataBoundControl.PerformSelect()
at System.Web.UI.WebControls.BaseDataBoundControl.DataBind()
at System.Web.UI.WebControls.Menu.DataBind()
at System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound()
at System.Web.UI.WebControls.Menu.EnsureDataBound()
at System.Web.UI.WebControls.Menu.CreateChildControls()
at System.Web.UI.Control.EnsureChildControls()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
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.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

error

Event Type: Error
Event Source: ASI
Event Category: None
Event ID: 0
Date: 6/3/2009
Time: 12:57:30 PM
User: N/A
Computer: GISERV1
Description:
Unexpected website error: Exception of type 'System.Web.HttpUnhandledException' was thrown.

System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.ArgumentException: Could not find the sitemap node with URL '/imis15/Admin/?hkey=6edd071c-aeca-42f5-847e-3e7aabea2a6b'.
at System.Web.UI.WebControls.SiteMapDataSource.GetNodes()
at System.Web.UI.WebControls.SiteMapDataSource.GetTreeView(String viewPath)
at System.Web.UI.WebControls.SiteMapDataSource.GetHierarchicalView(String viewPath)
at System.Web.UI.HierarchicalDataSourceControl.System.Web.UI.IHierarchicalDataSource.GetHierarchicalView(String viewPath)
at System.Web.UI.WebControls.HierarchicalDataBoundControl.GetData(String viewPath)
at System.Web.UI.WebControls.Menu.DataBindItem(MenuItem item)
at System.Web.UI.WebControls.Menu.PerformDataBinding()
at System.Web.UI.WebControls.HierarchicalDataBoundControl.PerformSelect()
at System.Web.UI.WebControls.BaseDataBoundControl.DataBind()
at System.Web.UI.WebControls.Menu.DataBind()
at System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound()
at System.Web.UI.WebControls.Menu.EnsureDataBound()
at System.Web.UI.WebControls.Menu.CreateChildControls()
at System.Web.UI.Control.EnsureChildControls()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
--- End of inner exception stack trace ---
at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.asicommon_controls_shared_formsauthentication_login_aspx.ProcessRequest(HttpContext context) in c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\imis15\7d4a15fe\d302aac7\App_Web_oslmwdof.0.cs:line 0
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

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

Okay, for some reason I can't enter the test SQL I want you to run, so I'll describe it.

On your iMIS DB, select ProviderKey from UserMain where UserId equals GUEST. Take that provider key and pass it to the asi_UserMainLogin stored procedure. This should return several results; let me know what they are. This will determine if the issue is the GUEST account, or something else.

Here you go:

CAC7B65A-1F80-47BC-8B01-A6E388FA143F     13375    GUEST    GUEST    673A2ED2-EC66-4E5A-8453-D16844186C71

CAC7B65A-1F80-47BC-8B01-A6E388FA143F
93D4477A-465E-4179-ADA9-6B854DA9BDB6    Everyone
2B672E12-1F2C-4445-8C6C-878915710E71     Contact
F1679893-65D3-4320-B4DA-CC54ED6E600F    C

Returned no rows for Userid, UserKey and Role

ABC419D1-84E0-4329-BEEA-1FD22AB8E13D    Authenticated Users

Can you do a "select * from UserMain where UserId = 'GUEST'" and tell me if there are values in DefaultDepartmentGroupKey and DefaultPerspectiveKey?

Yes:

DefaultDepartmentGroupKey                                    DefaultPerspectiveKey

E3FE346D-79C5-47FF-8C63-F21244BBA29A     3391C497-FAA5-4944-B60F-9AD04C0B5B70

Hm... what I'm confused about is that that group (Administrative) doesn't show up in the list of memberships (the second result set)... I'm wondering if that could be causing or contributing to the problem.

How about doing a "select * from GroupMember where MemberContactKey = '[Guest's UserKey]'" and make sure that there's 1 row, IsActive is true, DropDate is null, and JoinDate is in the past?

there is 1 row, IsActive is true, DropDate is null and JoinDate is also null.

Can you set JoinDate to 6/1/2009, reset IIS (or recycle the worker process) and see if that resolves the issue?

Updated the JoinDate, recycled worker processes and still get the error.

Okay, so it's probably not the GUEST account.

Try running the following and see if anything comes back:

SELECT * FROM DocumentMain WHERE DocumentTypeCode = 'NAV' AND DocumentStatusCode < 40

No rows returned.

Change DocumentTypeCode to 'WEB' and see if that gets any rows.

Also, if you're navigating to http://server/imis15/, try going to http://server/imis15/Admin/ instead, maybe that will work around the issue.

No rows returned for WEB either.

Adding /Admin to the URL reulsts in Page cannot be found.

Hm. Okay, at this point I would recommend you work with TS to get them your database and see if they can reproduce it. If they can, we can do some investigating and see what's going on, I don't think it's related to GUEST, but I don't have any other good guesses on what the issue is.

OK, I will do that.  By the way, and maybe it's not related at all, but I just discovered that if I go to the desktop, then go to iSA and Manage Websites, if I click on the Web view I can preview it without any errors.  But, I also noticed that I cannot edit any IQA Queries.  I can open them in Edit, but I can't get past the Query Summary screen.  Same is true if I try to create a new query.  I am a bit nervous now as I am supposed to be doing another 15.1 upgrade this week.

For the IQA queries, make sure you've filled out all the required fields on the Summary tab (such as the Query Name) before trying to switch tabs. There should be red error messages if that's the reason you can't change tabs.

The Preview note is interesting... you might go to iSA > Manage websites, select each website there, and click Publish (make sure "publish children" is checked). That might reset whatever's getting stuck. If Preview is working, then the general structure is sound, but something isn't quite "there".

it published without any errors, but I still get the sitemap error when I try to open the site.

On the IQA, the problem is I don't have the tabs (that were there at 15.0.3) to navigate.  I don't have Summary, Sources, Filters, Display and Sorting.  All I get is the Query Summary screen with the Define, Run, Security to the left, and I can't click on those either.

If you click Security, what do you get? I'm guessing that the system thinks you don't have permissions to edit the query.

I can't click on Security.  I am logged on as Manager

Eric,  for what it is worth, I just did a multi-instance install of this instance against a non-converted database and re-ran the upgrade.  Same customer, but different copy of the database to be used as a test install.  I get the same sitemap error on that second instance.

In that new instance, I deleted the Guest member record and recreated it.  I then went to the Credentials page, created the logon, still got the error.  I then set Guest as a full users, SysAdmin Role and added 8's to all the staff access, saved it, then reset Guest to Public User.  Bingo, I can now logon in the web view without getting the error.  So, unless you can think of something that I may have negatively affected, I will do the same on the production account.

Shouldn't negatively affect anything that I can think of. You might pass that info along to TS as a workaround until we can get the issue patched... thanks!

Did you ever try making the guest user a full user and test it?

The symptoms sound very simiar to the issue I had.  All was resolved when I created my guest user but I created it as a full user with admin rights then removed the rights.

(even the preview issue worked)

Troy Cantrell Director Information Technology California Travel and Tourism Commission

No not yet.  The problem is that when I go in to User Credentials for Guest, the member record isn't tied to anything.  So, is I try to select a user to create the logon, I get the ProviderError.  So I have been unable to change the user class.  I don't know if I can delete the Guest member record and recreate it from scratch without causing more problems.

Troy,

That did the trick, at least for the dev instance.  If I feel brave I will try the same on the prod instance tomorrow.