Hi All,
I have written a system to automatically output our survey responses to a pdf file and uploaded to our project management system. For surveys that include a large number of photos, I encountered an bug in my system where not all of the images where getting inserted into the PDF even though they are all there in the database when I go back to check. Yes I know this is my issue, BUT I was wondering if there was table that had an entry with the status of the upload and processing of the survey?
I am using a Postgresql trigger on the *_CORE table to trigger the PDF creation, but I suspect that basically my system is moving too quickly and outputting the PDF before the image entries on their various tables are finalized in the database. Is there a table that has the status of the database write for the specific survey?
Right now my only workaround is to add a delay in the PDF creation for a set time (60 seconds seems to work the best) but I would prefer to check the database every few seconds to see if the survey has completed uploading in case there is a delay or ideally things could be moving faster.
Thanks!