You’re offline. This is a read only version of the page.
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:
I doesn't look like I can do much with that dataset.
Any suggestions?
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
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?
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?
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
#1
Martin Dráb
491
Most Valuable Professional
#2
Abhilash Warrier
310
#3
Saalim Ansari
301
Share
Report
All responses (
Answers (
