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:c467fbcd-74a2-405c-a168-eb98e19fd541
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 599 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (599,6,'{"status":"ok","response":{"player":{"pid":599,"title":"Yusuf Pathan","short_name":"Y Pathan","first_name":"Yusuf Pathan","last_name":"","middle_name":"","birthdate":"1982-11-17","birthplace":"Baroda, Gujarat","country":"in","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":8.5,"facebook_profile":"https:\/\/www.facebook.com\/OfficialYusufPathan\/","twitter_profile":"https:\/\/twitter.com\/iamyusufpathan?ref_src=twsrc%5Egoogle%7Ctwcamp%5Eserp%7Ctwgr%5Eauthor","instagram_profile":"https:\/\/www.instagram.com\/yusuf_pathan\/","debut_data":"","thumb_url":"","nationality":"India"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":57,"innings":41,"notout":11,"runs":810,"balls":713,"highest":123,"run100":2,"run50":3,"run4":62,"run6":43,"average":"27.00","strike":"113.60","catches":17,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":22,"innings":18,"notout":5,"runs":236,"balls":161,"highest":37,"run100":0,"run50":0,"run4":11,"run6":17,"average":"18.15","strike":"146.58","catches":9,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":274,"innings":243,"notout":67,"runs":4852,"balls":3482,"highest":100,"run100":1,"run50":21,"run4":376,"run6":243,"average":"27.56","strike":"139.34","catches":86,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":199,"innings":175,"notout":33,"runs":4797,"balls":4344,"highest":148,"run100":9,"run50":28,"run4":0,"run6":0,"average":"33.78","strike":"110.42","catches":83,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":100,"innings":158,"notout":18,"runs":4825,"balls":5611,"highest":210,"run100":11,"run50":20,"run4":0,"run6":0,"average":"34.46","strike":"85.99","catches":80,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"17","innings":"14","notout":"4","runs":"343","balls":"169","highest":"80","run100":"0","run50":"1","run4":"28","run6":"25","average":"34.30","strike":"202.96","catches":"4","stumpings":"0"}},"bowling":{"odi":{"match_id":0,"inning_id":0,"matches":57,"innings":50,"balls":1490,"overs":248.2,"runs":1365,"wickets":33,"bestinning":"3\/49","bestmatch":"3\/49","econ":"5.49","average":"41.36","strike":"45.1","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":22,"innings":17,"balls":305,"overs":50.5,"runs":438,"wickets":13,"bestinning":"2\/22","bestmatch":"2\/22","econ":"8.61","average":"33.69","strike":"23.4","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":274,"innings":140,"balls":2210,"overs":368.2,"runs":2814,"wickets":99,"bestinning":"4\/10","bestmatch":"4\/10","econ":"7.63","average":"28.42","strike":"22.3","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":199,"innings":0,"balls":6034,"overs":1005.4,"runs":5133,"wickets":124,"bestinning":"5\/52","bestmatch":"5\/52","econ":"5.10","average":"41.39","strike":"48.6","wicket4i":2,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":100,"innings":0,"balls":13384,"overs":2230.4,"runs":6568,"wickets":201,"bestinning":"6\/40","bestmatch":"","econ":"2.94","average":"32.67","strike":"66.5","wicket4i":5,"wicket5i":14,"wicket10m":2,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"17","innings":"2","balls":"16","overs":"2.4","runs":"25","wickets":"2","bestinning":"0\/2","bestmatch":"","econ":"9.38","average":"12.50","strike":"8.00","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"c88290f432b1749fbbe5edcb3580645c","modified":"2025-06-13 21:43:21","datetime":"2025-06-13 21:43:21","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":599,"title":"Yusuf Pathan","short_name":"Y Pathan","first_name":"Yusuf Pathan","last_name":"","middle_name":"","birthdate":"1982-11-17","birthplace":"Baroda, Gujarat","country":"in","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":8.5,"facebook_profile":"https:\/\/www.facebook.com\/OfficialYusufPathan\/","twitter_profile":"https:\/\/twitter.com\/iamyusufpathan?ref_src=twsrc%5Egoogle%7Ctwcamp%5Eserp%7Ctwgr%5Eauthor","instagram_profile":"https:\/\/www.instagram.com\/yusuf_pathan\/","debut_data":"","thumb_url":"","nationality":"India"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":57,"innings":41,"notout":11,"runs":810,"balls":713,"highest":123,"run100":2,"run50":3,"run4":62,"run6":43,"average":"27.00","strike":"113.60","catches":17,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":22,"innings":18,"notout":5,"runs":236,"balls":161,"highest":37,"run100":0,"run50":0,"run4":11,"run6":17,"average":"18.15","strike":"146.58","catches":9,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":274,"innings":243,"notout":67,"runs":4852,"balls":3482,"highest":100,"run100":1,"run50":21,"run4":376,"run6":243,"average":"27.56","strike":"139.34","catches":86,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":199,"innings":175,"notout":33,"runs":4797,"balls":4344,"highest":148,"run100":9,"run50":28,"run4":0,"run6":0,"average":"33.78","strike":"110.42","catches":83,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":100,"innings":158,"notout":18,"runs":4825,"balls":5611,"highest":210,"run100":11,"run50":20,"run4":0,"run6":0,"average":"34.46","strike":"85.99","catches":80,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"17","innings":"14","notout":"4","runs":"343","balls":"169","highest":"80","run100":"0","run50":"1","run4":"28","run6":"25","average":"34.30","strike":"202.96","catches":"4","stumpings":"0"}},"bowling":{"odi":{"match_id":0,"inning_id":0,"matches":57,"innings":50,"balls":1490,"overs":248.2,"runs":1365,"wickets":33,"bestinning":"3\/49","bestmatch":"3\/49","econ":"5.49","average":"41.36","strike":"45.1","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":22,"innings":17,"balls":305,"overs":50.5,"runs":438,"wickets":13,"bestinning":"2\/22","bestmatch":"2\/22","econ":"8.61","average":"33.69","strike":"23.4","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":274,"innings":140,"balls":2210,"overs":368.2,"runs":2814,"wickets":99,"bestinning":"4\/10","bestmatch":"4\/10","econ":"7.63","average":"28.42","strike":"22.3","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":199,"innings":0,"balls":6034,"overs":1005.4,"runs":5133,"wickets":124,"bestinning":"5\/52","bestmatch":"5\/52","econ":"5.10","average":"41.39","strike":"48.6","wicket4i":2,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":100,"innings":0,"balls":13384,"overs":2230.4,"runs":6568,"wickets":201,"bestinning":"6\/40","bestmatch":"","econ":"2.94","average":"32.67","strike":"66.5","wicket4i":5,"wicket5i":14,"wicket10m":2,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"17","innings":"2","balls":"16","overs":"2.4","runs":"25","wickets":"2","bestinning":"0\/2","bestmatch":"","econ":"9.38","average":"12.50","strike":"8.00","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"c88290f432b1749fbbe5edcb3580645c","modified":"2025-06-13 21:43:21","datetime":"2025-06-13 21:43:21","api_version":"3.0"}', Modified = GetDate() WHERE Id = 599 AND DataTypeId = 6 END Player profile of Yusuf Pathan, India