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:e15468b0-730c-4142-9f01-c5c58a73eccc
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 1899 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (1899,6,'{"status":"ok","response":{"player":{"pid":1899,"title":"Roelof van der Merwe","short_name":"R Merwe","first_name":"Roelof van der Merwe","last_name":"","middle_name":"","birthdate":"1984-12-31","birthplace":"johannesburg,Transvaal","country":"nl","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/people\/Roelof-Van-der-Merwe\/100083113765394\/","twitter_profile":"https:\/\/twitter.com\/roela52","instagram_profile":"https:\/\/www.instagram.com\/roela52\/","debut_data":"","thumb_url":"","nationality":"Netherlands"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":39,"innings":27,"notout":7,"runs":278,"balls":328,"highest":57,"run100":0,"run50":1,"run4":17,"run6":7,"average":"13.90","strike":"84.75","catches":13,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":63,"innings":43,"notout":19,"runs":541,"balls":415,"highest":75,"run100":0,"run50":2,"run4":42,"run6":16,"average":"22.54","strike":"130.36","catches":23,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":359,"innings":237,"notout":91,"runs":3123,"balls":2376,"highest":89,"run100":0,"run50":10,"run4":266,"run6":110,"average":"21.39","strike":"131.43","catches":149,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":218,"innings":174,"notout":49,"runs":3127,"balls":3263,"highest":165,"run100":1,"run50":11,"run4":243,"run6":83,"average":"25.01","strike":"95.83","catches":92,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":80,"innings":128,"notout":16,"runs":3588,"balls":5163,"highest":205,"run100":6,"run50":22,"run4":409,"run6":51,"average":"32.03","strike":"69.49","catches":61,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"15","innings":"4","notout":"2","runs":"16","balls":"11","highest":"6","run100":"0","run50":"0","run4":"3","run6":"0","average":"8.00","strike":"145.45","catches":"8","stumpings":"0"}},"bowling":{"odi":{"match_id":0,"inning_id":0,"matches":39,"innings":39,"balls":1963,"overs":327.1,"runs":1547,"wickets":45,"bestinning":"3\/14","bestmatch":"3\/14","econ":"4.72","average":"34.37","strike":"43.6","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":63,"innings":61,"balls":1207,"overs":201.1,"runs":1318,"wickets":68,"bestinning":"4\/35","bestmatch":"4\/35","econ":"6.55","average":"19.38","strike":"17.7","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":359,"innings":340,"balls":6565,"overs":1094.1,"runs":7999,"wickets":332,"bestinning":"6\/20","bestmatch":"6\/20","econ":"7.31","average":"24.09","strike":"19.7","wicket4i":4,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":218,"innings":206,"balls":9725,"overs":1620.5,"runs":7821,"wickets":287,"bestinning":"5\/26","bestmatch":"5\/26","econ":"4.82","average":"27.25","strike":"33.8","wicket4i":12,"wicket5i":4,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":80,"innings":124,"balls":10252,"overs":1708.4,"runs":5069,"wickets":150,"bestinning":"5\/174","bestmatch":"8\/104","econ":"2.96","average":"33.79","strike":"68.3","wicket4i":8,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"15","innings":"6","balls":"48","overs":"8","runs":"97","wickets":"3","bestinning":"1\/11","bestmatch":"1\/11","econ":"12.13","average":"32.33","strike":"16.00","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"28dcb884894b447f4ed768a68083f0ad","modified":"2025-06-20 02:19:24","datetime":"2025-06-20 02:19:24","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":1899,"title":"Roelof van der Merwe","short_name":"R Merwe","first_name":"Roelof van der Merwe","last_name":"","middle_name":"","birthdate":"1984-12-31","birthplace":"johannesburg,Transvaal","country":"nl","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/people\/Roelof-Van-der-Merwe\/100083113765394\/","twitter_profile":"https:\/\/twitter.com\/roela52","instagram_profile":"https:\/\/www.instagram.com\/roela52\/","debut_data":"","thumb_url":"","nationality":"Netherlands"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":39,"innings":27,"notout":7,"runs":278,"balls":328,"highest":57,"run100":0,"run50":1,"run4":17,"run6":7,"average":"13.90","strike":"84.75","catches":13,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":63,"innings":43,"notout":19,"runs":541,"balls":415,"highest":75,"run100":0,"run50":2,"run4":42,"run6":16,"average":"22.54","strike":"130.36","catches":23,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":359,"innings":237,"notout":91,"runs":3123,"balls":2376,"highest":89,"run100":0,"run50":10,"run4":266,"run6":110,"average":"21.39","strike":"131.43","catches":149,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":218,"innings":174,"notout":49,"runs":3127,"balls":3263,"highest":165,"run100":1,"run50":11,"run4":243,"run6":83,"average":"25.01","strike":"95.83","catches":92,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":80,"innings":128,"notout":16,"runs":3588,"balls":5163,"highest":205,"run100":6,"run50":22,"run4":409,"run6":51,"average":"32.03","strike":"69.49","catches":61,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"15","innings":"4","notout":"2","runs":"16","balls":"11","highest":"6","run100":"0","run50":"0","run4":"3","run6":"0","average":"8.00","strike":"145.45","catches":"8","stumpings":"0"}},"bowling":{"odi":{"match_id":0,"inning_id":0,"matches":39,"innings":39,"balls":1963,"overs":327.1,"runs":1547,"wickets":45,"bestinning":"3\/14","bestmatch":"3\/14","econ":"4.72","average":"34.37","strike":"43.6","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":63,"innings":61,"balls":1207,"overs":201.1,"runs":1318,"wickets":68,"bestinning":"4\/35","bestmatch":"4\/35","econ":"6.55","average":"19.38","strike":"17.7","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":359,"innings":340,"balls":6565,"overs":1094.1,"runs":7999,"wickets":332,"bestinning":"6\/20","bestmatch":"6\/20","econ":"7.31","average":"24.09","strike":"19.7","wicket4i":4,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":218,"innings":206,"balls":9725,"overs":1620.5,"runs":7821,"wickets":287,"bestinning":"5\/26","bestmatch":"5\/26","econ":"4.82","average":"27.25","strike":"33.8","wicket4i":12,"wicket5i":4,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":80,"innings":124,"balls":10252,"overs":1708.4,"runs":5069,"wickets":150,"bestinning":"5\/174","bestmatch":"8\/104","econ":"2.96","average":"33.79","strike":"68.3","wicket4i":8,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"15","innings":"6","balls":"48","overs":"8","runs":"97","wickets":"3","bestinning":"1\/11","bestmatch":"1\/11","econ":"12.13","average":"32.33","strike":"16.00","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"28dcb884894b447f4ed768a68083f0ad","modified":"2025-06-20 02:19:24","datetime":"2025-06-20 02:19:24","api_version":"3.0"}', Modified = GetDate() WHERE Id = 1899 AND DataTypeId = 6 END Player profile of Roelof van der Merwe, Netherlands
