Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / FRx SP12
Microsoft Dynamics SL (Archived)

FRx SP12

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I installed FRx service pack 12 on a SL 6.5 system and it has been functional for about a week.  However, today, when the user tries to launch FRx and it asks for the company which they select and they provide credentials, FRx loops back around and asks for the company again with no error message or indication of what the problem is.  When I look at the event log for applications on the workstation it states that the login for Master80 failed.  This is an SL 6.5 installation and, as far as I know, it should be using Master60SP and not Master80.  The first question is: does anyone know what it is trying to use Master80 (which I believe was introduced with version 7.0 of SL when using Windows authentication)?  The second question is: if SP12 requires Master80, is there a script to set that up correctly as what I believe would be a SQL user?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: FRx SP12

    While this was useful information, it did not resolve this issue because that post is about sending FRx output to an XML file while this issue is sending it to an Excel file.  I did, however, do what this post suggested just in case it might have helped, but it did not.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: FRx SP12

    Thanks for your comments..

    I have faced the same error 91 issue in FRx during one of our client SL upgrade process from 6.5 to 2011 FP1. That time i have searched the solution for that issue and finally got the resolution from Microsoft kb support (please refer the below link) and its worked for me.

    support.microsoft.com/.../966275

    Thanks

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: FRx SP12

    Yes, I did figure out that SP12 was not going to work with SL 6.5.  I was very excited to try your suggestion for the error 91 but I am sorry to report that this did not resolve the issue.  As you know, error 91 is sort of a catch-all error so finding the exact cause can be a pain.  I do not have any other clients with this exact combination of pieces so I do not have a working reference point.

    I do not know it helps or not but this client was able to export to Excel until we moved off of FRx SP5.  We had to move off of SP5 because they got new workstations with Windows 7 and could not connect to the ODBC under SP5 with Windows 7.  I have tried several things including uninstalling FRx on the server and the client on the workstations and installing the Base FRx followed by SP5 then SP9 and finally SP11.  Along the way I tried the Export under SP9 and got the error.  I did, before discovering that SP12 would not work with SL 6.5, install SP12 and then used unwise to roll back to SP11.

    I am beginning to think that the uninstall process is not cleaning itself up entirely leaving behind some pieces (files or registry entries) that are causing the issue.  I am pushing the client to move to SL 2011 (for this and many other reasons) but they have to fit SQL 2008 and Server 2008 into their budget first (they have Server 2003 and SQLK 2005).  My clients using SL 2011 and FRx SP12 do not have this issue so I know it can be made to work.

    Thanks for your response and, if you have any other suggestions, I am open to them.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: FRx SP12

    FRx Sp12 is only applicable to the SL version 7.0 and greater.

    Regarding the Error "Runtime error '91': Object variable or With block variable not set", follow the below steps to resolve the issue

    Log into Windows as an administrative user. Browse to the FRx directory in Windows Explorer. Right-click on the FRxXMLTag.XML file, select Properties, and then click the Security tab. Add the group Everyone, select Full Control, then click OK.

    Thanks

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: FRx SP12

    From what research I have been able to do, FRx SP12 is only for SL 7.0 and SL  2011 so I rolled back my client to SP11.  However, the reason for going to the latest service pack was to attempt to fix a problem exporting an FRx report to an Excel file.  With SP9 and SP11 the user was getting a runtime error 91 but that went away with SP12 (when it was working for that first week).  Now that we are back at the SP11 level, the export to Excel is failing again.

    I am aware that SP9 had an issue similar to this and that was fixed with a hotfix but that hot fix is no longer available and, supposedly, was included in SP11.  I also am aware that a runtime error 91 is actually a very general error that can be caused by a multitude of things so it is possible that this client's issue is unrelated to that particular hotfix.

    So, my question becomes one as to what people have found to be some of the causes of this error.  the output file path and file name does not have any spaces.  The report generates fine going to a printer or to the drill down viewer.  It also exports to a CSV file just fine.  I tried changing the Excel page options to a value greater than the total number of pages in the report and that did not resolve the issue.  I tried creating just a simple 2 column 1 row report and direct it to either Excel or Formatted Excel and that failed.  I went to the server and tried all of the above on the server (which does not even have Office installed) and a got the same results.

    Here are the rest of the particulars.  SL 6.5 SP2.  Workstation is a Windows 7 with Office 2010.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans