Infrastructure Management database and operating system issues
The following issues are related to the database or to the operating system:
Cannot load ianywhere error
SAP SQL Anywhere generates a
cannot load ianywhere/ml/jdbcodbc/IIStatement File jdbcodbc\c\nativeobj.c at line #507--aborting execution error when the SAP SQL Anywhere server is already installed.
This SAP SQL Anywhere related error is displayed when the SAP SQL Anywhere server is already installed. The Infrastructure Management installation is running, and the dbisqlg.exe file exists in the background processes.
In the error message, click Yes to abort execution of the dbisqlg.exe file. To avoid this error, close the dbisqlg.exe process before you begin the installation.
Connection terminated abnormally
Connection to the database is terminated abnormally.
Connections to the database are closed, for example, when the jserver process is restarted. This error message is displayed in the storm_ <hostName>db.log file located in the installationDirectory/pw/asatmp directory.
No response is required. You can ignore this message.
Creation of a table fails
Creation of a table can fail when keywords that are reserved for the database are used for column headings.
You can use the register monitor script to validate whether the table is created after executing the script. When naming column headings, third-party developers might have used keywords that are reserved for the database. Ensure that no one uses the keywords that are reserved for the database. You can obtain a comprehensive list of reserved keywords from the database vendor. The following is a partial list of reserved keywords:
- ASA Database
- Sybase and Oracle\ Databases:
This is not a comprehensive list of keywords that are reserved for the databases mentioned previously. Developers must try to find the list of reserved words from database vendors.
The database crashes after an assertion failure.
For information about how to recover from an assertion failure, see .
Incorrect page count for table
Incorrect page count is displayed after deleting pages from a table in the database.
If an incorrect page count is displayed after you delete pages from a table in the database, perform the following tasks to correct this issue:
- Unload the table content.
- Delete the table. If you are unable to delete the table, rename the original table and create a new table by using the original table name.
- Reload the correct table content back to the table.
Reloading creates the table and adds the contents to the table.
Size of the Oracle data file
If you are using Infrastructure Management on Oracle, and if Oracle runs out of free space, the following error message is written to the TrueSight.log file:
ORA-01653: unable to extend table PROACT.AUTODISCOVERY_ERRORS by 8 in tablespace NGP_TS
ORA-01654: unable to extend index AUTOPROACT._PATROL__SCA_0_STATS_5_N_1 by 1024 in tablespace PNET_TS_AUTO
Contact the Oracle administrator to create a new data file. As a best practice, you can monitor the Oracle tablespace using the Oracle KM. For information on configuring Oracle DB for monitoring, see
Installation fails due to incorrect Oracle character set
The Infrastructure Management installation fails with the following error in the installation log file:
failure Error: NLS_CHARACTERSET is set to [WE8MSWIN1252]. It needs to be set to [AL32UTF8]
To resolve this issue, run the installer again and change the Oracle character set to Unicode (AL32UTF8) in the Database Configuration Assistant, Step 9 of 11: Installation Parameters screen.
Reestablishing a lost connection to the Oracle database
Infrastructure Management automatically reconnects to the Oracle database if the database connection is lost temporarily. The database connection may be lost due to many factors, such as network latency and unresponsive database due to high system load. This is applicable only to the Oracle database.
The database reconnection mechanism will not work while the following operations are running:
- Auto Work Flow (Create/Update/Delete of Monitor Types/instances/devices/groups)
- Devices (Create/Update/Delete)
- Graphs (Create/Update/Delete)
- SLA (Create/Update/Delete)
- Groups (Create/Update/Delete)
- Schema creation during installation
- Monitor wizard (Create/Update/Delete)
- Integration Service (Add/Update/Delete)
If the database connection goes down for more than one minute and if the connection is not established, the Administrator is notified through an e-mail message that there is a problem connecting to the database.
To reconnect to the database
- Check the e-mail message and the ProactiveNet.log for the error
"Failed to establish DB connection after retries ."
- Check the network connection and the database server status.
- Restart the BMC TrueSight Infrastructure Management Server after restoring the database connection.
The following is an example of the e-mail message sent to the Administrator.
Exporting Oracle tables
The required files (custom_dump_dir_pnet.sql and pnet_exp_selected_tables.par) to export Oracle tables are available under the <Installation directory>/pw/pronto/sysdata/oracle_dump_utils directory.
To export the Oracle tables, perform the following steps:
- On the Oracle Server, set oracle_sid, connect to the database by typing
sqlplusat the command prompt.
- Log in with sys user
Enter user-name: sys/<password>@<sid> as sysdba
- Execute the sql script custom_dump_dir_pnet.sql and specify the location of the dump directory file and user (for example, proact) at the prompt.
- To export the selected table of Infrastructure Management user, use the pnet_exp_selected_tables.par file and then from the command prompt, run the expdp utility by specifying the username, password, sid, and pnet_exp_selected_tables.par.
expdp <Infrastructure Management_username>/<password>@<sid> PARFILE=<path\pnet_exp_selected_tables.par>
Check the exp_selected_table_data.log file for logs whether export succeeded or not.
- Collect the exported dump EXP_SELECTED_TABLE_DATA.DMP from the dump directory you specified in step 3 and upload it to the BMC FTP site (ftp.bmc.com) along with following details:
- Infrastructure Management user name
- Tablespace for Infrastructure Management user. To get this information, see the following example:
select default_tablespace, username from dba_users where username = ‘<Infrastructure Management_username>’
The pronet_db.log file captures all the database activities if debug is enabled. Otherwise, it captures the SQL exceptions that occur during run time.
Maximum number of processes exceeded
When using the same database for multiple Infrastructure Management servers, you get the following exceptions:
Could not open connection or a
Got minus one from a read call IO error.
Exception stack trace 1:
Exception stack trace 2:
To resolve this issue, you must increase the processes in multiples of hundred. The default value is 1000, you can increase it in multiples of hundreds like 1100,1200,1500 based on the traffic that you are monitoring.
To increase the number of processes allowed on a database server do the following:
Log on to the database using the following command:
sys/****@<SID> are your user credentials.
sys/****@<SID> as sysdba alter system set processes =1500 scope=spfile
Restart the database.
Restarting the database after executing the command increases the number of processes.
Unable to extend the Oracle System tablespaces SYSTEM or SYSAUX
ORA-01658: unable to create INITIAL extent for segment in tablespace SYSAUX
Recommended SYSTEM tablespace size is 2 GB and SYSAUX tablespace size is 3 GB to avoid this error.
Verify and fix one or all of the following in these tablespaces if required:
- The SYSTEM tablespace is not the default or temporary tablespace for the normal database users.
- Look for space consuming tables such as AUD$ in the SYSTEM tablespace and move it to a different tablespace.
- Query and check for objects consuming most of the space on these tablespaces and either move those outside for later use or delete it if you do not want those objects.
- Look for tables in SYSTEM and SYSAUX tablespaces that store historical query data, AWR snapshot, and audit information, which can be either deleted or truncated.
- If you cannot perform any of the above, add additional disk space to these tablespaces.