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:76aeaeee-2074-4af5-a2d3-f563e2d7823b
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 57187 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (57187,6,'{"status":"ok","response":{"player":{"pid":57187,"title":"Anrich Nortje","short_name":"A Nortje","first_name":"Anrich Nortje","last_name":"","middle_name":"","birthdate":"1993-11-16","birthplace":"Kariega, South Africa","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/anrichnortje02\/","twitter_profile":"https:\/\/twitter.com\/AnrichNortje02","instagram_profile":"https:\/\/www.instagram.com\/anrich_nortje\/","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"South Africa"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":19,"innings":33,"notout":9,"runs":187,"balls":618,"highest":40,"run100":0,"run50":0,"run4":27,"run6":0,"average":"7.79","strike":"30.25","catches":6,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":22,"innings":7,"notout":1,"runs":40,"balls":59,"highest":10,"run100":0,"run50":0,"run4":3,"run6":0,"average":"6.66","strike":"67.79","catches":3,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":42,"innings":12,"notout":6,"runs":17,"balls":35,"highest":4,"run100":0,"run50":0,"run4":1,"run6":0,"average":"2.83","strike":"48.57","catches":10,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":144,"innings":46,"notout":23,"runs":185,"balls":180,"highest":25,"run100":0,"run50":0,"run4":18,"run6":4,"average":"8.04","strike":"102.77","catches":38,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":56,"innings":23,"notout":5,"runs":150,"balls":229,"highest":17,"run100":0,"run50":0,"run4":13,"run6":0,"average":"8.33","strike":"65.50","catches":12,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":67,"innings":93,"notout":25,"runs":906,"balls":2046,"highest":79,"run100":0,"run50":4,"run4":109,"run6":12,"average":"13.32","strike":"44.28","catches":15,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"16","innings":"1","notout":"0","runs":"4","balls":"6","highest":"4","run100":"0","run50":"0","run4":"0","run6":"0","average":"4.00","strike":"66.67","catches":"4","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":19,"innings":32,"balls":3057,"overs":509.3,"runs":1870,"wickets":70,"bestinning":"6\/56","bestmatch":"8\/120","econ":"3.67","average":"26.71","strike":"43.6","wicket4i":1,"wicket5i":4,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":22,"innings":21,"balls":1006,"overs":167.4,"runs":982,"wickets":36,"bestinning":"4\/51","bestmatch":"4\/51","econ":"5.85","average":"27.27","strike":"27.9","wicket4i":3,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":42,"innings":41,"balls":869,"overs":144.5,"runs":1016,"wickets":53,"bestinning":"4\/7","bestmatch":"4\/7","econ":"7.01","average":"19.16","strike":"16.3","wicket4i":3,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":144,"innings":143,"balls":3161,"overs":526.5,"runs":4145,"wickets":181,"bestinning":"4\/7","bestmatch":"4\/7","econ":"7.86","average":"22.90","strike":"17.4","wicket4i":5,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":56,"innings":54,"balls":2658,"overs":443,"runs":2296,"wickets":89,"bestinning":"4\/46","bestmatch":"4\/46","econ":"5.18","average":"25.79","strike":"29.8","wicket4i":4,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":67,"innings":115,"balls":11064,"overs":1844,"runs":6124,"wickets":234,"bestinning":"6\/44","bestmatch":"9\/98","econ":"3.32","average":"26.17","strike":"47.2","wicket4i":12,"wicket5i":9,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"16","innings":"16","balls":"180","overs":"30","runs":"289","wickets":"11","bestinning":"1\/5","bestmatch":"1\/5","econ":"9.63","average":"26.27","strike":"16.36","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"b999c5546d2954b27d13735f3a878a05","modified":"2025-06-25 23:07:39","datetime":"2025-06-25 23:07:39","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":57187,"title":"Anrich Nortje","short_name":"A Nortje","first_name":"Anrich Nortje","last_name":"","middle_name":"","birthdate":"1993-11-16","birthplace":"Kariega, South Africa","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/anrichnortje02\/","twitter_profile":"https:\/\/twitter.com\/AnrichNortje02","instagram_profile":"https:\/\/www.instagram.com\/anrich_nortje\/","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"South Africa"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":19,"innings":33,"notout":9,"runs":187,"balls":618,"highest":40,"run100":0,"run50":0,"run4":27,"run6":0,"average":"7.79","strike":"30.25","catches":6,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":22,"innings":7,"notout":1,"runs":40,"balls":59,"highest":10,"run100":0,"run50":0,"run4":3,"run6":0,"average":"6.66","strike":"67.79","catches":3,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":42,"innings":12,"notout":6,"runs":17,"balls":35,"highest":4,"run100":0,"run50":0,"run4":1,"run6":0,"average":"2.83","strike":"48.57","catches":10,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":144,"innings":46,"notout":23,"runs":185,"balls":180,"highest":25,"run100":0,"run50":0,"run4":18,"run6":4,"average":"8.04","strike":"102.77","catches":38,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":56,"innings":23,"notout":5,"runs":150,"balls":229,"highest":17,"run100":0,"run50":0,"run4":13,"run6":0,"average":"8.33","strike":"65.50","catches":12,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":67,"innings":93,"notout":25,"runs":906,"balls":2046,"highest":79,"run100":0,"run50":4,"run4":109,"run6":12,"average":"13.32","strike":"44.28","catches":15,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"16","innings":"1","notout":"0","runs":"4","balls":"6","highest":"4","run100":"0","run50":"0","run4":"0","run6":"0","average":"4.00","strike":"66.67","catches":"4","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":19,"innings":32,"balls":3057,"overs":509.3,"runs":1870,"wickets":70,"bestinning":"6\/56","bestmatch":"8\/120","econ":"3.67","average":"26.71","strike":"43.6","wicket4i":1,"wicket5i":4,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":22,"innings":21,"balls":1006,"overs":167.4,"runs":982,"wickets":36,"bestinning":"4\/51","bestmatch":"4\/51","econ":"5.85","average":"27.27","strike":"27.9","wicket4i":3,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":42,"innings":41,"balls":869,"overs":144.5,"runs":1016,"wickets":53,"bestinning":"4\/7","bestmatch":"4\/7","econ":"7.01","average":"19.16","strike":"16.3","wicket4i":3,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":144,"innings":143,"balls":3161,"overs":526.5,"runs":4145,"wickets":181,"bestinning":"4\/7","bestmatch":"4\/7","econ":"7.86","average":"22.90","strike":"17.4","wicket4i":5,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":56,"innings":54,"balls":2658,"overs":443,"runs":2296,"wickets":89,"bestinning":"4\/46","bestmatch":"4\/46","econ":"5.18","average":"25.79","strike":"29.8","wicket4i":4,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":67,"innings":115,"balls":11064,"overs":1844,"runs":6124,"wickets":234,"bestinning":"6\/44","bestmatch":"9\/98","econ":"3.32","average":"26.17","strike":"47.2","wicket4i":12,"wicket5i":9,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"16","innings":"16","balls":"180","overs":"30","runs":"289","wickets":"11","bestinning":"1\/5","bestmatch":"1\/5","econ":"9.63","average":"26.27","strike":"16.36","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"b999c5546d2954b27d13735f3a878a05","modified":"2025-06-25 23:07:39","datetime":"2025-06-25 23:07:39","api_version":"3.0"}', Modified = GetDate() WHERE Id = 57187 AND DataTypeId = 6 END Player profile of Anrich Nortje, South Africa