Error messages

Error messages provide information about problems that occur while running the probe. You can use the information that they contain to resolve such problems.

The following table describes the error messages specific to this probe. For information about generic Netcool/OMNIbus error messages, see the IBM Tivoli Netcool/OMNIbus Probe and Gateway Guide.

Table 1. Error messages
Error	Description	Action
`Probe is connecting to JDBC data source`	The probe is attempting to connect to the data source using JDBC with the credentials specified by the DBUsername, DBPassword, JdbcUrl, and JdbcDriver properties.	The probe was started by the user and is now connecting to the data source.
`Probe is disconnecting from JDBC data source`	Probe is attempting to disconnect from the data source.	The shutting down process was initiated.
`Probe is shutting down ...`	The probe is shutting down.	The shutting down process was initiated.
`JDBC probe is an accessor probe. Please configure either InitialResync or ResyncInterval to enable the probe to be run and receiving data.`	The probe could not acquire data from the data source because the InitialResync property is set to false and the ResyncInterval property is set to 0.	Either set the InitialResync property to true or set the ResyncInterval property to a value greater than 0.
`SelectSqlFile is empty or not configured. Please configure SelectSqlFile to enable the probe to be run and receiving data.`	The SelectSqlFile property has either been omitted or the file specified does not contain a valid SQL `SELECT` statement.	Set the SelectSqlFile property to a file containing an SQL `SELECT` statement that retrieves events from the required table in the data source.
`Could not read the contents of sql file`	The probe failed to read the SQL file specified by the SelectSqlFile property.	Check that the file specified by the SelectSqlFile property is not corrupt. Check also that you have specified the correct path and file name.
`SQL file not found or unable to open`	The probe failed to read the SQL file specified by the SelectSqlFile property.	Check the path of the file specified by the SelectSqlFile property and check that the file specified is not corrupt.
`Probe is unable to connect to JDBC data source`	The probe attempted to connect to the JDBC data source, but failed.	Check that you have set the JdbcDriver, JdbcUrl, DBUsername, and DBPassword properties correctly. See Connecting to an event source using JDBC.
`Exception occured during retrieve probe property from service provider.`	The probe failed to load property services from the OIDK library.	Check your probe environment to ensure that your property file has been configured correctly. If the problem persists, contact IBM software support.
`Data backup file features requires to work pairly with MarkerColumn property. Please refer to the References Guide on how to set the MarkerColumn & DataBackupFile accordingly`	The data recovery and backup functionality has not been configured correctly using the DataBackupFile and MarkerColumn properties. Both properties need to be set correctly for the probe to be able to perform partial resynchronization.	Check the values set for the DataBackupFile and MarkerColumn properties See Configuring partial resynchronization.
`Probe may not able to perform partial resync due to could not find the matchable marker column. Please ensure the column name is existed in both MarkerColumn property and the mandatory query.`	The probe could not find the matchable marker column specified by the MarkerColumn property within the mandatory select query result. The marker column name must exist in, and be in the same case as, the results returned by the select query specified by the SelectSqlFile property.	Check the values set for the MarkerColumn property and SelectSqlFile property. See Configuring partial resynchronization.
`Please double check your query and make sure the column name is correct`	The marker column specified by the MarkerColumn property is not included in the results returned by the mandatory SQL `SELECT` statement.	Check the query specified by the SelectSqlFile property and make sure that the column name is correct. See Configuring partial resynchronization.
`MarkerColumnSensitive property has been set to true. Please ensure the column name defined in MarkerColumn is the same with the result return by select query with case-sensitive.`	The MarkerColumnSensitive property has been set to `true`.	Check that the column name specified by the MarkerColumn property is the same as the result returned by, and in the same case as, the `SELECT` statement in the file specified by the SelectSqlFile property. See Acquiring data from case-insensitive and case-sensitive databases.
`MarkerColumnSensitive property value is true. Please set it to false if you required the marker column to be compared in ignored-case (case-insensitive).`	The value of the MarkerColumnSensitive property has been set to `true` but the probe could not find the matched marker column.	You may need to set the MarkerColumnSensitive property it to `false` if the database operates in a case-insensitive environment. See Acquiring data from case-insensitive and case-sensitive databases.
`Probe unable to find the JDBC Driver class, please set JdbcDriver property and your environment CLASSPATH.`	The probe could not find the JDBC driver class specified by the JdbcDriver property.	Check that the JdbcDriver property is set to the path to the JDBC drivers and set the `$CLASSPATH` or `%CLASSPATH%` environment variable to include the path to the JDBC drivers. See Connecting to an event source using JDBC.
`Probe encountered SQL exception during pre-sql process. Please check your pre-sql query configured in PreSqlFile property.`	Probe has encountered an SQL exception during the pre-SQL selection processing.	Check the pre-SQL query specified by the PreSqlFile property.
`Probe encountered SQL exception during post-sql process. Please check your post-sql query configured in PostSqlFile property.`	Probe has encountered an SQL exception during the post-SQL selection processing.	Check the post-SQL query specified by the PostSqlFile property.
`Probe will skip the pre-sql process due to the file is blank`	The probe skipped the pre-sql process because the file specified by the PreSqlFile property is blank.	Change the value of the PreSqlFile property to specify a valid pre-SQL query.
`Probe will skip the post-sql process due to the file is blank`	The probe skipped the post-sql process because the file specified by the PostSqlFile property is blank.	Change the value of the PostSqlFile property to specify a valid post-SQL query.