I received the error message “Cannot send document to Document Agent” when I tried to send a document this morning. I did a scan/repair on both the security and document domains and I am still getting the error message. The report I am trying to send is 10.6 MB. I tried a smaller report, 33K, and it worked okay. Is there a size limit for reports sent to doc agent? If so, what is it, and if size is not the problem, does anyone have any other suggestions?
In a message dated 98-08-28 11:23:07 EDT, you write:
The report I am
trying to send is 10.6 MB. I tried a smaller report, 33K, and it worked okay. Is there a size limit for reports sent to doc agent? If so, what is it, and if size is not the problem, does anyone have any other suggestions?
Thanks,
Lynne Fee
Lynne:
There should not be a limit on size of reports. When you send a report to the repository, it breaks the report up into chunks and saves each chunk with a unique ID number. In my Oracle repository, the length of the key for that table is 10 digits. That means that your report needs to have fewer chunks than 9,999,999,999. Hopefully that is not the problem!
I suspect it is more likely that you may be running out of room in your database? Perhaps your DBA could help you identify that problem. The exact error message you get when you export would be helpful.
Final thought: have you considered purging your data prior to exporting? This would send just the report structure. There probably is no need to store the data in the repository, which should make the report smaller (much smaller!) and reduce the amount of time required to export (and import) the document.
To purge your data, click on the “View Data” button on your toolbar (it looks like a cube) and on that screen click on the Purge button.
In Informix, documents are stored as BLOBs (Binary Large Objects). I had a situation with an Informix repository where we hadn’t allocated enough BLOB space. In any event, it sounds like a sizing issue.