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:e0e833cc-6984-454e-ab65-10e212402d62 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90175 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90175,1,'{"status":"ok","response":{"mid":90175,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Italy Women won by 29 runs","day_remaining_over":"","team_batting":"Spain Women","team_bowling":"Italy Women","live_inning_number":2,"live_score":{"runs":92,"overs":20,"wickets":6,"target":122,"runrate":4.6,"required_runrate":""},"commentary":2,"wagon":2,"batsmen":[{"name":"Elspeth Fowler","batsman_id":125176,"runs":4,"balls_faced":5,"fours":0,"sixes":0,"strike_rate":"80.00"},{"name":"Payal Chilongia","batsman_id":134379,"runs":12,"balls_faced":20,"fours":0,"sixes":0,"strike_rate":"60.00"}],"bowlers":[],"commentaries":[],"day":"0","session":"0","live_inning":{"iid":197136,"number":2,"name":"Spain Women inning","short_name":"ESP-W inn.","status":2,"issuperover":"false","result":4,"batting_team_id":124546,"fielding_team_id":126802,"scores":"92\/6","scores_full":"92\/6 (20 ov)","fielder":[{"fielder_id":"121355","fielder_name":"Methnara Rathnayake","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":2,"is_substitute":"false"},{"fielder_id":"47693","fielder_name":"Chloe Piparo","catches":1,"runout_thrower":0,"runout_catcher":0,"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":"Naomi Hillman Bermejo","batsman_id":"121354","runs":"35","balls":"46","how_out":"c C Piparo b P Kanankege","score_at_dismissal":82,"overs_at_dismissal":"18.1","bowler_id":"124049","dismissal":"caught","number":6},"extra_runs":{"byes":0,"legbyes":2,"wides":17,"noballs":0,"penalty":"0","total":19},"equations":{"runs":92,"wickets":6,"overs":"20","bowlers_used":6,"runrate":"4.60"},"current_partnership":[],"did_not_bat":[{"player_id":134380,"name":"Memoona Riaz"},{"player_id":115802,"name":"Muskan Naseeb"},{"player_id":115804,"name":"Rabia Mushtaq"}],"max_over":"0","target":"122","recent_scores":[],"last_five_overs":[],"last_ten_overs":[]},"teams":[{"tid":124546,"title":"Spain Women","abbr":"ESP-W","alt_name":"Spain Women","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Spain.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Spain.png","country":"es","sex":"female","team_owner":"","head_coach":"","scores_full":"92\/6 (20 ov)","scores":"92\/6","overs":"20"},{"tid":126802,"title":"Italy Women","abbr":"ITA-W","alt_name":"Italy Women","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121402.411.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121402.411.png","country":"it","sex":"female","team_owner":"","head_coach":"","scores_full":"121\/9 (20 ov)","scores":"121\/9","overs":"20"}],"players":[{"pid":47693,"title":"Chloe Piparo","short_name":"C Piparo","first_name":"Chloe Piparo","last_name":"","middle_name":"","birthdate":"1994-09-05","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/chloepiparo\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"bat","role_str":""},{"pid":51582,"title":"Ilenia Sims","short_name":"I Sims","first_name":"Ilenia Sims","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"England","role":"all","role_str":""},{"pid":51846,"title":"Emilia Bartram","short_name":"EL Bartram","first_name":"Emilia Bartram","last_name":"","middle_name":"","birthdate":"1993-10-03","birthplace":"","country":"it","primary_team":[],"logo_url":"","playing_role":"all","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":"Italy","role":"all","role_str":"(C)"},{"pid":113993,"title":"Annie Wikman","short_name":"A Wikman","first_name":"Annie Wikman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","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":"Australia","role":"bat","role_str":""},{"pid":115795,"title":"Uswa Syed","short_name":"U Syed","first_name":"Uswa Syed","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"es","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":"Spain","role":"all","role_str":""},{"pid":115799,"title":"Amy Brown Carrera","short_name":"A B Carrera","first_name":"Amy Brown Carrera","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"es","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":"Spain","role":"bat","role_str":""},{"pid":115802,"title":"Muskan Naseeb","short_name":"M Naseeb","first_name":"Muskan Naseeb","last_name":"","middle_name":"","birthdate":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"bat","role_str":""},{"pid":115804,"title":"Rabia Mushtaq","short_name":"R Mushtaq","first_name":"Rabia Mushtaq","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"es","primary_team":[],"logo_url":"","playing_role":"bowl","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":"Spain","role":"bowl","role_str":""},{"pid":121354,"title":"Naomi Hillman Bermejo","short_name":"N H Bermejo","first_name":"Naomi Hillman Bermejo","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"es","primary_team":[],"logo_url":"","playing_role":"bowl","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":"Spain","role":"bowl","role_str":""},{"pid":121355,"title":"Methnara Rathnayake","short_name":"M Rathnayake","first_name":"Methnara Rathnayake","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"wk","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":"India","role":"wk","role_str":"(WK)"},{"pid":121360,"title":"Chathurika Mahamalage","short_name":"C Mahamalage","first_name":"Chathurika Mahamalage","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"it","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":"Italy","role":"all","role_str":""},{"pid":121364,"title":"Dilaisha Nanayakkara","short_name":"D Nanayakkara","first_name":"Dilaisha Nanayakkara","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","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":"India","role":"all","role_str":""},{"pid":124049,"title":"Pasindi Kanankege","short_name":"P Kanankege","first_name":"Pasindi Kanankege","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"it","primary_team":[],"logo_url":"","playing_role":"bowl","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":"Italy","role":"bowl","role_str":""},{"pid":125176,"title":"Elspeth Fowler","short_name":"E Fowler","first_name":"Elspeth Fowler","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"es","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":"Spain","role":"bat","role_str":"(C)"},{"pid":134379,"title":"Payal Chilongia","short_name":"P Chilongia","first_name":"Payal Chilongia","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"es","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":"Spain","role":"bowl","role_str":""},{"pid":134380,"title":"Memoona Riaz","short_name":"M Riaz","first_name":"Memoona Riaz","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"es","primary_team":[],"logo_url":"","playing_role":"all","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":"Spain","role":"all","role_str":""},{"pid":139440,"title":"Teshani Araliya","short_name":"T Araliya","first_name":"Teshani Araliya","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"it","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":"Italy","role":"bowl","role_str":""},{"pid":139442,"title":"Andrea Davidson Soler","short_name":"A D Soler","first_name":"Andrea Davidson Soler","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"es","primary_team":[],"logo_url":"","playing_role":"bat","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":"Spain","role":"bat","role_str":""},{"pid":142572,"title":"Alexis Hartley","short_name":"A Hartley","first_name":"Alexis Hartley","last_name":"","middle_name":"","birthdate":"1985-06-28","birthplace":"","country":"es","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":"Spain","role":"all","role_str":""},{"pid":142573,"title":"Amelia Jones","short_name":"A Jones","first_name":"Amelia Jones","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"es","primary_team":[],"logo_url":"","playing_role":"wk","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":"Spain","role":"wk","role_str":"(WK)"}]},"etag":"5b8a866abd686257b3b6921c9ff14206","modified":"2025-06-14 00:55:18","datetime":"2025-06-14 00:55:18","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90175,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Italy Women won by 29 runs","day_remaining_over":"","team_batting":"Spain Women","team_bowling":"Italy Women","live_inning_number":2,"live_score":{"runs":92,"overs":20,"wickets":6,"target":122,"runrate":4.6,"required_runrate":""},"commentary":2,"wagon":2,"batsmen":[{"name":"Elspeth Fowler","batsman_id":125176,"runs":4,"balls_faced":5,"fours":0,"sixes":0,"strike_rate":"80.00"},{"name":"Payal Chilongia","batsman_id":134379,"runs":12,"balls_faced":20,"fours":0,"sixes":0,"strike_rate":"60.00"}],"bowlers":[],"commentaries":[],"day":"0","session":"0","live_inning":{"iid":197136,"number":2,"name":"Spain Women inning","short_name":"ESP-W inn.","status":2,"issuperover":"false","result":4,"batting_team_id":124546,"fielding_team_id":126802,"scores":"92\/6","scores_full":"92\/6 (20 ov)","fielder":[{"fielder_id":"121355","fielder_name":"Methnara Rathnayake","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":2,"is_substitute":"false"},{"fielder_id":"47693","fielder_name":"Chloe Piparo","catches":1,"runout_thrower":0,"runout_catcher":0,"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":"Naomi Hillman Bermejo","batsman_id":"121354","runs":"35","balls":"46","how_out":"c C Piparo b P Kanankege","score_at_dismissal":82,"overs_at_dismissal":"18.1","bowler_id":"124049","dismissal":"caught","number":6},"extra_runs":{"byes":0,"legbyes":2,"wides":17,"noballs":0,"penalty":"0","total":19},"equations":{"runs":92,"wickets":6,"overs":"20","bowlers_used":6,"runrate":"4.60"},"current_partnership":[],"did_not_bat":[{"player_id":134380,"name":"Memoona Riaz"},{"player_id":115802,"name":"Muskan Naseeb"},{"player_id":115804,"name":"Rabia Mushtaq"}],"max_over":"0","target":"122","recent_scores":[],"last_five_overs":[],"last_ten_overs":[]},"teams":[{"tid":124546,"title":"Spain Women","abbr":"ESP-W","alt_name":"Spain Women","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Spain.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Spain.png","country":"es","sex":"female","team_owner":"","head_coach":"","scores_full":"92\/6 (20 ov)","scores":"92\/6","overs":"20"},{"tid":126802,"title":"Italy Women","abbr":"ITA-W","alt_name":"Italy Women","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121402.411.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121402.411.png","country":"it","sex":"female","team_owner":"","head_coach":"","scores_full":"121\/9 (20 ov)","scores":"121\/9","overs":"20"}],"players":[{"pid":47693,"title":"Chloe Piparo","short_name":"C Piparo","first_name":"Chloe Piparo","last_name":"","middle_name":"","birthdate":"1994-09-05","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/chloepiparo\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"bat","role_str":""},{"pid":51582,"title":"Ilenia Sims","short_name":"I Sims","first_name":"Ilenia Sims","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","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":"England","role":"all","role_str":""},{"pid":51846,"title":"Emilia Bartram","short_name":"EL Bartram","first_name":"Emilia Bartram","last_name":"","middle_name":"","birthdate":"1993-10-03","birthplace":"","country":"it","primary_team":[],"logo_url":"","playing_role":"all","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":"Italy","role":"all","role_str":"(C)"},{"pid":113993,"title":"Annie Wikman","short_name":"A Wikman","first_name":"Annie Wikman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"au","primary_team":[],"logo_url":"","playing_role":"bat","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":"Australia","role":"bat","role_str":""},{"pid":115795,"title":"Uswa Syed","short_name":"U Syed","first_name":"Uswa Syed","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"es","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":"Spain","role":"all","role_str":""},{"pid":115799,"title":"Amy Brown Carrera","short_name":"A B Carrera","first_name":"Amy Brown Carrera","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"es","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":"Spain","role":"bat","role_str":""},{"pid":115802,"title":"Muskan Naseeb","short_name":"M Naseeb","first_name":"Muskan Naseeb","last_name":"","middle_name":"","birthdate":"","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.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"bat","role_str":""},{"pid":115804,"title":"Rabia Mushtaq","short_name":"R Mushtaq","first_name":"Rabia Mushtaq","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"es","primary_team":[],"logo_url":"","playing_role":"bowl","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":"Spain","role":"bowl","role_str":""},{"pid":121354,"title":"Naomi Hillman Bermejo","short_name":"N H Bermejo","first_name":"Naomi Hillman Bermejo","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"es","primary_team":[],"logo_url":"","playing_role":"bowl","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":"Spain","role":"bowl","role_str":""},{"pid":121355,"title":"Methnara Rathnayake","short_name":"M Rathnayake","first_name":"Methnara Rathnayake","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"wk","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":"India","role":"wk","role_str":"(WK)"},{"pid":121360,"title":"Chathurika Mahamalage","short_name":"C Mahamalage","first_name":"Chathurika Mahamalage","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"it","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":"Italy","role":"all","role_str":""},{"pid":121364,"title":"Dilaisha Nanayakkara","short_name":"D Nanayakkara","first_name":"Dilaisha Nanayakkara","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","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":"India","role":"all","role_str":""},{"pid":124049,"title":"Pasindi Kanankege","short_name":"P Kanankege","first_name":"Pasindi Kanankege","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"it","primary_team":[],"logo_url":"","playing_role":"bowl","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":"Italy","role":"bowl","role_str":""},{"pid":125176,"title":"Elspeth Fowler","short_name":"E Fowler","first_name":"Elspeth Fowler","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"es","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":"Spain","role":"bat","role_str":"(C)"},{"pid":134379,"title":"Payal Chilongia","short_name":"P Chilongia","first_name":"Payal Chilongia","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"es","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":"Spain","role":"bowl","role_str":""},{"pid":134380,"title":"Memoona Riaz","short_name":"M Riaz","first_name":"Memoona Riaz","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"es","primary_team":[],"logo_url":"","playing_role":"all","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":"Spain","role":"all","role_str":""},{"pid":139440,"title":"Teshani Araliya","short_name":"T Araliya","first_name":"Teshani Araliya","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"it","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":"Italy","role":"bowl","role_str":""},{"pid":139442,"title":"Andrea Davidson Soler","short_name":"A D Soler","first_name":"Andrea Davidson Soler","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"es","primary_team":[],"logo_url":"","playing_role":"bat","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":"Spain","role":"bat","role_str":""},{"pid":142572,"title":"Alexis Hartley","short_name":"A Hartley","first_name":"Alexis Hartley","last_name":"","middle_name":"","birthdate":"1985-06-28","birthplace":"","country":"es","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":"Spain","role":"all","role_str":""},{"pid":142573,"title":"Amelia Jones","short_name":"A Jones","first_name":"Amelia Jones","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"es","primary_team":[],"logo_url":"","playing_role":"wk","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":"Spain","role":"wk","role_str":"(WK)"}]},"etag":"5b8a866abd686257b3b6921c9ff14206","modified":"2025-06-14 00:55:18","datetime":"2025-06-14 00:55:18","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90175 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:2799d7c7-ecdd-4551-976c-ae5933fb8c54 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90175 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90175,3,'{"status":"ok","response":{"match_id":90175,"title":"Italy Women vs Spain Women","short_title":"ITA-W vs ESP-W","subtitle":"13th Match","match_number":"14","format":8,"format_str":"Women T20","status":2,"status_str":"Completed","status_note":"Italy Women won by 29 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":126802,"name":"Italy Women","short_name":"ITA-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121402.411.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121402.411.png","scores_full":"121\/9 (20 ov)","scores":"121\/9","overs":"20"},"teamb":{"team_id":124546,"name":"Spain Women","short_name":"ESP-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Spain.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Spain.png","scores_full":"92\/6 (20 ov)","scores":"92\/6","overs":"20"},"date_start":"2025-05-29 08:15:00","date_end":"2025-05-29 18:15:00","timestamp_start":1748506500,"timestamp_end":1748542500,"date_start_ist":"2025-05-29 13:45:00","date_end_ist":"2025-05-29 23:45:00","venue":{"venue_id":"473","name":"Roma Cricket Ground","location":"ROME","country":"ITALY","timezone":""},"umpires":"Mark Jameson (Germany), David McLean (Scotland)","referee":"Graham McCrea (Ireland)","equation":"","live":"","result":"ITA-W won by 29 runs","result_type":1,"win_margin":"29 runs","winning_team_id":126802,"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":"Italy Women elected to bat","winner":126802,"decision":1}},"etag":"b8467f56f130ab8a4647a57df0e83884","modified":"2025-06-14 00:55:19","datetime":"2025-06-14 00:55:19","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90175,"title":"Italy Women vs Spain Women","short_title":"ITA-W vs ESP-W","subtitle":"13th Match","match_number":"14","format":8,"format_str":"Women T20","status":2,"status_str":"Completed","status_note":"Italy Women won by 29 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":126802,"name":"Italy Women","short_name":"ITA-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121402.411.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121402.411.png","scores_full":"121\/9 (20 ov)","scores":"121\/9","overs":"20"},"teamb":{"team_id":124546,"name":"Spain Women","short_name":"ESP-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Spain.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Spain.png","scores_full":"92\/6 (20 ov)","scores":"92\/6","overs":"20"},"date_start":"2025-05-29 08:15:00","date_end":"2025-05-29 18:15:00","timestamp_start":1748506500,"timestamp_end":1748542500,"date_start_ist":"2025-05-29 13:45:00","date_end_ist":"2025-05-29 23:45:00","venue":{"venue_id":"473","name":"Roma Cricket Ground","location":"ROME","country":"ITALY","timezone":""},"umpires":"Mark Jameson (Germany), David McLean (Scotland)","referee":"Graham McCrea (Ireland)","equation":"","live":"","result":"ITA-W won by 29 runs","result_type":1,"win_margin":"29 runs","winning_team_id":126802,"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":"Italy Women elected to bat","winner":126802,"decision":1}},"etag":"b8467f56f130ab8a4647a57df0e83884","modified":"2025-06-14 00:55:19","datetime":"2025-06-14 00:55:19","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90175 AND DataTypeId = 3 END
Live Report & Scorecard of Italy Women vs Spain Women 13th Match