Announcement

Collapse
No announcement yet.

Migration Projectserver2003 to projectserver2007

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Migration Projectserver2003 to projectserver2007

    Hi,

    I have a lot of problems with the migration. I installed Projectserver 2007 as in de Manual. I installed Project Pro 2007 with the migration tool. When I'm running the tool it stops and the log looks like this.

    06/04/2010 11:13:50.935 Log file Initialized
    06/04/2010 11:13:50.950 Migration tool version is 12,0,4518,1014
    06/04/2010 11:13:50.950 Configuration file is c:\p12migration.ini
    06/04/2010 11:13:51.482 Connecting to Project Server 2007 Draft db...
    06/04/2010 11:13:51.497 Creating DSN: name = MSP-12-WORKING-DB-DSN, server = snltests\testamf2008, db = Project2007Draft, trusted = 1
    06/04/2010 11:13:51.544 Created DSN MSP-12-WORKING-DB-DSN
    06/04/2010 11:13:51.700 Connection string DSN=MSP-12-WORKING-DB-DSN;UID=;APP=2007 Microsoft Office system;WSID=SNLTESTS;DATABASE=Project2007Draft;Tru sted_Connection=Yes
    06/04/2010 11:13:51.700 Connecting to Project Server 2007 published db...
    06/04/2010 11:13:51.700 Creating DSN: name = MSP-12-PUBLISHED-DB-DSN, server = snltests\testamf2008, db = Project2007Published, trusted = 1
    06/04/2010 11:13:51.716 Created DSN MSP-12-PUBLISHED-DB-DSN
    06/04/2010 11:13:51.732 Connection string DSN=MSP-12-PUBLISHED-DB-DSN;UID=;APP=2007 Microsoft Office system;WSID=SNLTESTS;DATABASE=Project2007Published ;Trusted_Connection=Yes
    06/04/2010 11:13:51.732 Project Server 2007 url = http://snltests/pwa
    06/04/2010 11:13:51.732 Creating Project Server 2007 soap object...
    06/04/2010 11:13:52.232 Creating Project Server 2007 resource soap object...
    06/04/2010 11:13:52.357 Creating Project Server 2007 winproj soap object...
    06/04/2010 11:13:52.575 Creating Project Server 2007 wssinterop soap object...
    06/04/2010 11:13:52.669 Getting all Upgraded Projects from Project Server 2007
    06/04/2010 11:13:52.685 preparing Query select distinct A.UPG_P11_ENT_ID, A.UPG_P12_ENT_UID, B.PROJ_NAME, C.UPG_PROJ_P11_NAME from dbo.MSP_P12UPGRADE_ENTITY_MAPS A, dbo.MSP_PROJECTS B, dbo.MSP_P12UPGRADE_PROJECT_UPGRADES C WHERE A.UPG_P12_ENT_UID = B.PROJ_UID AND A.UPG_P11_ENT_ID = C.UPG_PROJ_P11_ID AND A.MD_ENT_TYPE_UID = 'CECFE271-6660-4ABE-97ED-208D3C71FC18'
    06/04/2010 11:13:52.685 Executing query failed with -1
    06/04/2010 11:13:52.700 Cmd failed retcode= -1
    06/04/2010 11:13:52.716 Err1 = S0002 Err2 = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.MSP_P12UPGRADE_ENTITY_MAPS'.
    06/04/2010 11:13:52.716 cmd.Execute failed with status hr = 80004005
    06/04/2010 11:13:52.716 ERROR: Initializing Project Server 2007 Communicator object failed
    06/04/2010 11:13:52.716 Initialize() failed

    Is there someone who know what the problem is? I can't find it on the internet. The things I found was the logfile longer.

    Thanks in advance

    Regards

    Bart

  • #2
    Re: Migration Projectserver2003 to projectserver2007

    This may be one where you need to get Microsoft involved, It looks as if a database or table 'dbo.MSP_P12UPGRADE_ENTITY_MAPS' doesnt exist (or has a different name)
    There are a few google results for it:
    http://www.google.co.uk/search?hl=en...meta=&aq=f&oq=
    Tom Jones
    MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
    PhD, MSc, FIAP, MIITT
    IT Trainer / Consultant
    Ossian Ltd
    Scotland

    ** Remember to give credit where credit is due and leave reputation points where appropriate **

    Comment


    • #3
      Re: Migration Projectserver2003 to projectserver2007

      Thanks for the quick answer, I found those results but there logfiles go futher then mine. Must I call Microsoft then for this?

      Thanks.

      Gr. Bart

      Comment


      • #4
        Re: Migration Projectserver2003 to projectserver2007

        No, you don't have to, but if you need results in a given timescale, the cost of the support call (free if you have a technet subscription) is, IMHO, well worthwhile!
        Tom Jones
        MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
        PhD, MSc, FIAP, MIITT
        IT Trainer / Consultant
        Ossian Ltd
        Scotland

        ** Remember to give credit where credit is due and leave reputation points where appropriate **

        Comment


        • #5
          Re: Migration Projectserver2003 to projectserver2007

          Ok, Thanks. I will call them

          Comment

          Working...
          X