I am confused by the use of EpiDataView, and the EpiUltraGrid. If I understand correctly EpiDataView is like a dataset in the background that can be used as a datasource for controls like an UltraGrid. Is that right?
What does that bit of code that I commented out at the bottom do?
Is there something obvious that I am missing with the Execute method?
Thanks you so much!!!
Nate
I have reviewed a lot of related threads, and found some simpler code to try. I have tried dozens of iterations and always come back to the same exact error. Here is my idealized, simplified code. It still throws the error. I feel like I am missing something critical.
Message: Exception has been thrown by the target of an invocation.
Inner Exception Message: Object reference not set to an instance of an object.
Program: CommonLanguageRuntimeLibrary
Method: InvokeMethod
Client Stack Trace
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object parameters, Object arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object parameters, CultureInfo culture)
at Ice.Lib.Customization.CustomScriptMethodInvoker.InvokeScriptMethod(MethodInfo scriptMethod, Object parameters)
at Ice.Lib.Customization.CustomScriptMethodInvoker.InvokeInitializeCustomCodeIfExists()
at Ice.Lib.Customization.CustomScriptManager.TryActionShowExceptionBoxOrLogVerificationErrorIfException(Action action, String exceptionBoxTitle)
Inner Exception
Object reference not set to an instance of an object.
at Ice.Adapters.DynamicQueryAdapter.GetQueryExecutionParametersByID(String pcQueryId)
at Script.LoadMyBAQ(String myBAQ, EpiUltraGrid myGrid)
at Script.InitializeCustomCode()
I got the grids to load the data like I want. But I couldn’t get it working with the Execute method. I had to use the ExecuteByID. I am afraid this will come back to bite me once I try to utilize the updateable features of the UBAQs. But this code is so much simpler!
Please let me know if I am getting too far off the main topic here.
I am trying to utilize the custom action in my UBAQ. Building on the successful code I last posted, this button code should:
Look at the checkboxes the user ticked on the UltraGrid. (This is really done in the BPM, but I think I may need to “update” the query after the user checks those boxes so that they are actually checked when the BPM runs, right?)
Run the custom action “ProcessCommands”.
Reload the UltraGrid with the updated query results.
Here is my button code:
private void epiBtnUpdateOur_Click(object sender, System.EventArgs args)
{
// ** Place Event Handling Code Here **
DynamicQueryAdapter dqa = new DynamicQueryAdapter(oTrans);
DataTable results;
DataTable dtresults;
results = new DataTable();
dtresults = new DataTable();
dqa.BOConnect();
dqa.ExecuteByID("x_ThisWeekUpdate_OurUnmatched");
dqa.Update("x_ThisWeekUpdate_OurUnmatched", results.DataSet);
dqa.RunCustomAction("x_ThisWeekUpdate_OurUnmatched", "ProcessCommands", dtresults.DataSet, true);
LoadMyBAQ("x_ThisWeekUpdate_OurUnmatched", epiUltraGridC2);
}
This is the error I am getting when I click the button.
Application Error
Exception caught in: Epicor.ServiceModel
Error Detail
Message: There is no BPM customization attached to Update method of ‘x_ThisWeekUpdate_OurUnmatched’ updatable query in ‘VTAERO’ company or BPM system is not enabled.
Please check presence of BPM customization and/or ask administrator for assistance.
Program: Epicor.ServiceModel.dll
Method: ShouldRethrowNonRetryableException
Client Stack Trace
at Epicor.ServiceModel.Channels.ImplBase1.ShouldRethrowNonRetryableException(Exception ex, DataSet[] dataSets) at Ice.Proxy.BO.DynamicQueryImpl.UpdateByID(String queryID, DataSet queryResultDataset) at Ice.Adapters.DynamicQueryAdapter.<>c__DisplayClass28_0.<Update>b__0(DataSet datasetToSend) at Ice.Adapters.DynamicQueryAdapter.ProcessUbaqMethod(String methodName, DataSet updatedDS, Func2 methodExecutor, Boolean refreshQueryResultsDataset)
at Ice.Adapters.DynamicQueryAdapter.Update(String queryID, DataSet updatedDS)
at Script.epiBtnUpdateOur_Click(Object sender, EventArgs args)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at Infragistics.Win.Misc.UltraButtonBase.OnClick(EventArgs e)
at Ice.Lib.Framework.EpiButton.OnClick(EventArgs e)
at Infragistics.Win.Misc.UltraButton.OnMouseUp(MouseEventArgs e)
at Ice.Lib.Framework.EpiButton.OnMouseUp(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
EDIT: I guess this success was a fluke. After some tweaking I came back and reused this code that once worked. Now I still get the error from above.
There is no BPM customization attached to Update method of ‘x_ThisWeekUpdate_OurUnmatched’ updatable query in ‘VTAERO’ company or BPM system is not enabled.
END EDIT
I got the custom action to work! Sort of… The action runs, and completes as if no checkboxes have been selected. The problem seems to be that the custom actions don’t see the checkboxes I have clicked. I think there is a problem in the Update part of the code.
I know the BPMs work well on their own.
private void epiBtnUpdateOur_Click(object sender, System.EventArgs args)
{
// ** Place Event Handling Code Here **
DynamicQueryAdapter dqa = new DynamicQueryAdapter(oTrans);
DataTable results;
results = new DataTable();
dqa.BOConnect();
dqa.Update("x_ThisWeekUpdate_OurUnmatched", results.DataSet);
dqa.RunCustomAction("x_ThisWeekUpdate_OurUnmatched", "ProcessCommands", results.DataSet, true);
LoadMyBAQ("x_ThisWeekUpdate_OurUnmatched", epiUltraGridC2);
}
I’ll try to look through some of this when I have a minute, but two things are worth mentioning straight away:
One of my team regularly gets that “No BPM attached” error with uBAQs, and I think it’s a bug. You can normally fix it by going to your uBAQ, making it non-updatable and saving, then making it updatable and saving again. The code seems to stay intact through doing that and somehow re-registers it with the main system.
As I said before, we don’t use Custom Actions (we tend to put everything we need into Update), but I think you need to pass in the dataset that contains your changes unless those changes are irrevelevant.
That didn’t work for me unfortunately. Now it seems like all of my custom actions are gone from both UBAQs. I don’t know how that could happen, but there are no custom actions in either BAQ. Now I have to figure out how to rebuild them.
We have this problem (one of my team regularly). Yes, the BPMs disappear when you un-check and save, but they come back when you check that box and save again. It’s often the only we have of getting the system to acknowledge they exist.
I don’t suppose there are any magic tricks to bring them back?
In all of my dozens of backup versions I neglected to get the version that worked. Backup, backup, and then backup again! Whoops!
Not that I know of. I had it pasted into notepad++ so I could see the code as I was in another one since I had 3 different baq’s all with their own custom actions that relied on the previous one. I got lucky I did that because when I was trying to test the BAQ without it being updateable I lost it.
Now I make sure I set up the custom action and call it by that rather than calling in on get rows, since if you do that, you can’t turn it of. lol
I had the BPM on post processing for get list. I wanted everything that came back to be acted on. Problem is, every time you run the BAQ the BPM fires. So if I put it on custom action, I can get my list first then activate the customer action if I want. it makes it so you have to code am extra step but it’s better.
Hi All,
I am still experiencing the BAQ Update error from the start of this post. Epicor tech support gave up on it without any help.
You can reproduce the error yourself with these steps:
Create two uBAQs called test1 and test2. Each query contains only a single calculated bit field set to false. This is a simple query with syntax:
select
(0) as [Calculated_Checkbox1]
The update box should be checked for both BAQs, and the checkboxes should be the updatable fields.
I turned off BPM Update and am using Advanced BPM update only. You do not need to setup custom actions or directives for this example.
Create a dashboard called TestDash.
Insert both uBAQs as grid views.
Set both views to updatable, and prompt for update on the checkboxes.
Save and compile your dashboard.
Open the compiled dashboard.
Refresh all queries. There should be one row in each with a single checkbox.
Click a checkbox in one query.
Then try to click a checkbox (or anywhere at all) in the other query.
Observe error.
I think I need steps to bypass the BAQUpdate action when switching between views, after selecting a row (or rows) to update, but before processing custom actions to utilize the updated rows.
Any help or nudge in the right direction would be greatly appreciated!
Thanks!
Nate
This is a big red flag and as I suspected it is the issue (at least with this example) when you set a UBAQ to advanced BPM you are REQUIRED to have a BPM enabled in the Update method for it to work correctly.
Even if that is not the exact problem in your original issue, the issue is that your UBAQ is throwing an error (of some sort) on update. You need to verify those UBAQs in the BAQ Designer first to figure out what the problem is.
PS: I did create 2 BAQS and followed your setup exactly TEST1 and TEST2 I only updated the one in the gif but the same principle applies.
Yes even if its just a blank code block with a comment on it. IT calls the Update method automatically when you do something so it needs to be there otherwise the BAQ will throw the error.
