I have created a dashboard that that have a few BAQ’s that publish and filters. The data showed in the dashboard grid views are displayed correctly as intended. But before deploying, when I Test the application, I get this error:
No errors in the individual BAQ’s as well.
Does anybody know where I can start to resolve this Issue?
Thanks!
I’m not great at this myself but I’ll offer some help. I think, starting in E10, most of the error information is kept on the server for security reasons. You can start by going onto the server where Epicor is (I’m assuming you’re on premises) and opening the Event Viewer. Drill down into App and services logs click the Epicor App Server. You should be able to find the error and a more detailed description of what failed there. HTH.
Do you have any BAQs that have ‘.’ in a name?
Example: “ThisBAQV2.5”
Hi, Sorry I missed this. I was out of the office for a couple of days. No, I don’t have any BAQs with a period in the name. The only special characters I use in naming BAQs are a dash “-” or an underscore “_”.
Were you able to find the error details?
Hi Rick, Thanks for following up.
Haven’t been able to check further yet. I’ll give an update as soon as I come back to this problem.
I got time to Check on this Issue and found out that the Ampersand in a field named ‘A&G’ in one of the BAQ’s is causing some error when the dashboard application is tested before deploying. No issues when Analyzed in BAQ designer but shows this in the Query phrase:
This particular BAQ has two queries:
1)The Inner subquery:
This query Displays all the labor details for all the jobs that are related to a project. Display Fields are:
Project_ProjectID, LaborDtl_JCDept, LaborDtl_LaborHrs.
2) The Main Query (A pivot)
This pivot sums the labor hours for each project By Department.
Only Issue is with the Department named A&G. Any recommendations or fixes I can try?
Hi, I’m sorry for the delay. I’ve been out on a much needed vacation and completely disconnected.
I try not to use special characters in my fields. Have you tried changing the department from ‘A&G’ to ‘A_G’? It’s possible the query is trying to use the ampersand as some kind of calculation. That would be my first fix attempt.
Hi! Yeah I would love a vacation myself! haha… Waiting till December. And Thanks for coming back on this topic!
I would like to do that (Chage the ‘A&G’ JCDept name into A_G ) but then all our previous records under A&G will get seperated from the new A_G department and will cause issue in many other areas.
I want to find a work around.
Right now I have a BAQ someone else created that looks like below.
It filters out any thing that doesn’t have a ProjectID field.
The display fields are the Job number of the labour record and a sum of the labour records.
The end result is showing all the jobs for each project and the sum of labour hours on each JOb.
So the Columns are: ProjectID, JobNum, Department1, Department2… etc
I want to get rid of the Job Number and just sum up all the labour hours by project.
Well as I’m typing this I think it’s not that hard, I’ll give it a try and update here… 
Finally, the Dashboard worked.
We have a JCDept called A&G. The ‘&’ in the name caused an error when testing the application before deploying.
How ever using the Brackets to encapsulate the where clause involving the ‘&’ was the trick.
left outer join (select
[JobHead3AG].[ProjectID] as [JobHead3AG_ProjectID],
(sum(LaborDtl3AG.LaborHrs)) as [Calculated_sumAG]
from Erp.LaborDtl as LaborDtl3AG
left outer join Erp.JobHead as JobHead3AG on
LaborDtl3AG.JobNum = JobHead3AG.JobNum
**where (LaborDtl3AG.JCDept = 'A&G')**
group by [JobHead3AG].[ProjectID]) as ANG on
Project.ProjectID = ANG.JobHead3AG_ProjectID
left outer join (select
[JobHead3AG].[ProjectID] as [JobHead3AG_ProjectID],
(sum(LaborDtl3AG.LaborHrs)) as [Calculated_sumAG]
from Erp.LaborDtl as LaborDtl3AG
left outer join Erp.JobHead as JobHead3AG on
LaborDtl3AG.JobNum = JobHead3AG.JobNum
**where ((LaborDtl3AG.JCDept = 'A&G' ))**
group by [JobHead3AG].[ProjectID]) as ANG on
Project.ProjectID = ANG.JobHead3AG_ProjectID