+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 25
MIS Systems Thread, SIMS FMS General SQL Error LRM07 in Technical; Hi all, The school manager is looking at creating the entry for new fianancial year in FMS, how ever when ...
  1. #1

    Join Date
    Oct 2012
    Posts
    86
    Thank Post
    11
    Thanked 3 Times in 3 Posts
    Rep Power
    5

    SIMS FMS General SQL Error LRM07

    Hi all,

    The school manager is looking at creating the entry for new fianancial year in FMS, how ever when it comes to clicking 'save' at the end of the process I get a lovely error message reading...

    'General SQL error [Microsoft SQL Native Client] SQL Server LRM07'

    Again I'll have to admit I'm a little wet behind the ears when it comes to SIMS, the server and workstation have been rebooted, all the other features in SIMS/FMS work perfectly happily for everyone in the school, it's just when trying to create a record for the new financial year.

    Does anyone have any suggestions as to where to start with this?

    Thanks in advance for the always sterling help.

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    LRM33 was a printer issue, so worth a try.

  3. #3
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 493 Times in 376 Posts
    Rep Power
    0
    It could be a printer error like @vikpaw suggested, but I think it's an error relating to lack of write permissions to the PDOXUSRS.NET file, or the folder it's stored in. In the BDE settings, we set the Paradox NET DIR location to C:\IDAPI and ensure every user has full write permissions to that folder.

  4. #4

    Join Date
    Oct 2012
    Posts
    86
    Thank Post
    11
    Thanked 3 Times in 3 Posts
    Rep Power
    5
    Quote Originally Posted by Rawns View Post
    It could be a printer error like @vikpaw suggested, but I think it's an error relating to lack of write permissions to the PDOXUSRS.NET file, or the folder it's stored in. In the BDE settings, we set the Paradox NET DIR location to C:\IDAPI and ensure every user has full write permissions to that folder.
    I think my lack of SIMS knowledge is my down fall here, what are the 'BDE settings, and paradox net etc, I understand about write permissions but not a lot else, unfortunately I've walked into a situation were everything has been setup long before I arrived and now there is literally no one in the school with any knowledge of the system and its configuration.

    When I search for the pdoxusers.net file it's sat on C:\ on the server in no folder

    Cheers
    .

  5. #5

    Join Date
    Oct 2012
    Posts
    86
    Thank Post
    11
    Thanked 3 Times in 3 Posts
    Rep Power
    5
    I'll log on to the system as domain admin and see if that changes the outcome as it should rule out write permissions...

  6. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    Then it's most likely permissions if you're using a win7 client.
    There are threads here with details on moving the file as granting permissions.

  7. #7

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    Try run as admin on FMS to rule it out.

  8. #8

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    But then your Sims drive connection may not work!

  9. #9
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 493 Times in 376 Posts
    Rep Power
    0
    Quote Originally Posted by lquinnuk View Post
    I think my lack of SIMS knowledge is my down fall here, what are the 'BDE settings, and paradox net etc, I understand about write permissions but not a lot else, unfortunately I've walked into a situation were everything has been setup long before I arrived and now there is literally no one in the school with any knowledge of the system and its configuration.

    When I search for the pdoxusers.net file it's sat on C:\ on the server in no folder

    Cheers
    .
    It's not specifically on the server (although it will be on the server as FMS is installed on it). It's a file on every machine that has the FMS client installed. I "believe" it controls table access to the FMS database to ensure users don't try and amend the same data at the same time.

    Open the control panel on the workstation, and you'll find a BDE Administrator option. Open it, select the configuration tab then expand Drivers | Native | Paradox and the first setting in the list is the NET DIR (where the PDOXUSRS.NET file is created). Try setting it to a folder off the root of C: (like C:\IDAPI) and click the blue arrow to save the changes. Create an IDAPI folder on the C: drive and ensure that users have full write access to this folder, then get the user to try again.
    Last edited by Rawns; 12th March 2013 at 01:53 PM.

  10. #10

    Join Date
    Oct 2012
    Posts
    86
    Thank Post
    11
    Thanked 3 Times in 3 Posts
    Rep Power
    5
    Quote Originally Posted by Rawns View Post
    It's not specifically on the server (although it will be on the server as FMS is installed on it). It's a file on every machine that has the FMS client installed. I "believe" it controls table access to the FMS database to ensure users don't try and amend the same data at the same time.

    Open the control panel on the workstation, and you'll find a BDE Administrator option. Open it, select the configuration tab then expand Drivers | Native | Paradox and the first setting in the list is the NET DIR (where the PDOXUSRS.NET file is created). Try setting it to a folder off the root of C: (like C:\IDAPI) and click the blue arrow to save the changes. Create an IDAPI folder on the C: drive and ensure that users have full write access to this folder, then get the user to try again.
    OK I'll give that a try, I've just tried logging onto the work station as domain admin and got the same error as before.

    I've spoken to the user and she's managed to create a new financial year, year in year out since 2001 so I'm puzzled as to why this year decided to have a problem.

    She's out on duty at the moment so I'll have to wait for her to get back before I can try it (coded door lock) I'll try it and let everyone know asap

  11. #11

    Join Date
    Oct 2012
    Posts
    86
    Thank Post
    11
    Thanked 3 Times in 3 Posts
    Rep Power
    5
    I've also tried running FMS directly from the server it's installed on loggin on as the user and performing the same actions, and I got the same error.

    I'm not sure if this changes anything in terms of diagnosing the problem

    cheers.

  12. #12

    Join Date
    Oct 2012
    Posts
    86
    Thank Post
    11
    Thanked 3 Times in 3 Posts
    Rep Power
    5
    Quote Originally Posted by Rawns View Post
    It's not specifically on the server (although it will be on the server as FMS is installed on it). It's a file on every machine that has the FMS client installed. I "believe" it controls table access to the FMS database to ensure users don't try and amend the same data at the same time.

    Open the control panel on the workstation, and you'll find a BDE Administrator option. Open it, select the configuration tab then expand Drivers | Native | Paradox and the first setting in the list is the NET DIR (where the PDOXUSRS.NET file is created). Try setting it to a folder off the root of C: (like C:\IDAPI) and click the blue arrow to save the changes. Create an IDAPI folder on the C: drive and ensure that users have full write access to this folder, then get the user to try again.
    Have carried out the instructions as you suggested but to no avail, exactly the same issue.

    I've got a called logged with our external support company who set up SIMS originally and am waiting to hear back from them.

    In the mean time any other suggestions will be greatly appreciated.

  13. #13

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    Reinstall SQL native client.
    Reinstall FMS.
    ideally on a new machine rather than mess with the existing working one.

  14. #14

    Join Date
    Oct 2012
    Posts
    86
    Thank Post
    11
    Thanked 3 Times in 3 Posts
    Rep Power
    5
    Quote Originally Posted by vikpaw View Post
    Reinstall SQL native client.
    Reinstall FMS.
    ideally on a new machine rather than mess with the existing working one.
    I was hoping to avoid such extreme actions, new machines are like gold dust in our school, as are old ones, I'll definitely wait for a reply from the support company before I go down that route.

    On the subject, how is FMS installed? I've installed SIMS by running the siminst.exe (that might be spelt slightly wrong) on the server, but as of yet I haven't needed to install FMS, is it more or less the same method?

  15. #15

    Join Date
    Oct 2012
    Posts
    86
    Thank Post
    11
    Thanked 3 Times in 3 Posts
    Rep Power
    5
    Is it possible that windows updates could have caused any problems.

    The SIMS server is still running 2003, could the work station (win 7) have installed any 2008/2012 SQL updates that are causing a conflict or is that unlikely?



SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. [SIMS] FMS general SQL error after server move
    By yjb in forum MIS Systems
    Replies: 12
    Last Post: 2nd November 2012, 04:37 PM
  2. Replies: 7
    Last Post: 1st December 2011, 10:26 PM
  3. [SIMS] General SQL Error aftering upgrading to FMS 6.136
    By adamf in forum MIS Systems
    Replies: 1
    Last Post: 22nd December 2010, 12:24 PM
  4. [SIMS - FMS] GDI32.DLL error [Solved]
    By jamesloker in forum MIS Systems
    Replies: 36
    Last Post: 15th July 2010, 12:04 AM
  5. SQL 2005 and SIMS FMS Finance
    By thom in forum MIS Systems
    Replies: 2
    Last Post: 30th August 2007, 05:50 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
  •