UNSOLVED

jschulenburg

updated

20 years ago

0

21158

December 18th, 2006 11:00

Move repository to another disk

Hi,

My collegue installed Dell OpenManage and now the complete package is installed on the system drive. I, however, would like to move the repository data to another, larger, drive (e.g. a data drive) to be sure the system drive isn't filled with updates completely.

Is there a way to move the repository or do i have to reïnstall Dell OpenManage?


Kind regards,
Jan Schulenburg
  • DELL-JamesC

    206 Posts

    481

    0

    Posted December 18th, 2006 19:00

    ITA stores all of it's data in a SQL database.  By default this is an MSDE / SQL Expres instance on the same server.  All you will need to do is delete all current packages in the ITA Software Updates screen in the gui, change the pointer in the database and re-import the updates.
     
    1.  Delete all packages from the ita gui, manage > software updates, left pane under IT Assistant Repository
    2.  Delete the package files from the default location on the C drive. 
    3.  Change the repositoryLocation field in the repository table.  The following TSQL example sets the repository location to e:\dell\ita\ItaRepository (note the double backslash at the lowest level!).  To change the data you can use the SQL CLI called OSQL.  Osql should be in the path on your ITA server, you can run osql -? to check.  Copy the code below and paste it into notepad. 
     
    /** change ITA Software Update Repository Location **/
    use itassist
    go
    SET QUOTED_IDENTIFIER ON
    GO
    SET ANSI_NULLS ON
    GO
    update repository
    set repositoryLocation = 'e:\dell\ita\\ItaRepository'
    where RepositoryName = 'IT Assistant Repository'
    GO
    SET QUOTED_IDENTIFIER OFF
    GO
    SET ANSI_NULLS ON
    GO
    /*****end****/
     
    4.  Change where you want the repository to be (the location in line 9) and save it as 'update_repository_loc.sql'.
    5.  Run it with osql -i update_repository_loc.sql -E  The output should look like this:
    E:\microsoft\sql>osql -i update_repository_loc.sql -E
    1> 2> 3> 1> 2> 1> 2> 1> 2> 3> 4> (1 row affected)
    1> 2> 1> 2> 1> 2>
    E:\microsoft\sql>
     
    6.  Restart the ITA Services.
    7.  Re-import some packages and verify they are being stored in the new location.

    Message Edited by DELL-JamesC on 12-18-200603:03 PM

  • 481

    0

    Posted December 20th, 2006 05:00

    Works like a charm! Thank you for this quick response.

    Kind regards,

    Jan Schulenburg
    Oad Reizen BV
  • dav1dr4y

    2 Posts

    481

    0

    Posted January 29th, 2008 16:00

    Excellent!  Thanks.
     
    /David
    :robotvery-happy:
  • StarkSA

    28 Posts

    481

    0

    Posted May 4th, 2008 14:00

    I followed these steps, moving the repository to a storage server.

     

    The repository location correctly displays in ITA, however, when importing packages in ITA the repository folders are empty.  There are no error messages in ITA or in the Event Logs.

  • OMNavigator

    291 Posts

    481

    0

    Posted May 5th, 2008 08:00

    Which version of IT Assistant are you using? I think there was a slight change in the folder structure of Repository when Online Synchronization feature got introduced... (there are 2 sub-folders under the Repository - ITA and Online) and corresponding 2 entries in the database.
  • StarkSA

    28 Posts

    481

    0

    Posted May 5th, 2008 13:00

    ITA version is 8.2

     

    The subfolders are created, but no files are downloaded using the online synchronization/import method.

     

     

  • bowhuntr09

    12 Posts

    481

    0

    Posted June 30th, 2008 14:00

    I have attempted the method listed here. I am running ITA 8.2.0 and the repository shows the right path in ITA now but when I try to import I get this error:

     

    Error Code: 1904

    Error message: e:\dell\ita\ItaRepository is not a supported repository location