none
SSMA for Access Console Issues

    Question

  • I am attempting to automate the process of migrating an Access database to SQL Server via the SSMA Console. The process works flawlessly via the GUI, but the console seems to have a very basic, but common coding issue -- or I'm missing something.

    Here is what is happening:

    I have used the sample scripts to customize my needs as they seem to provide everything I need -- that being a very basic access database being linked into a very basic sql database...

    I have built a batch file that executes the following: 
    SSMAforAccessConsole.exe -s script.xml -c server.xml -v variables.xml -l log.txt

    The console ends with this message: 
    [2/4/2013 11:44:49 AM]    START map-schema
    FATALERR Access Database was not found by name 'Test_Access_Database'

    In locating the map-schema line (in script.xml) it reads:
    <map-schema source-schema="$AccessDatabase$" sql-server-schema="$SQLServerDb$.dbo" />

    Referencing the AccessDatabase variable line, which reads:
    <variable name="$AccessDatabase$" value="Test_Access_Database.mdb"/>

    I know that the AccessDatabase variable is being read properly prior to this, in-code, because if I change the value to an incorrect file name it will ding me with the ".mdb" still appended... and I am sure that this is the area where it is breaking because if I, for example, "hard-code" a '1' before the variable  the error reads:
    FATALERR Access Database was not found by name '1Test_Access_Database'

    A common mistake made by programmers (being one myself) is to unintentionally parse a string containing a file name through a function that removes the file extension (thus giving just the file's root name)... I believe this is the case with this scenario.

    Obviously I could be mistaken, or I could just run it manually, but I need this to be an automated process as it is a part of my company's life-cycle and they require their database admins to execute and test the process.

    Please let me know as soon as possible if I'm making a simple mistake, or of any work-arounds or patches that could allow me to continue using this product as a solution -- as it does appear to be the most accurate and dependable process available for performing this task.

    Here is my full list of scripts being used:

    (Please note that all of my Schemas are in a custom directory, thus I have removed one '.' directory iterator from my scripts)

    script.xml

    <?xml version="1.0" encoding="utf-8"?>
    <ssma-script-file xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation=".\Schemas\A2SSConsoleScriptSchema.xsd">
    
      <config>
        <output-providers>      
          <output-window suppress-messages="false" destination="file" file-name="./LogMessages.txt"/>
    
          <upgrade-project action="yes"/>
          
          <user-input-popup mode="continue"/>
    
          <data-migration-connection source-use-last-used="false"
                                     target-server="$SQLServerName$"/>
    
          <progress-reporting enable="true"
                              report-messages="true"
                              report-progress="every-1%"/>
    
          <reconnect-manager on-source-reconnect="reconnect-to-last-used-server" 
    							           on-target-reconnect="generate-an-error"/>
    
          <object-overwrite action="overwrite" />
    
          <log-verbosity level="error"/>
    
        </output-providers>
      </config>
    
      <script-commands>
    
        <create-new-project project-folder="$project_folder$" 
    						project-name="$project_name$" 
    						overwrite-if-exists="true"
    						project-type="$project-type$" />
    
        <load-access-database database-file="$AccessDbFolder$\$AccessDatabaseFile$"/>
    
        <connect-target-database server="$SQLServerName$" />
    
        <map-schema source-schema="$AccessDatabase$" sql-server-schema="$SQLServerDb$.dbo" />
    
        <convert-schema object-name="$AccessDatabase$" 
                            object-type="Databases" />
    
        <synchronize-target object-name="$SQLServerDb$.dbo"
                            on-error="report-each-as-warning"
                            report-errors-to="$SynchronizationReports$" />
    
        <migrate-data object-name="$AccessDatabase$.Tables"
                      object-type="category"
                      write-summary-report-to="$SummaryReports$"
                      report-errors="true"
                      verbose="true" />
    
        <link-tables>
          <metabase-object object-name="$AccessDatabase$.Tables" object-type="category"/>
        </link-tables>
    
        <save-project />
        <close-project if-modified="save" />
      </script-commands>
    </ssma-script-file>

    variables.xml

    <?xml version="1.0" encoding="utf-8"?>
    <variables xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation=".\Schemas\ConsoleScriptVariablesSchema.xsd">
    
      <variable name="$WorkingFolder$"  value="."/>
    
      <variable-group name="AccessConnection">
       <variable name="$AccessDbFolder$" value="\\US_SERVER1\admin$$"/>
       <variable name="$AccessDatabase$" value="Test_Access_Database.mdb"/>
       <variable name="$AccessDatabaseFile$" value="$AccessDatabase$.accdb"/>
      </variable-group>
    
      <variable-group name="SQLServerConnection">
        <variable name="$SQLServerName$" value="(local)"/>
        <variable name="$SQLServerDb$"  value="TEST_SQL_DB"/>
      </variable-group>
    
      <variable-group name="TEST_SQL_DB">
        <variable name="$project_folder$" value="$WorkingFolder$\$project_name$"/>
        <variable name="$project_name$" value="TEST_SQL_DB_TEST1"/>
        <variable name="$project-type$" value="sql-server-2008"/>
        <variable name="$ConvertARReportsFolder$"  value="$WorkingFolder$\$AssessmentReportFolderName$"/>
        <variable name="$SynchronizationReports$" value="$WorkingFolder$"/>
        <variable name="$SaveScriptFolder$" value="$WorkingFolder$"/>
        <variable name="$AssessmentReportFolderName$"       value="AssessmentReports"/>
        <variable name="$AssessmentReports$"                value="$WorkingFolder$\$AssessmentReportFolderName$"/>
        <variable name="$SummaryReports$"                   value="$WorkingFolder$"/>
      </variable-group>
    </variables>

    server.xml

    <?xml version="1.0" encoding="utf-8"?>
    <servers xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation=".\Schemas\A2SSConsoleScriptServersSchema.xsd">
      <sql-server name="(local)">
        <windows-authentication>
          <database value ="$SQLServerDb$"/>
          <server value ="$SQLServerName$"/>
          <encrypt value="true"/>
          <trust-server-certificate value="true"/>
        </windows-authentication>
      </sql-server>  
    </servers>

    Log Results:

    [Command Line Processor: Mandatory] [6156/1] [2013-02-04 12:53:03]: Microsoft SSMA for Access v5.2.1257
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: Start Validating command sequence....
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: Validating command sequence finished....
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: #### Start processing command sequence...
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: ## Processing command #1
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: ## Command code: create-new-project 
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: CommandStarted was called with command code: create-new-project
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: Creating project 'TEST_SQL_DB_TEST1' in folder '.\TEST_SQL_DB_TEST1'
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 1%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 2%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 3%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 4%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 5%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 6%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 7%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 8%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 9%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 10%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 11%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 12%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 13%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 14%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 15%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 16%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 17%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 18%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 19%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 20%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 21%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 22%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 23%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 24%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 25%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 26%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 27%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 28%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 29%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 30%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 31%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 32%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 33%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 34%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 35%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 36%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 37%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 38%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 39%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 40%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 41%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 42%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 43%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 44%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 45%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 46%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 47%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 48%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 49%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 50%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 51%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 52%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 53%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 54%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 55%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 56%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 57%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 58%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 59%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 60%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 61%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 62%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 63%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 64%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 65%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 66%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 67%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 68%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 69%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 70%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 71%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 72%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 73%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 74%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 75%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 76%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 77%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 78%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 79%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 80%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 81%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 82%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 83%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 84%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 85%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 86%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 87%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 88%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 89%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 90%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 91%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 92%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 93%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 94%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 95%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 96%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 97%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 98%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 99%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 100%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: Project created
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: CommandFinished was called
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: ## Command processed
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: ## Processing command #2
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: ## Command code: load-access-database 
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: CommandStarted was called with command code: load-access-database
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteWarningMessage was called with message: No files found with pattern '\\US_SERVER1\admin$\Test_Access_Database.mdb.accdb'
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: CommandFinished was called
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: ## Command processed
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: ## Processing command #3
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: ## Command code: connect-target-database 
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: CommandStarted was called with command code: connect-target-database
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: Establishing connection to sql-server server '(local)'
    [Generic: Error] [6156/3] [2013-02-04 12:53:04]: Exception: The remote server returned an error: (407) Proxy Authentication Required.
     site: System.Net.WebResponse GetResponse()
     source: System
       at System.Net.HttpWebRequest.GetResponse()
       at Microsoft.SSMA.Framework.Generic.SQM.SqmFileUploader.DoUpload()
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 1%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 2%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 3%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 4%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 5%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 6%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 7%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 8%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 9%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 10%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 11%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 12%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 13%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 14%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 15%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 16%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 17%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 18%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 19%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 20%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 21%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 22%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 23%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 24%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 25%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 26%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 27%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 28%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 29%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 30%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 31%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 32%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 33%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 34%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 35%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 36%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 37%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 38%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 39%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 40%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 41%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 42%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 43%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 44%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 45%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 46%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 47%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 48%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 49%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 50%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 51%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 52%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 53%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 54%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 55%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 56%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 57%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 58%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 59%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 60%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 61%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 62%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 63%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 64%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 65%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 66%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 67%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 68%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 69%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 70%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 71%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 72%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 73%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 74%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 75%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 76%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 77%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 78%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 79%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 80%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 81%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 82%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 83%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 84%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 85%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 86%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 87%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 88%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 89%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 90%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 91%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 92%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 93%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 94%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 95%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 96%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 97%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 98%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 99%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 100%
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: CommandFinished was called
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: ## Command processed
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: ## Processing command #4
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: ## Command code: map-schema 
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: CommandStarted was called with command code: map-schema
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: ReportFatalException was called
    [Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: Exception: Access Database was not found by name 'Test_Access_Database'
     site: System.Collections.Generic.List`1[Microsoft.SSMA.Framework.Generic.XTree.XNode] SearchInMetabase(Microsoft.SSMA.Framework.Generic.Collectors.XMetabase, Microsoft.SSMA.Framework.Generic.SqlBase.CompoundObjectPath, Microsoft.SSMA.Framework.Generic.SSMAWorkspace.DefaultSSMAWorkspace)
     source: SSMAforAccessConsole
       at Microsoft.SSMA.GUI.Access2SqlServer.CommandProcessor.CommandProcessors.ObjectSearchHelper.SearchInMetabase(XMetabase metabase, CompoundObjectPath objectPath, DefaultSSMAWorkspace workspace)
       at Microsoft.SSMA.GUI.Generic.CommandProcessor.CommandProcessors.SchemaMappingAbstractProcessor.ProcessCommandImpl(XNode command)
       at Microsoft.SSMA.GUI.Generic.CommandProcessor.CommandProcessors.CommandAbstractProcessor.ProcessCommand(XNode command)
       at Microsoft.SSMA.GUI.Generic.CommandProcessor.AbstractCommandProcessor.ProcessCommand(XNode command)
       at Microsoft.SSMA.GUI.Generic.CommandProcessor.AbstractCommandProcessor.ProcessCommandSequence(XNode commandList)
       at Microsoft.SSMA.GUI.Generic.CommandProcessor.AbstractCommandProcessor.ProcessCommandFile(String scriptFile, String serversFile, List`1 variableFiles, Int32& exitCode)
    [Command Line Processor: Error] [6156/1] [2013-02-04 12:53:04]: ## ERROR: Access Database was not found by name 'Test_Access_Database'
    [Command Line Processor: Error] [6156/1] [2013-02-04 12:53:04]: Exception: Access Database was not found by name 'Test_Access_Database' site: System.Collections.Generic.List`1[Microsoft.SSMA.Framework.Generic.XTree.XNode] SearchInMetabase(Microsoft.SSMA.Framework.Generic.Collectors.XMetabase, Microsoft.SSMA.Framework.Generic.SqlBase.CompoundObjectPath, Microsoft.SSMA.Framework.Generic.SSMAWorkspace.DefaultSSMAWorkspace) source: SSMAforAccessConsole at Microsoft.SSMA.GUI.Access2SqlServer.CommandProcessor.CommandProcessors.ObjectSearchHelper.SearchInMetabase(XMetabase metabase, CompoundObjectPath objectPath, DefaultSSMAWorkspace workspace) at Microsoft.SSMA.GUI.Generic.CommandProcessor.CommandProcessors.SchemaMappingAbstractProcessor.ProcessCommandImpl(XNode command) at Microsoft.SSMA.GUI.Generic.CommandProcessor.CommandProcessors.CommandAbstractProcessor.ProcessCommand(XNode command) at Microsoft.SSMA.GUI.Generic.CommandProcessor.AbstractCommandProcessor.ProcessCommand(XNode command) at Microsoft.SSMA.GUI.Generic.CommandProcessor.AbstractCommandProcessor.ProcessCommandSequence(XNode commandList) at Microsoft.SSMA.GUI.Generic.CommandProcessor.AbstractCommandProcessor.ProcessCommandFile(String scriptFile, String serversFile, List`1 variableFiles, Int32& exitCode) [Generic: Error] [6156/3] [2013-02-04 12:53:04]: Exception: The remote server returned an error: (407) Proxy Authentication Required. site: System.Net.WebResponse GetResponse() source: System at System.Net.HttpWebRequest.GetResponse() at Microsoft.SSMA.Framework.Generic.SQM.SqmFileUploader.DoUpload() [Generic: Error] [6156/1] [2013-02-04 12:53:05]: Exception: The remote server returned an error: (407) Proxy Authentication Required. site: System.Net.WebResponse GetResponse() source: System at System.Net.HttpWebRequest.GetResponse() at Microsoft.SSMA.Framework.Generic.SQM.SqmFileUploader.DoUpload()

    System Specs:

    Windows 7 (64 bit)

    Microsoft Office 2010

    Microsoft SQL Server 2008

    Microsoft SQL Server Migration Assistant v5.2.1257

    If you need any further information I will gladly supply it.

    All tips, help, and assistance are appreciated.

    Thank you for your valued time.




    • Edited by XReply Monday, February 04, 2013 8:29 PM Removing redundant word
    • Changed type XReply Tuesday, February 05, 2013 3:35 PM Didn't realize General Discussion didn't allow "mark as answer"
    Monday, February 04, 2013 5:36 PM

