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:6b9cd9ec-6862-4a7a-9e72-e6fdc576c7b6
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 84301 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (84301,6,'{"status":"ok","response":{"player":{"pid":84301,"title":"D''Arcy Short","short_name":"DJM Short","first_name":"D''Arcy Short","last_name":"","middle_name":"","birthdate":"1990-08-09","birthplace":" Katherine, Northern Territory","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":18958,"recent_appearance":1517646000,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/shortyjnr23\/","debut_data":"","thumb_url":"","nationality":"Australia"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":8,"innings":8,"notout":1,"runs":211,"balls":269,"highest":69,"run100":0,"run50":1,"run4":16,"run6":1,"average":"30.14","strike":"78.43","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":23,"innings":23,"notout":2,"runs":642,"balls":540,"highest":76,"run100":0,"run50":4,"run4":71,"run6":15,"average":"30.57","strike":"118.88","catches":8,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":172,"innings":172,"notout":16,"runs":4959,"balls":3821,"highest":122,"run100":2,"run50":34,"run4":517,"run6":158,"average":"31.78","strike":"129.78","catches":70,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":73,"innings":68,"notout":5,"runs":2105,"balls":2247,"highest":257,"run100":4,"run50":8,"run4":221,"run6":51,"average":"33.41","strike":"93.68","catches":24,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":25,"innings":44,"notout":4,"runs":1261,"balls":2447,"highest":87,"run100":0,"run50":8,"run4":166,"run6":8,"average":"31.52","strike":"51.53","catches":21,"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":{"odi":{"match_id":0,"inning_id":0,"matches":8,"innings":5,"balls":90,"overs":15,"runs":114,"wickets":0,"bestinning":"","bestmatch":"","econ":"7.60","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":23,"innings":9,"balls":114,"overs":19,"runs":151,"wickets":3,"bestinning":"1\/13","bestmatch":"1\/13","econ":"7.94","average":"50.33","strike":"38.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":172,"innings":112,"balls":1580,"overs":263.2,"runs":2220,"wickets":67,"bestinning":"5\/21","bestmatch":"5\/21","econ":"8.43","average":"33.13","strike":"23.5","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":73,"innings":55,"balls":1526,"overs":254.2,"runs":1586,"wickets":38,"bestinning":"3\/53","bestmatch":"3\/53","econ":"6.23","average":"41.73","strike":"40.1","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":25,"innings":36,"balls":1819,"overs":303.1,"runs":1233,"wickets":28,"bestinning":"3\/78","bestmatch":"4\/43","econ":"4.06","average":"44.03","strike":"64.9","wicket4i":0,"wicket5i":0,"wicket10m":0,"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":"905acbd027f0793972b5124495d7dd93","modified":"2025-06-23 18:38:42","datetime":"2025-06-23 18:38:42","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":84301,"title":"D''Arcy Short","short_name":"DJM Short","first_name":"D''Arcy Short","last_name":"","middle_name":"","birthdate":"1990-08-09","birthplace":" Katherine, Northern Territory","country":"au","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":18958,"recent_appearance":1517646000,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/shortyjnr23\/","debut_data":"","thumb_url":"","nationality":"Australia"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":8,"innings":8,"notout":1,"runs":211,"balls":269,"highest":69,"run100":0,"run50":1,"run4":16,"run6":1,"average":"30.14","strike":"78.43","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":23,"innings":23,"notout":2,"runs":642,"balls":540,"highest":76,"run100":0,"run50":4,"run4":71,"run6":15,"average":"30.57","strike":"118.88","catches":8,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":172,"innings":172,"notout":16,"runs":4959,"balls":3821,"highest":122,"run100":2,"run50":34,"run4":517,"run6":158,"average":"31.78","strike":"129.78","catches":70,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":73,"innings":68,"notout":5,"runs":2105,"balls":2247,"highest":257,"run100":4,"run50":8,"run4":221,"run6":51,"average":"33.41","strike":"93.68","catches":24,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":25,"innings":44,"notout":4,"runs":1261,"balls":2447,"highest":87,"run100":0,"run50":8,"run4":166,"run6":8,"average":"31.52","strike":"51.53","catches":21,"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":{"odi":{"match_id":0,"inning_id":0,"matches":8,"innings":5,"balls":90,"overs":15,"runs":114,"wickets":0,"bestinning":"","bestmatch":"","econ":"7.60","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":23,"innings":9,"balls":114,"overs":19,"runs":151,"wickets":3,"bestinning":"1\/13","bestmatch":"1\/13","econ":"7.94","average":"50.33","strike":"38.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":172,"innings":112,"balls":1580,"overs":263.2,"runs":2220,"wickets":67,"bestinning":"5\/21","bestmatch":"5\/21","econ":"8.43","average":"33.13","strike":"23.5","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":73,"innings":55,"balls":1526,"overs":254.2,"runs":1586,"wickets":38,"bestinning":"3\/53","bestmatch":"3\/53","econ":"6.23","average":"41.73","strike":"40.1","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":25,"innings":36,"balls":1819,"overs":303.1,"runs":1233,"wickets":28,"bestinning":"3\/78","bestmatch":"4\/43","econ":"4.06","average":"44.03","strike":"64.9","wicket4i":0,"wicket5i":0,"wicket10m":0,"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":"905acbd027f0793972b5124495d7dd93","modified":"2025-06-23 18:38:42","datetime":"2025-06-23 18:38:42","api_version":"3.0"}', Modified = GetDate() WHERE Id = 84301 AND DataTypeId = 6 END Player profile of D'Arcy Short, Australia
