How can we help you today? How can we help you today?
trek_madone
Activity overview Badges (0) Posts (1) Comments (6)

Comments

Sort by recent activity
No update and support stopped responding. I think this is now a known issue but RedGate is ignoring it. / comments
  1. Community
  2. SQL Prompt
  3. SQL History not showing anything
No update and support stopped responding.I think this is now a known issue but RedGate is ignoring it.
0 votes
Hi @Dan_J Unfortunately, I can't provide you the SQLHistory.db. It's against our company policy. I think the log I provided above should be enough for your developers to start looking into this issue.  / comments
  1. Community
  2. SQL Prompt
  3. SQL History not showing anything
Hi @Dan_J Unfortunately, I can't provide you the SQLHistory.db. It's against our company policy. I think the log I provided above should be enough for your developers to start looking into this iss...
0 votes
Hi @Dan_J Any update on this? / comments
  1. Community
  2. SQL Prompt
  3. SQL History not showing anything
Hi @Dan_J Any update on this?
0 votes
Same version: [image] [image] / comments
  1. Community
  2. SQL Prompt
  3. SQL History not showing anything
Same version:
0 votes
Hi @Dan_J, I have both SSMS 18.12.1 and 19.2. I recently installed 19.2 to try if it's working on this version but it's same behavior. Sorry but I cannot send you log files because it's against our company policy. However, I have this error and it's consistent with all the logs: ~~~~~~~~~~~~~~~~~~~~~ 2024-01-05 15:23:50.525 -06:00 [Information] Logging level set to 'Information' 2024-01-05 15:23:50.646 -06:00 [Information] Started successfully with identifier '***removed***' 2024-01-05 15:23:50.792 -06:00 [Error] Error converting message to object: {   "clientIdentifier": "***removed***",   "queryIdentity": "***removed***",   "name": "SQLQuery3.sql",   "path": "C:\\Users\\***removed***\\AppData\\Local\\Temp\\~vsE565.sql",   "contents": "***removed***",   "connection": {     "server": "***removed***",     "serverType": "***removed***",     "authenticationType": "WindowsAuthentication",     "database": "***removed***",     "userName": "***removed***",     "advancedOptions": {       "connectioN_TIMEOUT": "30",       "exeC_TIMEOUT": "0",       "packeT_SIZE": "4096",       "encrypT_CONNECTION": "False",       "trusT_SERVER_CERTIFICATE": "False",       "usE_CUSTOM_CONNECTION_COLOR": "False",       "custoM_CONNECTION_COLOR": "-986896",       "usE_CUSTOM_TENANT_ID": "False",       "custoM_TENANT_ID": "",       "database": "***removed***"     }   },   "saveReason": "QueryEdited" } Newtonsoft.Json.JsonSerializationException: Cannot deserialize the current JSON object (e.g. {"name":"value"}) into type 'System.Collections.Generic.IReadOnlyDictionary`2[System.String,System.String]' because the type requires a JSON array (e.g. [1,2,3]) to deserialize correctly. To fix this error either change the JSON to a JSON array (e.g. [1,2,3]) or change the deserialized type so that it is a normal .NET type (e.g. not a primitive type like integer, not a collection type like an array or List<T>) that can be deserialized from a JSON object. JsonObjectAttribute can also be added to the type to force it to deserialize from a JSON object. Path 'operation.message.connection.advancedOptions.connectioN_TIMEOUT', line 1, position 635.    at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateObject(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)    at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateValueInternal(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)    at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.ResolvePropertyAndCreatorValues(JsonObjectContract contract, JsonProperty containerProperty, JsonReader reader, Type objectType)    at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateObjectUsingCreatorWithParameters(JsonReader reader, JsonObjectContract contract, JsonProperty containerProperty, ObjectConstructor`1 creator, String id)    at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateObject(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)    at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateValueInternal(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)    at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.ResolvePropertyAndCreatorValues(JsonObjectContract contract, JsonProperty containerProperty, JsonReader reader, Type objectType)    at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateObjectUsingCreatorWithParameters(JsonReader reader, JsonObjectContract contract, JsonProperty containerProperty, ObjectConstructor`1 creator, String id)    at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateObject(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)    at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateValueInternal(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)    at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize(JsonReader reader, Type objectType, Boolean checkAdditionalContent)    at Newtonsoft.Json.JsonSerializer.DeserializeInternal(JsonReader reader, Type objectType)    at Newtonsoft.Json.Linq.JToken.ToObject(Type objectType, JsonSerializer jsonSerializer)    at Newtonsoft.Json.Linq.JToken.ToObject(Type objectType)    at Newtonsoft.Json.Linq.JToken.ToObject[T]()    at RedGate.SqlPrompt.SqlHistory.Server.OperationConverter.<CreateCommandOperation>g__ToCommandMessage|3_0[T](JObject jObject) 2024-01-05 15:23:50.825 -06:00 [Error] Error deserializing operation json: Newtonsoft.Json.JsonSerializationException: Cannot deserialize the current JSON object (e.g. {"name":"value"}) into type 'System.Collections.Generic.IReadOnlyDictionary`2[System.String,System.String]' because the type requires a JSON array (e.g. [1,2,3]) to deserialize correctly. To fix this error either change the JSON to a JSON array (e.g. [1,2,3]) or change the deserialized type so that it is a normal .NET type (e.g. not a primitive type like integer, not a collection type like an array or List<T>) that can be deserialized from a JSON object. JsonObjectAttribute can also be added to the type to force it to deserialize from a JSON object. Path 'operation.message.connection.advancedOptions.connectioN_TIMEOUT', line 1, position 635.    at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateObject(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)    at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateValueInternal(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)    at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.ResolvePropertyAndCreatorValues(JsonObjectContract contract, JsonProperty containerProperty, JsonReader reader, Type objectType)    at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateObjectUsingCreatorWithParameters(JsonReader reader, JsonObjectContract contract, JsonProperty containerProperty, ObjectConstructor`1 creator, String id)    at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateObject(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)    at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateValueInternal(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)    at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.ResolvePropertyAndCreatorValues(JsonObjectContract contract, JsonProperty containerProperty, JsonReader reader, Type objectType)    at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateObjectUsingCreatorWithParameters(JsonReader reader, JsonObjectContract contract, JsonProperty containerProperty, ObjectConstructor`1 creator, String id)    at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateObject(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)    at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateValueInternal(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)    at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize(JsonReader reader, Type objectType, Boolean checkAdditionalContent)    at Newtonsoft.Json.JsonSerializer.DeserializeInternal(JsonReader reader, Type objectType)    at Newtonsoft.Json.Linq.JToken.ToObject(Type objectType, JsonSerializer jsonSerializer)    at Newtonsoft.Json.Linq.JToken.ToObject(Type objectType)    at Newtonsoft.Json.Linq.JToken.ToObject[T]()    at RedGate.SqlPrompt.SqlHistory.Server.OperationConverter.<CreateCommandOperation>g__ToCommandMessage|3_0[T](JObject jObject)    at RedGate.SqlPrompt.SqlHistory.Server.OperationConverter.CreateCommandOperation(JObject jObject)    at RedGate.SqlPrompt.SqlHistory.Server.OperationConverter.ReadJson(JsonReader reader, Type objectType, IOperation existingValue, Boolean hasExistingValue, JsonSerializer serializer)    at Newtonsoft.Json.JsonConverter`1.ReadJson(JsonReader reader, Type objectType, Object existingValue, JsonSerializer serializer)    at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.DeserializeConvertable(JsonConverter converter, JsonReader reader, Type objectType, Object existingValue)    at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize(JsonReader reader, Type objectType, Boolean checkAdditionalContent)    at Newtonsoft.Json.JsonSerializer.DeserializeInternal(JsonReader reader, Type objectType)    at Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings)    at Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value, JsonConverter[] converters)    at RedGate.SqlPrompt.SqlHistory.Server.NamedPipeListener.ProcessOperationJson(String input, INamedPipeStream stream) / comments
  1. Community
  2. SQL Prompt
  3. SQL History not showing anything
Hi @Dan_J,I have both SSMS 18.12.1 and 19.2. I recently installed 19.2 to try if it's working on this version but it's same behavior.Sorry but I cannot send you log files because it's against our c...
0 votes
Hi Dan, Thanks for your response. I am using Windows Authentication. Advanced Search also shows nothing. [image] [image] If I uncheck the state Open, I get few results, but I can't open them either, throws an error. [image] [image] / comments
  1. Community
  2. SQL Prompt
  3. SQL History not showing anything
Hi Dan,Thanks for your response.I am using Windows Authentication.Advanced Search also shows nothing.If I uncheck the state Open, I get few results, but I can't open them either, throws an error.
0 votes
Total activity
8
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1