Answers

  • I'm in a similar situation, but can't get past the vague error "FATALERR Invalid argument used".

    Anyway, as to your code, in your variables.xml file I would have done the following:

       <variable name="$AccessDatabase$" value="Test_Access_Database"/>
       <variable name="$AccessDatabaseFile$" value="$AccessDatabase$.mdb"/>

    The changes are:

    1. remove the .mdb extension in the first line; and
    2. change .accdb to .mdb in the second line.

    I'm not suggesting I'm correct and you're not, but my suggested changes seem to me to be a possible solution.

    Nevertheless, the error message seems to be ignoring file extensions anyway, so maybe its a red herring.

    Edit: I finally got mine to run - in my variables script I use the same construction as suggested in my post, so maybe it is the solution ...
    • Edited by blackvan253 Tuesday, February 05, 2013 2:59 AM
    • Marked as answer by XReply Tuesday, February 05, 2013 3:35 PM
    Tuesday, February 05, 2013 1:17 AM

All replies

  • Hello,

    Please try to contact SSMA support team at the following email address:

    accssma@microsoft.com  

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Monday, February 04, 2013 8:06 PM
  • I will do that, and post my findings so that it may be useful to others.
    Monday, February 04, 2013 8:27 PM
  • Hello,

    Thank you in advance.

    Have a great day!

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Monday, February 04, 2013 8:36 PM
  • I'm in a similar situation, but can't get past the vague error "FATALERR Invalid argument used".

    Anyway, as to your code, in your variables.xml file I would have done the following:

       <variable name="$AccessDatabase$" value="Test_Access_Database"/>
       <variable name="$AccessDatabaseFile$" value="$AccessDatabase$.mdb"/>

    The changes are:

    1. remove the .mdb extension in the first line; and
    2. change .accdb to .mdb in the second line.

    I'm not suggesting I'm correct and you're not, but my suggested changes seem to me to be a possible solution.

    Nevertheless, the error message seems to be ignoring file extensions anyway, so maybe its a red herring.

    Edit: I finally got mine to run - in my variables script I use the same construction as suggested in my post, so maybe it is the solution ...
    • Edited by blackvan253 Tuesday, February 05, 2013 2:59 AM
    • Marked as answer by XReply Tuesday, February 05, 2013 3:35 PM
    Tuesday, February 05, 2013 1:17 AM
  • Those lines are actually the default settings (short of the file name) that come with the sample. I did find it strange, as well, that they had placed an .accdb as the extension. I will attempt your change now as it does seem the logical solution. I am glad to hear it worked for you.

    Edit: That was it -- a simple, logical solution. I do see where I was confused in setting up the variable... The added .accdb extension in the sample file did not help the confusion. Thank you, blackvan, that was very helpful.
    • Edited by XReply Tuesday, February 05, 2013 3:12 PM
    Tuesday, February 05, 2013 3:01 PM