Nothing has changed on that form for over 13 years. It was last modified in Dec 2000 and the macro runs using a Remedy Administrator account so permissions would not be an issue.
Regarding the Macro: Here are the details: We click a button on a GUI form that passes parameters to a script that contains the runmacro command. That part works, however, when the runmacro tries to process on the server side we are seeing some errors and we can't figure out why they are happening. They worked just fine on all our other 7.1 servers but not on this 7.6.04 server. More Info: This is the format of the actual Macro ProcessHR Set-schema: $FORM$ $SERVERNAME$ Query: 810103266=$LOAD_FILES$ [1] Form-open: Form-entry-list: 0 Modify-bulk: 600000450=Process Form-final: modify @ end We pass in the Form Name, Server Name and the Load File information and the macro should be doing a bulk modify on the form that it gets passed. Here is what is passed in. /appl/Remedy/bin/runmacro -x =<THIS WAS REMOVED PER HP SECURITY POLICY> -h /appl/pub/downloads/hrdata/macros -d /appl/pub/downloads/hrdata/macros/arcmds -e ProcessHR -p LOAD_FILES=HR_empl_new_03072013_test2.csv -p FORM=HR_Employee_Bulk_Load -p SERVERNAME=<THIS WAS REMOVED PER HP SECURITY POLICY> -U <THIS WAS REMOVED PER HP SECURITY POLICY> -P <THIS WAS REMOVED PER HP SECURITY POLICY> In that same script we capture the entry and the results in a log and in that log we see the following: Wed Mar 13 10:40:31 CDT 2013 Processing File HR_empl_new_03072013_test2.csv /appl/Remedy/bin/runmacro -x =<THIS WAS REMOVED PER HP SECURITY POLICY> -h /appl/pub/downloads/hrdata/macros -d /appl/pub/downloads/hrdata/macros/arcmds -e ProcessHR -p LOAD_FILES=HR_empl_new_03072013_test2.csv -p FORM=HR_Employee_Bulk_Load -p SERVERNAME=<THIS WAS REMOVED PER HP SECURITY POLICY> -U <THIS WAS REMOVED PER HP SECURITY POLICY> -P <THIS WAS REMOVED PER HP SECURITY POLICY> Cannot establish a network connection to the AR System server - <THIS WAS REMOVED PER HP SECURITY POLICY> : RPC: Miscellaneous tli error - event requires attention Permission denied [ARERR 90] Executing macro - ProcessHR. Please wait... Macro - ProcessHR processing complete. Wed Mar 13 10:40:31 CDT 2013 Christopher Pruitt Business Consulting III Remedy Developer BMC Certified Administrator: BMC Remedy AR System 7.6.04 HP Enterprises Services [email protected] www.hp.com<http://www.hp.com/> [HP_logo] Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe D'Souza Sent: Tuesday, March 19, 2013 5:35 PM To: [email protected] Subject: Re: Frustration ** What is the macro designed to do? Was it designed to act on any of the OTB forms and perhaps write to one of them? If so it might be worth checking if something on that form and its fields have changed permission wise if the macro was to read or write to one of them. Joe ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Pruitt, Christopher (Bank of America Account) Sent: Tuesday, March 19, 2013 5:06 PM To: [email protected]<mailto:[email protected]> Subject: Frustration Hello Fellow Listers. I have been fighting a runmacro issue on version 7.6.04 for almost a month now. I have tried every trick I can think of. I keep getting the following error every time I try and execute a runmacro command. Cannot establish a network connection to the AR System server - <REMOVED> : RPC: Miscellaneous tli error - event requires attention Permission denied [ARERR 90] We added: export SHLIB_PATH=/appl/Remedy/bin and export NLSPATH=/appl/Remedy/locale/C to our .profile We made sure that the Symbolic Link for runmacro.cat in /usr/lib/nls/msg/C/ is pointing to the correct directory We ran the locale command and all looks good And still none of these made a difference Is there any other path I need to set on my .profile or copy the runmacro.cat file to? This is very frustrating, the runmacro worked just fine before we upgraded, however, when we upgraded from 7.1 to 7.6.04 it just stopped working. Environment; AR System: 7.6.04 SP4 201209051922 OS: HP-UX B.11.31 Database: 10.2.0.4.0 - 64bi Database Client Library: /appl/oracle/product/11.2.0/Client_11.2.0 Christopher Pruitt Remedy Developer BMC Certified Administrator: BMC Remedy AR System 7.6.04 HP Enterprise Services Bank of America Account | CIA - Integrated Applications | IW Infrastructure Team +1.972.605.7702 office | [email protected]<mailto:[email protected]> Upcoming OOO: 4/1 through 4/5 - Vacation _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
<<inline: image001.png>>
