So Iâ€™m testing my first converted BPM from E9 that updates a database table and I canâ€™t seem to get it working.
Below is my code.
This BPM is updating OrderRel.ReqDate whenever and associated Jobâ€™s Due Date is updated.
This is a Post Processing BPM on JobEntry.Update.
When this runs, the error is:
Description: The underlying provider failed on EnlistTransaction.
Inner Exception: The operation failed because the session is not single threaded.
Any ideas what I have wrong?
foreach (var ttJobHead_iterator in (from ttJobHead_Row in ttJobHead
where ttJobHead_Row.Company == Session.CompanyID
var ttJobHeadRow = ttJobHead_iterator;
foreach (var JobProd_iterator in (from JobProd_Row in Db.JobProd
where string.Compare(JobProd_Row.Company, ttJobHeadRow.Company, true) == 0
&& string.Compare(JobProd_Row.JobNum, ttJobHeadRow.JobNum, true) == 0
JobProd = JobProd_iterator;
if (JobProd.OrderNum > 0)
using (var txscope1 = IceDataContext.CreateDefaultTransactionScope())
OrderRel = (from OrderRel_Row in Db.OrderRel
where string.Compare(OrderRel_Row.Company, JobProd.Company, true) == 0
&& OrderRel_Row.OrderNum == JobProd.OrderNum
&& OrderRel_Row.OrderLine == JobProd.OrderLine
&& OrderRel_Row.OrderRelNum == JobProd.OrderRelNum
if (OrderRel != null)
OrderRel.ReqDate = ttJobHeadRow.ReqDueDate;
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
addr: 37 Shuman Ave | Stoughton | Ma | 02072-3734
Ask us about our clean, green and beautiful matting and flooring
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
[Non-text portions of this message have been removed]