SQL reporting Services report error

(0) Share

Report

Posted on by Bob Callanan

789

Our client recently applied the Year end update and are now running GP 18.3.1200. We've found at least one SQL Server Reporting Services doesn't run (the Historical RM Aged Trial Balance). I've redeployed the reports but the same error persists:

An error has occurred during report processing. (rsProcessingAborted)
- Query execution failed for dataset 'dsPrmCustomerID'. (rsErrorExecutingCommand)
  - Semantic query execution failed. Invalid object name 'dbo.Customers'. (rsSemanticQueryEngineError)

I doesn't look like I can do much with that dataset.

Any suggestions?

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Derek Albaugh Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I have 18.3.1200 and that SSRS report works fine.

I'm interested in the 'Invalid object name 'dbo.Customers' message. Does the 'Customers' view exist in the company database that you're running the report against?

You can use these scripts against the company database to verify:

1. Select * from Customers

2. Select * from sysobjects where name = 'Customers'

'Customers' is a SQL View that should exist in each company database.

Thanks

Was this reply helpful? Yes No
Bob Callanan 789 on at

Like (0)

Report
Copy link

Link copied!

That appears to be the issue. The report was running against a TEST company so I was looking at data. Their database is missing the customers, customer items and customer address views - and I'm guessing several others. I'll move these three over from TEST but any suggestion on recreating any others that might be missing?

Was this reply helpful? Yes No
Bob Callanan 789 on at

Like (0)

Report
Copy link

Link copied!

That was it - the report was running against their TEST company so I was looking at possible data issues. I can tell we're missing multiple VIEWS somehow. Is there an easy way to find/recreate them?

Was this reply helpful? Yes No
Suggested answer

Derek Albaugh Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Easiest way would be to script them into a query window from another company database, then use that script to create them in the company database missing them.

Otherwise, Database Maintenance Utility is used to re-create Views.

Thanks

Was this reply helpful? Yes No