Hi all,
After running the v11.0_new.sql script, I seem to be getting errors in relation to the view LV_TKT_HIST_REPORT. The errors are all of this nature (below) and come up both when I run a procedure that relies on this view (like AP_PERFORMANCE_REPORT) or when I just try and select * from the view.
Msg 207, Level 16, State 1, Procedure LV_TKT_HIST_REPORT, Line 3 Invalid column name 'time_slot'.
After trying to refresh the view I get several further errors....one of which relates to the system procedure called ‘sp_refreshsqlmodule_internal’ which doesn’t actually seem to exist (cannot locate this procedure ANYWHERE)!! There is one called ‘sp_refreshsqlmodule'.....
I wondered if anyone else has had this problem or whether this is ticket worthy. I should mention we are running on SQL server 2012.
Thanks for any help and advice in advance, totally stumped!
Tash
Unknown said: I should mention we are running on SQL server 2012.
I should mention we are running on SQL server 2012.
Sounds support-ticket-worthy based on this alone.
Thanks Chris. I have since realized what the problem is....we have customized that view to read from a different table so I will work on fixing it instead of posting a ticket.