Hi,
I have an application that has a form in which I load data and a file.
In one particular record, for some reason I cannot explain the file field shows 0 files, but in a list where the record is displayed 3 file icons are displayed. (2 of them broken)
The rest of the records work fine.
This is the list:
This is the tab of the edit form where the File field displays. Note that it is empty, when it should be showing 3 files.
This is the Form, which by the way gets corrupted too.
It should look like this: (every tab is different)
And for the corrupted record looks like this: (same tab)
And the rest of the tabs look exactly the same as this, and what they show is a mix of the File field and some other fields from the first tab.
Once I open the edit form for the record, all the application hangs, that is, it becomes completely unresponsive and it is not possible to exit the Form or perform any action at all.
This happens only for this record.
I need to fix this without breaking anything else as this is already in use.
I thought that the files where saved in the database as blobs, but in the database the File field is not in the table that holds the rest of the information.
How can I "clean" this record from that images without deleting the record?
I'd like to understand a bit better how the image managing works, to be able to solve this kind of issues, that are a bit unclear,as they are treated differently from the rest of the fields of the relation.
Any help on fixing/understanding this will be much appreciated!!
Thank you!!
Warm regards!!
Here are the application logs I could gather when entering the form for the field.
2025-07-24 19:11:57 websocket TRANSACTION 259947, started by login ID 3 (172.18.0.1)
2025-07-24 19:11:57 websocket TRANSACTION 259947, get data, payload: {"relationId":"598b2cfe-2889-47b1-9757-f6fc8f7c4a0c","joins":[{"attributeId":"c5302166-9ec8-4d3e-8882-83d6c648374f","index":1,"indexFrom":0,"connector":"LEFT"}],"expressions":[{"attributeId":"debe5167-49ae-4be8-8ff6-0e422d45f516","index":1,"groupBy":false,"aggregator":null,"distincted":false},{"attributeId":"154b26b3-2e91-4ee5-aec2-b7af6adeb479","index":1,"groupBy":false,"aggregator":null,"distincted":false}],"filters":[{"connector":"AND","operator":"=","index":0,"side0":{"brackets":1,"value":"","attributeId":"88e972f0-1841-40a3-a7ec-91498853aed6","attributeIndex":0,"attributeNested":0,"nowOffset":null},"side1":{"brackets":1,"value":8,"attributeId":null,"attributeIndex":0,"attributeNested":0,"nowOffset":null}}],"orders":[{"attributeId":"5e761721-172f-4721-a2f8-dbf7b81e2041","index":0,"ascending":true}],"limit":50,"offset":0}
2025-07-24 19:12:17 websocket TRANSACTION 110613, started by login ID 3 (172.18.0.1)
2025-07-24 19:12:17 websocket TRANSACTION 110613, set data, payload: {"0":{"relationId":"c1512db2-96d7-47cd-b7f3-2139eefce7aa","attributeId":null,"indexFrom":-1,"recordId":8,"attributes":[{"attributeId":"944a4a2f-450c-48a4-889d-7eda22161096","attributeIdNm":null,"outsideIn":false,"value":"Internet"}],"encKeysSet":[]}}
2025-07-24 19:12:18 websocket TRANSACTION 347910, started by login ID 3 (172.18.0.1)
2025-07-24 19:12:18 websocket TRANSACTION 347910, get data, payload: {"relationId":"c1512db2-96d7-47cd-b7f3-2139eefce7aa","indexSource":0,"joins":[{"attributeId":"7b4f5e32-2acd-4a3a-919d-3a9f243a19bd","index":1,"indexFrom":0,"connector":"LEFT"}],"expressions":[{"attributeId":"684ab696-1f77-49c5-a299-8d9ba5a95c0e","attributeIdNm":null,"index":0,"outsideIn":false},{"attributeId":"024aed03-3d9d-477e-9343-b717903ccadc","attributeIdNm":null,"index":0,"outsideIn":false},{"attributeId":"491b41ed-88e9-4c75-b7c3-49bba93a0ed6","attributeIdNm":null,"index":0,"outsideIn":false},{"attributeId":"59e7ea9b-ef67-447e-a341-28d26032e6aa","attributeIdNm":null,"index":0,"outsideIn":false},{"attributeId":"2650c9ef-43de-4968-aead-fa7764a6c842","attributeIdNm":null,"index":0,"outsideIn":false},{"attributeId":"944a4a2f-450c-48a4-889d-7eda22161096","attributeIdNm":null,"index":0,"outsideIn":false},{"attributeId":"6eac60dd-b0d9-4a05-9045-f4256b76e4c7","attributeIdNm":null,"index":0,"outsideIn":false},{"attributeId":"2a1cf5c9-b98c-45f1-939b-b58eda7e46f3","attributeIdNm":null,"index":0,"outsideIn":false},{"attributeId":"11e642e4-d356-414e-8df4-7ada1364c62b","attributeIdNm":null,"index":0,"outsideIn":false},{"attributeId":"82468d55-4dbf-4f2b-b11e-9c685e03c1da","attributeIdNm":null,"index":0,"outsideIn":false}],"filters":[{"connector":"AND","index":0,"operator":"=","side0":{"attributeId":"2e770d7b-23d7-47a2-a821-fc894a6923d3","attributeIndex":0,"brackets":0},"side1":{"brackets":0,"value":8}}],"getPerm":true}
2025-07-24 19:12:18 websocket TRANSACTION 310530, started by login ID 3 (172.18.0.1)
2025-07-24 19:12:18 websocket TRANSACTION 310530, get data, payload: {"relationId":"a8c1640b-b586-4dc0-9189-deb4bd0743d0","joins":[],"expressions":[{"attributeId":"6ce446f5-20e7-4796-b898-7b797f4a0dba","index":0,"groupBy":false,"aggregator":null,"distincted":false}],"filters":[{"connector":"AND","index":0,"operator":"= ANY","side0":{"attributeId":"15006555-1e54-4d71-9fcc-3cc58d1d212b","attributeIndex":0,"brackets":0},"side1":{"brackets":0,"value":[1]}}],"orders":[{"attributeId":"6ce446f5-20e7-4796-b898-7b797f4a0dba","index":0,"ascending":true}]}
2025-07-24 19:12:18 websocket TRANSACTION 334351, started by login ID 3 (172.18.0.1)
2025-07-24 19:12:18 websocket TRANSACTION 334351, get data, payload: {"relationId":"598b2cfe-2889-47b1-9757-f6fc8f7c4a0c","joins":[{"attributeId":"c5302166-9ec8-4d3e-8882-83d6c648374f","index":1,"indexFrom":0,"connector":"LEFT"}],"expressions":[{"attributeId":"debe5167-49ae-4be8-8ff6-0e422d45f516","index":1,"groupBy":false,"aggregator":null,"distincted":false},{"attributeId":"154b26b3-2e91-4ee5-aec2-b7af6adeb479","index":1,"groupBy":false,"aggregator":null,"distincted":false}],"filters":[{"connector":"AND","operator":"=","index":0,"side0":{"brackets":1,"value":"","attributeId":"88e972f0-1841-40a3-a7ec-91498853aed6","attributeIndex":0,"attributeNested":0,"nowOffset":null},"side1":{"brackets":1,"value":8,"attributeId":null,"attributeIndex":0,"attributeNested":0,"nowOffset":null}}],"orders":[{"attributeId":"5e761721-172f-4721-a2f8-dbf7b81e2041","index":0,"ascending":true}],"limit":50,"offset":0}
2025-07-24 19:12:18 websocket TRANSACTION 496275, started by login ID 3 (172.18.0.1)
2025-07-24 19:12:18 websocket TRANSACTION 150449, started by login ID 3 (172.18.0.1)
2025-07-24 19:12:18 websocket TRANSACTION 363242, started by login ID 3 (172.18.0.1)
2025-07-24 19:12:18 websocket TRANSACTION 496275, get data, payload: {"relationId":"a6bef97d-9efe-42ae-a07b-08002d4fff13","joins":[],"expressions":[{"attributeId":"eb31030e-488a-424b-8f25-befe33e5f05b","index":0,"groupBy":false,"aggregator":null,"distincted":false}],"filters":[{"connector":"AND","index":0,"operator":"= ANY","side0":{"attributeId":"060cdf31-864d-407c-beff-fd03f70d49c0","attributeIndex":0,"brackets":0},"side1":{"brackets":0,"value":[1]}}],"orders":[{"attributeId":"eb31030e-488a-424b-8f25-befe33e5f05b","index":0,"ascending":true}]}
2025-07-24 19:12:18 websocket TRANSACTION 363242, get data, payload: {"relationId":"d6ae588c-2c47-4575-abef-c7205f38b119","joins":[],"expressions":[{"attributeId":"10b027db-1f32-4811-b94a-692c0c92c0fc","index":0,"groupBy":false,"aggregator":null,"distincted":false}],"filters":[{"connector":"AND","index":0,"operator":"= ANY","side0":{"attributeId":"06287253-9f1e-471f-9290-a7f9d2112e9e","attributeIndex":0,"brackets":0},"side1":{"brackets":0,"value":[4]}}],"orders":[{"attributeId":"10b027db-1f32-4811-b94a-692c0c92c0fc","index":0,"ascending":true}]}
2025-07-24 19:12:18 websocket TRANSACTION 150449, get data, payload: {"relationId":"33cf08df-ad73-4921-b746-21f39f746add","joins":[],"expressions":[{"attributeId":"f34c582f-e9d5-436f-8a7d-c8e2ad6a0ee4","index":0,"groupBy":false,"aggregator":null,"distincted":false}],"filters":[{"connector":"AND","index":0,"operator":"= ANY","side0":{"attributeId":"712b81e7-967e-458b-8d8a-5faa549fa385","attributeIndex":0,"brackets":0},"side1":{"brackets":0,"value":[5]}}],"orders":[{"attributeId":"f34c582f-e9d5-436f-8a7d-c8e2ad6a0ee4","index":0,"ascending":true}]}
