In Hong Kong at the moment

So it’s been a month since my last post.

I’m in Hong Kong servicing yet another non-standard implementation for an A & E firm.

I just finished troubleshooting a very annoying issue with converting them from Vision 5.1 to Vision 6.1 (SP3).

The first issue was that the setup couldn’t load the reports properly, neither could the service pack.  So… I reloaded the reports from Report Administration… took a few tries to get this right, adjusting roles in the ReportServer management interface as well as making sure the DeltekVision logon had proper access rights to the servers etc.

Then… I was able to load reports, but kept getting the 401 Unauthorized error when trying to preview them… I have worked literally 2 days on this issue.

Here is the error that kept coming up:

———————————-
Username: 
ADMIN


Class: 
Deltek.Framework.Report.Client.BaseReportViewerControl


Function: 
RefreshAfterBuild
FrameworkException: 
The request failed with HTTP status 401: Unauthorized.


Call Stack: 
Deltek.Framework.Report.Client.BaseReportViewerControl.RefreshAfterBuild(returnObj As ReturnObject)
Microsoft.Reporting.WinForms.ReportViewer.set_Messages(value As IReportViewerMessages)
Microsoft.Reporting.WinForms.RSParams.ApplyCustomResources()
Microsoft.Reporting.WinForms.RSParams.EnsureParamsLoaded(forceCredentialsShown As Boolean, parameterInfos As ReportParameterInfoCollection)
Microsoft.Reporting.WinForms.RSParams.GetDataSources(allSatisfied As Boolean&) As ReportDataSourceInfoCollection
Microsoft.Reporting.WinForms.ServerReport.GetDataSources(allCredentialsSet As Boolean&) As ReportDataSourceInfoCollection
Microsoft.Reporting.WinForms.ServerReport.GetExecutionInfo()
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(Report As String, HistoryID As String) As ExecutionInfo
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.IsSecureMethod(methodname As String) As Boolean
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods() As String[]


———————-

The problem?  The problem is that I was running Vision 6.1 on MY LAPTOP… meaning, I was logging into the app from my personal laptop… which is NOT a part of my client’s domain.
I had not set up a reverse proxy for the Vision implementation because all of the access is through a VPN for security reasons… however my laptop is neither accessing through VPN nor on the domain… thus I was getting this error.
Solution?  Try logging on to Vision 6.1 from a machine on the domain and Voila!  Success!
Since it’s Saturday, now I can take the rest of the day off!
(p.s. if you’re interested in having me work on your non standard Vision implementation, please contact me in December of 2010.  I will most likely be in Hong Kong until then)

Comments or questions for Loren?

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s