NetIQ AppManager 7.0.x
NetIQ Minutely QDB SQL Job
NetIQ AppManager Repository Database (QDB)
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).
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.
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.