Results 1 to 10 of 10

Thread: sql2000 to sql2005 upgrade.

  1. #1
    Join Date
    Feb 2003
    Posts
    34

    sql2000 to sql2005 upgrade.

    SQL 2005 Upgrade advisor throws following error:

    Existing Meta Data Services packages should be moved to SQL Server storage (in the msdb database) or to structured storage files before you upgrade. There are no DTS packages in the system...

    Ignored the error and tried upgrade anyway but the process stops with error: "Upgrade Advisor returned -1" after complete upgrade analysis.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    What's sp level of sql2k?

  3. #3
    Join Date
    Feb 2003
    Posts
    34
    8.00.2055 SP4 Enterprise Edition

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938

  5. #5
    Join Date
    Feb 2003
    Posts
    34
    there are no DTS packages to begin with on this box. (msdb..sysdtspackages table is empty)

  6. #6
    Join Date
    Feb 2003
    Posts
    34
    and no meta data services packages...

  7. #7
    Join Date
    Jan 2010
    Posts
    37
    What does the install log say about the error?

    http://http://msdn.microsoft.com/en-...SQL.90%29.aspx

  8. #8
    Join Date
    Feb 2003
    Posts
    34
    no luck yet but thanks for the lead. summary.txt had the following text. Also none of the detailed log files had a "return value 3" string anywhere.

    Microsoft SQL Server 2005 9.00.1399.06
    ==============================
    OS Version : Microsoft Windows Server 2003 family, Standard Edition Service Pack 2 (Build 3790)
    Time : Wed Jan 13 11:26:34 2010


    SQL Server Setup was interrupted. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt.


    Time : Wed Jan 13 11:28:54 2010

  9. #9
    Join Date
    Feb 2003
    Posts
    34
    was going thru the core log in detail found this. any thoughts(see lines starting with the word error):
    -----------------------------------------------------------
    Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlsval.dll Version:2005.90.1399.0
    <EndFunc Name='DwLaunchMsiExec' Return='1602' GetLastError='0'>
    Complete: InvokeSqlSetupDllAction at: 2010/0/13 11:28:53, returned false
    Error: Action "InvokeSqlSetupDllAction" failed during execution.
    Action "AnalyzeInstallStage" will be skipped due to the following restrictions:
    Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
    Action "PrepareForChainingStage" will be skipped due to the following restrictions:
    Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
    Action "SequenceChainingActionsStage" will be skipped due to the following restrictions:
    Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
    Action "InstallChainedPackagesStage" will be skipped due to the following restrictions:
    Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
    Running: ReportChainingResults at: 2010/0/13 11:28:54
    Error: Action "ReportChainingResults" threw an exception during execution.
    DwLaunchMsiExec() returned : 1602
    Error Code: 0x80070642 (1602)
    Windows Error Text: User cancelled installation.

    Source File Name: sqlchaining\sqlchainingactions.cpp
    Compiler Timestamp: Thu Sep 1 22:23:05 2005
    Function Name: sqls::ReportChainingResults:erform
    Source Line Number: 2992

    Source File Name: datastore\cachedpropertycollection.cpp
    Compiler Timestamp: Fri Jul 29 01:13:49 2005
    Function Name: CachedPropertyCollection::findProperty
    Source Line Number: 130
    ----------------------------------------------------------
    Failed to find property "watsonFailedActionErrorCode" {"SetupStateScope", "", ""} in cache
    Source File Name: datastore\propertycollection.cpp
    Compiler Timestamp: Fri Jul 29 01:13:50 2005
    Function Name: SetupStateScope.watsonFailedActionErrorCode
    Source Line Number: 44
    ----------------------------------------------------------
    No collector registered for scope: "SetupStateScope"
    Failed to create CAB file due to datastore exception
    Source File Name: datastore\cachedpropertycollection.cpp
    Compiler Timestamp: Fri Jul 29 01:13:49 2005
    Function Name: CachedPropertyCollection::findProperty
    Source Line Number: 130
    ----------------------------------------------------------
    Failed to find property "watsonFailedActionErrorCode" {"SetupStateScope", "", ""} in cache
    Source File Name: datastore\propertycollection.cpp
    Compiler Timestamp: Fri Jul 29 01:13:50 2005
    Function Name: SetupStateScope.watsonFailedActionErrorCode
    Source Line Number: 44
    ----------------------------------------------------------
    No collector registered for scope: "SetupStateScope"
    Message pump returning: 1602

  10. #10
    Join Date
    Feb 2003
    Posts
    34
    PROBLEM RESOLVED: MS WAS ON PHONE:
    *******************************
    COPIED THIS DLL ONE LEVEL UP
    C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA\bin\BPAClient.dll

    and upgrade worked like a charm. Believe its a bug...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •