Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / FRX 6.7 AA report issu...
Microsoft Dynamics GP (Archived)

FRX 6.7 AA report issue after moving the sysdata folder from Windows 2003 32bit SQL 2000 to Windows 2008 64bit SQL 2008 R2

(0) ShareShare
ReportReport
Posted on by Uma Loganathan 425

Hi,

I have moved the GP10 SP3 from Windows 2003 32bit SQL 2000 to Windows 2008 64bit SQL 2008 R2.  And FRx6.7 SP12 was installed in OS 2003.

I have installed FRx6.7 SP12 in OS 2008 R2. Since Frx AA wizard will not support 64bit OS, I am not able to run the AA wizard in OS 2008 server.

I tried one workaround. I have created ODBC for OS 2008 (SQL Server 2008 R2) in old server 2003 and mapped the ODBC in FRx. And tried to run the FRx. I can able to run the reports except AA. But the AA reports are not working. It was giving an error message :

"FRx32.OFSIMain.CheckOFSIConnection8900: A DirectLink error has occurred attempting to connect to the DB for this company."

Could you please help me how to run the AA reports in new server 2008 ?

Thanks & Regards,

Uma.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    RE: FRX 6.7 AA report issue after moving the sysdata folder from Windows 2003 32bit SQL 2000 to Windows 2008 64bit SQL 2008 R2

    Hi Uma,

    How did you fix the issue?

    by assigning the GP users(having access to Trx dimensions & Codes) to DYNGRP or Any other alternatives?

  • Uma Loganathan Profile Picture
    Uma Loganathan 425 on at
    RE: FRX 6.7 AA report issue after moving the sysdata folder from Windows 2003 32bit SQL 2000 to Windows 2008 64bit SQL 2008 R2

    Hi Nataraj,

    I have fixed the issue. There were no data in Frl tables after I moved the DB from SQL 2000 to SQL 2008.. I have inserted the values into Frl tables, then I can able to run AA reports.

    Regards,

    Uma Loganath.

  • Uma Loganathan Profile Picture
    Uma Loganathan 425 on at
    RE: FRX 6.7 AA report issue after moving the sysdata folder from Windows 2003 32bit SQL 2000 to Windows 2008 64bit SQL 2008 R2

    Hi Nataraj,

    Thanks for your reply. I am using "SA" login to run the Frx reports.

    I can able to generate other reports except AA reports.

    what is the meaning of "The Analytical Accounting user's SQL Server profile must be part of the DYNGRP SQL Server group ".

    Please help me.

    Thanks,

    Uma.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: FRX 6.7 AA report issue after moving the sysdata folder from Windows 2003 32bit SQL 2000 to Windows 2008 64bit SQL 2008 R2

    Hi Uma,

    Please have a look on the below KB Article(s)

    support.microsoft.com/.../963944

    support.microsoft.com/.../en-us;spid=9186

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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans