# Menu Security Report **URL:** \ **Category:** Epicor ERP 10\ **Tags:** e10\ **Created:** [March 27, 2019, 1:11pm UTC](https://www.epiusers.help/t/menu-security-report/54004 "2019-03-27T13:11:55Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Kimberley](https://www.epiusers.help/user_avatar/www.epiusers.help/kimberley/32/50847_2.png) [@Kimberley](https://www.epiusers.help/u/Kimberley)\ **Post date:** [March 27, 2019, 1:11pm UTC](https://www.epiusers.help/t/menu-security-report/54004/1 "2019-03-27T13:11:55Z")
> **[Menu Security Report](https://www.epiusers.help/t/menu-security-report/52282)** > > Has anyone on 10.2.300.8 have any issues running the Menu Security Report? Have to run it for audits and it keeps timing out. I increased the Report time out settings for SSRS but still no luck. Here is he error I get… Program... I had previously posted this about not being able to run the Menu Security Report. I have opened a ticket with Epicor but they had me run the Performance Diagnostic Tool. Not sure why but they found a few errors/warning and not that all I felt were related I did the fixes they suggested and the report will still NOT RUN…it times out. I have another server for development and the report runs fine on that server. I also ran PDT and had all the same errors/warnings as my production. I don’t think that has anything to do with the report not running. I even had someone i know who had Epicor installed local on there PC to test it and failed for them too. Any thoughts, Suggestions on why this report will not run and how to get support to listen. ---
**Author:** ![Kimberley](https://www.epiusers.help/user_avatar/www.epiusers.help/kimberley/32/50847_2.png) [@Kimberley](https://www.epiusers.help/u/Kimberley)\ **Post date:** [March 27, 2019, 1:39pm UTC](https://www.epiusers.help/t/menu-security-report/54004/2 "2019-03-27T13:39:58Z")
I just had someone I know at another company test this report and they got the same error. ---
**Author:** ![utaylor](https://www.epiusers.help/user_avatar/www.epiusers.help/utaylor/32/64664_2.png) [@utaylor](https://www.epiusers.help/u/utaylor)\ **Post date:** [March 27, 2019, 4:23pm UTC](https://www.epiusers.help/t/menu-security-report/54004/3 "2019-03-27T16:23:41Z")
I have never had success running this report. ---
**Author:** ![Mark\_Wonsil](https://www.epiusers.help/user_avatar/www.epiusers.help/mark_wonsil/32/51594_2.png) [@Mark\_Wonsil](https://www.epiusers.help/u/Mark_Wonsil)\ **Post date:** [March 27, 2019, 4:32pm UTC](https://www.epiusers.help/t/menu-security-report/54004/4 "2019-03-27T16:32:49Z")
Same. ---
**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\ **Post date:** [March 27, 2019, 4:48pm UTC](https://www.epiusers.help/t/menu-security-report/54004/5 "2019-03-27T16:48:56Z")
> [@utaylor](#): > > I have never had success running this report. Support: “Functions as expected. Closing case…” 😉 ---
**Author:** ![utaylor](https://www.epiusers.help/user_avatar/www.epiusers.help/utaylor/32/64664_2.png) [@utaylor](https://www.epiusers.help/u/utaylor)\ **Post date:** [March 27, 2019, 4:51pm UTC](https://www.epiusers.help/t/menu-security-report/54004/6 "2019-03-27T16:51:53Z")
Did you actually get that response? I never took the time to create a case. ---
**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\ **Post date:** [March 27, 2019, 4:53pm UTC](https://www.epiusers.help/t/menu-security-report/54004/7 "2019-03-27T16:53:51Z")
No. I was being facetious. But since it appears that all users have that issue, it must be a “feature”. But I am surprised that if the bug is so persistent, that Support isn’t aware of it. ---
**Author:** ![utaylor](https://www.epiusers.help/user_avatar/www.epiusers.help/utaylor/32/64664_2.png) [@utaylor](https://www.epiusers.help/u/utaylor)\ **Post date:** [March 27, 2019, 4:58pm UTC](https://www.epiusers.help/t/menu-security-report/54004/8 "2019-03-27T16:58:56Z")
I would bet there is a problem case that has been open for a while. ---
**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\ **Post date:** [March 27, 2019, 5:01pm UTC](https://www.epiusers.help/t/menu-security-report/54004/9 "2019-03-27T17:01:54Z")
If so, that sucks that they’d give @Kimberley the run-around, doing things that aren’t the actual solution. ---
**Author:** ![Hogardy](https://www.epiusers.help/user_avatar/www.epiusers.help/hogardy/32/18785_2.png) [@Hogardy](https://www.epiusers.help/u/Hogardy)\ **Post date:** [March 27, 2019, 5:07pm UTC](https://www.epiusers.help/t/menu-security-report/54004/10 "2019-03-27T17:07:11Z")
This report runs well on our upgrade “test” production env. (10.2.300.11) Going live this week end, will make sure to test this afterwards…and post the result. Pierre ---
**Author:** ![jgehling](https://www.epiusers.help/user_avatar/www.epiusers.help/jgehling/32/78990_2.png) [@jgehling](https://www.epiusers.help/u/jgehling)\ **Post date:** [March 27, 2019, 5:18pm UTC](https://www.epiusers.help/t/menu-security-report/54004/11 "2019-03-27T17:18:10Z")
This report never worked for us. I suggest making a BAQ and exporting to excel as your report. ---
**Author:** ![bordway](https://www.epiusers.help/user_avatar/www.epiusers.help/bordway/32/30753_2.png) [@bordway](https://www.epiusers.help/u/bordway)\ **Post date:** [March 27, 2019, 5:49pm UTC](https://www.epiusers.help/t/menu-security-report/54004/12 "2019-03-27T17:49:31Z")
Have you tried specifying filters? I have a different version, but it also fails when I run it “wide open” no filters. After adding a filter, one run was successful at least. I have run into this issue with other reports, in several versions of Epicor. Kind of a pain when this comes up… but I can usually break a problem print job up into several runs/filter options. FYI… the error when running “wide open”… hmmmm? > > Microsoft SQL Server Reporting Services 10.50.1600.1 > > Program Ice.Services.Lib.RunTask raised an unexpected exception with > > the following message: RunTask: Client found response content type > > of ‘text/html; charset=utf-8’, but expected ‘text/xml’. ---
**Author:** ![Kimberley](https://www.epiusers.help/user_avatar/www.epiusers.help/kimberley/32/50847_2.png) [@Kimberley](https://www.epiusers.help/u/Kimberley)\ **Post date:** [March 29, 2019, 12:17pm UTC](https://www.epiusers.help/t/menu-security-report/54004/13 "2019-03-29T12:17:43Z")
Yes I have only selected Active employees which is under 200 so it should run fine. I can run it if I select 1 user. It ran fine for us in E9 but not in E10 ---
**Author:** ![Kimberley](https://www.epiusers.help/user_avatar/www.epiusers.help/kimberley/32/50847_2.png) [@Kimberley](https://www.epiusers.help/u/Kimberley)\ **Post date:** [March 29, 2019, 12:21pm UTC](https://www.epiusers.help/t/menu-security-report/54004/14 "2019-03-29T12:21:26Z")
I thought about making a BAQ but always thought getting all the right tables and joins were a nightmare. ---
**Author:** ![bordway](https://www.epiusers.help/user_avatar/www.epiusers.help/bordway/32/30753_2.png) [@bordway](https://www.epiusers.help/u/bordway)\ **Post date:** [March 29, 2019, 3:12pm UTC](https://www.epiusers.help/t/menu-security-report/54004/15 "2019-03-29T15:12:55Z")
> [@Kimberley](#): > > BAQ but always thought getting all the right tables Yes, I’ve never liked the report so ended up building a few BAQs. Wonder if you have access to EpicCare? There is a knowledgebase article “BAQ Example of CTE using Menu Hierarchy”. [https://epicorcs.service-now.com/epiccare?id=epiccare\_kb\_article&sys\_id=a4713280db2b6a04b3227e09af96199a](https://epicorcs.service-now.com/epiccare?id=epiccare_kb_article&sys_id=a4713280db2b6a04b3227e09af96199a) May be a foundation for adding the security components you need? Note there are some allow/disallow fields which are tilde separated values, these can be a pain to break out. ---
**Author:** ![Kimberley](https://www.epiusers.help/user_avatar/www.epiusers.help/kimberley/32/50847_2.png) [@Kimberley](https://www.epiusers.help/u/Kimberley)\ **Post date:** [April 4, 2019, 1:01pm UTC](https://www.epiusers.help/t/menu-security-report/54004/16 "2019-04-04T13:01:34Z")
I pulled that KB but when I try to recreate what they have in there instructions I get an error. Has anyone successfully used this KB? ---
**Author:** ![tsmith](https://www.epiusers.help/user_avatar/www.epiusers.help/tsmith/32/64774_2.png) [@tsmith](https://www.epiusers.help/u/tsmith)\ **Post date:** [April 4, 2019, 1:06pm UTC](https://www.epiusers.help/t/menu-security-report/54004/17 "2019-04-04T13:06:11Z")
Attached is a BAQ I used for our security audit during our last upgrade. It gives the full menu structure and the assigned security for each menu item. [PSG-tmsIndentedMenu.baq](https://epiusers.help/uploads/default/original/2X/f/f913cc28f25677327f0b3c3fafdf0bf08233eb69.baq) (39.0 KB) ---
**Author:** ![Kimberley](https://www.epiusers.help/user_avatar/www.epiusers.help/kimberley/32/50847_2.png) [@Kimberley](https://www.epiusers.help/u/Kimberley)\ **Post date:** [April 4, 2019, 4:29pm UTC](https://www.epiusers.help/t/menu-security-report/54004/18 "2019-04-04T16:29:36Z")
Thanks this is exactly what I was working on. I don’t understand why i was getting an error. I was trying to change the SubQuery Options and i get this…maybe something is out of sequence. ![image](https://epiusers.help/uploads/default/original/2X/4/49f785509e693c83ad94fcbdd56fb788681ce049.png) ---
**Author:** ![tsmith](https://www.epiusers.help/user_avatar/www.epiusers.help/tsmith/32/64774_2.png) [@tsmith](https://www.epiusers.help/u/tsmith)\ **Post date:** [April 4, 2019, 4:32pm UTC](https://www.epiusers.help/t/menu-security-report/54004/19 "2019-04-04T16:32:05Z")
There should be four subqueries total in the BAQ: ![image](https://epiusers.help/uploads/default/original/2X/0/002cff1b91e9eece3e48f38ab77d96557aadb8a6.png) ---
**Author:** ![Kimberley](https://www.epiusers.help/user_avatar/www.epiusers.help/kimberley/32/50847_2.png) [@Kimberley](https://www.epiusers.help/u/Kimberley)\ **Post date:** [April 4, 2019, 4:32pm UTC](https://www.epiusers.help/t/menu-security-report/54004/20 "2019-04-04T16:32:55Z")
That is what I was just wondering. The instructions from Epicor don’t say you have to have the sub queries first but makes sense… Thanks for your help. [Next page](https://www.epiusers.help/t/menu-security-report/54004.md?page=2)