Viewing the Integration Status and History

the fastest way to spot errors is to look at the integration log you can also view the status of your data import and cancel a running import viewing the integration queue docid 5iads1vlkbibhfonuatnrviewing the data integration log file integration docid 5iads1vlkbibhfonuatnrviewing the integration log sccm docid 5iads1vlkbibhfonuatnrviewing data integration history docid 5iads1vlkbibhfonuatnrcanceling a running or queued job docid 5iads1vlkbibhfonuatnr viewing the integration queue the integration queue only shows active or running jobs once the import is completed or aborted, the job disappears from the list from the configuration console, click extend > integration tools > integration queue to view the integration queue workspace the application displays running jobs if there are no running jobs, the workspace is empty the application can process multiple integration jobs at one time viewing the data integration log file integration log in to open the integration log workspace the list of data imports appears sample integration log if an import was successful, one line appears under logtype stats errors encountered are shown with two lines stats and errorstats stats double click to view a summary of the job errorstats double click to view a summary of the errors open the attachment to view the rows containing errors the last column contains specific details about the error you can modify the data (correct the errors) in the attachment file and save it to the source location for re import the error message will be ignored and the data will be imported into the database viewing the integration log sccm view the details of the processed job from the integration log workspace log in to open the integration log workspace the list of import jobs appear with the following information field description log type shows three log types queued indicates that the source id from sccm has been queued in the inventory management asset data processor verified indicates that the source id from sccm has been successfully created in the database stats shows the statistics about the number of rows processed source id sccm root table key (computer system data) shown on the object mapping page of the wizard target id asset id that is derived from the asset identifier mapping function on the field mapping page of the wizard start time time when the job should run end time if applicable, the time by which the job should end total processed total number of records processed if there are no new mappings added, there will probably be no records processed message informational message, which varies according to the log type while the job is being processed, you can view it from the integration queue workspace viewing data integration history the integration history workspace shows all jobs, including canceled jobs log in to open the integration history workspace the list of import jobs appears also shown is the following information for each job field description connection name source name the name and source of the integration job as defined in about configuring data integration docid\ g6i68njtolujzngtisr3s queue status indicates the status of the job this field is color coded queued the job has not yet run but is in the queue this status is replaced by running when the job begins running the job is currently running this status is replaced by completed when the job ends abort requested a user has canceled the job, but the cancellation has not yet taken place this status is replaced by aborting as soon as the cancellation begins aborting the job is in the cancel process this realtime status only appears when the cancellation is running and is replaced by aborted when the cancellation is complete aborted the job has been successfully canceled this final status remains in the history workspace completed the job has been successfully run this final status remains in the history workspace batch number the number of the last batch processed a batch is 200 rows of data batch processed the total number of rows that have been processed in the last batch batch failed the total number of rows that have failed in the last batch process row number the total number of rows in all batches for the current job if the job has 10 batches, for example, this field shows the total number of rows for all batches (2000) batch start time batch end time the start and end time of the last batch processed display batch time taken the number of seconds to run the last batch start time the start time of the entire job display queue running time the number of seconds to run the job, including initialization and dispatching created by created on modified by modified on automatically generated by the application based on the logged in user id canceling a running or queued job you can only cancel a running or queued job log in to open the integration history workspace a list of queued, current (running), and past jobs appear from the toolbar, click abort integration event the application adds the cancellation to the queue and the job status changes to abort requested usually this takes only a few seconds you might need to refresh the screen to update the status cancel integration job when the cancellation process begins, the status changes to aborting it usually takes less than a minute for a job to cancel, depending on the amount of data being processed when the cancellation is complete, the status changes to aborted this status remains in the integration history workspace