** 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
Is your report path ok. I noticed this when doing some contracting work for other orgs that occasionally the path is different and it's tripped me up
sometimes it's just the file name and others it's Tessitura_custom/...
Thank, Heath. That wasn't it. When I added Tessitura_custom/ I got this error.
I have never see Tessitura_custom/ on any of our reports but I thought I would try. Here is my report setup:
Do you see something I don't see?
Ashley
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.