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:c305be5b-8d68-4538-9e10-965315b68506 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90172 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90172,1,'{"status":"ok","response":{"mid":90172,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Jersey Women won by 49 runs","day_remaining_over":"","team_batting":"Isle of Man Women","team_bowling":"Jersey Women","live_inning_number":2,"live_score":{"runs":91,"overs":17.1,"wickets":10,"target":141,"runrate":5.3,"required_runrate":""},"commentary":2,"wagon":2,"batsmen":[{"name":"Georgina Ford","batsman_id":149030,"runs":0,"balls_faced":0,"fours":0,"sixes":0,"strike_rate":"0.00"}],"bowlers":[{"name":"Chloe Greechan","bowler_id":115785,"overs":3.1,"runs_conceded":14,"wickets":1,"maidens":0,"econ":"4.42"},{"name":"Olivia Bastin","bowler_id":145394,"overs":3,"runs_conceded":12,"wickets":0,"maidens":0,"econ":"4"}],"commentaries":[],"day":"0","session":"0","live_inning":{"iid":197118,"number":2,"name":"Isle of Man Women inning","short_name":"IM-W inn.","status":2,"issuperover":"false","result":1,"batting_team_id":126803,"fielding_team_id":124545,"scores":"91\/10","scores_full":"91\/10 (17.1 ov)","fielder":[{"fielder_id":"115781","fielder_name":"Trinity Smith","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"115778","fielder_name":"Lily Greig","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"127561","fielder_name":"Florence Tanguy","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"115774","fielder_name":"Mia Maguire","catches":0,"runout_thrower":1,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"115773","fielder_name":"Grace Wetherall","catches":1,"runout_thrower":0,"runout_catcher":1,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":[],"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Alanya Thorpe","batsman_id":"121374","runs":"9","balls":"15","how_out":"b C Greechan","score_at_dismissal":91,"overs_at_dismissal":"17.1","bowler_id":"115785","dismissal":"bowled","number":10},"extra_runs":{"byes":0,"legbyes":2,"wides":2,"noballs":3,"penalty":"0","total":7},"equations":{"runs":91,"wickets":10,"overs":"17.1","bowlers_used":5,"runrate":"5.30"},"current_partnership":[],"did_not_bat":[],"max_over":"0","target":"141","recent_scores":[],"last_five_overs":[],"last_ten_overs":[]},"teams":[{"tid":124545,"title":"Jersey Women","abbr":"JER-W","alt_name":"Jersey Women","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/JER-CR1@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/JER-CR1@2x.png","country":"je","sex":"female","team_owner":"","head_coach":"","scores_full":"140\/6 (20 ov)","scores":"140\/6","overs":"20"},{"tid":126803,"title":"Isle of Man Women","abbr":"IM-W","alt_name":"Isle of Man Women","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121305.632.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121305.632.png","country":"es","sex":"female","team_owner":"","head_coach":"","scores_full":"91\/10 (17.1 ov)","scores":"91\/10","overs":"17.1"}],"players":[{"pid":115773,"title":"Grace Wetherall","short_name":"G Wetherall","first_name":"Grace Wetherall","last_name":"","middle_name":"","birthdate":"2006-11-11","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"all","role_str":""},{"pid":115774,"title":"Mia Maguire","short_name":"M Maguire","first_name":"Mia Maguire","last_name":"","middle_name":"","birthdate":"2007-01-16","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"wk","role_str":"(WK)"},{"pid":115778,"title":"Lily Greig","short_name":"L Greig","first_name":"Lily Greig","last_name":"","middle_name":"","birthdate":"2005-01-12","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"bat","role_str":""},{"pid":115781,"title":"Trinity Smith","short_name":"T Smith","first_name":"Trinity Smith","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"all","role_str":""},{"pid":115782,"title":"Analise Merritt","short_name":"A Merritt","first_name":"Analise Merritt","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"all","role_str":""},{"pid":115785,"title":"Chloe Greechan","short_name":"C Greechan","first_name":"Chloe Greechan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"bowl","role_str":"(C)"},{"pid":121369,"title":"Clare Crowe","short_name":"C Crowe","first_name":"Clare Crowe","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bat","role_str":""},{"pid":121371,"title":"Rachel Overman","short_name":"R Overman","first_name":"Rachel Overman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bat","role_str":""},{"pid":121372,"title":"Lucy Barnett","short_name":"L Barnett","first_name":"Lucy Barnett","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"all","role_str":""},{"pid":121374,"title":"Alanya Thorpe","short_name":"A Thorpe","first_name":"Alanya Thorpe","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bowl","role_str":"(C)"},{"pid":121375,"title":"Ellan Cleator","short_name":"E Cleator","first_name":"Ellan Cleator","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bat","role_str":""},{"pid":121379,"title":"Catherine Perry","short_name":"C Perry","first_name":"Catherine Perry","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"bowl","role_str":""},{"pid":121381,"title":"Danielle Murphy","short_name":"D Murphy","first_name":"Danielle Murphy","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"bowl","role_str":""},{"pid":127551,"title":"Aimee Aikenhead","short_name":"A Aikenhead","first_name":"Aimee Aikenhead","last_name":"","middle_name":"","birthdate":"2023-06-22","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"bat","role_str":""},{"pid":127561,"title":"Florence Tanguy","short_name":"F Tanguy","first_name":"Florence Tanguy","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"bowl","role_str":""},{"pid":129640,"title":"Caitlin Henery","short_name":"C Henery","first_name":"Caitlin Henery","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"all","role_str":""},{"pid":129860,"title":"Rebecca Webster","short_name":"R Webster","first_name":"Rebecca Webster","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"wk","role_str":"(WK)"},{"pid":141793,"title":"Sam Hassall","short_name":"S Hassall","first_name":"Sam Hassall","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":145394,"title":"Olivia Bastin","short_name":"O Bastin","first_name":"Olivia Bastin","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"bowl","role_str":""},{"pid":148669,"title":"Tallulah Spry","short_name":"T Spry","first_name":"Tallulah Spry","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"bat","role_str":""},{"pid":148986,"title":"Annabel Mossop","short_name":"A Mossop","first_name":"Annabel Mossop","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"bowl","role_str":""},{"pid":149030,"title":"Georgina Ford","short_name":"G Ford","first_name":"Georgina Ford","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"bowl","role_str":""}]},"etag":"67d3d216689df0bad290f4901312818c","modified":"2025-07-10 14:19:15","datetime":"2025-07-10 14:19:15","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90172,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Jersey Women won by 49 runs","day_remaining_over":"","team_batting":"Isle of Man Women","team_bowling":"Jersey Women","live_inning_number":2,"live_score":{"runs":91,"overs":17.1,"wickets":10,"target":141,"runrate":5.3,"required_runrate":""},"commentary":2,"wagon":2,"batsmen":[{"name":"Georgina Ford","batsman_id":149030,"runs":0,"balls_faced":0,"fours":0,"sixes":0,"strike_rate":"0.00"}],"bowlers":[{"name":"Chloe Greechan","bowler_id":115785,"overs":3.1,"runs_conceded":14,"wickets":1,"maidens":0,"econ":"4.42"},{"name":"Olivia Bastin","bowler_id":145394,"overs":3,"runs_conceded":12,"wickets":0,"maidens":0,"econ":"4"}],"commentaries":[],"day":"0","session":"0","live_inning":{"iid":197118,"number":2,"name":"Isle of Man Women inning","short_name":"IM-W inn.","status":2,"issuperover":"false","result":1,"batting_team_id":126803,"fielding_team_id":124545,"scores":"91\/10","scores_full":"91\/10 (17.1 ov)","fielder":[{"fielder_id":"115781","fielder_name":"Trinity Smith","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"115778","fielder_name":"Lily Greig","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"127561","fielder_name":"Florence Tanguy","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"115774","fielder_name":"Mia Maguire","catches":0,"runout_thrower":1,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"115773","fielder_name":"Grace Wetherall","catches":1,"runout_thrower":0,"runout_catcher":1,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":[],"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Alanya Thorpe","batsman_id":"121374","runs":"9","balls":"15","how_out":"b C Greechan","score_at_dismissal":91,"overs_at_dismissal":"17.1","bowler_id":"115785","dismissal":"bowled","number":10},"extra_runs":{"byes":0,"legbyes":2,"wides":2,"noballs":3,"penalty":"0","total":7},"equations":{"runs":91,"wickets":10,"overs":"17.1","bowlers_used":5,"runrate":"5.30"},"current_partnership":[],"did_not_bat":[],"max_over":"0","target":"141","recent_scores":[],"last_five_overs":[],"last_ten_overs":[]},"teams":[{"tid":124545,"title":"Jersey Women","abbr":"JER-W","alt_name":"Jersey Women","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/JER-CR1@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/JER-CR1@2x.png","country":"je","sex":"female","team_owner":"","head_coach":"","scores_full":"140\/6 (20 ov)","scores":"140\/6","overs":"20"},{"tid":126803,"title":"Isle of Man Women","abbr":"IM-W","alt_name":"Isle of Man Women","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121305.632.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121305.632.png","country":"es","sex":"female","team_owner":"","head_coach":"","scores_full":"91\/10 (17.1 ov)","scores":"91\/10","overs":"17.1"}],"players":[{"pid":115773,"title":"Grace Wetherall","short_name":"G Wetherall","first_name":"Grace Wetherall","last_name":"","middle_name":"","birthdate":"2006-11-11","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"all","role_str":""},{"pid":115774,"title":"Mia Maguire","short_name":"M Maguire","first_name":"Mia Maguire","last_name":"","middle_name":"","birthdate":"2007-01-16","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"wk","role_str":"(WK)"},{"pid":115778,"title":"Lily Greig","short_name":"L Greig","first_name":"Lily Greig","last_name":"","middle_name":"","birthdate":"2005-01-12","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"bat","role_str":""},{"pid":115781,"title":"Trinity Smith","short_name":"T Smith","first_name":"Trinity Smith","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"all","role_str":""},{"pid":115782,"title":"Analise Merritt","short_name":"A Merritt","first_name":"Analise Merritt","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"all","role_str":""},{"pid":115785,"title":"Chloe Greechan","short_name":"C Greechan","first_name":"Chloe Greechan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"bowl","role_str":"(C)"},{"pid":121369,"title":"Clare Crowe","short_name":"C Crowe","first_name":"Clare Crowe","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bat","role_str":""},{"pid":121371,"title":"Rachel Overman","short_name":"R Overman","first_name":"Rachel Overman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bat","role_str":""},{"pid":121372,"title":"Lucy Barnett","short_name":"L Barnett","first_name":"Lucy Barnett","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"all","role_str":""},{"pid":121374,"title":"Alanya Thorpe","short_name":"A Thorpe","first_name":"Alanya Thorpe","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bowl","role_str":"(C)"},{"pid":121375,"title":"Ellan Cleator","short_name":"E Cleator","first_name":"Ellan Cleator","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bat","role_str":""},{"pid":121379,"title":"Catherine Perry","short_name":"C Perry","first_name":"Catherine Perry","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"bowl","role_str":""},{"pid":121381,"title":"Danielle Murphy","short_name":"D Murphy","first_name":"Danielle Murphy","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"bowl","role_str":""},{"pid":127551,"title":"Aimee Aikenhead","short_name":"A Aikenhead","first_name":"Aimee Aikenhead","last_name":"","middle_name":"","birthdate":"2023-06-22","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"bat","role_str":""},{"pid":127561,"title":"Florence Tanguy","short_name":"F Tanguy","first_name":"Florence Tanguy","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"bowl","role_str":""},{"pid":129640,"title":"Caitlin Henery","short_name":"C Henery","first_name":"Caitlin Henery","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"all","role_str":""},{"pid":129860,"title":"Rebecca Webster","short_name":"R Webster","first_name":"Rebecca Webster","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"wk","role_str":"(WK)"},{"pid":141793,"title":"Sam Hassall","short_name":"S Hassall","first_name":"Sam Hassall","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":145394,"title":"Olivia Bastin","short_name":"O Bastin","first_name":"Olivia Bastin","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"bowl","role_str":""},{"pid":148669,"title":"Tallulah Spry","short_name":"T Spry","first_name":"Tallulah Spry","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"bat","role_str":""},{"pid":148986,"title":"Annabel Mossop","short_name":"A Mossop","first_name":"Annabel Mossop","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"bowl","role_str":""},{"pid":149030,"title":"Georgina Ford","short_name":"G Ford","first_name":"Georgina Ford","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"bowl","role_str":""}]},"etag":"67d3d216689df0bad290f4901312818c","modified":"2025-07-10 14:19:15","datetime":"2025-07-10 14:19:15","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90172 AND DataTypeId = 1 END

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:c81d1491-9a5f-4052-aa5e-8beaad0d201d Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90172 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90172,3,'{"status":"ok","response":{"match_id":90172,"title":"Isle of Man Women vs Jersey Women","short_title":"IM-W vs JER-W","subtitle":"12th Match","match_number":"11","format":8,"format_str":"Women T20","status":2,"status_str":"Completed","status_note":"Jersey Women won by 49 runs","verified":"false","pre_squad":"false","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129599,"title":"ICC Womens T20 World Cup Europe Qualifier Division 2","abbr":"ICC Womens T20 World Cup Europe Qualifier ","type":"tournament","category":"women","match_format":"woment20","season":"2025","status":"live","datestart":"2025-05-25","dateend":"2025-05-29","country":"int","total_matches":"15","total_rounds":"1","total_teams":"6"},"teama":{"team_id":126803,"name":"Isle of Man Women","short_name":"IM-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121305.632.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121305.632.png","scores_full":"91\/10 (17.1 ov)","scores":"91\/10","overs":"17.1"},"teamb":{"team_id":124545,"name":"Jersey Women","short_name":"JER-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/JER-CR1@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/JER-CR1@2x.png","scores_full":"140\/6 (20 ov)","scores":"140\/6","overs":"20"},"date_start":"2025-05-28 13:00:00","date_end":"2025-05-28 23:00:00","timestamp_start":1748437200,"timestamp_end":1748473200,"date_start_ist":"2025-05-28 18:30:00","date_end_ist":"2025-05-29 04:30:00","venue":{"venue_id":"1213565","name":"Simar Cricket Ground","location":"Rome","country":"Italy","timezone":""},"umpires":"Shanaka Fernando (Italy), David McLean (Scotland)","referee":"Graham McCrea (Ireland)","equation":"","live":"","result":"JER-W won by 49 runs","result_type":2,"win_margin":"49 runs","winning_team_id":124545,"commentary":2,"wagon":2,"latest_inning_number":2,"presquad_time":"","verify_time":"","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":[],"pitch":{"pitch_condition":"","batting_condition":"Average","pace_bowling_condition":"Average","spine_bowling_condition":"Average"},"toss":{"text":"Isle of Man Women elected to bowl","winner":126803,"decision":2}},"etag":"67d3d216689df0bad290f4901312818c","modified":"2025-07-10 14:19:15","datetime":"2025-07-10 14:19:15","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90172,"title":"Isle of Man Women vs Jersey Women","short_title":"IM-W vs JER-W","subtitle":"12th Match","match_number":"11","format":8,"format_str":"Women T20","status":2,"status_str":"Completed","status_note":"Jersey Women won by 49 runs","verified":"false","pre_squad":"false","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129599,"title":"ICC Womens T20 World Cup Europe Qualifier Division 2","abbr":"ICC Womens T20 World Cup Europe Qualifier ","type":"tournament","category":"women","match_format":"woment20","season":"2025","status":"live","datestart":"2025-05-25","dateend":"2025-05-29","country":"int","total_matches":"15","total_rounds":"1","total_teams":"6"},"teama":{"team_id":126803,"name":"Isle of Man Women","short_name":"IM-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121305.632.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121305.632.png","scores_full":"91\/10 (17.1 ov)","scores":"91\/10","overs":"17.1"},"teamb":{"team_id":124545,"name":"Jersey Women","short_name":"JER-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/JER-CR1@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/JER-CR1@2x.png","scores_full":"140\/6 (20 ov)","scores":"140\/6","overs":"20"},"date_start":"2025-05-28 13:00:00","date_end":"2025-05-28 23:00:00","timestamp_start":1748437200,"timestamp_end":1748473200,"date_start_ist":"2025-05-28 18:30:00","date_end_ist":"2025-05-29 04:30:00","venue":{"venue_id":"1213565","name":"Simar Cricket Ground","location":"Rome","country":"Italy","timezone":""},"umpires":"Shanaka Fernando (Italy), David McLean (Scotland)","referee":"Graham McCrea (Ireland)","equation":"","live":"","result":"JER-W won by 49 runs","result_type":2,"win_margin":"49 runs","winning_team_id":124545,"commentary":2,"wagon":2,"latest_inning_number":2,"presquad_time":"","verify_time":"","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":[],"pitch":{"pitch_condition":"","batting_condition":"Average","pace_bowling_condition":"Average","spine_bowling_condition":"Average"},"toss":{"text":"Isle of Man Women elected to bowl","winner":126803,"decision":2}},"etag":"67d3d216689df0bad290f4901312818c","modified":"2025-07-10 14:19:15","datetime":"2025-07-10 14:19:15","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90172 AND DataTypeId = 3 END
Live Report & Scorecard of Isle of Man Women vs Jersey Women 12th Match
CricDirect Cricket News, Results and Stats
 

Isle of Man Women vs Jersey Women, 12th Match, ICC Womens T20 World Cup Europe Qualifier Division 2

Isle of Man Women
IM-W
91/10 (17.1)
Jersey Women
JER-W
140/6 (20)
Jersey Women won by 49 runs
Match Details
Date
2025-05-28 13:00:00
Venue
Simar Cricket Ground, Rome
Toss
Isle of Man Women elected to bowl
Umpires
    Tv Umpires
      Match Referee
        × Close