[BR Files] Missing stored procedure: _ResetQuestByCharName

04/27/2012 21:11 pH33n1x<3#1
Anyone have this stored procedure for Black Rogue DB? o.O
I keep getting this error in GS and it's really annoying (doesn't affect performance, just annoying -_-):

Query Error!!! Query Result : -1, Query : {CALL _ResetQuestByCharName ( 'RainyDays' )}
SQL Error State:42000, Native Error Code: AFC, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure '_ResetQuestByCharName'.
{CALL _ResetQuestByCharName ( 'RainyDays' )}
Query Error!!! Query Result : -1, Query : {CALL _ResetQuestByCharName ( 'RainyDays' )}
{CALL _ResetQuestByCharName ( 'RainyDays' )}
AQ_BrutalQuery:: DB Query Error(-1): {CALL _ResetQuestByCharName ( 'RainyDays' )}
AQ_CharDataSaver:: DB Query Error(100): UPDATE _TIMEDJOB SET TimeToKeep=2704 WHERE ID=2 AND CharID=7299
04/27/2012 21:19 Disco Teka#2
#moved
04/27/2012 21:22 jockeyrullz#3
what you are doing is correct. there is a bug with the sql server stored procedure. apparently

the schemas hasn't changed since 3.5? were you able to go through the same process in ts3.5 without running into this error?

it looks like you have found the way to solve this problem. there are a few other step types that have similar error. specifically the IVI steps.before the bug is fixed, you can use validate to determines whether the statement and column information for the selected schema matches the tables and columns in the database.alternatively, you may look at the file below to find out the correct spelling of the stored procedures.
<TestStand 4.0>\Components\NI\Models\TestStandModels\Database \SQL Server Create Stored Proc Result Tables.sql
Look carefully at writing issues