# Loan Agent Aggregator stopped working

**URL:** <https://speciforum.org/t/loan-agent-aggregator-stopped-working/2462>\
**Category:** Get Help\
**Created:** [April 2, 2025, 1:19pm UTC](https://speciforum.org/t/loan-agent-aggregator-stopped-working/2462 "2025-04-02T13:19:28Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![fedoras](https://yyz1.discourse-cdn.com/flex029/user_avatar/speciforum.org/fedoras/32/455_2.png) [@fedoras](https://speciforum.org/u/fedoras)\
**Post date:** [April 2, 2025, 1:19pm UTC](https://speciforum.org/t/loan-agent-aggregator-stopped-working/2462/1 "2025-04-02T13:19:28Z")

</div>

My [nifty solution](https://github.com/NHMDenmark/DanSpecify/blob/master/App%20Resources/NHMD/Invertebrate%20Zoology/Standard%20Loan%20Form%20Sp7.jrxml) for generating loan forms in Specify7 has suddenly stopped working, because of a strange issue with an aggregator not doing its job. For my code to work, its crucial that loan agents are separated by a semicolon. However, I am not sure what happened, but all of a sudden the separator refuse to appear in my underlying query:

 ![image](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/b/b143471a4402fe00b1776eb3218b9143c05ccef6.png)

I have double checked the aggregator under record formatters and it should work, but it won’t anymore and I don’t understand why:

 ![image](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/3/3954c51a886b0b7745034002a4593ff088c7d79e.png)

There is a slight possibility that this behaviour changed after a recent update…

| Specify 7 Version: | v7.9.6.2 |
| --- | --- |
| Git SHA: | [08dc1042e592b069a58682bbe5a59691ef14a879 (opens in a new tab)](https://github.com/specify/specify7/commit/08dc1042e592b069a58682bbe5a59691ef14a879) |

| Build Date: | 9 months ago |
| --- | --- |
| Specify 6 Version: | 6.8.03 |
| Database Version: | 6.8.03 |
| DB Schema Version: | [2.10](https://specify-test1.science.ku.dk/specify/datamodel/) |

---

<div class="post-metadata">

**Author:** ![Grant](https://yyz1.discourse-cdn.com/flex029/user_avatar/speciforum.org/grant/32/4255_2.png) [@Grant](https://speciforum.org/u/Grant)\
**Post date:** [April 2, 2025, 1:27pm UTC](https://speciforum.org/t/loan-agent-aggregator-stopped-working/2462/2 "2025-04-02T13:27:19Z")

</div>

Hi @fedoras,

The semicolons defined as separators in the table aggregation within the `DataObjFormatters` app resource (which specifies the table formats and aggregations) are removed automatically in `v7.9.6.2` due to a bug in whitespace stripping for that resource.

This issue only occurs when a user modifies a table format or aggregation; otherwise, it remains unchanged.

This issue will be fixed **automatically** for all users when updating to `v7.10.2` later this spring, but for now you can run the following SQL statement to add the semicolon separators back if they are removed (after any edits to the table formats or aggregation in that discipline):

```sql
UPDATE spappresourcedata spard
SET spard.data = REPLACE(spard.data, 'separator=""', 'separator="; "')
WHERE spard.SpAppResourceID IN (
    SELECT spar.SpAppResourceID
    FROM spappresource spar
    WHERE spar.Name = 'DataObjFormatters'
);

```

---

<div class="post-metadata">

**Author:** ![fedoras](https://yyz1.discourse-cdn.com/flex029/user_avatar/speciforum.org/fedoras/32/455_2.png) [@fedoras](https://speciforum.org/u/fedoras)\
**Post date:** [April 2, 2025, 1:51pm UTC](https://speciforum.org/t/loan-agent-aggregator-stopped-working/2462/3 "2025-04-02T13:51:20Z")

</div>

Thank you Grant! I incidentally checked our test installation of 7.10.2 and there it was working as usual. So the upgrade did break this momentarily, but I am glad we’re up and running again after that hotfix! 👍🏻

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/1/18a843c97bc32b40e8ad0e035755bc88ffaacaf7.svg) [@system](https://speciforum.org/u/system)\
**Post date:** [April 9, 2025, 1:52pm UTC](https://speciforum.org/t/loan-agent-aggregator-stopped-working/2462/4 "2025-04-09T13:52:11Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.