How to solve this Error "Error executing code: QueryBuildDataSource object not initialized"

Finance and Operations/AX Developer Forum
1

Hi Guys,

I got this error :

Error executing code: QueryBuildDataSource object not initialized.

Stack trace

(S)\Classes\QueryBuildDataSource\addRange
(S)\Classes\GR_ReportDP\processReport - line 14
(S)\Classes\SrsReportProviderQueryBuilder\initialize - line 59
(S)\Jobs\

This is my code,

public void processReport()
{

contract = this.parmDataContract() as GR_ReportContract;

fromDate = contract.parmFromDate();
toDate = contract.parmToDate();

q = this.parmQuery();

if(fromDate && toDate){
q.dataSourceTable(tableNum(VendPackingSlipTrans)).addRange(fieldNum(VendPackingSlipTrans, PurchaseLineExpectedDeliveryDate)).value(SysQuery::range(fromDate, toDate));
}

qr = new QueryRun(q);
while(qr.next())
{
vendPackingSlipTrans = qr.get(tableNum(VendPackingSlipTrans));

tmp.clear();

tmp.CostLedgerVoucher = vendPackingSlipTrans.CostLedgerVoucher;
tmp.GRDate = vendPackingSlipTrans.DeliveryDate;
tmp.DeliveryDate = vendPackingSlipTrans.PurchaseLineExpectedDeliveryDate;
tmp.AccountingDate = vendPackingSlipTrans.AccountingDate;
tmp.ItemId = vendPackingSlipTrans.ItemId;
tmp.PurchId = vendPackingSlipTrans.OrigPurchid;
tmp.PurchName = vendPackingSlipTrans.Name;
tmp.QtyOrdered = vendPackingSlipTrans.PdsCWOrdered;
tmp.PackingSlipId = vendPackingSlipTrans.PackingSlipId;
tmp.ValueMST = vendPackingSlipTrans.ValueMST;

tmp.insert();
}

}

Please help me to solve these issues.

Regards,

2

What does this returns?

3

return DynamicQuery

this’s code of parmQuery

public Query parmQuery(Query _dynamicQuery = dynamicQuery)

{

queryName queryName;

dynamicQuery = _dynamicQuery;

if(!dynamicQuery)

{

// if queryName exists.

queryName = this.parmMetadata().getQueryName();

if(queryName)

{

dynamicQuery = new Query(queryName);

}

}

return dynamicQuery;

}

4

I mean what does the query (q) return? Does it has VendPackingSlipTrans data source in it?
q.dataSourceTable(tableNum(VendPackingSlipTrans)).

5

Did you assign Query in your DP class ?

Like : SRSReportParameterAttribute(classstr(QueryName))]

or

you can also check table (VendPackingSlipTrans) exists in query.

Thanks

6

Thanks,
I trying drop datasource in query and add new datasource.