Hi everyone -
I have a support ticket open for this issue as well, but figured I'd ask you all as well!
I am attempting to do some test rollovers in our TEST environment and am running into issues. First, I updated the rollovers set for this current season to roll into next season (FY20 into FY21) and when I ran the rollover sets, it was showing me the rollovers from last year (FY19 into FY20).
This morning, I created a new rollover set in case that was the issue, but when I attempted to run it I got the following error:
Has this happened to anyone else? I am 99% sure I have all the setup correct (all packages, performances, price types are in the selected rollover MOS and dates are active)
Thanks in advance!
Kari
Kari,
Any chance you can copy/paste the text of the error? Maybe others are different, but I cannot blow it up and read it successfully.
John
Whoops - didn't realize how small it was! Here's what the message is:
Report request cancelled due to a Datawindow Retrieval Error - Error Code: 50000, Error Text: Select Error: SQLSTATE = 42000Microsoft OLE DB Provider for SQL ServerError in TP_ROLLOVERN
Hmmm... That seems to imply that there is an issue running the procedure that runs the rollover report, which means that something is indeed wrong.
The most immediate thing that occurs to me to get a clearer answer would be to run that procedure with the same parameters directly from the database and see the error message given there as it would likely provide more clear details. But then, I spend much of my time in the database, so naturally that is what occurs to me. Is that even a possibility for you?
I probably should have mentioned in my initial post that we are RAMP hosted, so I don't think that is something that I can do.
If you are RAMP hosted then I doubt Emily's suggestion is the issue. As for the database question, that is more of a staff knowledge issue than a RAMP one. We are also on RAMP, and most of my job is inside the database. But if you do not have a staff member who is fluent in SQL, then access to the database would not be prudent.
Other normal thoughts regarding RollOvers:
That was always at least my starting point.
John -
Thanks for all the insight. I am slowly working on building my SQL fluency, but I'm not at a point where I would be able to troubleshoot things like this.
Regarding everything else, for this particular rollover set, it's a one to one package rollover with the source left blank and the mapping table is not used, and I did select a ticketing (uncontrolled) batch.
Not sure what else to check, so I'm hoping I'll get a response to my support ticket soon.
Ya... nevermind! :)