AIG Line Count Not Matching Waiting to Upload Stuck Documents

Issue
Documents from AIG may get stuck in waiting to upload because the XML is missing billing detail records.
Solution
To Diagnose: Lookup dcnNumber if you do not have it. If the documents were originally output withing the last 3 days, you can go to the C:\MetaSource\Bin\AIG\XML folder on DRPR-PP2 and search for the dcnNumber. Look at the attribute and make sure there is a matching number of line detail records. You can also look at the exception listed under the xml attribute. It should read something like "Exception: com.aig.mbdc.wsdl.keyeddata.KeyedDataServiceFaultType: Error In SP. The bill line count in the recordtype H doesnt equal the lines received" Another method of verification is to look at tblAIG_Output_XMLHeader and view the same exception in the status_text field We need to re-export these records so that the XML gets generated successfully: 1. Disable AIG XMLUpload on DRPR-PP2 2. Disable AIG Output on DCS-SLC-PP2 3. Disable AIG Finalize Output on DCS-SLC-PP2 4. Delete records for affected documents from tblAIG_Output_XMLHeader 5. Delete records for affected documents from tblAIG_Output_XMLDetail 6. Set the 'err' field in tblAIG_Data to empty (Blank out 'err' field)  7. Restart tasks for steps 1-3

Did you find this article helpful?