+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 30 of 30
MIS Systems Thread, reason 0!!!!! in Technical; This is how I have managed to fix a reason 0 error before. Reason 0 Fix Take a backup using ...
  1. #16
    danrhodes's Avatar
    Join Date
    Sep 2008
    Location
    Wath Upon Dearne
    Posts
    1,513
    Thank Post
    157
    Thanked 181 Times in 150 Posts
    Rep Power
    67
    This is how I have managed to fix a reason 0 error before.

    Reason 0 Fix

    Take a backup using SQL Sesrver management Studio

    Paste the following into the query windows and then click execute

    use sims
    go
    exec sims.db_p_install
    exec sims.db_p_grant

  2. #17

    Join Date
    Sep 2007
    Location
    Somerset
    Posts
    59
    Thank Post
    5
    Thanked 14 Times in 11 Posts
    Rep Power
    16
    Just to throw another cause of reason 0 into the pot, we are currently having problems (only in the last 2 weeks) where our corporately provided AV (eTrust) is preventing the openning of files in the S:\SIMS\Setups folder to return the file version number to SIMSLOAD to see if an update is required. This is not a SIMS problem, but a problem in SIMS caused by another product.
    We can show this by seeing how long File explorer takes to display the file version.

  3. #18
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    54
    akitajewsk,
    Have you not registered a case for this with your Support Desk?

  4. #19

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    Quote Originally Posted by splattthecat View Post
    Just to throw another cause of reason 0 into the pot, we are currently having problems (only in the last 2 weeks) where our corporately provided AV (eTrust) is preventing the openning of files in the S:\SIMS\Setups folder to return the file version number to SIMSLOAD to see if an update is required. This is not a SIMS problem, but a problem in SIMS caused by another product.
    We can show this by seeing how long File explorer takes to display the file version.
    I'm sure somewhere in the recommended setup, you are supposed to exclude the S folder from AV checks. There's definitely a list of certain file extensions that should be excluded if not the entire drive.

    I've often had this issue when hacking around with test servers, and it can be due to mismatch between password and username from restoring the wrong file to the server. The detach / reattach thing or those sql scripts mentioned earlier can sometimes fix that.
    Last edited by vikpaw; 20th July 2010 at 11:19 AM. Reason: irrelevant part of post moved to other thread

  5. #20

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    Quote Originally Posted by creese View Post
    Perhaps a SIMS error message thread should started, as most of the above is of no use to the OP.

    Check connect,ini, SQL Engine, shared drive. 3 simple checks, if it's none of those dig a bit deeper, it really is very simple 99.9% of cases and takes no more than 2 minutes as opposed to 48hrs discussing how the error would be better worded. I'm off, I have offered the OP help off-thread.
    Good point, i will prune off posts but it may obscure some meaning.

    EDIT: here for anyone bothered http://www.edugeek.net/forums/mis-sy...-messages.html
    Last edited by vikpaw; 20th July 2010 at 11:22 AM.

  6. #21
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    54
    Quote Originally Posted by vikpaw View Post
    Good point, i will prune off posts but it may obscure some meaning.EDIT: here for anyone bothered http://www.edugeek.net/forums/mis-sy...-messages.html
    Maybe somebody should cream off the incorrect statements that appear on here.

    What is good for the goose is good for the gander!

  7. #22

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    Quote Originally Posted by Sivadam View Post
    Maybe somebody should cream off the incorrect statements that appear on here.

    What is good for the goose is good for the gander!
    WHAT?!
    There are no incorrect statements.

  8. #23

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,036
    Thank Post
    167
    Thanked 343 Times in 278 Posts
    Rep Power
    168
    Quote Originally Posted by vikpaw View Post
    WHAT?!
    There are no incorrect statements.
    Printers causing Reason 0?? Since when?

  9. #24

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    Quote Originally Posted by creese View Post
    Printers causing Reason 0?? Since when?
    It does have a validating prefix 'I believe'.

    Quote Originally Posted by Michael View Post
    I believe reason 0 can also mean no printer is installed.
    There's no way to vet every post for accuracy. It's up to the reader to determine how useful the advice is and make their own judgement.
    Anyone else could have ( should have? ) corrected that, but the thread was too busy being derailed.

  10. #25

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,036
    Thank Post
    167
    Thanked 343 Times in 278 Posts
    Rep Power
    168
    Quote Originally Posted by vikpaw View Post
    It does have a validating prefix 'I believe'.
    .
    Wait for the avalanche of posts starting 'I believe.....'

    EDIT: I had a PM from the OP and I will help him through the problem.

  11. #26
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    54
    Quote Originally Posted by akitajewski View Post
    We are running sims in our school ....... but the problem is we keep on getting this reason 0 does anyone know what it mean please we are kind of confussed now
    One assumes you had checked KB72254 from SupportNet before posting to this thread??


    And
    Well done Creese!

  12. #27

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336

    I believe. . .

    Quote Originally Posted by creese View Post
    Wait for the avalanche of posts starting 'I believe.....'

    EDIT: I had a PM from the OP and I will help him through the problem.
    ... Good job - report back wont ya..?

  13. #28

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    The discussion concerning use of Capita SupportNet and support desks in general has been moved to a new thread here

    http://www.edugeek.net/forums/mis-sy...iscussion.html

    Please can any more posts here be on topic regarding the Reason 0 error. For the most part Creese is working through the issue with the OP and will hopefully report back with the resolution.

  14. #29

    Join Date
    Aug 2010
    Location
    Bristol
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by danrhodes View Post
    This is how I have managed to fix a reason 0 error before.

    Reason 0 Fix

    Take a backup using SQL Sesrver management Studio

    Paste the following into the query windows and then click execute

    use sims
    go
    exec sims.db_p_install
    exec sims.db_p_grant
    Wow !
    worked like a treat !
    Thank you so much.

    (we upgraded SQL 2005 to SQL 2008 on to a new SBS 2008 server)

  15. #30

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,135
    Thank Post
    352
    Thanked 577 Times in 474 Posts
    Rep Power
    142
    Quote Originally Posted by enigmalive View Post
    Wow !
    worked like a treat !
    Thank you so much.

    (we upgraded SQL 2005 to SQL 2008 on to a new SBS 2008 server)
    SBS - Small business server?!? As in, not supported and has exchange? You have Exchange and SIMS (SQL) running on the same box??

SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

Similar Threads

  1. [Video] The real reason for the recession.
    By mattx in forum Jokes/Interweb Things
    Replies: 0
    Last Post: 22nd January 2010, 02:10 PM
  2. Sims Reason 0
    By FN-GM in forum MIS Systems
    Replies: 24
    Last Post: 14th September 2009, 09:05 PM
  3. Reason 3
    By amvc in forum MIS Systems
    Replies: 3
    Last Post: 9th June 2008, 09:50 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
  •