This is for E10.0
I have a BPM that I’m trying to use to automate Fulfillment Workbench. I’ve run the trace and have the proper methods, but I can’t get past a particular point. I run GetListOfOrders with a orderRelWhereClause set. This returns the one record I want to process. Then I run OrderAllocationGetRows and pass the tableset from GetListOfOrders (and a 0 for the other parameter). I would expect to get a record back, but I do not. Any ideas?
@Jason_Woods are you using the BL Tester to test this? I just did this on 10.2.400 (Demo) using the BL tester with no issues and got 1 record back in results as OrderAlloc dataset.
Interestingly I ran the OrderAllocationGetRows the first time without doing any of your previous steps and got an error, something about not having an input dataset. Now, even after closing I just get a null dataset. Probably operator error no doubt.
I had this running in 10.1.400 but it’s been switched off for a while so I don’t know if anything’s changed in more recent versions. I do know it was finicky and the code in the main BPM had to run async so as not to fall foul of incomplete processes presumably on other threads, but it doesn’t sound like your issue is anything like that.
dsOrderAllocList = orderAlloc.GetList("OrderNum = " + orderNum.ToString(), 100, 1, out morePages, "");
dsOrderAlloc = orderAlloc.OrderAllocationGetRows(dsOrderAllocList, 0);
foreach (var row in dsOrderAlloc.OrderAlloc)
is the relevant snippet that was working for us. It sounds like you’re doing exactly the same?
Close. Here is the exact code:
string OrderRelFilter = "OrderNum = 12345 and OrderLine = 1 and OrderRelNum = 1";
dsOAList = hFWB.GetListOfOrders("","","",OrderRelFilter,"","NoFilter,NoFilter,NoFilter,NoFilter","","","NoFilter","","","", 0, 0, out morePages, "");
//I get one record here
dsOA = hFWB.OrderAllocationGetRows(dsOAList, 0);`
//I get zero records here
Which makes me wonder if there’s a difference between the record that your .GetListOfOrders returns and my .GetList returns that results in different behaviour at our identical next stage. But I must admit my memories of this project are a bit hazy now, apart from it being painful getting the right results through the whole process.
I was trying the BLTester and I can get it to connect yet. I’ll try again later today.
Jason Woods
http://LinkedIn.com/in/jasoncwoods
Wow. I used BLTester and tried your way and mine. It works great there. But the BPM did not. I then changed to use just GetList and Voilà! All better!
1 Like