Error "Object reference not set to an instance of an object" in report after View Query Changed

Hi

I have changed a query with adding a new table and kept all the field name same. This query I have been using in no of reports.

I have taken the following steps to update a report in which this query has been used.

a) Edited the Query in SSRS Report in visual studio

b) Previewed the report

c) Added the report in AOT.

d) In AOT compiled and deployed the report on to the server

e) When I run the report I am getting the error “Object reference not set to an instance of an object” .

Need help to resolve the issue

Thanks

Ravi

You need to restart you AX service in order to solve this.