System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'StatusId'.
Invalid column name 'ErrorLog'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Etoz.ConnectData.DataAccess.ExecuteQuery(String query) in c:\inetpub\wwwroot\cricdirect.com\api\v6\App_Code\db\data_access.cs:line 117
ClientConnectionId:eb2c06a1-07fc-482c-b674-f08eb4d24292
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 53712 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (53712,6,'{"status":"ok","response":{"player":{"pid":53712,"title":"Roston Chase","short_name":"RL Chase","first_name":"Roston Chase","last_name":"","middle_name":"","birthdate":"1992-03-22","birthplace":"Barbados","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/rostonlamarchase\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/younggross22\/","debut_data":"","thumb_url":"","nationality":"West Indies"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":49,"innings":90,"notout":4,"runs":2265,"balls":4862,"highest":137,"run100":5,"run50":11,"run4":243,"run6":17,"average":"26.33","strike":"46.58","catches":23,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":60,"innings":45,"notout":8,"runs":953,"balls":1253,"highest":94,"run100":0,"run50":5,"run4":72,"run6":6,"average":"25.75","strike":"76.05","catches":28,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":34,"innings":26,"notout":7,"runs":440,"balls":377,"highest":67,"run100":0,"run50":2,"run4":36,"run6":13,"average":"23.15","strike":"116.71","catches":12,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":112,"innings":94,"notout":22,"runs":1907,"balls":1542,"highest":85,"run100":0,"run50":11,"run4":163,"run6":65,"average":"26.48","strike":"123.67","catches":38,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":111,"innings":92,"notout":13,"runs":2591,"balls":3080,"highest":136,"run100":2,"run50":16,"run4":204,"run6":44,"average":"32.79","strike":"84.12","catches":53,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":104,"innings":175,"notout":19,"runs":5367,"balls":0,"highest":137,"run100":11,"run50":29,"run4":0,"run6":0,"average":"34.40","strike":"","catches":56,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"","innings":"","notout":"","runs":"","balls":"","highest":"","run100":"","run50":"","run4":"","run6":"","average":"","strike":"","catches":"","stumpings":""}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":49,"innings":72,"balls":6793,"overs":1132.1,"runs":3910,"wickets":85,"bestinning":"8\/60","bestmatch":"8\/60","econ":"3.45","average":"46.00","strike":"79.9","wicket4i":4,"wicket5i":4,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":60,"innings":51,"balls":2071,"overs":345.1,"runs":1721,"wickets":36,"bestinning":"3\/30","bestmatch":"3\/30","econ":"4.98","average":"47.80","strike":"57.5","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":34,"innings":30,"balls":530,"overs":88.2,"runs":621,"wickets":24,"bestinning":"3\/12","bestmatch":"3\/12","econ":"7.03","average":"25.87","strike":"22.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":112,"innings":94,"balls":1627,"overs":271.1,"runs":1896,"wickets":75,"bestinning":"3\/12","bestmatch":"3\/12","econ":"6.99","average":"25.28","strike":"21.6","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":111,"innings":85,"balls":3459,"overs":576.3,"runs":2777,"wickets":82,"bestinning":"4\/19","bestmatch":"4\/19","econ":"4.81","average":"33.86","strike":"42.1","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":104,"innings":148,"balls":11904,"overs":1984,"runs":6263,"wickets":185,"bestinning":"8\/60","bestmatch":"10\/104","econ":"3.15","average":"33.85","strike":"64.3","wicket4i":6,"wicket5i":10,"wicket10m":2,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"0","innings":"","balls":"","overs":"0","runs":"","wickets":"","bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":"","wicket5i":"","wicket10m":""}}},"etag":"472a27f4c5a2c9e258be78a7a6376e46","modified":"2025-06-23 20:57:28","datetime":"2025-06-23 20:57:28","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":53712,"title":"Roston Chase","short_name":"RL Chase","first_name":"Roston Chase","last_name":"","middle_name":"","birthdate":"1992-03-22","birthplace":"Barbados","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/rostonlamarchase\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/younggross22\/","debut_data":"","thumb_url":"","nationality":"West Indies"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":49,"innings":90,"notout":4,"runs":2265,"balls":4862,"highest":137,"run100":5,"run50":11,"run4":243,"run6":17,"average":"26.33","strike":"46.58","catches":23,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":60,"innings":45,"notout":8,"runs":953,"balls":1253,"highest":94,"run100":0,"run50":5,"run4":72,"run6":6,"average":"25.75","strike":"76.05","catches":28,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":34,"innings":26,"notout":7,"runs":440,"balls":377,"highest":67,"run100":0,"run50":2,"run4":36,"run6":13,"average":"23.15","strike":"116.71","catches":12,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":112,"innings":94,"notout":22,"runs":1907,"balls":1542,"highest":85,"run100":0,"run50":11,"run4":163,"run6":65,"average":"26.48","strike":"123.67","catches":38,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":111,"innings":92,"notout":13,"runs":2591,"balls":3080,"highest":136,"run100":2,"run50":16,"run4":204,"run6":44,"average":"32.79","strike":"84.12","catches":53,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":104,"innings":175,"notout":19,"runs":5367,"balls":0,"highest":137,"run100":11,"run50":29,"run4":0,"run6":0,"average":"34.40","strike":"","catches":56,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"","innings":"","notout":"","runs":"","balls":"","highest":"","run100":"","run50":"","run4":"","run6":"","average":"","strike":"","catches":"","stumpings":""}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":49,"innings":72,"balls":6793,"overs":1132.1,"runs":3910,"wickets":85,"bestinning":"8\/60","bestmatch":"8\/60","econ":"3.45","average":"46.00","strike":"79.9","wicket4i":4,"wicket5i":4,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":60,"innings":51,"balls":2071,"overs":345.1,"runs":1721,"wickets":36,"bestinning":"3\/30","bestmatch":"3\/30","econ":"4.98","average":"47.80","strike":"57.5","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":34,"innings":30,"balls":530,"overs":88.2,"runs":621,"wickets":24,"bestinning":"3\/12","bestmatch":"3\/12","econ":"7.03","average":"25.87","strike":"22.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":112,"innings":94,"balls":1627,"overs":271.1,"runs":1896,"wickets":75,"bestinning":"3\/12","bestmatch":"3\/12","econ":"6.99","average":"25.28","strike":"21.6","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":111,"innings":85,"balls":3459,"overs":576.3,"runs":2777,"wickets":82,"bestinning":"4\/19","bestmatch":"4\/19","econ":"4.81","average":"33.86","strike":"42.1","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":104,"innings":148,"balls":11904,"overs":1984,"runs":6263,"wickets":185,"bestinning":"8\/60","bestmatch":"10\/104","econ":"3.15","average":"33.85","strike":"64.3","wicket4i":6,"wicket5i":10,"wicket10m":2,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"0","innings":"","balls":"","overs":"0","runs":"","wickets":"","bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":"","wicket5i":"","wicket10m":""}}},"etag":"472a27f4c5a2c9e258be78a7a6376e46","modified":"2025-06-23 20:57:28","datetime":"2025-06-23 20:57:28","api_version":"3.0"}', Modified = GetDate() WHERE Id = 53712 AND DataTypeId = 6 END Player profile of Roston Chase, West Indies
