Understanding Verification, Import Logs, and Rejection Files

When you submit a CSV for import, AIR ImportExpress validates the contract, location, and reinsurance exposure data to see whether the exposure data is acceptable for import. If the exposure data is not acceptable, it displays an error message and does not submit the import job for processing. The error message provides information to help you fix the problem.

If the source CSV files contain invalid values, AIR ImportExpress highlights those values during the Scan Mappings process and does not continue the import process until you map incorrect values to valid Touchstone values.

AIR ImportExpress includes a Verify button that you can use to validate the exposure data and fix any errors before submitting the import.

After successfully submitting an Import job for processing, you can monitor the status in the Activity Monitor. Here are some guidelines for understanding and using the information in the Activity Monitor:

•       When you see an import whose status is “Completed with Exceptions”, always view the Import log. To view the summary log, select the activity and then click View Log on the ribbon or right-click the activity and then select View Log. For each type of import, AIR ImportExpress creates log files that summarize information about the job, including the number of records successfully processed, and about errors that occurred during import as a result of validation rule violations. For more detailed information about import errors, right-click the import activity in the Activity Monitor and then click View Detailed Log or View Operational Log. The latter two logs can be quite large in size, depending on the number of errors and the size of the import file.

•       Sometimes AIR ImportExpress creates rejection files for imported contracts, locations, and reinsurance files that contain invalid data. These files are useful because you can save the files, correct the invalid exposure data, and then reimport them. AIR ImportExpress may have created rejection files even when the status is “Completed.” Therefore, AIR recommends that you always review both the summary log and any rejection files. To view rejection files, select the activity, click the drop-down arrow next to the View Log button, and then select the rejection file that you want to open. The rejection file opens in a spreadsheet application. You can save the file and edit it as needed. You can also right-click the import activity, click View Rejection File(s), and then select the rejection file that you want to open. To open all the rejection files in addition to the detailed and summary log files in separate windows, click Open All. To save all the rejection and log files, click Save All. When the Select Destination window opens, browse to the directory in which you want to save the files. Then click Save.

•       AIR ImportExpress rejects exposure data with retired or expired currencies. It sends appropriate error messages to the log file and adds the locations to the rejection file.

•       Each import job has its own set of criteria that determines the success or failure of the import.

•       In general, if AIR ImportExpress is able to import some contracts and locations, the status is likely to be “Completed”. However, even though the job has successfully completed, there may be problems with some of the data, and so AIR ImportExpress may generate rejection files.

•       A job fails only when it cannot be completed at all.

•       A job completes with exceptions if the job completes but something is not correct, for example, if a detailed loss analysis does not have any results for the intersection of the model with the data. For example, if you run an analysis with a model for California earthquakes, but you only have Florida exposure data, the job is likely to complete with exceptions.