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:dc4e52d7-79e8-49a2-9310-b960476953fe
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 43839 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (43839,6,'{"status":"ok","response":{"player":{"pid":43839,"title":"Janith Liyanage","short_name":"J Liyanage","first_name":"Janith Liyanage","last_name":"","middle_name":"","birthdate":"1995-07-12","birthplace":"Colombo","country":"lk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"Sri Lanka"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":25,"innings":20,"notout":4,"runs":723,"balls":879,"highest":101,"run100":1,"run50":5,"run4":54,"run6":19,"average":"45.18","strike":"82.25","catches":3,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":3,"innings":3,"notout":0,"runs":28,"balls":45,"highest":11,"run100":0,"run50":0,"run4":0,"run6":0,"average":"9.33","strike":"62.22","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":73,"innings":68,"notout":7,"runs":1102,"balls":986,"highest":70,"run100":0,"run50":5,"run4":81,"run6":34,"average":"18.06","strike":"111.76","catches":29,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":112,"innings":102,"notout":19,"runs":3445,"balls":4140,"highest":130,"run100":5,"run50":21,"run4":224,"run6":104,"average":"41.50","strike":"83.21","catches":47,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":79,"innings":125,"notout":14,"runs":3983,"balls":7410,"highest":140,"run100":6,"run50":28,"run4":342,"run6":90,"average":"35.88","strike":"53.75","catches":46,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"3","innings":"1","notout":"1","runs":"6","balls":"3","highest":"6","run100":"0","run50":"0","run4":"1","run6":"0","average":"","strike":"200.00","catches":"2","stumpings":"0"}},"bowling":{"odi":{"match_id":0,"inning_id":0,"matches":25,"innings":13,"balls":212,"overs":35.2,"runs":206,"wickets":2,"bestinning":"1\/16","bestmatch":"1\/16","econ":"5.83","average":"103.00","strike":"106.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":3,"innings":0,"balls":0,"overs":0,"runs":0,"wickets":0,"bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":73,"innings":47,"balls":658,"overs":109.4,"runs":927,"wickets":32,"bestinning":"3\/17","bestmatch":"3\/17","econ":"8.45","average":"28.96","strike":"20.5","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":112,"innings":76,"balls":1920,"overs":320,"runs":1724,"wickets":50,"bestinning":"5\/29","bestmatch":"5\/29","econ":"5.38","average":"34.48","strike":"38.4","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":79,"innings":99,"balls":4998,"overs":833,"runs":2911,"wickets":72,"bestinning":"4\/18","bestmatch":"5\/31","econ":"3.49","average":"40.43","strike":"69.4","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"3","innings":"1","balls":"6","overs":"1","runs":"8","wickets":"0","bestinning":"0\/8","bestmatch":"","econ":"8.00","average":"","strike":"","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"4b2ef14d59ff1b0d11161df84f28cc25","modified":"2025-07-19 21:29:47","datetime":"2025-07-19 21:29:47","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":43839,"title":"Janith Liyanage","short_name":"J Liyanage","first_name":"Janith Liyanage","last_name":"","middle_name":"","birthdate":"1995-07-12","birthplace":"Colombo","country":"lk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"Sri Lanka"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":25,"innings":20,"notout":4,"runs":723,"balls":879,"highest":101,"run100":1,"run50":5,"run4":54,"run6":19,"average":"45.18","strike":"82.25","catches":3,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":3,"innings":3,"notout":0,"runs":28,"balls":45,"highest":11,"run100":0,"run50":0,"run4":0,"run6":0,"average":"9.33","strike":"62.22","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":73,"innings":68,"notout":7,"runs":1102,"balls":986,"highest":70,"run100":0,"run50":5,"run4":81,"run6":34,"average":"18.06","strike":"111.76","catches":29,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":112,"innings":102,"notout":19,"runs":3445,"balls":4140,"highest":130,"run100":5,"run50":21,"run4":224,"run6":104,"average":"41.50","strike":"83.21","catches":47,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":79,"innings":125,"notout":14,"runs":3983,"balls":7410,"highest":140,"run100":6,"run50":28,"run4":342,"run6":90,"average":"35.88","strike":"53.75","catches":46,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"3","innings":"1","notout":"1","runs":"6","balls":"3","highest":"6","run100":"0","run50":"0","run4":"1","run6":"0","average":"","strike":"200.00","catches":"2","stumpings":"0"}},"bowling":{"odi":{"match_id":0,"inning_id":0,"matches":25,"innings":13,"balls":212,"overs":35.2,"runs":206,"wickets":2,"bestinning":"1\/16","bestmatch":"1\/16","econ":"5.83","average":"103.00","strike":"106.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":3,"innings":0,"balls":0,"overs":0,"runs":0,"wickets":0,"bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":73,"innings":47,"balls":658,"overs":109.4,"runs":927,"wickets":32,"bestinning":"3\/17","bestmatch":"3\/17","econ":"8.45","average":"28.96","strike":"20.5","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":112,"innings":76,"balls":1920,"overs":320,"runs":1724,"wickets":50,"bestinning":"5\/29","bestmatch":"5\/29","econ":"5.38","average":"34.48","strike":"38.4","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":79,"innings":99,"balls":4998,"overs":833,"runs":2911,"wickets":72,"bestinning":"4\/18","bestmatch":"5\/31","econ":"3.49","average":"40.43","strike":"69.4","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"3","innings":"1","balls":"6","overs":"1","runs":"8","wickets":"0","bestinning":"0\/8","bestmatch":"","econ":"8.00","average":"","strike":"","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"4b2ef14d59ff1b0d11161df84f28cc25","modified":"2025-07-19 21:29:47","datetime":"2025-07-19 21:29:47","api_version":"3.0"}', Modified = GetDate() WHERE Id = 43839 AND DataTypeId = 6 END Player profile of Janith Liyanage, Sri Lanka
