This tool is one of the primary builders of the inventory spreadsheet.
It creates tables that are subsequently used to propagate different sheets in the spreadsheet. One of the first things it does it to copy BulkInv to BulkInvTemp. In the event of failure, the tool rolls back to the temp version so as to allow for the users to continue to reach the spreadsheet.
In some cases, depending on where it fails, the tool cannot continue because the builinvTemp table exists (cannot create a new one) and it is necessary to delete the file (use Drop BulkInv_temp task in the SSIS package). After this, manually run it and all should be fine. You will need to check the history on the scheduled job to find the problem.
In the majority of cases --- it is self correcting.