Question
AGF Investments Inc
CA
Last activity: 9 Sep 2025 16:44 EDT
Case attachment is not opening after uploaded for the 1st time
We have an external db mssql table that has the file details - the file name(varchar) and file content(varbinary). In an activity, we read of a file using the RDB-List we get the files for a particular document. after retrieving the files, for each file, we create Data-WorkAttach-File, LinkPage pages with required properties set and save them. the first time we run this activity, we see the file attached to the document. but unable to open or download it. However, when we run this second time, the file is attached again and it is working fine. What could be the potential reason for this?
Cognizant Technology Solutions
SE
@SowmyaR3732 I suspect there could be some issue with commit. The changes may be getting committed at the end of first iteration of activity. As it is committed as part of first iteration, it makes it avilable for the file to be opened or downloaded. Can you check in this angle once. Thanks