Results 1 to 8 of 8
  1. #1
    Join Date
    Mar 2004
    Posts
    4

    Exclamation Unanswered: NTDBSMGR.EXE problem

    running Pervasive SQL V8 on a win 2003 Server for a third party commercial applicaiton. The problem were having is sometimes all aplication on the clients hang. During this time CPU at 99% on NTDBSMGR.EXE and I restart the server to resolve the problem.


    What sould I do,to resolve this problem.
    some log in pvsw.log is ..
    03-26-2004 12:14:31 NTMKDE 00000634 NTDBSMGR.EXE DIALOG2 W The file C:\D7000\D7K\@BM2004\CARI00C.DAT is rolling back.
    03-26-2004 12:14:32 NTMKDE 00000634 NTDBSMGR.EXE DIALOG2 W The file C:\D7000\D7K\@BM2004\CARI10T.DAT is rolling back.
    03-26-2004 12:14:59 NTMKDE 00000634 NTDBSMGR.EXE DIALOG2 W The file C:\D7000\D7K\@BM2004\CRHDSTN.DAT is rolling back.
    03-26-2004 12:17:00 NTMKDE 00000634 NTDBSMGR.EXE DIALOG2 W The file C:\D7000\D7K\@BM2004\STOK29T.DAT is rolling back.
    03-26-2004 12:18:11 NTMKDE 00000634 NTDBSMGR.EXE DIALOG2 W The file C:\D7000\D7K\@BM2004\STOK74T.DAT is rolling back.
    03-26-2004 12:58:14 NTMKDE 000005C0 NTDBSMGR.EXE DIALOG2 W Resources allocated
    03-27-2004 09:56:51 NTMKDE 000005C4 NTDBSMGR.EXE DIALOG2 W Resources allocated
    03-29-2004 10:02:08 NTMKDE 00000554 NTDBSMGR.EXE DIALOG2

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    Are you using Pervasive.SQL V8 SP1? If not, you should update. When the engine jumps to 99% CPU utilization, are you running any ODBC/SQL queries? If so, you're probably running an unoptimized query.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  3. #3
    Join Date
    Mar 2004
    Posts
    4
    I have installed Pervasive.SQL V8 Security Feature Pack (8.5) yesterday to resolve this problem. Should I install service pack1 ?

  4. #4
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    No. 8.5 was released after SP1. Did installing 8.5 solve the problem?
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  5. #5
    Join Date
    Mar 2004
    Posts
    4

    Red face

    no ( any advice?

  6. #6
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    Open a support incident with Pervasive would be my next suggestion.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  7. #7
    Join Date
    Mar 2004
    Posts
    4
    I turned of cache engine on each client 2 days ago. for 2 days no problem..

  8. #8
    Join Date
    Apr 2004
    Posts
    1
    Originally posted by micromadmax
    I turned of cache engine on each client 2 days ago. for 2 days no problem..
    Did this fix the problem? The problem that I'm seeing has nearly identical symptoms - only it is 7.95 (2000i). NTDBSMGR goes wild and all other client activity essentially stops.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •