+ Post New Thread
Results 1 to 12 of 12
MIS Systems Thread, SIMS Document Server, no documents found in Technical; Hi, We seem to have lost the custom reports on our database server. When you click the report, it comes ...
  1. #1

    Join Date
    Nov 2007
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    SIMS Document Server, no documents found

    Hi,
    We seem to have lost the custom reports on our database server.
    When you click the report, it comes back with a popup that basically says the document for this report does not exist in the document server.
    It was there a matter of days beforehand...
    Running the test to connect to the document server works ok. The document server folder c:\docstorage\ has a folder with the name of the file server in, and if you drill down the folders you get to documents.

    Can anyone shed any light...

    Cheers,
    Adyb

  2. #2
    altecsole's Avatar
    Join Date
    Jun 2005
    Location
    Whittington, Lancashire
    Posts
    286
    Thank Post
    40
    Thanked 36 Times in 26 Posts
    Rep Power
    26

    Re: SIMS Document Server, no documents found

    Have you just upgraded to SQL2005? We had this problem after our upgrade. We renamed the docstorage folder and restored our old one from backup. You'll have to edit your folder names if you've changed your instance name.

    We have no instance name so our path is:
    \DocStorage\ServerName\SIMS\lots of folders etc

    If our instance name was SIMS the path would be:
    \DocStorage\ServerName\SIMS\sims\lots of folders etc

  3. #3

    Join Date
    Nov 2007
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: SIMS Document Server, no documents found

    Nope, not upgraded a thing. I would understand this better if we had...
    They are just no longer linked to the available reports. The reports are all listed, but you can not access them....

  4. #4

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,413
    Thank Post
    642
    Thanked 964 Times in 664 Posts
    Blog Entries
    2
    Rep Power
    327

    Re: SIMS Document Server, no documents found

    Have you checked permissions on the folder?

  5. #5

    Join Date
    May 2006
    Posts
    159
    Thank Post
    5
    Thanked 10 Times in 5 Posts
    Rep Power
    19

    Re: SIMS Document Server, no documents found

    Did you try restarting the service?

    That usually does the trick for us when it craps out

  6. #6

    Join Date
    Nov 2007
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: SIMS Document Server, no documents found

    Right,

    the plot thickens. It looks like the server was upgraded earlier in the month from SQLAnywhere to MS SQL server.
    Not sure who performed the upgrade. The standard documents are there - it has lost the documents in the My Reports folder.
    Any thoughts....

    Adyb

  7. #7

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,413
    Thank Post
    642
    Thanked 964 Times in 664 Posts
    Blog Entries
    2
    Rep Power
    327

    Re: SIMS Document Server, no documents found

    Try renaming the DOCSTORAGE\<servername>\SIMS folder to SIMS2005 and restarting the Doc server service.

  8. #8
    rpwillis's Avatar
    Join Date
    Aug 2007
    Location
    SalamanderSoft Ltd
    Posts
    182
    Thank Post
    50
    Thanked 63 Times in 51 Posts
    Rep Power
    26

    Re: SIMS Document Server, no documents found

    I've found running FileMon from SysInternals (now owned by MicroSoft) the best tool for figuring out problems with DocServer.

    It will be able to show you which files DocServer is trying to access and the result (success, error etc).

    The best thing is that it's completely free.

    It's available from
    http://www.microsoft.com/technet/sys...k/Filemon.mspx
    Richard

  9. #9
    altecsole's Avatar
    Join Date
    Jun 2005
    Location
    Whittington, Lancashire
    Posts
    286
    Thank Post
    40
    Thanked 36 Times in 26 Posts
    Rep Power
    26

    Re: SIMS Document Server, no documents found

    Quote Originally Posted by adyb
    Right, the plot thickens. It looks like the server was upgraded earlier in the month from SQLAnywhere to MS SQL server.
    Not sure who performed the upgrade. The standard documents are there - it has lost the documents in the My Reports folder.
    Any thoughts....Adyb
    Restore your DocStorage from backup.

  10. #10

    Join Date
    Nov 2007
    Location
    UK
    Posts
    9
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: SIMS Document Server, no documents found

    Quote Originally Posted by adyb
    Right,

    the plot thickens. It looks like the server was upgraded earlier in the month from SQLAnywhere to MS SQL server.
    Not sure who performed the upgrade. The standard documents are there - it has lost the documents in the My Reports folder.
    Any thoughts....

    Adyb
    Sqlanywhere was the FMS so that means your fms has been converted to sql, and that your sims is properly also on sql 2005 instead of 2000. Sims has been sql for a number of years now, in your docstorage folder it should have the new instance on it?

  11. #11
    Ravening_Wolf's Avatar
    Join Date
    Oct 2006
    Location
    Essex :(
    Posts
    290
    Thank Post
    1
    Thanked 3 Times in 3 Posts
    Rep Power
    18

    Re: SIMS Document Server, no documents found

    We had a similar problem following the upgrade. In the end it turned out that there was another file which needed to be run (SIMSDocumentServerSetup.exe located in S:\Sims\Setups) in order for the new installation to properly locate the documents. It is possible that the person who completed the upgrade missed this step (it wasn't documented for the manual migration procedure).

  12. #12
    cuke2u's Avatar
    Join Date
    May 2008
    Posts
    15
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by Ravening_Wolf View Post
    We had a similar problem following the upgrade. In the end it turned out that there was another file which needed to be run (SIMSDocumentServerSetup.exe located in S:\Sims\Setups) in order for the new installation to properly locate the documents. It is possible that the person who completed the upgrade missed this step (it wasn't documented for the manual migration procedure).

    Hi, you are a genius, this fixed my post 2008 May upgrade issues entirely, just ran it on all workstations and the problem was solved.
    Many Thanks...
    Chris

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Document Server not working
    By woody in forum MIS Systems
    Replies: 13
    Last Post: 28th September 2011, 02:13 PM
  2. Tidying Up and found this....
    By mattx in forum Windows
    Replies: 3
    Last Post: 16th September 2007, 08:43 AM
  3. SIMS Document Mangement Server - empty documents?
    By SteveMC in forum MIS Systems
    Replies: 7
    Last Post: 1st June 2007, 03:00 PM
  4. Eeek! They have found us!!
    By ITWombat in forum Comments and Suggestions
    Replies: 14
    Last Post: 12th June 2006, 12:45 PM
  5. Found it!!
    By Dos_Box in forum Windows Vista
    Replies: 1
    Last Post: 17th May 2006, 08:34 AM

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
  •