Error executing historic database script

0 votes
Hi all, new to Betwise so sorry if this is not the place.

I created a local SQL DB (SQLEXPRESS) and I am wondering if I have some sort of configuration issue because the out of the box script to backfill historic data produces the following error. Any help would be great.


Cannot execute script.


Specified argument was out of the range of valid values.
Parameter name: chars (SQLEditors)

Program Location:

   at Microsoft.SqlServer.Management.UI.VSIntegration.ShellTextBuffer.GetText(Int32 startPosition, Int32 chars)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ShellTextBuffer.get_Text()
   at Microsoft.SqlServer.Management.UI.VSIntegration.ShellCodeWindowControl.GetSelectedTextSpan()
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptEditorControl.GetSelectedTextSpan()
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptAndResultsEditorControl.OnExecScript(Object sender, EventArgs a)
asked Dec 23, 2019 by ccowell93 Plater (120 points)

1 Answer

0 votes
Hi - the out of the box script should be run on the system command line (either in Windows for the exe script or in the Bash Shell for Mac / Linux systems) rather than within the database itself - so not from an SQL client.   Please see the instructions in the manual for this.  If you have any other issues please send to the contact form and we can give you specific help.
answered Dec 30, 2019 by colin Guru (13,100 points)
I ended up getting it working using MySQL Workbench to execute. SSMS or an OBDC driver seemed to be my problem.
Cool, thanks for letting us know