A customer could suddenly not open the form Settle Open Transactions (VendOpenTrans) and the system would lock up. I looked at the query for the main datasource and when I rebuilt it in a job I got the same result.
The query with parts commented out will work and return records for the Party ID 5637155687 - VendTransOpen joined with VendTrans joined with VendTable:
qvto = query.addDataSource(tableNum(VendTransOpen));
qvtr = qvto.addDataSource(tableNum(VendTrans));
qvtr.addLink(fieldNum(VendTransOpen, AccountNum), fieldNum(VendTrans, AccountNum));
qvtr.addLink(fieldNum(VendTransOpen, RefRecId), fieldNum(VendTrans, RecId));
qvtr.addRange(fieldNum(VendTrans, Approved)).value(queryValue(1));
//qhw = qvtr.addDataSource(tableNum(HcmWorker));
//qhw.addLink(fieldNum(VendTrans, Approver), fieldNum(HcmWorker, RecId));
//qhw.joinMode(JoinMode::OuterJoin);
//qll = qvtr.addDataSource(tableNum(LogisticsLocation));
//qll.joinMode(JoinMode::OuterJoin);
//qll.addLink(fieldNum(VendTrans, RemittanceLocation), fieldNum(LogisticsLocation, RecId));
qvt1 = qvtr.addDataSource(tableNum(VendTable));
qvt1.addLink(fieldNum(VendTrans, AccountNum), fieldNum(VendTable, AccountNum));
qvt1.addRange(fieldNum(VendTable, Party)).value(queryValue(5637155687));
//qvt = qvto.addDataSource(tableNum(VendTable));
//qvt.addLink(fieldNum(VendTransOpen, AccountNum), fieldNum(VendTable, AccountNum));
//qdim = qvto.addDataSource(tableNum(DimensionAttributeValueCombination));
//qdim.joinMode(JoinMode::OuterJoin);
//qdim.addLink(fieldNum(VendTransOpen, CashDiscountLedgerDimension), fieldNum(DimensionAttributeValueCombination, RecId));
If I add ANY of the other datasources I will get every record with every join added - too much data to handle...
In debug I see VendTransOpen_q query forming as expected and as soon as one of the others are added it only shows "Query object" with no info in debugger. Any ideas on the source of this issue?
