11:16:44 [ERR][ Workbench]: Console redirection failed. 11:16:44 [INF][ WBContext]: Parsing application arguments. 11:16:44 [INF][ WBContext]: C:\Program Files (x86)\MySQL\MySQL Workbench CE 6.0.6\MySQLWorkbench.exe 11:16:44 [INF][ Workbench]: Starting up Workbench 11:16:44 [INF][ Workbench]: Current environment: Command line: "C:\Program Files (x86)\MySQL\MySQL Workbench CE 6.0.6\MySQLWorkbench.exe" CurrentDirectory: C:\Program Files (x86)\MySQL\MySQL Workbench CE 6.0.6 HasShutdownStarted: False OSVersion: Microsoft Windows NT 6.1.7601 Service Pack 1 SystemDirectory: C:\Windows\system32 TickCount: 70837869 UserInteractive: True Version: 4.0.30319.18052 WorkingSet: 28745728 11:16:44 [INF][ Workbench]: Environment variables: PROCESSOR_ARCHITEW6432 = AMD64 windows_tracing_flags = 3 COMPUTERNAME = DEV-PC CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files EICDDrive = F:\ HOMEPATH = \Users\jj VBOX_INSTALL_PATH = C:\Program Files\Oracle\VirtualBox\ PROCESSOR_REVISION = 2a07 USERDOMAIN = DEV-PC PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC TMP = C:\Users\jj\AppData\Local\Temp TEMP = C:\Users\jj\AppData\Local\Temp LOCALAPPDATA = C:\Users\jj\AppData\Local PUBLIC = C:\Users\Public VS90COMNTOOLS = C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\Tools\ ProgramFiles(x86) = C:\Program Files (x86) Path = C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Intel\DMIX;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files (x86)\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\;C:\Program Files (x86)\Windows Live\Shared;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\;C:\Program Files\Microsoft SQL Server\110\DTS\Binn\;C:\Program Files\Microsoft\Web Platform Installer\;C:\Program Files (x86)\Microsoft ASP.NET\ASP.NET Web Pages\v1.0\;C:\Program Files (x86)\Windows Kits\8.0\Windows Performance Toolkit\;C:\Program Files (x86)\Bitvise SSH Client;C:\Program Files (x86)\MySQL\MySQL Utilities 1.3.4\ PROCESSOR_LEVEL = 6 PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 42 Stepping 7, GenuineIntel lib = C:\Program Files\SQLXML 4.0\bin\ PSModulePath = C:\Windows\system32\WindowsPowerShell\v1.0\Modules\;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\PowerShell\Modules\ NUMBER_OF_PROCESSORS = 4 CommonProgramFiles = C:\Program Files (x86)\Common Files ProgramData = C:\ProgramData ProgramW6432 = C:\Program Files ProgramFiles = C:\Program Files (x86) FP_NO_HOST_CHECK = NO SystemRoot = C:\Windows SESSIONNAME = Console CommonProgramW6432 = C:\Program Files\Common Files LOGONSERVER = \\DEV-PC USERPROFILE = C:\Users\jj APPDATA = C:\Users\jj\AppData\Roaming HOMEDRIVE = C: windows_tracing_logfile = C:\BVTBin\Tests\installpackage\csilogfile.log VS110COMNTOOLS = C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\Tools\ USERNAME = jj PROCESSOR_ARCHITECTURE = x86 OS = Windows_NT ComSpec = C:\Windows\system32\cmd.exe SystemDrive = C: windir = C:\Windows ALLUSERSPROFILE = C:\ProgramData 11:16:44 [INF][ Workbench]: Current version given by meta info is: 6.0.6 11:16:44 [INF][ Workbench]: Setting PATH to: C:\Windows\system32;C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Intel\DMIX;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files (x86)\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\;C:\Program Files (x86)\Windows Live\Shared;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\;C:\Program Files\Microsoft SQL Server\110\DTS\Binn\;C:\Program Files\Microsoft\Web Platform Installer\;C:\Program Files (x86)\Microsoft ASP.NET\ASP.NET Web Pages\v1.0\;C:\Program Files (x86)\Windows Kits\8.0\Windows Performance Toolkit\;C:\Program Files (x86)\Bitvise SSH Client;C:\Program Files (x86)\MySQL\MySQL Utilities 1.3.4\ 11:16:44 [INF][ mforms managed]: Initializing mforms wrapper 11:16:45 [INF][ WBContext UI]: Initializing workbench context UI with these values: base dir: C:\Program Files (x86)\MySQL\MySQL Workbench CE 6.0.6 plugin path: C:\Program Files (x86)\MySQL\MySQL Workbench CE 6.0.6 struct path: module path: C:\Program Files (x86)\MySQL\MySQL Workbench CE 6.0.6/modules library path: C:\Program Files (x86)\MySQL\MySQL Workbench CE 6.0.6 user data dir: C:\Users\jj\AppData\Roaming\MySQL\Workbench open at start: open type: run at startup: run type: Force SW rendering: No Force OpenGL: No quit when done: No 11:16:45 [INF][ WBContext]: WbContext::init 11:16:45 [INF][ grt]: Scanning module directory C:\Users\jj\AppData\Roaming\MySQL\Workbench\modules. 11:16:45 [INF][ grt]: Scanning module directory .. 11:16:45 [INF][ grt]: Scanning module directory C:\Program Files (x86)\MySQL\MySQL Workbench CE 6.0.6/modules. 11:16:45 [INF][ ]: Initialized Lua module C:\Program Files (x86)\MySQL\MySQL Workbench CE 6.0.6/modules\catalog_utils.grt.lua (WbUtils) 11:16:45 [INF][ WBA]: Looking for extension modules for WBA... 11:16:45 [INF][ WBA]: 0 extension modules found 11:16:46 [INF][ grt]: Scanning module directory C:\Program Files (x86)\MySQL\MySQL Workbench CE 6.0.6. 11:16:46 [WRN][ grt]: C:\Users\jj\AppData\Roaming\MySQL\Workbench\connections.xml:24: link '{DC843F93-D087-490D-9CA4-B40A7E5A3286}' key=owner could not be resolved 11:16:46 [WRN][ grt]: C:\Users\jj\AppData\Roaming\MySQL\Workbench\other_connections.xml:15: link '{DC843F93-D087-490D-9CA4-B40A7E5A3286}' key=owner could not be resolved 11:16:46 [INF][ WBContext]: System info: MySQL Workbench Community (GPL) for Windows version 6.0.6 revision 11184 Configuration Directory: C:\Users\jj\AppData\Roaming\MySQL\Workbench Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench CE 6.0.6 Cairo Version: 1.8.8 OS: Microsoft Windows 7 Home Premium Edition Service Pack 1 (build 7601), 64-bit CPU: 4x Intel(R) Core(TM) i5-2400 CPU @ 3.10GHz, 3.9 GiB RAM Active video adapter Intel(R) HD Graphics Family Installed video RAM: 1809 MB Current video mode: 1920 x 1080 x 4294967296 colors Used bit depth: 32 Driver version: 8.15.10.2509 Installed display drivers: igdumd64.dll,igd10umd64.dll,igd10umd64.dll,igdumdx32,igd10umd32,igd10umd32 Current user language: English (South Africa) 11:16:46 [INF][ WQE backend]: Found auto-save workspace C:\Users\jj\AppData\Roaming\MySQL\Workbench\sql_workspaces\Archives-1.autosave 11:16:46 [INF][ Workbench]: UI is up 11:16:46 [INF][ Workbench]: Running the application 11:44:28 [INF][ SSH tunnel]: Starting tunnel 11:44:29 [INF][ WQE.net]: Launching SQL IDE 11:44:29 [INF][ WQE.net]: SQL IDE UI is ready 11:45:55 [INF][ grt]: Connecting to Mssql@BMSI05_ODBC... 11:45:55 [INF][ grt]: Opening ODBC connection to DSN=BMSI05_ODBC;DATABASE=Archive;UID=TRID_ADM;PWD=XXXX... 11:45:55 [INF][ grt]: Connecting to Mssql@BMSI05_ODBC... 11:45:55 [INF][ grt]: Opening ODBC connection to DSN=BMSI05_ODBC;DATABASE=Archive;UID=TRID_ADM;PWD=XXXX... 11:46:00 [INF][ grt]: Connecting to Mssql@BMSI05_ODBC... 11:46:00 [INF][ grt]: Opening ODBC connection to DSN=BMSI05_ODBC;DATABASE=Archive;UID=TRID_ADM;PWD=XXXX... 11:46:15 [INF][ grt]: Connecting to Mssql@BMSI05_ODBC... 11:46:15 [INF][ grt]: Opening ODBC connection to DSN=BMSI05_ODBC;DATABASE=;UID=TRID_ADM;PWD=XXXX... 11:46:15 [INF][ grt]: Connected 11:46:39 [INF][ grt]: Connecting to Mysql@localhost:3306... 11:46:39 [INF][ grt]: Connecting to Mysql@localhost:3306... 11:46:39 [INF][ grt]: Connected 11:46:43 [INF][ Wizard]: Execute 'Connect to source DBMS' 11:46:43 [INF][ Wizard]: Execute 'Check target DBMS connection' 11:46:43 [INF][ Wizard]: Starting thread for 'Retrieve schema list from source' 11:46:57 [INF][ Wizard]: Execute 'Connect to source DBMS' 11:46:57 [INF][ grt]: Connecting to Mssql@BMSI05_ODBC... 11:46:57 [INF][ grt]: Opening ODBC connection to DSN=BMSI05_ODBC;DATABASE=;UID=TRID_ADM;PWD=XXXX... 11:46:57 [INF][ grt]: Connected 11:46:58 [INF][ Wizard]: Starting thread for 'Reverse engineer selected schemata' 11:46:58 [INF][ grt]: Reverse engineering dbo from Archives 11:46:58 [INF][ grt]: Reverse engineering 9 tables from dbo 11:46:58 [INF][ grt]: Reverse engineering 0 views from dbo 11:46:58 [INF][ grt]: Reverse engineering 0 routines from dbo 11:46:58 [INF][ grt]: Reverse engineering 0 triggers from dbo 11:46:58 [INF][ grt]: Reverse engineering foreign keys for tables in schema dbo 11:46:58 [INF][ Wizard]: Execute 'Post-processing of reverse engineered schemata' 11:46:58 [INF][ grt]: Merging reverse engineered schema objects into a single schema... 11:47:12 [INF][ Wizard]: Starting thread for 'Migrate Selected Objects' 11:47:12 [INF][ Wizard]: Starting thread for 'Generate SQL CREATE Statements' 11:47:21 [INF][ Wizard]: Execute 'Connect to Target Database' 11:47:21 [INF][ Wizard]: Execute 'Perform Checks in Target' 11:47:39 [INF][ Wizard]: Starting thread for 'Create Schemata and Objects' 11:47:39 [INF][ grt]: Execute statement SET FOREIGN_KEY_CHECKS = 0 11:47:39 [INF][ grt]: Execute statement DROP SCHEMA IF EXISTS `Archives` 11:47:40 [INF][ grt]: Execute statement CREATE SCHEMA IF NOT EXISTS `Archives` 11:47:41 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `Archives`.`WHDataBases` ( `ServerName` VARCHAR(100) NOT NULL, `DataBaseName` VARCHAR(100) NOT NULL, `UDLFileName` VARCHAR(100) NULL, `Type` VARCHAR(4) NULL, `Active` VARCHAR(2) NULL, `ConnectionString` VARCHAR(500) NULL) 11:47:41 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `Archives`.`WHImportStats` ( `ServerName` VARCHAR(40) NOT NULL, `DBName` VARCHAR(40) NOT NULL, `ArchiveTable` VARCHAR(500) NOT NULL, `SourceAX_R2` VARCHAR(4) NULL, `RecordsInSource` INT NULL, `RecordsImported` INT NULL, `LastUpdate` DATETIME NULL, `RecType` VARCHAR(2) NULL) 11:47:41 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `Archives`.`WHTableMaster` ( `ArchiveTable` VARCHAR(500) NOT NULL, `ServerName` VARCHAR(40) NULL, `DBName` VARCHAR(40) NULL, `SourceAX_R2` VARCHAR(4) NULL, `FLC` VARCHAR(60) NULL, `Records` INT NULL, `LastUpdate` DATETIME NULL, `NonZeroRecords` INT NULL, `NonZeroLastUpdate` DATETIME NULL, `RecType` VARCHAR(2) NULL, `Id` INT NOT NULL, `Active` VARCHAR(2) NULL, PRIMARY KEY (`ArchiveTable`(255)), INDEX `Ix_FLC` (`FLC` ASC), INDEX `Ix_LastUpd` (`LastUpdate` ASC), INDEX `IxRecType` (`RecType` ASC), INDEX `Ix_ID` (`Id` ASC), INDEX `Ix_Active` (`Active` ASC)) 11:47:41 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `Archives`.`WHDailyImportLog` ( `ImportRun` DATE NOT NULL, `ID` INT NOT NULL, `TmStamp` DATETIME NOT NULL, `ImportCount` INT NULL, `Duration` INT NULL, PRIMARY KEY (`ImportRun`, `ID`, `TmStamp`)) 11:47:41 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `Archives`.`WHArchiveOldData` ( `Id` INT NOT NULL, `TmStamp` DATETIME NULL, `Value` DECIMAL(30,4) NULL, `Status` SMALLINT NULL, INDEX `IX_Id` (`Id` ASC)) 11:47:41 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `Archives`.`NeonImport` ( `LastDay` DATETIME NULL) 11:47:41 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `Archives`.`WHArchive` ( `Id` INT NOT NULL, `TmStamp` DATETIME NULL, `Value` DECIMAL(30,4) NULL, `Status` SMALLINT NULL, INDEX `Ix_ID` (`Id` ASC), INDEX `Ix_TmStamp` (`TmStamp` ASC)) 11:47:41 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `Archives`.`AuditArchive` ( `ID` INT NOT NULL, `TimeStamp` DATETIME NULL, `UserName` VARCHAR(100) NULL, `Source` VARCHAR(512) NULL, `AuditAction` VARCHAR(512) NULL, `Action` VARCHAR(100) NULL) 11:47:42 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `Archives`.`AuditTablesMaster` ( `DBName` VARCHAR(40) NOT NULL, `TableName` VARCHAR(256) NOT NULL, `ID` INT NOT NULL, `Type` VARCHAR(4) NULL) 11:47:42 [INF][ grt]: Scripts for 9 tables, 0 views and 0 routines were executed for schema Archives 11:47:42 [INF][ grt]: Execute statement SET FOREIGN_KEY_CHECKS = 1 11:47:54 [INF][ Wizard]: Execute 'Prepare information for data copy' 11:47:54 [INF][ Wizard]: Starting thread for 'Determine number of rows to copy' 11:56:09 [ERR][ Wizard]: Thread 'Determine number of rows to copy' failed: Error getting row count from source tables 11:57:42 [INF][ WQE.net]: Shutting down SQL editor (Archives) 11:57:42 [INF][ Workbench]: Shutting down Workbench 11:57:42 [INF][ mforms managed]: Shutting down mforms wrapper 11:57:42 [INF][ Workbench]: Done