Analyze the XML data from the failed transaction for the field in question, in this case it was REVENUEATTRIBUTE, found in XML as AttributeTypeID.
Run the following script against the database:
select * from bbncattributecategoryidmap BBAC
join attributecategory AC on bbac.attributecategoryid = ac.id
where BBAC.ID in ('x', 'x', 'x')
Where X= the Revenue AttributeTypeIDs in question, could be multiple, could be just one.
Once results are received, match the GUID from the error message to the row in the script results which should allow you to view the Revenue Attribute name that is needed in the batch to commit.
Add that field to the batch template and retry download.
Blackbaud Community
Connect and collaborate with fellow Blackbaud users.
