Common Database Issues and Solutions with BMC Remedy AR Server

November 18th, 2009 by Venkat Leave a reply »

These are general database related issues faced by Remedy Admins/Developers

1) Cannot access database files

Issue: When starting the AR System server, you receive a message stating that one or more files cannot be accessed. The server will not start if an important configuration file is missing.

Solution: First, check that you are running as the user who installed the AR System, usually root. The database files are owned by this user to protect them from unauthorized access. The AR System server must be run as this user to be able to access these files.

If you are running as the correct user, check the file /etc/ar.conf for UNIX or\<ar_install_dir>\conf\ar.cfg for Windows NT. It should contain an entry beginning withServer-directory: followed by the full path name to the AR System database directory (for example, /<ar_install_dir>/db). If this is not correct, change the path name and restart the server.

If you are the correct user and the path name is correct, check to see if the file that is mentioned in the error message exists (maybe it was accidentally deleted). If the file is missing, restore it from a file backup. Remember, no one should delete any files in this database directory. The AR System creates and deletes the files as appropriate based on operations within the AR System.

If the file exists, check the permissions on the file to make sure that it is readable and writable by the current user. Again, no one should modify or change any of the files in this database directory. The AR System updates and manages these files as appropriate based on operations within the AR System.

2) Cannot access the SQL database

Issue: At start-up, you get a message stating that the server cannot access the SQL database. If it cannot access the database, the server will not start.

Action: First, if you are using the UNIX AR System, check that you are running as the user who installed the AR System, usually root. You must always run the server as the user who installed the AR System files.If you are running as the correct user, look in the file /etc/ar.conf for UNIX or\<ar_install_dir>\conf\ar.cfg for Windows NT. It should contain an entry beginning with Dbhome-directory: followed by the full path name to the home directory of the SQL database (for example, /usr/sybase). If this is not correct, change the path name and restart the server.

If you are the correct user and the path name is correct, check the other settings in the UNIX/etc/ar.conf or Windows NT \<ar_install_dir>\conf\ar.cfg file to make sure that they are correct for your database. The labels and settings are specific to the database you are using. In general, you should set all of the environment variables that you need before starting any interactive tool that accesses the database. If these are not set correctly, correct them as needed.

3) SQL database full (SQL database)

Issue: The space allocated to the database system (either for the data or transaction log) has been filled.

Action: You can use the ALTER command in the database system to allocate additional space. For more information, see the documentation that came with your database.

Delete ARs which you no longer need and do not need to access in the future.

Archive older ARs that you do not currently need, but may need in the future. You can use the User Tool to find ARs that you can archive (for example, you can query for all ARs closed over 6 months ago). Then, use the Report option and choose the AR Export format. This exports all of the ARs that matched the query criteria into a file that is compatible with the arcopy program. Using the arcopyprogram and this file, you can restore these ARs at a later date, if needed.

Source: sun.com

Advertisement

2 comments

  1. George says:

    Nice post, But it would be nicer if you have shown with some examples..

    • Venkat says:

      Hi George,

      For each error mentioned in the post they had a brief example and explanation. I can explain more if you need anything in particular. Feel free to ping me anytime.

      Venkat

Dare to share..

%d bloggers like this: