Best Of
Re: SQL Prompt
Hi there,
Thank you for you post.
If you are using SQL Prompt 10 then you would need to be on SSMS 18.
Prior versions are not compatible. If you need to use SSMS 16 then you will need an older version like SQL Prompt 9
Ben_P
1 ·
Re: "A duplicate definition was found for the stored procedure '[dbo].[sproc_name]'.
Note 3: I tried deleting the stored procedure '[dbo].[sproc_name]'.from the database I was trying to link source code to, but got the same error for the same sproc.
stone
1 ·
Re: "A duplicate definition was found for the stored procedure '[dbo].[sproc_name]'.
Note: Here is the remaining sentences in the error message:
Ensure that case sensitivity options are set correctly and all object creation scripts are valid.If the problem persists, contact Redgate support.
at RedGate.SQLCompare.Engine.DatabaseObjectExistsException.ThrowIfDuplicateObject[T](String key, Dictionary`2 existingObjects, T dbObject, Func`2 getObjectNameForException)
at RedGate.SQLCompare.Engine.SerializableDatabaseObjectCollection`1.Add(T value)
at RedGate.SQLCompare.Engine.StoredProcedures.Add(StoredProcedure value)
at RedGate.SQLCompare.Engine.ReadFromFolder.ReadScriptAnalysis.ProcessNodeCreateOrAlterProcedure(Element currentNode)
at RedGate.SQLCompare.Engine.ReadFromFolder.ReadScriptAnalysis.TraverseNode(AST node)
at RedGate.SQLCompare.Engine.ReadFromFolder.ReadScriptAnalysis.TraverseNode(AST node)
at RedGate.SQLCompare.Engine.ReadFromFolder.ReadScriptAnalysis.VisitNode(Element node, AnalysisProvider`1 provider)
at RedGate.SQLCompare.Rewriter.Analysis.Analyser`1.AnalyseNode(Element root)
at RedGate.SQLCompare.Rewriter.Analysis.Analyser`1.Analyse(IEnumerable`1 elements)
at RedGate.SQLCompare.Engine.ReadFromFolder.DatabaseFromParseResultPopulator.AddToModel(FileInfo file, ParseResult parseResult, ReadScriptAnalysis analysis, LazyFileContents fullFileText, Boolean throwOnFileParseFailed, List`1 parserMessages)
at RedGate.SQLCompare.Engine.ReadFromFolder.DatabaseFromParseResultPopulator.Populate(ParseResult parseResult)
at RedGate.SQLCompare.Engine.ReadFromFolder.DatabaseFromScriptFilesPopulator.AddFromFiles(List`1 sortedFiles)
at RedGate.SQLCompare.Engine.ReadFromFolder.DatabaseFromScriptFilesPopulator.Populate(IEnumerable`1 filesToUse)
at RedGate.SQLCompare.Engine.Model.DatabaseObjects.DatabaseFromFolderPopulator.DatabaseFromFolderPopulator.PopulateFromFolder(Database database, DirectoryInfo path, ScriptDatabaseInformation dbinfo, Options options, IEnumerable`1 filesToUse, IReadFromFolderCache cache, CancellationToken cancellationToken)
at RedGate.SQLCompare.Engine.Model.DatabaseObjects.DatabaseFromFolderPopulator.DatabaseFromFolderPopulator.Populate(String path, CancellationToken cancellationToken)
at RedGate.SQLSourceControl.Engine.CompareEngineImpl.Registration.Incremental.ScriptsFolder.DatabaseFromSnapshotCachePopulator.Populate(String path, CancellationToken cancellationToken)
at RedGate.SQLCompare.Engine.Database.<>c__DisplayClass126_0.<Register>b__0()
at RedGate.SQLCompare.Engine.Utils.GetTimeToRun[T](Func`1 action)
at RedGate.SQLCompare.Engine.Database.Register(String path, ScriptDatabaseInformation dbinfo, Nullable`1 optionsParam, IEnumerable`1 filesToUse, IReadFromFolderCache cache, IDatabaseFromFolderPopulator databasePopulator)
at RedGate.SQLSourceControl.Engine.CompareEngineImpl.Compare.CompareDatabase.RegisterScriptsFolder(DirectoryInfo path, ICompareScriptDatabaseInformation scriptFolderOptions, ICompareOptions options)
at RedGate.SQLSourceControl.Engine.Diff.DiffBuildSessions.CompareDatabaseRegistrar.<>c__DisplayClass4_0.<Register>b__0()
at RedGate.SQLSourceControl.Engine.Utils.Task.SharedUtilsUtils.DoActionWithCancel(ICancellableOperationStatus status, ICancellable cancellable, Action action)
at RedGate.SQLSourceControl.Engine.Diff.DiffBuildSessions.CompareDatabaseRegistrar.Register(ScriptsFolderDatabaseSource source, ICancellableOperationStatus status)
at RedGate.SQLSourceControl.Engine.Diff.DiffBuildSessions.SocDatabaseRegistrar.Register(ScriptsFolderDatabaseSource databaseSource, ICancellableOperationStatus status)
at RedGate.SQLSourceControl.Engine.Diff.DiffBuildSessions.TwoWorkspaceRegistrar.<>c__DisplayClass14_0.<GetRegisterWorkspacesActions>b__0(ICancellableOperationStatus s)
at RedGate.SQLSourceControl.Engine.Utils.Task.NamedOperation.Operation(ICancellableOperationStatus cancellableOperation)
at RedGate.SQLSourceControl.Engine.Utils.Task.CancellableUtils.<>c__DisplayClass3_0.<StartTask>b__0()
at RedGate.SQLSourceControl.Engine.Utils.Task.CancellableUtils.ExceptionHandler.ThrowIfErrored()
at RedGate.SQLSourceControl.Engine.Utils.Task.CancellableUtils.DoInParallel(ICancellableOperationStatus status, INamedOperation[] namedActions)
at RedGate.SQLSourceControl.Engine.Diff.DiffBuildSessions.TwoWorkspaceRegistrar.RegisterWorkspaces(IWorkspaces workspaces, ICompareScriptDatabaseInformation scriptDatabaseInformation)
at RedGate.SQLSourceControl.Engine.Diff.DiffBuildSessions.ThreeWayDiffSession.RegisterWorkspaces(IWorkspaces workspaces, SourceControlRevision transientRevision)
at RedGate.SQLSourceControl.Engine.Diff.DiffBuildSessions.ThreeWayDiffSession.BuildCommon()
at RedGate.SQLSourceControl.Engine.Diff.DiffBuildSessions.DiffBuilder.GetChangeSetResolvingNoOps[T](String source, IBoundDatabase boundDatabase, IChangeSetFactory`1 changeSetFactory, ICancellableOperationStatus status, SourceControlOperation sourceControlOperation)
at RedGate.SQLSourceControl.Engine.Diff.DiffBuildSessions.DiffBuilder.BuildToCommitChangeSet(IBoundDatabase boundDatabase, ICancellableOperationStatus status)
at RedGate.SQLSourceControl.Engine.Diff.BoundDatabase.<GetCancellableCommitableChanges>b__24_0(ICancellableOperationStatus status)
at RedGate.SQLSourceControl.Engine.Utils.Task.MutexedCancellableOperation`1.<>c__DisplayClass7_0.<Invoke>b__0()
at RedGate.SQLSourceControl.Engine.Utils.Task.CancellableOperationBase.PerformAction(Action action)
at RedGate.SQLSourceControl.Engine.Utils.Task.CancellableOperationBase.InvokeWithTracker(Action action)
at RedGate.SQLSourceControl.Engine.Utils.Task.MutexedCancellableOperation`1.Invoke()
at RedGate.SQLSourceControl.Engine.Diff.BoundDatabase.RunCommitableChangesOperationThenCleanUp(ICancellableOperation`1 changes)
at RedGate.SQLSourceControl.Engine.Diff.BoundDatabase.<>c__DisplayClass40_0.<NotifyInteractedWith>b__1()
at RedGate.SQLSourceControl.Engine.Utils.ErrorReporting.ErrorReporterBase.Do(Action toDo, Predicate`1 isFatalPredicate, Boolean rethrow)
stone
1 ·
Re: Exception Info: System.FormatException
Hi all,
This issue was resolved through a support ticket.
Be sure to have the following product versions (or later) installed to resolve this error:
https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.23.11448.exe
https://download.red-gate.com/checkforupdates/SQLCompare/SQLCompare_15.3.14.27393.exe
This issue was resolved through a support ticket.
Be sure to have the following product versions (or later) installed to resolve this error:
https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.23.11448.exe
https://download.red-gate.com/checkforupdates/SQLCompare/SQLCompare_15.3.14.27393.exe
chrisqtran
1 ·
Unable to count local partitions for index
I am trying to create a local index on a partitioned table using SCO and a set of schema scripts and receive the error:
Failed to parse file C:\..\CURR\Indexes\LMEREFIT_MBU_TRD_REGS_IDX1.sql - Unable to count local partitions for index.
The sql in the index file is
CREATE INDEX CURR.LMEREFIT_MBU_TRD_REGS_IDX1 ON CURR.LMEREFIT_MBU_TRD_REGS (UNIQUE_TRANSACTION_ID) LOCAL;
while the table in question is partitioned
...
Failed to parse file C:\..\CURR\Indexes\LMEREFIT_MBU_TRD_REGS_IDX1.sql - Unable to count local partitions for index.
The sql in the index file is
CREATE INDEX CURR.LMEREFIT_MBU_TRD_REGS_IDX1 ON CURR.LMEREFIT_MBU_TRD_REGS (UNIQUE_TRANSACTION_ID) LOCAL;
while the table in question is partitioned
...
PARTITION BY RANGE (REPORT_DATE)
INTERVAL (NUMTOYMINTERVAL(1, 'MONTH'))
(
PARTITION p0 VALUES LESS THAN (TO_DATE('2023-01-01', 'YYYY-MM-DD'))
);
Obviously the index can be created in SQL Developer, but now our scripts don't match the schema.
I get the same error if I compare the schema scripts to an earlier version. What is causing this error?
Obviously the index can be created in SQL Developer, but now our scripts don't match the schema.
I get the same error if I compare the schema scripts to an earlier version. What is causing this error?
RobertMBCL
1 ·
Re: Installing a Flyway Desktop Repository on Microsoft OneDrive
I probably should have researched the Flyway Support site better before posting this, as it is recommended by Redgate not to do this for this very reason...
https://documentation.red-gate.com/flyway/learn-more-about-flyway/troubleshooting/projects-in-onedrive
https://documentation.red-gate.com/flyway/learn-more-about-flyway/troubleshooting/projects-in-onedrive
JimmyG
1 ·
Re: Anyone else have suggestions not working in latest update of SQL Prompt?
Ben_P said:The issue seems to be due to SSMS 19.3 using MDS 3.1.5 whilst SQL Prompt uses 3.1.1. Whilst the team work on a solution for this, it is recommended to use an earlier version of SSMS, such as 19.2 or 18.12.1. Users have also reported that downgrading SQL Prompt to 10.4.4 has worked for them:
https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.4.4865.exe
Hi Ben - what's the solution for the latest issue where the column picker etc stopped working randomly and upgrading has not hellped?
Davidian
1 ·
Re: issue with seeing 'schema model'
Thank you for your insights and help, it turns out my colleague was not signed into his flyway. After signing in he was able to see the schema-model, thank you again!
Re: SQL Prompt Refreshing very slowly, different query when connecting to DB
Hi @MFrenzel
Thanks for chiming in, thankfully this issue has now since been replicated by development and they are currently testing the fix we are planning to implement. Once that has cleared smoke testing and is released in a new version of SQL Prompt, I will circle back here and let you guys know. Looking at the solution, it seems to be significantly faster after the fix is applied.
Cheers,
Christian Perez
Product Support
Thanks for chiming in, thankfully this issue has now since been replicated by development and they are currently testing the fix we are planning to implement. Once that has cleared smoke testing and is released in a new version of SQL Prompt, I will circle back here and let you guys know. Looking at the solution, it seems to be significantly faster after the fix is applied.
Cheers,
Christian Perez
Product Support
cperez
1 ·
