Job Management Partner 1/Asset Information Manager Planning and Setup Guide
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.
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.
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.
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.
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:
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.
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
jamemb_workcomp.exe releases the automatically expanded area for an Embedded RDB work file.
jamemb_workcomp.exe
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 |
Execute jamemb_workcomp.exe as a user with administrator permissions.
All Rights Reserved. Copyright (C) 2009, 2011, Hitachi, Ltd.