Hello All, I have some questions around attachment field, and wanted to check in here with experts to understand it more clearly. 1. What is the max size of file allowed for an attachment ? Max attachment size allowed is currently set at 10MB in ar.conf. - In HPD Ticket, I was able to attach file bigger than 10MB (~13MB), and then on the DB side I checked the actual size, as Remedy compresses it and saves it - so the file's compressed size was less than 10MB which makes sense. Then I tried attaching a different file with bigger size - (~42MB), got attached and again the compressed file size was little less than 10MB. But the above result is not constant, in first attempt it errored out - throwing the following error( then when I tried again it did get attached): "ARERR [154] Malloc in client library failed" Also, during similar exercise I noticed one more kind of error popping up - "ARERR [8703] Bad attachment size" 2. Compression ratio , file types, etc ? Now when I try the similar exercise on CHG ticket(Attachment pool contains 3 attachment fields) When I try to attach a file bigger than 10MB it errors out giving - "Max file Size allowed is only 9765.6K(<10mb)". Why does this error pops up in CHG ticket only, why not in HPD ticket? Why in CHG ticket, it is not allowing to attach a bigger size? Also, some additonal doubts: 1. Files types allowed - Is there any limitation in file types allowed in Remedy. 2. compression ratio, and other relevant details which will help me to understand the attachment field capacity considering the environment and version of remedy we are in. 3. Also, I read ( KA318917) that I would have to check server operating system and configuration. So what exactly I need to check? 4. Is there any limit on number of attachment fields in an attachment pool (pros and cons) 5. What is the max we can go upto for Db-Max-Attach-Size setting in ar.conf and pros and cons.
Environment Info: AR Server Version : 5.01.02 Patch 1313 Hardware : sun4u Operating System : SunOS 5.10 DB : SQL -- Oracle DB Version : 10.2.0.5.0 - 64bi Working on an attachment field on a form. Currently, we have Attachment Pool field on HPD and CHG form. HPD: 1. No of attachment fields - 6 CHG: 1. No of attachment fields - 3. Entry in ar.conf : Db-Max-Attach-Size: 10000000 ~ 10MB Db-Max-Text-Size: 20000000 ~ 20MB >From Config Guide for Remedy v 5 for ar.conf: Db-Max-Attach-Size The maximum size (in bytes) for attached files in the Oracle RDBMS. The default value is 1000000 (1 MB). The maximum value allowed is limited by your server operating system and configuration. 176 "Appendix A—AR System Configuration Files Action Request System 5.1 Db-Max-Text-Size The maximum size allowed for long character text data in Oracle databases, SQL Server, and Sybase databases. For Oracle databases, this value is also used for memory allocation during the processing of long text data; therefore, you must use it conservatively. The default for an Oracle database is 1 MB. For SQL Server and Sybase, the default is 2,147,483,647 bytes. The maximum value allowed for either database is 2,147,483,647 bytes. Just trying to understand what are the limitations of attachment field. Pl advise. Raj _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
