Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

FRx Error - Please Help

Posted on by

I've installed FRx on the server, along with SP10 and was able to configure the production company and Set as Default with no problems.  Now I suddenly can't get in and I'm getting the following two errors when I try to set the company as default:

First Error

Error 91  Object variable or With Block variable not set

(This error occurred while populating the frl_entity table in the GLX database)

 

After clicking OK on that error I get the following message:

Second Error

FRx Professional  FRx Engine Failed to create GL Index file

 

This is an new installation.

Any ideas?  I've looked in the knowledgebase and Binged this, as well, to no avail.

Kind regards,

Todd M Bowlsby

*This post is locked for comments

  • Todd M Bowlsby Profile Picture
    Todd M Bowlsby 1,675 on at
    Re: Re: FRx Error - Please Help

    Alicia:

    I'm happy to hear that.  You are most welcome.

    Warm regards,

    Todd M Bowlsby

    InterDyn - Remington Consulting

    971-207-6161

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: FRx Error - Please Help

    Todd,

    Thanks for the suggestion.

    Your suggestion fixed our error.

    Alicia

  • Bullsai Profile Picture
    Bullsai on at
    Re: Re: FRx Error - Please Help

    Kay:

    Thanks for the responses; I appreciate it.

    I finally figured this issue out last night (this morning) at 3:00 AM PST!  It turns out the GL40200 table holds the COA Segment values.  There was an invalid segment value in that table.  I had to delete that value and all is well!

    Take care,

    Todd M Bowlsby

  • K Day Profile Picture
    K Day 7,365 on at
    Re: FRx Error - Please Help

    the frl_entity table is in the G32 file (which is basically an access database)

    It contains columns like account length, account mask, max segments

    Try renaming that file as ***.G32.old, so you don't delete it, and try to let it rebuild one for you when you log on.

     So the second message is caused by the first one.

  • K Day Profile Picture
    K Day 7,365 on at
    Re: Re: Re: FRx Error - Please Help

    What version are you on?  Have you upgraded to SP 10 yet?  (Sorry, didn't read closely, you are on SP 10)

      If not, I reccomend doing so.  Every time I see "Error 91" that is the first thing I think of.

    What is your configuration like?  Shared sysdata?  Clients installed pointing to the shared sysdata?  Citrix of Terminal Server? Does the user have access to the I/O

    The failure to build the G/L Index means that it coudl not update the *.G32 File (in the sysdaya directory), which holds a list of what your GL accounts look like.  It basically looks for differences when you add a new GL account, compares one of the GL tables in SQl to the .G32 file.

    You can delete these G32 files and then next time you log into a company, it will build a new one.

  • Bullsai Profile Picture
    Bullsai on at
    Re: Re: FRx Error - Please Help

    Rotash:

    Just tried that per your suggestion and it did not make a difference.  Thanks for the suggestion, though.

    Todd M Bowlsby

  • Re: FRx Error - Please Help

    Have you run the SBI Script (which comes with SP)?

    Rohtash Kapoor
    http://www.MicrosoftDynamicsForums.com

     

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans