Management Reporter regional option error

(0) Share

Report

Posted on by Community Member

I am suddenly receiving an error on certain companies when running existing reports. The report fails with "The regional option for company 'XXXX' is not valid." and "Bad or missing data was encountered while loading he report and it building blocks. Report generation has been cancelled."

I have rebooted the server, rebuilt the Data Mart and checked everything else I can think of. 3 of 27 companies receive this error on every report, all others function normally.

The only thing that has changed is that I have added 5 new companies to get ready for 2016. I created them on the live company. I have since configured the same companies on a test server and backed them up and restored them on the live server. The companies that receive the error are all long time existing companies tha have not been restored.

Upgraded MR to the latest CU in September.

Any ideas?

*This post is locked for comments

I have the same question (1)

All responses (3)

Answers (1)

Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report
Copy link

Link copied!

For these new companies that you have created, did you enable visibility to management reporter in GP 2015 in the system settings ?

Are you using multi currency?

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (2)

Report
Copy link

Link copied!

This is a known issue with CU13 and lower (3647752). To prevent the issue from occurring, upgrade to CU14:

mbs.microsoft.com/.../MROverview

To correct any bad settings which occurred prior to upgrading to CU14:

1. Run this script against the ManagementReporter SQL database:

select * from ControlCompany

--If you are using CU13, the table name needs to be Reporting.ControlCompany.

2. Note the CultureName field which is 2nd from last. You may see settings such as "chr-Cher-US'. You will need to correct the CultureName to a valid setting:

update ControlCompany set CultureName = ‘en-US’ where Code = 'ABC'

--If you are using CU13, the table name needs to be Reporting.ControlCompany.

3. Restart Report Designer if it was open and try the reports again.

The actual issue (3647752) flips the CultureName when making changes to the settings under Company -> Companies in MR. Upgrading to CU14+ should prevent it from changing again.

Was this reply helpful? Yes No
Syed Wajid Ali 25 on at

Like (0)

Report
Copy link

Link copied!

Thank you Really great time.. Save a lot of time .

Was this reply helpful? Yes No