+ Post New Thread
Page 1 of 3 123 LastLast
Results 1 to 15 of 35
MIS Systems Thread, SIMs Server Migration - Documents Server Issue in Technical; We've recently completed a SIMs server migration, using DBAttach to detach from the old server SQL instance, and then DBAttach ...
  1. #1

    Join Date
    Apr 2011
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    SIMs Server Migration - Documents Server Issue

    We've recently completed a SIMs server migration, using DBAttach to detach from the old server SQL instance, and then DBAttach again to re-attach that file onto the new server.

    However, we've had an issue with our document storage, in that when we try to run a report the following error pops up -

    ---------------------------
    SIMS .net
    ---------------------------
    Error: Retrieving the COM class factory for component with CLSID {000209FF-0000-0000-C000-000000000046} failed due to the following error: 80040154.
    ---------------------------
    OK
    ---------------------------

    This seems to indicate a registry issue, but any help or advice that you can offer will be appreciated!

  2. #2

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28° 31' 48.89", +28° 25' 37.42" ... if only.
    Posts
    3,258
    Thank Post
    182
    Thanked 375 Times in 304 Posts
    Rep Power
    183
    Having a quick look, there is a very similar error which relates to 64 bit systems

    Which report are you running, or is it any report?

  3. #3
    NorthernSands's Avatar
    Join Date
    Mar 2011
    Location
    Qatar
    Posts
    134
    Thank Post
    21
    Thanked 19 Times in 19 Posts
    Rep Power
    11
    Just to confirm:


    1. Did you change the location of the DocStorage server in SIMS (via Tools > Setups > Document Management Server)?
    2. Did you copy the DocStorage contents over to the new server?



    I tend to run SIMS and import the latest reports before copying DocStorage, this way the required folder structure is set up for you. You must do point 1) beforehand.

    Oh, and welcome to the forum.

  4. Thanks to NorthernSands from:

    waldronm2000 (3rd May 2011)

  5. #4

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28° 31' 48.89", +28° 25' 37.42" ... if only.
    Posts
    3,258
    Thank Post
    182
    Thanked 375 Times in 304 Posts
    Rep Power
    183
    Quote Originally Posted by NorthernSands View Post
    Just to confirm:


    1. Did you change the location of the DocStorage server in SIMS (via Tools > Setups > Document Management Server)?
    2. Did you copy the DocStorage contents over to the new server?



    I tend to run SIMS and import the latest reports before copying DocStorage, this way the required folder structure is set up for you. You must do point 1) beforehand.
    If the Docstorage doesn't exist, the error is usually that the report doesn't exist.

    Your point 2. is well worth mentioning. It saves having to work out the path.

    If the Docstorage is in the wrong place or you want to move it, use the following:
    Change the path of Docstorage to a physical drive as follows:

    1. At the Document Server machine select a DOS command prompt.

    2. Change the drive to point to the drive where document server is installed e.g C:\

    3. Type cd\Program Files\SIMS\SIMS .net Document Server and press enter

    4. Type dmconfig and press enter

    5. This will display the dmconfig settings
    e.g

    C:\Program Files\SIMS\SIMS .net Document Server>dmconfig
    Current server configuration:
    Protocol: http
    Port: 8080
    Directory: C:\DOCSTORAGE

    6. Type dmconfig /D D:\DOCSTORAGE (to change to D:\drive)

    7. Press enter (note: document server service will need to be restarted for this to take effect)

  6. Thanks to creese from:

    waldronm2000 (3rd May 2011)

  7. #5
    waldronm2000's Avatar
    Join Date
    Dec 2009
    Location
    Southend
    Posts
    129
    Thank Post
    49
    Thanked 12 Times in 11 Posts
    Rep Power
    13
    Hi guys

    Thanks for the replies. I was working with Andy on this one. To try to answer your queries...

    We backed up the entire contents of the Docstorage folder on an old server that was being decommissioned, and restored the contents to a new server. The Docstorage location was definitely updated on the new server, and I believe it was also checked via dmconfig.

    The original server was running Windows Server 2003 32-bit, and the new server is WS 2008 64-bit.

    Any pointers would be appreciated

    Thanks
    Mark

  8. #6
    waldronm2000's Avatar
    Join Date
    Dec 2009
    Location
    Southend
    Posts
    129
    Thank Post
    49
    Thanked 12 Times in 11 Posts
    Rep Power
    13
    By the way, it seems to affect any report.

  9. #7

    Join Date
    Sep 2007
    Location
    Somerset
    Posts
    63
    Thank Post
    6
    Thanked 18 Times in 13 Posts
    Rep Power
    18
    Are you are trying to run this report on the server itself? and if so is Microsoft Office installed on the server. I have had this sort of error when I forget Office isn't installed on servers.

  10. Thanks to splattthecat from:

    waldronm2000 (3rd May 2011)

  11. #8
    waldronm2000's Avatar
    Join Date
    Dec 2009
    Location
    Southend
    Posts
    129
    Thank Post
    49
    Thanked 12 Times in 11 Posts
    Rep Power
    13
    Good point! This is the error on the server, which doesn't have office installed. However, users are still reporting that reports aren't working, so it may be that they're getting a different message. I'll check it out.

    Thanks.

  12. #9
    waldronm2000's Avatar
    Join Date
    Dec 2009
    Location
    Southend
    Posts
    129
    Thank Post
    49
    Thanked 12 Times in 11 Posts
    Rep Power
    13
    Just had a look, and now things seem to have changed (although this seems to have happened at some point over the long weekend)...

    Although Services snap-in reports that document server service is running, netstat doesn't report the port as open, and clients fail to connect to it. Have restarted the service, but this makes no difference.

    Dmconfig reports that the documents are on C: and the Backup is on D:. If I try to change this with Dmconfig it crashes with a permission issue, even though I have Full Control on the file it can't access.

  13. #10

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,483
    Thank Post
    372
    Thanked 657 Times in 537 Posts
    Rep Power
    162
    Did the servername change, if so, you need to change the servername'd folder in docstorage folder, also in Tools > Setups > Document Management Server?

  14. Thanks to matt40k from:

    waldronm2000 (4th May 2011)

  15. #11
    waldronm2000's Avatar
    Join Date
    Dec 2009
    Location
    Southend
    Posts
    129
    Thank Post
    49
    Thanked 12 Times in 11 Posts
    Rep Power
    13
    Thanks for that. Server name changed from SERVER1 to ADMIN1, and folder name was changed accordingly.

  16. #12
    NorthernSands's Avatar
    Join Date
    Mar 2011
    Location
    Qatar
    Posts
    134
    Thank Post
    21
    Thanked 19 Times in 19 Posts
    Rep Power
    11
    Googling the original error suggests that it's related to a 32Bit process failing to run on the 64Bit OS.

    When the new server had SIMS installed, did you use the SIMSInst.EXE that was part of your original setups folder from the 2K3 box, or did you install from the latest install CD / ISO?

    I don't know if this is the cause of the problem, or if it'll fix it, but it comes to mind that the SIMSInst.EXE could be _very_ old. For some reason this file doesn't get updated when running SOLUS. You could try installing from a fresh setups folder or CD / ISO.

  17. #13
    waldronm2000's Avatar
    Join Date
    Dec 2009
    Location
    Southend
    Posts
    129
    Thank Post
    49
    Thanked 12 Times in 11 Posts
    Rep Power
    13
    We had various issues during the install, and eventually removed SIMS and reinstalled from an up-to-date SIMSInst.exe from a new setups folder.

  18. #14

    Join Date
    Jun 2007
    Location
    London
    Posts
    895
    Thank Post
    64
    Thanked 171 Times in 140 Posts
    Rep Power
    56
    According to the registry on my SIMS server CLSID {000209FF-0000-0000-C000-000000000046} refers to the 'Microsoft Office Persistent Handler'. Dunno what exactly it does but, when we had the same problem, installing MS Office on the server fixed it. But then splatthecat already told you that & you ignored it.

  19. Thanks to timzim from:

    waldronm2000 (4th May 2011)

  20. #15

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,483
    Thank Post
    372
    Thanked 657 Times in 537 Posts
    Rep Power
    162
    Back to the OP - Basically your trying to run a MS Word\Excel report without Word\Excel installed, if you create a report which outputs to a text file (txt or csv), it'll be fine. You can get away with installing the Word\Excel viewers



SHARE:
+ Post New Thread
Page 1 of 3 123 LastLast

Similar Threads

  1. Migration from CC3 server 2003 to CC4 on server 2008 - anyone else?
    By Max_Power in forum Network and Classroom Management
    Replies: 4
    Last Post: 12th January 2011, 12:34 PM
  2. SIMS Server Migration
    By mtillbrook in forum MIS Systems
    Replies: 17
    Last Post: 7th June 2010, 08:38 AM
  3. Sims installation issue on server
    By Avalon in forum MIS Systems
    Replies: 2
    Last Post: 17th October 2009, 10:15 PM
  4. SIMS Document Server, no documents found
    By adyb in forum MIS Systems
    Replies: 11
    Last Post: 4th June 2008, 03:44 PM
  5. SIMS Document Mangement Server - empty documents?
    By SteveMC in forum MIS Systems
    Replies: 7
    Last Post: 1st June 2007, 04:00 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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