User profile for DucNguyen – Support

Activity overview Badges (0) Posts (0) Comments (1)

Activity overview

Latest activity by DucNguyen

I run trial newest SQLPrompt_10.13.7.360 and new SSMS 19.0.2 and I have similar error and this is log i read from logs folder. I think after change from old SSMS and to new SSMS file sqlhistory.db has error 2023-05-01 16:45:14.435 +07:00 [Information] Logging level set to 'Information' 2023-05-01 16:45:14.744 +07:00 [Information] Started successfully with identifier 'NbMNXQ7b8eUNZgI/tvdzpFniLMchsRJnuoHGvPL7QEw=' 2023-05-01 16:45:28.455 +07:00 [Fatal] Error initializing server code = Constraint (19), message = System.Data.SQLite.SQLiteException (0x800027AF): constraint failed FOREIGN KEY constraint failed at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt) at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt) at System.Data.SQLite.SQLiteDataReader.NextResult() at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave) at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior) at RedGate.SqlPrompt.SqlHistory.Storage.Upgrades.Migrations.Migration.Run(IDbCommand command) at RedGate.SqlPrompt.SqlHistory.Storage.Upgrades.SchemaUpgrader.RunSchemaMigration(IDbConnection connection, Int64 fromVersion) at RedGate.SqlPrompt.SqlHistory.Storage.Upgrades.SchemaUpgrader.UpgradeToLatestVersion(IDbConnection connection) at RedGate.SqlPrompt.SqlHistory.Storage.StoreInitializer.InitializeInner(String tabHistoryPath, String sqlHistoryPath) at RedGate.SqlPrompt.SqlHistory.Storage.StoreInitializer.Initialize(String tabHistoryPath, String sqlHistoryPath) 2023-05-01 16:45:28.665 +07:00 [Error] Error processing query: GetQueryVersions System.NotSupportedException: Unknown save reason QueryClosed at RedGate.SqlPrompt.SqlHistory.Storage.SaveReasonConverter.ToSaveReason(String saveReason) at RedGate.SqlPrompt.SqlHistory.Storage.Queries.Sql.GetQueryVersion.CreateQueryVersion(IDataReader reader) at RedGate.SqlPrompt.SqlHistory.Storage.Queries.Sql.GetQueryVersions.<Run>d__2.MoveNext() at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) at RedGate.SqlPrompt.SqlHistory.Storage.Queries.QueryStore.GetQueryVersions(Guid queryIdentity) at RedGate.SqlPrompt.SqlHistory.Server.Queries.QueryProcessor.Handle(QueryOperation operation) 2023-05-01 16:45:28.666 +07:00 [Information] Skipping indexing due to an up-to-date index 2023-05-01 16:45:28.672 +07:00 [Error] Error serializing operation result json: System.NullReferenceException: Object reference not set to an instance of an object. at RedGate.SqlPrompt.SqlHistory.Messaging.NamedPipeStream.Write(String message) at RedGate.SqlPrompt.SqlHistory.Server.NamedPipeListener.ProcessQuery(INamedPipeStream stream, QueryOperation operation) System.NullReferenceException: Object reference not set to an instance of an object. at RedGate.SqlPrompt.SqlHistory.Messaging.NamedPipeStream.Write(String message) at RedGate.SqlPrompt.SqlHistory.Server.NamedPipeListener.ProcessQuery(INamedPipeStream stream, QueryOperation operation) 2023-05-01 16:45:28.683 +07:00 [Information] Killing process 'RedGate.SqlPrompt.SqlHistory.Server' / comments

I run trial newest SQLPrompt_10.13.7.360 and new SSMS 19.0.2 and I have similar error and this is log i read from logs folder. I think after change from old SSMS and to new SSMS file sqlhistory.db ...

0 votes

Total activity: 2
Last activity: February 06, 2025 12:06
Member since: February 06, 2025 12:06

Following: 0 users
Followed by: 0 users
Votes: 0
Subscriptions: 1