Thanks to everyone who replied! I have decided to let the current transaction filters create the file and PUSH an entry (with the path & file name in a text field) into the Attachment form. An escalation will run every 10 minutes to ping the attachment records without files attached, and trigger filters to run the ADD-ATTACHMENT process. After some investigation, it turned out that the users can easily tolerate the 10 minute delay.
"Sometimes you can't get there from here, but you can get there from somewhere else" Joel Joel Sender [email protected] 310.829.5552 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Grooms, Frederick W Sent: Monday, July 07, 2014 7:01 AM To: [email protected] Subject: Re: PERFORM-ACTION-ADD-ATTACHMENT fails I do something similar in a single filter (I'm on Unix but the same Idea applies). (NOTE: No `! needed as all work is done in set fields) Here is the workflow I use. Set Fields Action: From Server : CURRENT TRANSACTION From Form : CURRENT TRANSACTION Set To Fields : $zTempAttachmentFileName$ = $PROCESS$ "MakeAttachment.sh" $SERVER$ "$zTempFormName$" $Ticket ID$ Set Fields Action: From Server : CURRENT TRANSACTION From Form : CURRENT TRANSACTION Set To Fields : $zTemp WorkFlow txt1$ = $PROCESS$ PERFORM-ACTION-ADD-ATTACHMENT 536870924 $zTempAttachmentFileName$ Run Process Action: Command Line : rm -f $zTempAttachmentFileName$ I think the basic differences are I have never used an attachment pool, I always use an attachment field Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Hamilton, Scott Sent: Monday, July 07, 2014 8:11 AM To: [email protected] Subject: Re: PERFORM-ACTION-ADD-ATTACHMENT fails Joel - I appreciate that you are using all available avenues to pursue this problem. Has this problem been escalated within BMC? Thanks, Scott Hamilton Project Manager Information Technology Department City of Cambridge, MA 617-349-7718 -----Original Message----- From: Joel Sender [mailto:[email protected]] Sent: Saturday, July 05, 2014 10:15 PM To: [email protected] Subject: PERFORM-ACTION-ADD-ATTACHMENT fails I have an ongoing case for this at BMC, but maybe the ARSlist can shed some light... Using a development ARS 8.1.1 server on Windows Server with an MS/SQL back-end. Custom application, simple workflow: run a process to create a PDF file and then attach it to a record in an ARS form. I execute a Run Process to create a PDF file "D:\$PerNumb$.pdf" where the $PerNumb$ is correctly taken from the current record. The file is definitely created correctly. I then attempt to add that file into an Attachment Pool in a filter Run-Process action with this command: PERFORM-ACTION-ADD-ATTACHMENT 617001300 "D:\$PerNumb$.pdf" The field ID is for the Attachment Pool That failed, too. I then tried several iterations of filters with and without the Tick-Bang (`!), but no luck. I submitted a ticket to BMC when the 'Run Process' failed and they suggested that I use a Set-Field action instead. I tried the Set-Field in an Active Link that executed After-Modify - to ensure that the file was created in a filter before attempting the attachment. Using an integer field to accept the Exit Code, I set the field to $PROCESS$ PERFORM-ACTION-ADD-ATTACHMENT 617001300 "D:\$PerNumb$.pdf" Same error in ALL cases: File pointer is NULL or invalid file pointer. (ARERR 295) Have I missed something basic? Has anyone gotten around this? Thanks in advance, Joel Joel Sender [email protected] 310.829.5552 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
