Db_Vista errors

Clovertech Forums Read Only Archives Cloverleaf Cloverleaf Db_Vista errors

  • Creator
    Topic
  • #49441
    Julie Kimmel
    Participant

      Hello,

      I am on Windows 2000, 5.2 Quovadx.

      Sometimes I get Db_Vista errors ….. I have heard that these errors would only occur if you attempt to get into the database multiple times at once….but I often get these errors when no one is anywhere near Cloverleaf. (also..these are not being backed up..so that can be ruled out)

      I can’t provide the specific error, I have seen a number of different ones (-921, -927 (I think))

      (when ever I see them I have to take imidiate action, and sometimes fail to capture the error or log file before it is overwritten for good to get my evidence)

      So I just wonder…what in the world could cause the Db_Vista errors when no users are involved?

      Thanks for any input!

      Julie

      Austin Regional Clinic

    Viewing 8 reply threads
    • Author
      Replies
      • #61972
        Rick Martin
        Participant

          Julie,

          We’ve experienced similar failures (Windows 2000 and 5.3).  We were also told to remove the directories from scanning by AntiVirus software, which we did, but still experience random failures.

          For those that have removed these directories from backup and antivirus scanning; how are you getting backups for disaster recovery purposes?

        • #61973
          garry r fisher
          Participant

            Hi Rick,

            Yes – Db_Vista’s are one of my favourites as well:-)

            The contents of the exec directories are created and updated at runtime – hence the need to exclude. If you do have a disaster and lose Cloverleaf then there is no need to restore this directory. As to recovery thebest way is to check SMAT or resend from the third party for the problem period. Hopefully you will not have a backlog so have data in the recovery database at the time of failure (Murphy’s law say’s different!).

            Regards

            Garry

          • #61974
            Charlie Bursell
            Participant

              A tip if you even suspect your database is corrupt.

              You can shut everything down then blow away the whole directory, $HCISTEDIR/exec/databases.

              Then simply copy the entire directory from $HCIROOT/siteProto/exec/databases to $HCISITEDIR/exec

              Be sure the permissions and ownship are correct after copy

              Sometimes you only need the vista.taf file, but sometimes just to be sure, I like to start from scratch.

            • #61975
              garry r fisher
              Participant

                Hi,

                We tend to do a similar thing but we delete the whole exec directory and then copy the one from siteProto. I might try Charlies suggestion next time I have a problem.

                Regards

                Garry

              • #61976
                TorfinnK
                Participant

                  Hi

                  We often excperienced the problem with a 921 db_Vista error on our Windows 2003 servers. My solution is to close down all processes and restart the server and in 98% it will work and we don’t loose messages. My excperience is that any hcidbinit command don’t work or delets the message that are in the error/recovery db’s. Deleting the exec/database directory will delete all messages in the db’s, but I used it as a last chance solution when a restart doesn’t work.

                  For me this is the single most irritating thing about Cloverleaf and IMHO Quovadx never taken this problem serious.

                • #61977
                  Rob Abbott
                  Keymaster

                    Quovadx is taking embedded database issues very seriously.

                    5.6 includes a significant upgrade to the embedded Raima database as well as support for per-site lock managers on Windows.

                    In addition there will be an option for an “RDM server” database which uses different technology than the existing lock managers.

                    The above enhancements should increase the stability of the database on the Windows platform.

                    We are looking for beta testers for 5.6.  If you’re interested, please contact your CRM.  

                    We’ll have more information on 5.6 at our user conference in October.

                    Rob Abbott
                    Cloverleaf Emeritus

                  • #61978
                    garry r fisher
                    Participant

                      Rob,

                      That’s good news. As usual I won’t be attending the user conference this year 🙁 – That’s one of the problems of living and working in the UK – there’s no quick and easy way to get to Texas.

                      When will further information be available on 5.6 to the likes of me:-)?

                      Regards

                      Garry

                    • #61979
                      Robert Gordon
                      Participant

                        We have found that trend micro can lock files in subsequent directories under the principal folder listed as an exception.  The solution involves configuring real time scan and manual scanning, which have seperate configuration files with the following information:

                        First exclude the database directory.

                        Include all file types in the directory as an exclusion with directory information; for some reason the global files type exclusion does not work for real time scan, but does work in manual scans.

                        Include the windows swap file as part of the exclusion; windows can swap out memory either program or data, if your virus solution scans memory why do the work twice.

                      • #61980
                        Rick Brown
                        Participant

                          For those of you that are getting dbvista errors that will not clear on Windows you can stop and start the QDX service to clear these instead of rebooting.  This seemed to do the trick for me in the past and may save you a few minutes instead of rebooting.  Go ahead and do a site cleanup before you bring things back up.

                          Good to hear each site will have it’s own locking mechanism.

                          Thanks,

                          Rick

                      Viewing 8 reply threads
                      • The forum ‘Cloverleaf’ is closed to new topics and replies.