web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

BP5.1 charts & KPI's HTTP status 401 error

(0) ShareShare
ReportReport
Posted on by 195

Hello,

I have the following setup: (everything is 64 bit)

BP5.1 and Sharepoint 2010 on Server 1 (Windows Server 2008)

SQL 2008 R2 & Great Plains R2 on Server 2 (Windows Server 2008)

*Just installed SP3 for all Dynamics apps*

If I sign into business portal from Server 1 as domain\administrator everything works. I can navigate to all pages, see all data and make any change.

However, if I sign into business portal as domain\administrator from any other computer none of the charts or KPI's show up. Instead I am presented with:

The request failed with HTTP status 401: Unauthorized. where the web part chart or graph should be. Everything else still works and is accessible.
I do not get any errors reported in event viewer on the SQL server, but I do get 2 on the SharePoint server.
Error 1:
Information 9/17/2012 4:14:00 PM MicrosoftBusinessFrameworkLog 0 None
Log Name:      Application
Source:        MicrosoftBusinessFrameworkLog
Date:          9/17/2012 4:14:00 PM
Event ID:      0
Task Category: None
Level:         Information
Keywords:      Classic
User:          N/A
Computer:      Server1
Description:
The description for Event ID 0 from source MicrosoftBusinessFrameworkLog cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
UserManager  VerifyUser  262  Domain\Username is not in UserWindowsIdentity table.
the message resource is present but the message is not found in the string/message table
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="MicrosoftBusinessFrameworkLog" />
    <EventID Qualifiers="0">0</EventID>
    <Level>4</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2012-09-17T23:14:00.000Z" />
    <EventRecordID>1790</EventRecordID>
    <Channel>Application</Channel>
    <Computer>evm-found02.Entirenet.net</Computer>
    <Security />
  </System>
  <EventData>
    <Data>UserManager  VerifyUser  262  domain\username is not in UserWindowsIdentity table. </Data>
  </EventData>
</Event>
Error 2:
Warning 9/17/2012 4:14:00 PM ASP.NET 2.0.50727.0 1309 Web Event
Log Name:      Application
Source:        ASP.NET 2.0.50727.0
Date:          9/17/2012 4:14:00 PM
Event ID:      1309
Task Category: Web Event
Level:         Warning
Keywords:      Classic
User:          N/A
Computer:      Server1
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 9/17/2012 4:14:00 PM
Event time (UTC): 9/17/2012 11:14:00 PM
Event ID: c279da71c9cb4998a281aea238da80ad
Event sequence: 1074
Event occurrence: 11
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/1060157504/ROOT-1-129923933614602420
    Trust level: WSS_Minimal
    Application Virtual Path: /
    Application Path: C:\inetpub\wwwroot\wss\VirtualDirectories\80\
    Machine name: Server1
 
Process information:
    Process ID: 3392
    Process name: w3wp.exe
    Account name: domain\username
 
Exception information:
    Exception type: AuthenticationException
    Exception message: Invalid user.
 
Request information:
    Request URL: 
    Request path: 
    User host address: 
    User: 
    Is authenticated: False
    Authentication Type: 
    Thread account name: domain\username
 
Thread information:
    Thread ID: 7
    Thread account name: domain\username
    Is impersonating: False
    Stack trace:    at Microsoft.BusinessFramework.UserManager.VerifyUser()
   at Microsoft.BusinessFramework.EnterpriseSession.Initialize(String enterpriseUrl)
   at ASP.global_asax.Session_OnEnd(Object sender, EventArgs e)
 
 
Custom event details:
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="ASP.NET 2.0.50727.0" />
    <EventID Qualifiers="32768">1309</EventID>
    <Level>3</Level>
    <Task>3</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2012-09-17T23:14:00.000Z" />
    <EventRecordID>1791</EventRecordID>
    <Channel>Application</Channel>
    <Computer>Server1</Computer>
    <Security />
  </System>
  <EventData>
    <Data>3005</Data>
    <Data>An unhandled exception has occurred.</Data>
    <Data>9/17/2012 4:14:00 PM</Data>
    <Data>9/17/2012 11:14:00 PM</Data>
    <Data>c279da71c9cb4998a281aea238da80ad</Data>
    <Data>1074</Data>
    <Data>11</Data>
    <Data>0</Data>
    <Data>/LM/W3SVC/1060157504/ROOT-1-129923933614602420</Data>
    <Data>WSS_Minimal</Data>
    <Data>/</Data>
    <Data>C:\inetpub\wwwroot\wss\VirtualDirectories\80\</Data>
    <Data>Server1</Data>
    <Data>
    </Data>
    <Data>3392</Data>
    <Data>w3wp.exe</Data>
    <Data>domain\username</Data>
    <Data>AuthenticationException</Data>
    <Data>Invalid user.</Data>
    <Data>
    </Data>
    <Data>
    </Data>
    <Data>
    </Data>
    <Data>
    </Data>
    <Data>False</Data>
    <Data>
    </Data>
    <Data>domain\username</Data>
    <Data>7</Data>
    <Data>domain\username</Data>
    <Data>False</Data>
    <Data>   at Microsoft.BusinessFramework.UserManager.VerifyUser()
   at Microsoft.BusinessFramework.EnterpriseSession.Initialize(String enterpriseUrl)
   at ASP.global_asax.Session_OnEnd(Object sender, EventArgs e)
</Data>
  </EventData>
</Event>
I have searched and have yet to find a resolution for this. Any help is appreciated.

*This post is locked for comments

I have the same question (0)
  • Rob Bernhardt Profile Picture
    on at

    Mike,

    Thanks for using the newsgroups.  It appears you have what is commonly referred to as the "double-hop" problem.  Using standard NTLM, the identity that you are using is not forwarded on past the first hop, and thus reporting services sees the identity as anonymous.  You have a couple options.  The first and recommended option is configuring kerberos authentication.  This allows for the identity to be delegated or forwarded from your BP server to your SQL server.  The second option is to hard-code the identity on the sql data source for reporting services.  Instead of relying on the identity to be forwarded, it would instead use a static identity for authentication and authorization with reporting services.  You must be very careful when doing this though because you are effectively reducing security in your solution.  I'd suggest trying this, verify it fixes the problem, and then explore kerberos.

    Thanks

    Rob

  • Mike Bryan Profile Picture
    195 on at

    I have tried running SSRS from both servers also implimenting kerberos and the issue is persistent. I am currently working with paid support to resolve the issue.

  • Rose Duley Profile Picture
    780 on at

    Hi Rob, can you please clarify if we must configure kerberos authentication on the Dynamics GP Web Services Installation and whether this is safe to do after having already installed the Dynamics GP Web Service?

  • Rob Bernhardt Profile Picture
    on at

    Rose,

    I don't believe you'll need Kerberos for web services.  As I mentioned on your other post, you may need it to support your SRS needs (depending on number of machines and configuration).

    Thanks

    Rob

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans