Environment
NetIQ AppManager 6.x
NetIQ AppManager 7.0.x
NetIQ Minutely QDB SQL Job
NetIQ AppManager Repository Database (QDB)
NetIQ AppManager 7.0.x
NetIQ Minutely QDB SQL Job
NetIQ AppManager Repository Database (QDB)
Situation
NetIQ Minutely QDB SQL Job fails with an error message in the Application Event Log.
NetIQ Minutely QDB' SQL Job fails error: INSERT statement conflicted with COLUMN FOREIGN KEY constraint
NetIQ Minutely QDB' SQL Job fails error: INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'Data_DataID_fk'. The conflict occurred in database 'QDB', table 'DataHeader', column 'DataID'. [SQLSTATE 23000] (Error 547) The statement has been terminated. [SQLSTATE 01000] (Error 3621).
NetIQ Minutely QDB' SQL Job fails error: INSERT statement conflicted with COLUMN FOREIGN KEY constraint
NetIQ Minutely QDB' SQL Job fails error: INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'Data_DataID_fk'. The conflict occurred in database 'QDB', table 'DataHeader', column 'DataID'. [SQLSTATE 23000] (Error 547) The statement has been terminated. [SQLSTATE 01000] (Error 3621).
Resolution
The DataRejected table in the AppManager Repository can be truncated using the following query using Microsoft SQL Server Query Analyzer:
- Select the Repository (QDB) from the drop down menu in the tool bar.
- Type the following SQL query:
TRUNCATE TABLE Datarejected - Execute the SQL query by using F5 or the green arrow.
Cause
DataRejected table in the QDB database contains one or more rows of data.
Additional Information
Formerly known as NETIQKB22586
The datarejected table is typically empty. It is possible during transmission failure or corruption of information detail some data stream information maybe missing from a data point. In this situation, the data is written to the datarejected table. If you need further information on this table and how data may end up in it, please contact NetIQ Technical Support.
The datarejected table is typically empty. It is possible during transmission failure or corruption of information detail some data stream information maybe missing from a data point. In this situation, the data is written to the datarejected table. If you need further information on this table and how data may end up in it, please contact NetIQ Technical Support.