ShopVision Performance Dashboards - Do they do anything?

I just opened Site Performance, Vendor Performance, and Customer Shipment Performance, and they both appear to be completely blank. They don’t load data, and there doesn’t seem to be an option to load in any data on the form.
Do you use these forms? Do they work? How?

I believe that there is a process that needs to run. They are like executive query that has to build a cube.

But don’t quote me on that, it’s a vague memory.

1 Like

You need to run a process called in side process set maintenance.
image

1 Like

Yep - there are 5 pre-established process sets you need to schedule to get all the ShopVision stuff to work. And even then it’s unlikely that all of it fits with your company’s view of the world. Note - when you schedule the process set, add a description so that you can see it properly in System Monitor screen - otherwise they all just say “process set”.

If you dig down into, you can modify them, I’ve just never bothered and have written my own stuff outside of ERP for Production, but the Supplier performance and Financial stuff is pretty good as long as you have the data.

1 Like

Does running these processes imply a performance impact? We are cloud DT. I don’t see why I wouldn’t just turn these on with my regular Global Scheduling process. Is there a preferred time to run them, and how long might it take?
Thanks everyone!

I would not run during production and not during MRP. Could cause performance issues.

1 Like

I like separate schedules for different type of processes - that allows me to disable a schedule if something is killing my server :slight_smile:

We set up a separate, Saturday night schedule and put all 5 in there. It take about 2 hours for ours to run and finish and it is a load, but depends on your server resources. Technically, I have a second Task Agent running and rule that says they run on that second agent - but we can discuss that another time.

It analytical data, not daily data, so once a week works for us. but you could separate them and run certain ones daily and others weekly…

1 Like

Why do I have so many copies of process sets? I am the only one that even knows what they are! I am certain no one else has been using these processes. Are these automatically created by an upgrade process? Do I need them all?

EDIT: And which process do I choose? The one with VTAERO or the one without any copmany?

Which instance is this? It looks like process sets were created for all of the Demo Epicor Companies (EPIC01 through EPIC06).

You would need to run these 5 process sets for each production company you want data for, so this is not odd for a multi-company environment. But if this is on your PROD instance and your companies are different, then I’d say this is left over from the initial installation (where the installer set all these up) and that you need to delete them all - except for the Vatero-only lines.

But you need to check some things - If you go to the System Agent and drill down to the tasks, you can get Task Parameters form the Action Menu and see how they were initially set up using a few of the columns. This picture shows that I have all 5 running for company 200, on a single Schedule.

1 Like

In my System Agent, none of these processes are scheduled. Except for the new process set I just created. I guess these must be leftover from an original install. Thanks Mike!

I don’t suppose there is a sneaky DMT form for this? I tried Process Set, and System Agent, but didn’t find any DMT forms.

not that I know of

So I created teg process set containing all five processes. I ran it, but almost immeditaly got this error in Event Monitor for all five processes:

Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask:
System.Exception: RunProcedure property must be set before calling ExecuteTask.
   at Ice.Hosting.TaskCaller.InnerExecuteTask(IceDataContext newContext) in C:\_releases\ICE\ICE4.2.100.11\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 70
   at Ice.Hosting.TaskCaller.ExecuteTask() in C:\_releases\ICE\ICE4.2.100.11\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 64
   at Ice.Lib.RunTask.BpmFriendlyTaskLauncher.Run(String sessionIdPrefix, IceContext db, Action taskRunner) in C:\_releases\ICE\ICE4.2.100.0\Source\Server\Services\Lib\RunTask\BpmFriendlyTaskLauncher.cs:line 63
   at Ice.Services.Lib.RunTaskSvc.InnerRunTask(Int64 ipTaskNum, Boolean suppressTransaction) in C:\_releases\ICE\ICE4.2.100.0\Source\Server\Services\Lib\RunTask\RunTask.cs:line 450

Do I have to run something other than the five processes listed:

I did some searching on Epicare this is what i found not sure if this helps or not but i have not seen this error. You will have to login before seeing the kb articale.

Knowledge Page - EpicCare (epicor.com)

2 Likes

That is very helpful! Thanks Devin!

The wording in the kb is a little confusing. I do have lots of processes for EPIC01 and others. The KB says to run the process with your site name in the title. At least for me, this is wrong. I had to choose the process without the site name in the title. The site name is listed in the CompanyID column, but only for the processes without my site name in the ProcessID field. But my processes are running now so maybe I will be able to see something in these dashboards finally!

I finally got these reports to run and found them to be pretty useless. Does anyone use these shop vision dashboards?

From the KB:
“If any field in either column has ANY null values in it (appears blank), the data cube will NOT BE BUILT because date fields cannot have nulls in them.”
If there are null values in the BAQs, how can I fix it? The KB just says you can’t have them, not what to do if you do have them.

@hmwillett I have a thing for raising the dead…
Capture

1 Like

Stop that. Covid was bad enough; we don’t need zombies now!