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:01be0523-1ac7-4a9d-90d6-66ece2754b9b
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 725 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (725,6,'{"status":"ok","response":{"player":{"pid":725,"title":"David Wiese","short_name":"D Wiese","first_name":"David Wiese","last_name":"","middle_name":"","birthdate":"1985-05-18","birthplace":"Roodepoort","country":"za","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/David_Wiese","instagram_profile":"https:\/\/www.instagram.com\/davidwiese96\/","debut_data":"","thumb_url":"","nationality":"South Africa"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":15,"innings":15,"notout":2,"runs":330,"balls":369,"highest":67,"run100":0,"run50":1,"run4":21,"run6":10,"average":"25.38","strike":"89.43","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":54,"innings":40,"notout":14,"runs":624,"balls":488,"highest":66,"run100":0,"run50":3,"run4":35,"run6":30,"average":"24.00","strike":"127.86","catches":20,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":397,"innings":297,"notout":103,"runs":4464,"balls":3086,"highest":79,"run100":0,"run50":12,"run4":296,"run6":245,"average":"23.01","strike":"144.65","catches":146,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":162,"innings":139,"notout":28,"runs":3939,"balls":3453,"highest":171,"run100":2,"run50":22,"run4":349,"run6":156,"average":"35.48","strike":"114.07","catches":50,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":124,"innings":194,"notout":20,"runs":5814,"balls":8190,"highest":208,"run100":11,"run50":32,"run4":811,"run6":101,"average":"33.41","strike":"70.98","catches":70,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"45","innings":"24","notout":"13","runs":"381","balls":"177","highest":"43","run100":"0","run50":"0","run4":"19","run6":"37","average":"34.64","strike":"215.25","catches":"18","stumpings":"0"}},"bowling":{"odi":{"match_id":0,"inning_id":0,"matches":15,"innings":15,"balls":737,"overs":122.5,"runs":686,"wickets":15,"bestinning":"3\/50","bestmatch":"3\/50","econ":"5.58","average":"45.73","strike":"49.1","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":54,"innings":54,"balls":1084,"overs":180.4,"runs":1299,"wickets":59,"bestinning":"5\/23","bestmatch":"5\/23","econ":"7.19","average":"22.01","strike":"18.3","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":397,"innings":354,"balls":6111,"overs":1018.3,"runs":8367,"wickets":324,"bestinning":"5\/19","bestmatch":"5\/19","econ":"8.21","average":"25.82","strike":"18.8","wicket4i":5,"wicket5i":7,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":162,"innings":149,"balls":6173,"overs":1028.5,"runs":5568,"wickets":146,"bestinning":"5\/25","bestmatch":"5\/25","econ":"5.41","average":"38.13","strike":"42.2","wicket4i":3,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":124,"innings":219,"balls":18071,"overs":3011.5,"runs":9643,"wickets":344,"bestinning":"6\/58","bestmatch":"10\/111","econ":"3.20","average":"28.03","strike":"52.5","wicket4i":17,"wicket5i":10,"wicket10m":1,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"45","innings":"18","balls":"129","overs":"21.3","runs":"233","wickets":"9","bestinning":"2\/15","bestmatch":"2\/15","econ":"10.84","average":"25.89","strike":"14.33","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"6fabb3f3e0ce479a687c446230d2211e","modified":"2025-06-24 05:37:24","datetime":"2025-06-24 05:37:24","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":725,"title":"David Wiese","short_name":"D Wiese","first_name":"David Wiese","last_name":"","middle_name":"","birthdate":"1985-05-18","birthplace":"Roodepoort","country":"za","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/David_Wiese","instagram_profile":"https:\/\/www.instagram.com\/davidwiese96\/","debut_data":"","thumb_url":"","nationality":"South Africa"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":15,"innings":15,"notout":2,"runs":330,"balls":369,"highest":67,"run100":0,"run50":1,"run4":21,"run6":10,"average":"25.38","strike":"89.43","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":54,"innings":40,"notout":14,"runs":624,"balls":488,"highest":66,"run100":0,"run50":3,"run4":35,"run6":30,"average":"24.00","strike":"127.86","catches":20,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":397,"innings":297,"notout":103,"runs":4464,"balls":3086,"highest":79,"run100":0,"run50":12,"run4":296,"run6":245,"average":"23.01","strike":"144.65","catches":146,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":162,"innings":139,"notout":28,"runs":3939,"balls":3453,"highest":171,"run100":2,"run50":22,"run4":349,"run6":156,"average":"35.48","strike":"114.07","catches":50,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":124,"innings":194,"notout":20,"runs":5814,"balls":8190,"highest":208,"run100":11,"run50":32,"run4":811,"run6":101,"average":"33.41","strike":"70.98","catches":70,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"45","innings":"24","notout":"13","runs":"381","balls":"177","highest":"43","run100":"0","run50":"0","run4":"19","run6":"37","average":"34.64","strike":"215.25","catches":"18","stumpings":"0"}},"bowling":{"odi":{"match_id":0,"inning_id":0,"matches":15,"innings":15,"balls":737,"overs":122.5,"runs":686,"wickets":15,"bestinning":"3\/50","bestmatch":"3\/50","econ":"5.58","average":"45.73","strike":"49.1","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":54,"innings":54,"balls":1084,"overs":180.4,"runs":1299,"wickets":59,"bestinning":"5\/23","bestmatch":"5\/23","econ":"7.19","average":"22.01","strike":"18.3","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":397,"innings":354,"balls":6111,"overs":1018.3,"runs":8367,"wickets":324,"bestinning":"5\/19","bestmatch":"5\/19","econ":"8.21","average":"25.82","strike":"18.8","wicket4i":5,"wicket5i":7,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":162,"innings":149,"balls":6173,"overs":1028.5,"runs":5568,"wickets":146,"bestinning":"5\/25","bestmatch":"5\/25","econ":"5.41","average":"38.13","strike":"42.2","wicket4i":3,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":124,"innings":219,"balls":18071,"overs":3011.5,"runs":9643,"wickets":344,"bestinning":"6\/58","bestmatch":"10\/111","econ":"3.20","average":"28.03","strike":"52.5","wicket4i":17,"wicket5i":10,"wicket10m":1,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"45","innings":"18","balls":"129","overs":"21.3","runs":"233","wickets":"9","bestinning":"2\/15","bestmatch":"2\/15","econ":"10.84","average":"25.89","strike":"14.33","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"6fabb3f3e0ce479a687c446230d2211e","modified":"2025-06-24 05:37:24","datetime":"2025-06-24 05:37:24","api_version":"3.0"}', Modified = GetDate() WHERE Id = 725 AND DataTypeId = 6 END Player profile of David Wiese, South Africa
