[sims] SIMs Server Migration - Documents Server Issue

[Andynonymous]

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!

[creese]

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?

[NorthernSands]

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.

[creese]

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)

[waldronm2000]

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

[waldronm2000]

By the way, it seems to affect any report.

[splattthecat]

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.

[waldronm2000]

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.

[waldronm2000]

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.

[matt40k]

Did the servername change, if so, you need to change the servername'd folder in docstorage folder, also in Tools > Setups > Document Management Server?

[waldronm2000]

Thanks for that. Server name changed from SERVER1 to ADMIN1, and folder name was changed accordingly.

[NorthernSands]

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.

[waldronm2000]

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.

[timzim]

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.

[matt40k]

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

[creese]

I'm with Tim and Matt on this. It sounds like MS Office to me.

 

Do the reports work from workstations? If so that is definitely the problem on the server.

[waldronm2000]

Thanks to all who replied. The original message is down to the fact that Office isn't installed, which I can't do as I'm waiting for the school to sort out a site license. In the meantime, have tried from a desktop with Office installed, but no joy. I don't get the error message (as pointed out, it only means Office isn't installed) but can't connect to the document server.

[LazyD]

Hello,

 

I have a very similar problem (I think) to waldronm2000 and am yet to find a solution.

 

As far as I was aware (which isn't a massive amount of awarness), when migrating the sims database to a new server, you can do the following and it should work:

 

- Detatch the database from old server and copy files to new server

- Copy the DOCSTORAGE folder from the old server to the new server

- Install sims server, workstation and document server from fresh installation media on the new server

- Attach the sims database using dbattach on the new server, perform any upgrades to the db as required using dbupgrade

- Overwrite the fresh DOCSTORAGE folder on the new server with the one from the old server and change the server name folder in the DOCSTORAGE folder to match the new server name

 

I have done this a number of times and it has worked ok.

 

On the latest migration I've got major problems with the reports. Weird thing about the old server, there was no "docstorage" folder, there was a folder called "documents" which seemed to be the docstorage folder, although how sims knew to use that when it wasn't called "docstorage" I have no idea.

 

So I've created a new docstorage folder on the new server in the correct location and I've put the folder that was the old servers name (which was in the unusual "documents" folder) into this new docstorage folder. I've then changed the name of that folder to match the new server's name. The only reports that work now are the capita ones. The schools old custom reports no longer run on server and workstations, I just get:

 

"Error: The system cannot find the file specified"

 

I have both the word and excel viewers installed on the server.

 

I've checked that the document server location is set to this new server in setups and the test runs ok. I've never had to change that bit anyway apart from when I've taken an image of a sims server and needed to change the host or ip to match the new server. Also, their old "documents" server which eventually has all those folders that are usually in the docstorage folder, also had a few other folders first. First was documents, then "sims" and "sims2008", in the sims folder is another folder called sims, then all the 00, 0a, 0b etc folders, in the sims2008 folder are 2 other folders, "SIMS" and "SIMS05", they both contain sets of the 00, 0a, 0b etc folders.

 

I have no idea what's going on here!

 

Can anyone help? Hope you figure it out waldronm2000.

[creese]

Run the Dos routine from post No.4. This will stop the Documents problem and give you the correct location.

[LazyD]

I've run

 

dmconfig /D D:\DOCSTORAGE

 

one of the first things I tried, problem remains.

 

Also getting this error when trying to run some reports:

http://img851.imageshack.us/img851/7896/wtreportserror.png

[creese]

After you ran Dmconfig was the last line the correct path. Unless you get it exactly right it often still says Documents, so hasn't done the job.

 

As for the error, what office product have you got installed on that machine?

[LazyD]

Yes the output from dmconfig was correct for both the docstorage location, which is D:\DOCSTORAGE in my case, and the backup location.

[creese]

If you have run Dmconfig, allowed it to set up Docstorage (try to run a report) then copied the old files over... it should work.

 

After running Dmconfig you did restart the Document server??

[LazyD]

Thanks for your replies.

 

Yes I did restart the server service after running dmconfig, I even restarted the whole server.

 

Do you not think this is something to do with the strange structure of the "documents" folder from the old server?

[creese]

The old Documents structure is a Red Herring. As long as Sims has setup the new structure of Docstorage it should work.

 

Have you checked paths in all ini files?