Microsoft Dynamics GP (Archived)

Microsoft FRX 6.7 Error

(0) Share

Report

Posted on by Community Member

Hello,

I selected a company as default on Microsoft FRX but after entering the password it gives this error

' This error occured while populating the Frl_entity table in the GLX database'

'FRX Egine failed to create GL index file'

How do i resolve this issue?

Thanks

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (0)

Suggested answer

Ryan Sandness on at

Like (0)

Report

Re: Microsoft FRX 6.7 Error

Hello,

Can you tell me if there is a specific error number associated with this error? there can be an error 91, an Error 9, or a more specific error message.

This error can occur from a damaged .G32 file in the shared SysData directory, an inconsistency in the sy00300 and gl40200 tables, a permission error in Dynamics, or other potential issues.

Do you know if any changes were recently made? Otherwise I would probably run a SQL Profile with Errors turned on and look for what is happening when logging into FRx.

If you can provide the exact error message I can try providing a few other suggestions.

Thanks

Ryan

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Microsoft FRX 6.7 Error

Hello Ryan,

Thanks for your response. their is no error number what i have is

'Subcsript out of range

This error occured while populating the Frl_entity table in the GLX database'

'FRX Egine failed to create GL index file'

Thank you

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Microsoft FRX 6.7 Error

Back up your entire FRX sysdata directory, rename the *.G32 files (to .G32old), relaunch FRx and see if it makes any difference. The first thing that should happen is FRx recreates the GL index.

Ian.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Microsoft FRX 6.7 Error

Hello,

Thanks for your responce.

But i did what you asked me to do yet its not working. Its giving the same error.

What else can i do.

Thank you

Was this reply helpful? Yes No
JMcCoy 185 on at

Like (0)

Report

Re: Microsoft FRX 6.7 Error

Here ya go: support.microsoft.com/.../964797

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Microsoft FRX 6.7 Error

Thanks for your response.

Please the server has enough space as regard the recomendation from support.microsoft.com/.../964797 . Which log should i truncate? I dont really get what i am to do?

Please help me further.

Thank you

Was this reply helpful? Yes No
Suggested answer

Ryan Sandness on at

Like (0)

Report

Re: Microsoft FRX 6.7 Error

If there are no space issues on the server I would recommend contacting support. You may have an inconsistency between some of your gl tables in Dynamics, or some sort of permissions errors on the system. You will likely need assistance in getting a SQL Profile to determine the cause of the error.

Thanks

Ryan

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Re: Microsoft FRX 6.7 Error

I would try running check links on the financial series to see if it fixes any issues with your GL tables. Make sure you have a backup first. If that does not do it try looking at your GL00100 and GL00105 tables. Perhaps there is a blank segment on one of the accounts.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Microsoft FRX 6.7 Error

I would check the period tables as well as chart of account master tables for an invalid record, o r blank record as this might be causing the error you are seeing in your FRx.

Also I will suggest you review the SY01500 table and match agains the actual company databases you have, as you might have more companies on the table thatn the actual DB and this giving you the error.

Let us know

Was this reply helpful? Yes No
Suggested answer

Ann B 15 on at

Like (0)

Report

Re: Microsoft FRX 6.7 Error

I have had this happen about 3 times...always same issue. In all cases the segment master: gl40200, was imported and the header record was imported as well. So: there is a segment ID of '0' that FRx has no idea what to do with.

Determine this is your issue: select * from GL40200 where SGMTNUMB ='0'

Run a delete statement like this: delete GL40200 where SGMTNUMB ='0'

Was this reply helpful? Yes No