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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Frx runtime error
Microsoft Dynamics GP (Archived)

Frx runtime error

(0) ShareShare
ReportReport
Posted on by Yury Polo 75

I've created a new company in FRx and receive the following errors when trying to access: 'Error 9 Subcript out of range. The error occurred while populating the frl_entity table in the GLX database' 'FRx engine failed to create GL index file.' Recently I have modified some segments for GLs using tools library. There were some wrong records in GL40200 table (for a segment that was not there anymore after my change and some blank segment reference). I have removed these. My error is still her. Any suggestions will be greatly appreciated.

Thank you.

Yury

*This post is locked for comments

I have the same question (0)
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    Step 1) Backup your company database

    Step 2) In SSMS run this script   DELETE GL00105

    DELETE GL40200 against this database

    Step 3) Run check links for Tools-> Maintenance -> Check Links -> Financial -> Account Master

    Step 4) Try FRx again

  • Yury Polo Profile Picture
    Yury Polo 75 on at

    Rich.  Thank you for the quick answer.  I will have to try it on Monday when back to work (no remote access to Great Plains or FRx).  I will post here if it worked.

    Also, I forgot to mention the version - we are on Great Plains 2013 R2 and FRx 6.7 service pack 12.  Would this approach work with this versions?

    Thank you again for your answers.

    Yury

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    Even though FRx is not officially supported on GP 2013 these scripts will work. Good luck and let us know how it goes.

  • EDJJR Profile Picture
    EDJJR on at

    Hello Yury,

    When you download an FRx Service Pack, there should be a SQL script (SBI).

    Run the SBI script and then try to log into the Company.

    Thank you,

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans