I’m hoping someone has come across this before because it’s got me…
I created a BAQ and while in development I used a variable parameter for the ProjectID, after finishing development I removed the parameter as it wasn’t needed for the dashboard. However, each time you run the BAQ or now dashboard it requests you enter a parameter but doesn’t give you the option to enter a parameter, the box is blank. I have tried removing it from defined parameters but it’s not there, it’s not even listed in the ICE.QueryCtrl db table. Although if I try and add a parameter again via the criteria selection, it shows my original parameter, but I’m still not able to delete it. Even if I try to create a new parameter with the same name, it says it already exists.
Has anyone seen this and resolved it? I’d rather not have to rebuild the BAQ.
Or add the parameter back, save it, test it, and remove it. (Note that just removing the parameter from the criteria won’t do it, you’ll have to actually go to the parameter settings and delete it from there)
Only idea other than what Brian and Jose suggested would be to try and clear your client cache. I’ve had some odd issues with dashboards where if I make a change to the BAQ, it won’t pass down to the dashboard until I wipe the cache. I’ve had to tell my users to do so if they don’t notice a change after completing a change request.
I’ve found that, in addition to deleting clearing client cache (as suggested by Ken), also navigate to the directory on your client PC where the custom dlls are stored (should be something like C:\ProgramData\Epicor<Server>\3.1.500.0<CompanyID>\shared\CustomDLLs) and make sure the dll is deleted since sometimes using the epicor clear client cache doesn’t work.
