We receive this error in FRx when we try to run the 'Build Local GL Index' utility on the Forecaster company within FRx. The reason we are trying to run this utility is because we are noticing discrepancies in our Reporting Tree that pulls in the budget data from Forecaster.
It will be helpful to know that we recently migrated our Great Plains system to new hardware (database and application servers). So originally we thought it was was a simple ODBC disconnect, but we verified the ODBC connection back to the server that Forecaster is still running on tests successfully. So when we go into Company > Information in the FRx application, everything saves correctly for the Forecaster company. We only get this error when we try to rebuild the GL indexes.
Our Forecaster environment has not been touched, so the DirectLink settings are still the same as before when they were working fine. We are on the latest FRx service pack as well.
Can FRx even point to a separate server to retrieve the Forecaster database or does it need to be local with the Great Plains databases as well?
*This post is locked for comments
I have the same question (0)
