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

**URL:** <https://www.dynamicsuser.net/t/how-to-solve-this-error-error-executing-code-querybuilddatasource-object-not-initialized/63287>\
**Category:** Developer Forum\
**Created:** [April 28, 2017, 9:56am UTC](https://www.dynamicsuser.net/t/how-to-solve-this-error-error-executing-code-querybuilddatasource-object-not-initialized/63287 "2017-04-28T09:56:45Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pranyoto](https://avatars.discourse-cdn.com/v4/letter/p/e274bd/32.png) [@Pranyoto](https://www.dynamicsuser.net/u/Pranyoto)\
**Post date:** [April 28, 2017, 9:56am UTC](https://www.dynamicsuser.net/t/how-to-solve-this-error-error-executing-code-querybuilddatasource-object-not-initialized/63287/1 "2017-04-28T09:56:45Z")

</div>

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,

---

<div class="post-metadata">

**Author:** ![kranthi](https://avatars.discourse-cdn.com/v4/letter/k/e480ec/32.png) [@kranthi](https://www.dynamicsuser.net/u/kranthi)\
**Post date:** [April 28, 2017, 10:19am UTC](https://www.dynamicsuser.net/t/how-to-solve-this-error-error-executing-code-querybuilddatasource-object-not-initialized/63287/2 "2017-04-28T10:19:25Z")

</div>

> [@](#):
>
> q = this.parmQuery();

What does this returns?

---

<div class="post-metadata">

**Author:** ![Pranyoto](https://avatars.discourse-cdn.com/v4/letter/p/e274bd/32.png) [@Pranyoto](https://www.dynamicsuser.net/u/Pranyoto)\
**Post date:** [April 28, 2017, 11:14am UTC](https://www.dynamicsuser.net/t/how-to-solve-this-error-error-executing-code-querybuilddatasource-object-not-initialized/63287/3 "2017-04-28T11:14:53Z")

</div>

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;

}

---

<div class="post-metadata">

**Author:** ![kranthi](https://avatars.discourse-cdn.com/v4/letter/k/e480ec/32.png) [@kranthi](https://www.dynamicsuser.net/u/kranthi)\
**Post date:** [April 28, 2017, 11:22am UTC](https://www.dynamicsuser.net/t/how-to-solve-this-error-error-executing-code-querybuilddatasource-object-not-initialized/63287/4 "2017-04-28T11:22:37Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![ajaygreatknit](https://avatars.discourse-cdn.com/v4/letter/a/e8c25b/32.png) [@ajaygreatknit](https://www.dynamicsuser.net/u/ajaygreatknit)\
**Post date:** [April 28, 2017, 11:51am UTC](https://www.dynamicsuser.net/t/how-to-solve-this-error-error-executing-code-querybuilddatasource-object-not-initialized/63287/5 "2017-04-28T11:51:05Z")

</div>

Did you assign Query in your DP class ?

Like : SRSReportParameterAttribute(classstr(QueryName))]

or

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

Thanks

---

<div class="post-metadata">

**Author:** ![Pranyoto](https://avatars.discourse-cdn.com/v4/letter/p/e274bd/32.png) [@Pranyoto](https://www.dynamicsuser.net/u/Pranyoto)\
**Post date:** [May 2, 2017, 5:31am UTC](https://www.dynamicsuser.net/t/how-to-solve-this-error-error-executing-code-querybuilddatasource-object-not-initialized/63287/6 "2017-05-02T05:31:35Z")

</div>

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