Job Management Partner 1/Asset Information Manager Planning and Setup Guide

[Contents][Glossary][Index][Back][Next]

11.7.2 Errors specific to Embedded RDB

When Embedded RDB is used, consider errors specific to Embedded RDB in addition to those described in 11.7.1 Errors common to the DBMS.

The possible causes and troubleshooting methods for each type of error are described below.

Organization of this subsection
(1) An error occurs during the creation of the asset management database and execution stops
(2) The login window opens, but a message "Page cannot be displayed" is displayed, and you cannot log in
(3) Database connection authentication fails
(4) A database communication error occurred or an error occurred inside the database
(5) A database capacity shortage occurred
(6) Available space has been reduced on the drive where the asset management database was created

(1) An error occurs during the creation of the asset management database and execution stops

The disk at the database storage destination or the Embedded RDB that was specified when creating the database might have reached its capacity.

Re-create the asset management database on a disk that has enough space for Size, Management area, and Operation area, according to the settings that were specified in the Detailed Database Settings dialog box that was displayed during database creation.

(2) The login window opens, but a message "Page cannot be displayed" is displayed, and you cannot log in

It is possible that no asset management database has been created.

First, you must open the Server Setup dialog box. Enter values in Login ID and Password under Database Information and click the OK button.

Avoid reserved words for the login ID and service name. For the reserved words, see RESWORDS.TXT stored in the Asset Information Manager installation folder.

After that, create the asset management database.

(3) Database connection authentication fails

An error message beginning with the following character string is output to the log:

Either Login ID or Password in Database Information may have been changed after Asset Information Manager operations started.

Start the Server Setup dialog box and then reset Login ID and Password under Database Information to the status existing when the asset management database was created.

You cannot change Login ID and Password under Database Information to different values.

(4) A database communication error occurred or an error occurred inside the database

An error message beginning with the following character string is output to the log:

The DBMS server may be starting up, shut down, or stopped. Check the following:

(5) A database capacity shortage occurred

An error message beginning with the following character string is output to the log:

A page shortage might have occurred in the database area.

Reorganize the asset management database. If the same error message is displayed again after reorganization, re-create the asset management database and change the size.

For details about how to reorganize the asset management database, see 12.2.1 Reorganizing the asset management database from the Database Manager dialog box or 12.2.2 Reorganizing the asset management database using commands. For details about how to change the size of the asset management database, see E.5 Changing the size of Embedded RDB.

(6) Available space has been reduced on the drive where the asset management database was created

The capacity of the work file of Embedded RDB (a file for storing the temporary information necessary for executing SQL statements) might have been expanded automatically, causing a shortage of disk space in the drive.

The work file capacity is automatically expanded when a large amount of search results are output. If there is not enough space on the drive where the asset management database was created, you can release the automatically expanded area for the work file by executing jamemb_workcomp.exe.

This subsection describes the function, format, and return values of jamemb_workcomp.exe, which releases the automatically expanded area for an Embedded RDB work file, and provides notes on command execution.

jamemb_workcomp.exe is stored in the following folder:

Asset-Information-Manager-installation-folder\exe

(a) Function

jamemb_workcomp.exe releases the automatically expanded area for an Embedded RDB work file.

(b) Format
jamemb_workcomp.exe
(c) Return value

The command returns one of the following return values:

Return value Description
0 Normal termination
11 Invalid option format
101 or greater Terminated with another error
(d) Notes on command execution

Execute jamemb_workcomp.exe as a user with administrator permissions.