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:c9699234-0d7b-4d54-8013-fb48c6dd87bb
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 52979 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (52979,6,'{"status":"ok","response":{"player":{"pid":52979,"title":"Obus Pienaar","short_name":"AJ Pienaar","first_name":"Obus Pienaar","last_name":"","middle_name":"","birthdate":"1989-12-12","birthplace":"Bloemfontein, Orange Free State","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/opienaar\/","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"South Africa"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":73,"innings":56,"notout":15,"runs":900,"balls":797,"highest":43,"run100":0,"run50":0,"run4":83,"run6":17,"average":"21.95","strike":"112.92","catches":22,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":96,"innings":89,"notout":21,"runs":2698,"balls":3147,"highest":141,"run100":3,"run50":18,"run4":232,"run6":38,"average":"39.67","strike":"85.73","catches":57,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":95,"innings":152,"notout":19,"runs":6038,"balls":10084,"highest":212,"run100":17,"run50":28,"run4":825,"run6":62,"average":"45.39","strike":"59.87","catches":58,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"18","innings":"16","notout":"4","runs":"555","balls":"249","highest":"69","run100":"0","run50":"4","run4":"42","run6":"43","average":"46.25","strike":"222.89","catches":"8","stumpings":"0"}},"bowling":{"t20":{"match_id":0,"inning_id":0,"matches":73,"innings":26,"balls":266,"overs":44.2,"runs":306,"wickets":9,"bestinning":"2\/14","bestmatch":"2\/14","econ":"6.90","average":"34.00","strike":"29.5","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":96,"innings":52,"balls":1521,"overs":253.3,"runs":1316,"wickets":35,"bestinning":"5\/15","bestmatch":"5\/15","econ":"5.19","average":"37.60","strike":"43.4","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":95,"innings":108,"balls":6293,"overs":1048.5,"runs":3373,"wickets":117,"bestinning":"5\/27","bestmatch":"9\/168","econ":"3.21","average":"28.82","strike":"53.7","wicket4i":6,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"18","innings":"16","balls":"168","overs":"28","runs":"226","wickets":"10","bestinning":"1\/13","bestmatch":"1\/13","econ":"8.07","average":"22.60","strike":"16.80","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"f1c48cb3054f92f3158d6377ce6aa0c4","modified":"2025-06-26 13:53:25","datetime":"2025-06-26 13:53:25","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":52979,"title":"Obus Pienaar","short_name":"AJ Pienaar","first_name":"Obus Pienaar","last_name":"","middle_name":"","birthdate":"1989-12-12","birthplace":"Bloemfontein, Orange Free State","country":"za","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"https:\/\/www.facebook.com\/opienaar\/","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"South Africa"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":73,"innings":56,"notout":15,"runs":900,"balls":797,"highest":43,"run100":0,"run50":0,"run4":83,"run6":17,"average":"21.95","strike":"112.92","catches":22,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":96,"innings":89,"notout":21,"runs":2698,"balls":3147,"highest":141,"run100":3,"run50":18,"run4":232,"run6":38,"average":"39.67","strike":"85.73","catches":57,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":95,"innings":152,"notout":19,"runs":6038,"balls":10084,"highest":212,"run100":17,"run50":28,"run4":825,"run6":62,"average":"45.39","strike":"59.87","catches":58,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"18","innings":"16","notout":"4","runs":"555","balls":"249","highest":"69","run100":"0","run50":"4","run4":"42","run6":"43","average":"46.25","strike":"222.89","catches":"8","stumpings":"0"}},"bowling":{"t20":{"match_id":0,"inning_id":0,"matches":73,"innings":26,"balls":266,"overs":44.2,"runs":306,"wickets":9,"bestinning":"2\/14","bestmatch":"2\/14","econ":"6.90","average":"34.00","strike":"29.5","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":96,"innings":52,"balls":1521,"overs":253.3,"runs":1316,"wickets":35,"bestinning":"5\/15","bestmatch":"5\/15","econ":"5.19","average":"37.60","strike":"43.4","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":95,"innings":108,"balls":6293,"overs":1048.5,"runs":3373,"wickets":117,"bestinning":"5\/27","bestmatch":"9\/168","econ":"3.21","average":"28.82","strike":"53.7","wicket4i":6,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"18","innings":"16","balls":"168","overs":"28","runs":"226","wickets":"10","bestinning":"1\/13","bestmatch":"1\/13","econ":"8.07","average":"22.60","strike":"16.80","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"f1c48cb3054f92f3158d6377ce6aa0c4","modified":"2025-06-26 13:53:25","datetime":"2025-06-26 13:53:25","api_version":"3.0"}', Modified = GetDate() WHERE Id = 52979 AND DataTypeId = 6 END Player profile of Obus Pienaar, South Africa
