Were are on ARS 6.0, Oracle 9, Win2k3. Our AR.cfg has "Db-Max-Attach-Size: 8000000". This provides an ~8MB limit on the compressed size of the file. IIRC either ARS or Oracle takes the file you give it, then compresses it, then tries to place it in the database. If the file size is over the Db-Max-Attach-Size threshold after it is compressed then you get the 8703 error. The setting you listed should be giving you ~10MB compressed to play with. If you still get the error (say when submitting a 7MB pdf) then something else is limiting it. As stated previously check the attachment pool field on the form. The field has its own maximum file size property. I believe this setting is in respect to the pre compressed file size. So you should probably make sure the maximum is set to at least 10MB if not more. If that isn't the answer then perhaps there is a configuration with the oracle database that affects the max blob size or something of that nature. Check with your Oracle DBA on that. Ken. ________________________________
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of [email protected] Sent: Monday, January 18, 2010 6:01 PM To: [email protected] Subject: ARS 5.12 max attachment size limitations? ** Anybody out there still running ARS 5.12 with Oracle 9i from a windows 2003 server, remote database? We are having a problem saving attachments larger than 5 megs. We have set the ar.cfg parameters of Db-Max-Attach-Size: 10000000 and Db-Max-Text-Size: 10000000 but this does not seem to allow us to attach a 4.75 meg pdf file. BMC Remedy support tells us that 5.12 is unsupported and to upgrade, which we are in the process of. Anybody out there have a ARS 5.12 Oracle 9i server that will take pdf attachments larger than 5 megs? There is apparently some difference in compressibility of pdf files verses those like word docs. Whatever we set this parameter to and restart the ARS service, it doesn't to let us save the record. The error we receive through the 5.12 user tool is error 8703, bad attachment size. If anybody has any ideas on this it would be much appreciated. Thanks Dave Taylor Lead Remedy Developer Boise, Inc _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ ******************************************************************* This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept for the presence of computer viruses. www.Hubbell.com - Hubbell Incorporated** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
