November 19, 2009 at 7:03 am
Please email me at support@LegalSports.com if you would like to be hired to fix our problem.
I have a USA telephone.
Thanks 🙂
An example below: (from the CookieMonster.log file)
00:00:00 [20] ERROR - invalid index source=/ScoreEater/ currentRow=/7/ currentCol=/1/
Index was outside the bounds of the array.: at CookieMonster.Eaters.ScoreEater.ParseTable(String table, Int32 totalSubHeaders, Int32 totalItems, String date)
00:00:00 [20] ERROR - invalid index source=/ScoreEater/ currentRow=/7/ currentCol=/2/
Index was outside the bounds of the array.: at CookieMonster.Eaters.ScoreEater.ParseTable(String table, Int32 totalSubHeaders, Int32 totalItems, String date)
00:00:00 [20] ERROR - invalid index source=/ScoreEater/ currentRow=/7/ currentCol=/3/
Index was outside the bounds of the array.: at CookieMonster.Eaters.ScoreEater.ParseTable(String table, Int32 totalSubHeaders, Int32 totalItems, String date)
00:00:00 [20] DEBUG - score saved rotationId=/0/ date=/20091118/ score=/9301/ status=// period=/FirstPeriod/
00:00:00 [20] ERROR - error updating score
Error converting data type varchar to numeric.: at CookieMonster.Data.DBConnection.RunProcedure(SqlCommand command)
at CookieMonster.Data.Game.UpdateScore(Int32 rotationId, String date, String score, String status, ScorePeriods period)
00:00:00 [20] ERROR - error updating score source=/ScoreEater/
error updating score: at CookieMonster.Data.Game.UpdateScore(Int32 rotationId, String date, String score, String status, ScorePeriods period)
at CookieMonster.Eaters.ScoreEater.SaveScoreByPeriod(Game dbGame, Int32 rotationId, String date, String score, String status, ScorePeriods period)
00:00:00 [20] DEBUG - score saved rotationId=/0/ date=/20091118/ score=/9302/ status=// period=/FirstPeriod/
00:00:00 [20] ERROR - error updating score
Error converting data type varchar to numeric.: at CookieMonster.Data.DBConnection.RunProcedure(SqlCommand command)
at CookieMonster.Data.Game.UpdateScore(Int32 rotationId, String date, String score, String status, ScorePeriods period)
00:00:00 [20] ERROR - error updating score source=/ScoreEater/
error updating score: at CookieMonster.Data.Game.UpdateScore(Int32 rotationId, String date, String score, String status, ScorePeriods period)
at CookieMonster.Eaters.ScoreEater.SaveScoreByPeriod(Game dbGame, Int32 rotationId, String date, String score, String status, ScorePeriods period)
00:00:00 [20] ERROR - error updating score
Error converting data type varchar to numeric.: at CookieMonster.Data.DBConnection.RunProcedure(SqlCommand command)
at CookieMonster.Data.Game.UpdateScore(Int32 rotationId, String date, String score, String status, ScorePeriods period)
00:00:00 [20] ERROR - error updating score source=/ScoreEater/
error updating score: at CookieMonster.Data.Game.UpdateScore(Int32 rotationId, String date, String score, String status, ScorePeriods period)
November 19, 2009 at 11:51 am
Where did you find this error. Try to paste SQL server error log error
November 19, 2009 at 11:58 am
Thanks for the reply 🙂
What I pasted above is from the error log.
the error is in the from the CookieMonster.log file
The CookieMonster.log is the program that gathers and distributes the info to the end user.
It is gathering the info properly. Problem is the info is not being seen on the user interface.
We would like to hire someone to fix the problem.
Send me an email to support@legalsports.com and will send you my toll free phone number etc.
Thanks
November 19, 2009 at 12:27 pm
Did this error just start happening or have you been getting a while? When it started had there been ANY changes in the database, app, OS, network, etc? Is it happening for all users or just specific users?
Is the code querying the database directly or is it running store procedure to return the data?
November 19, 2009 at 12:53 pm
Hi Lynn,
We ran a query to delete some old data. This is when the problem started.
Anything that was imported into the program prior to the query worked fine for as long as the imported items were current. Anything imported after the query failed to show the results to the user.
I can see that the program is sorting the data correctly. The data just cannot be seen by the user.
Note: The problem only exists in 3 of about 100 tables.
Thanks
November 19, 2009 at 1:19 pm
Do you have a backup of the database prior to when the data was deleted?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply