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:463bcdd2-7a56-4172-8e26-4d3de95b2b22
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 215 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (215,6,'{"status":"ok","response":{"player":{"pid":215,"title":"Kevin O''Brien","short_name":"K O''Brien","first_name":"Kevin O''Brien","last_name":"","middle_name":"","birthdate":"1984-03-04","birthplace":"Dublin, Ireland","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Ireland"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":3,"innings":6,"notout":1,"runs":258,"balls":467,"highest":118,"run100":1,"run50":1,"run4":29,"run6":0,"average":"51.60","strike":"55.24","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":153,"innings":141,"notout":18,"runs":3619,"balls":4076,"highest":142,"run100":2,"run50":18,"run4":332,"run6":84,"average":"29.42","strike":"88.78","catches":67,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":110,"innings":103,"notout":10,"runs":1973,"balls":1507,"highest":124,"run100":1,"run50":5,"run4":165,"run6":82,"average":"21.21","strike":"130.92","catches":40,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":258,"innings":239,"notout":32,"runs":4577,"balls":3405,"highest":124,"run100":2,"run50":15,"run4":376,"run6":208,"average":"22.11","strike":"134.41","catches":93,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":247,"innings":228,"notout":35,"runs":5689,"balls":6492,"highest":142,"run100":3,"run50":28,"run4":507,"run6":140,"average":"29.47","strike":"87.63","catches":103,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":47,"innings":66,"notout":11,"runs":2039,"balls":3327,"highest":171,"run100":2,"run50":14,"run4":237,"run6":35,"average":"37.07","strike":"61.28","catches":36,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"11","innings":"6","notout":"1","runs":"148","balls":"60","highest":"64","run100":"0","run50":"1","run4":"10","run6":"15","average":"29.60","strike":"246.67","catches":"4","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":3,"innings":2,"balls":60,"overs":10,"runs":31,"wickets":0,"bestinning":"","bestmatch":"","econ":"3.10","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":153,"innings":116,"balls":4296,"overs":716,"runs":3726,"wickets":114,"bestinning":"4\/13","bestmatch":"4\/13","econ":"5.20","average":"32.68","strike":"37.6","wicket4i":5,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":110,"innings":52,"balls":917,"overs":152.5,"runs":1149,"wickets":58,"bestinning":"4\/45","bestmatch":"4\/45","econ":"7.51","average":"19.81","strike":"15.8","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":258,"innings":133,"balls":2107,"overs":351.1,"runs":2688,"wickets":121,"bestinning":"4\/22","bestmatch":"4\/22","econ":"7.65","average":"22.21","strike":"17.4","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":247,"innings":177,"balls":6377,"overs":1062.5,"runs":5594,"wickets":170,"bestinning":"4\/13","bestmatch":"4\/13","econ":"5.26","average":"32.90","strike":"37.5","wicket4i":7,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":47,"innings":55,"balls":2745,"overs":457.3,"runs":1304,"wickets":47,"bestinning":"5\/39","bestmatch":"6\/54","econ":"2.85","average":"27.74","strike":"58.4","wicket4i":2,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"11","innings":"0","balls":"0","overs":"0","runs":"0","wickets":"0","bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"b6fcf75360c90f85d57f35548efcccef","modified":"2025-06-22 20:05:30","datetime":"2025-06-22 20:05:30","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":215,"title":"Kevin O''Brien","short_name":"K O''Brien","first_name":"Kevin O''Brien","last_name":"","middle_name":"","birthdate":"1984-03-04","birthplace":"Dublin, Ireland","country":"ie","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Ireland"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":3,"innings":6,"notout":1,"runs":258,"balls":467,"highest":118,"run100":1,"run50":1,"run4":29,"run6":0,"average":"51.60","strike":"55.24","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":153,"innings":141,"notout":18,"runs":3619,"balls":4076,"highest":142,"run100":2,"run50":18,"run4":332,"run6":84,"average":"29.42","strike":"88.78","catches":67,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":110,"innings":103,"notout":10,"runs":1973,"balls":1507,"highest":124,"run100":1,"run50":5,"run4":165,"run6":82,"average":"21.21","strike":"130.92","catches":40,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":258,"innings":239,"notout":32,"runs":4577,"balls":3405,"highest":124,"run100":2,"run50":15,"run4":376,"run6":208,"average":"22.11","strike":"134.41","catches":93,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":247,"innings":228,"notout":35,"runs":5689,"balls":6492,"highest":142,"run100":3,"run50":28,"run4":507,"run6":140,"average":"29.47","strike":"87.63","catches":103,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":47,"innings":66,"notout":11,"runs":2039,"balls":3327,"highest":171,"run100":2,"run50":14,"run4":237,"run6":35,"average":"37.07","strike":"61.28","catches":36,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"11","innings":"6","notout":"1","runs":"148","balls":"60","highest":"64","run100":"0","run50":"1","run4":"10","run6":"15","average":"29.60","strike":"246.67","catches":"4","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":3,"innings":2,"balls":60,"overs":10,"runs":31,"wickets":0,"bestinning":"","bestmatch":"","econ":"3.10","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":153,"innings":116,"balls":4296,"overs":716,"runs":3726,"wickets":114,"bestinning":"4\/13","bestmatch":"4\/13","econ":"5.20","average":"32.68","strike":"37.6","wicket4i":5,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":110,"innings":52,"balls":917,"overs":152.5,"runs":1149,"wickets":58,"bestinning":"4\/45","bestmatch":"4\/45","econ":"7.51","average":"19.81","strike":"15.8","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":258,"innings":133,"balls":2107,"overs":351.1,"runs":2688,"wickets":121,"bestinning":"4\/22","bestmatch":"4\/22","econ":"7.65","average":"22.21","strike":"17.4","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":247,"innings":177,"balls":6377,"overs":1062.5,"runs":5594,"wickets":170,"bestinning":"4\/13","bestmatch":"4\/13","econ":"5.26","average":"32.90","strike":"37.5","wicket4i":7,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":47,"innings":55,"balls":2745,"overs":457.3,"runs":1304,"wickets":47,"bestinning":"5\/39","bestmatch":"6\/54","econ":"2.85","average":"27.74","strike":"58.4","wicket4i":2,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"11","innings":"0","balls":"0","overs":"0","runs":"0","wickets":"0","bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"b6fcf75360c90f85d57f35548efcccef","modified":"2025-06-22 20:05:30","datetime":"2025-06-22 20:05:30","api_version":"3.0"}', Modified = GetDate() WHERE Id = 215 AND DataTypeId = 6 END Player profile of Kevin O'Brien, Ireland
