+ Post New Thread
Results 1 to 7 of 7
MIS Systems Thread, FMS: General SQL Error - Could not find stored procedure ‘pix_GetARGUID’. in Technical; Hi Everyone, Got an odd problem with FMS, I’ve basically upgraded our server and moved SIMS and everything to a ...
  1. #1
    MattGibson's Avatar
    Join Date
    May 2008
    Location
    Epsom
    Posts
    169
    Thank Post
    20
    Thanked 11 Times in 8 Posts
    Rep Power
    15

    FMS: General SQL Error - Could not find stored procedure ‘pix_GetARGUID’.

    Hi Everyone,

    Got an odd problem with FMS, I’ve basically upgraded our server and moved SIMS and everything to a new DC all seems to be fine apart from FMS won’t work. It pops up with the logon screen and prompts you for a username and password, then I get the following message:
    Error
    General SQL Error.
    [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure ‘pix_GetARGUID’.
    I’ve tried updating the SQL Native Client Driver to 2008 as suggested by someone else; Firewalls are all disabled. I tried a dummy username and password and it says invalid logon so I know its authenticating….. Any suggestions are welcome.

    Server 2008 R2 x64

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,844
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    This error is on the server?
    Can u reinstall the FMS client after update if native client ..

  3. #3
    MattGibson's Avatar
    Join Date
    May 2008
    Location
    Epsom
    Posts
    169
    Thank Post
    20
    Thanked 11 Times in 8 Posts
    Rep Power
    15
    Hi Vickpaw,

    I can confirm that I've done this several times, even tried pasting the install folder from the old server.

    Tried FMSInst.exe that did nothing the. Went into the \Setups\FMS\ then ran the FMSApplication.exe which Installed the application and the SQL driver.

  4. #4
    Ghostgame's Avatar
    Join Date
    Jun 2012
    Location
    Ipswich
    Posts
    281
    Thank Post
    30
    Thanked 66 Times in 39 Posts
    Rep Power
    20
    Have you tried de-attaching and then attaching the FMS database?
    Might iron out some kinks.

  5. 2 Thanks to Ghostgame:

    MattGibson (30th May 2013), vikpaw (30th May 2013)

  6. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,844
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    That's true. How did you move the database to new server. If in place detach reattach doesn't work, you might have to detach from old and reattach it to the new.

  7. Thanks to vikpaw from:

    MattGibson (30th May 2013)

  8. #6
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    Worrying if a stored procedure is missing. Maybe run dbUpgrade and point it to the FMS setups folder to check that the FMS database has not somehow missed a database upgrade file.

  9. Thanks to Rawns from:

    MattGibson (30th May 2013)

  10. #7
    MattGibson's Avatar
    Join Date
    May 2008
    Location
    Epsom
    Posts
    169
    Thank Post
    20
    Thanked 11 Times in 8 Posts
    Rep Power
    15
    Thanks Guys, By De-Attch and Re-attached seems to have worked so not sure what that's all about considering I did the same process yesterday!

    I've also just ran DBUpdate and it was well out of date! v3.something! when were on v6 now!! - Anyway all working!

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SIMS FMS General SQL Error LRM07
    By lquinnuk in forum MIS Systems
    Replies: 24
    Last Post: 13th March 2013, 07:02 AM
  2. [SIMS] FMS general SQL error after server move
    By yjb in forum MIS Systems
    Replies: 12
    Last Post: 2nd November 2012, 03:37 PM
  3. Replies: 7
    Last Post: 1st December 2011, 09:26 PM
  4. [SIMS] General SQL Error aftering upgrading to FMS 6.136
    By adamf in forum MIS Systems
    Replies: 1
    Last Post: 22nd December 2010, 11:24 AM
  5. Replies: 2
    Last Post: 21st August 2009, 11:36 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
  •