** self-hosted**
I am rebuilding a report in SSRS that was originally build by my predecessor in Infomaker. I keep getting this error, but only in the client:
cannot read the next data row for the dataset
I am not sure why it is saying that it cannot find the object or that the permissions aren't there because they most certainly are for ImpUsers and the Tessapp.
AND the report works fine with the Infomaker template. This only started after I deployed my new SSRS template.
If I run that sp in SSMS with the same parameters, I do not get an error.
When I run the report inside Visual Studio with the same parameters, I do not get an error.
This is only occurring in the client. Any thoughts?
Ashley Elliott
Database Administrator
St. Louis Symphony Orchestra
314-286-4198
ashleye@slso.org
Hi Ashley,
Just a thought - is this a new stored procedure? Are you on RAMP?
We're on RAMP and I have noticed when I'm being lazy with my code and creating an object in the impresario database and not creating it using dbo.LRP_<whatever>, the object is created with my RAMP username as the owner. This isn't a problem when working in InfoMaker/SSRS but the Tessitura application needs all db objects to have dbo as the owner.
Martin
Thanks for your reply! This is not a new proc - it was created in 2010 by my predecessor - and we are self hosted.
Ashley