Understanding the Error Log Report

When a file you uploaded is "rejected", this means that it did not meet the minimum qualitative standards in order to be processed correctly by our platform. We will go over two notions in this article:

  • Correcting my file
  • The meaning of the quality indicators

To correct your file:

1.  By clicking on the three little dot on the line you want, select the download icon and download your error log in .csv or .xslx.

Capture d’écran 2024-01-03 à 15.56.55

2.  Review the Error Log which indicates which error is contained in which column and line of your input file.

3.  Upload the corrected version of your input file, which should now be accepted by the platform.

 

How to read and interpret the error log report ? 

    • Error_type → this represents the type of error that you are facing. The error type can be: Expected value, Data Type (String, float, integer), Size (number of characters), Null (this field can’t be empty), but also numerous functional checks like in the example above with the "Portfolio data consistency" or "NAV consistency" check
    • Error_message → this is the message to explain the Error_type in words
    • Expected_message →  what the variable should be: it can be an expected list or the type of data for instance. This column is not systematically filled as we assume that the error_type and error_message sometimes give enough information to deal with the error
    • Received_message → the value there actually is in the uploaded file
    • Line_number → which line is concerned
    • column_name → which column is concerned
    • CIC_code → what is the CIC code for this line (this is an important information as most of our checks are done by looking at the CIC code of the security and interpreting from there what are the mandatory and non mandatory columns)
    • Fund_ID → useful when there is multiple funds in a single file
    • Is_blocking → is the error blocking to get to the next level of quality
    • Quality → indicates the quality for which it is blocking (if applicable)

 

Quality indicators

The Manaos platform qualifies the quality level of your file into two categories:

  1. Basic: Your file meets the minimum validity requirements for scenarios such as ESG analysis.
  2. Regulatory: Your file meets the overall validity requirements for regulatory financial reporting scenarios

If your client requires regulatory reporting standards, be aware that a "Basic" quality status is insufficient and they will require you to correct your file to meet regulatory reporting standards.