I did a little exercise of checking configuration and tidied up where needed. One item I found was two companies in Management Reporter which were not needed; these were the FW and FWC companies.
When I selected the first of them and hit delete, I received the following message:
I’ve experienced a number of errors in Management Reporter where the one reported on via the application does not match the one behind the scenes so I fired up the Windows Event Viewer to take a look for the error:
In this case, the error on screen was fairly accurate but the Windows Event Viewer narrowed the error down to the ControlTreeDetail table which meant I only needed to check through the trees to see where it was used. But I found it wasn’t used anywhere.
Trying to save a little time, I opted to do an online search to see if anyone else had seen a similar issue before. I found a post by fellow GP blogger Janakiram MP where he had a similar issue.
Using Janakiram’s post, I explored the Management Reporter SQL database before narrowing the issue down to the Specification Sets:
Obvious in hindsight, that if there was no report or tree in the company I was looking at (the live GP company, that there must be one in another company using a different specification set.
I opened the Building Block Groups window () to confirm:
I tried to delete the FRxDemo building block group and found I couldn’t as it was in use. A quick realisation that the FW and FWC companies were using the building block group so I can’t just delete it. Instead I had to go to the Companies window and modify FW and FWC to change the Building block group to Default by clicking the Modify button:
Once done, I returned to the Building Block Groups, selected the FRxDemo specification set and hit Delete.
I was then able to return to the Company window and delete both the FW and FWC companies without receiving an error.