Runmacro for a simple extract
All, I have a requirement to perform a data extract from a simple form and transfer to another system. Previously I've done this via a simple runmacro process run from a desktop - a report is used, csv is generated which is run via the windows scheduler and then ftp'd over to the other system. As the windows server we were using is no longer available, I am now attempting to perform the same task direct on the Remedy server itself - we're running AR 7.6.04 on Solaris against an oracle database. /apps/server/bin/runmacro -h /apps/server/idmgmt -d /apps/server/idmgmt -e idmgmt -U my login -P my password? -x server id -a tcp port BMC Remedy Action Request System Unix Runmacro Version 8.0.00 Copyright (c) BMC Software, Inc. 1991-2010. All rights reserved. Executing macro - idmgmt. Please wait... Macro - idmgmt processing complete. It produces nothing. The macro and report layouts were created on a windows desktop and transferred via a WinSCP binary transfer to the server in question. Any suggestions would be most welcome. Regards Dave Barber ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Runmacro fails
Hi Misi,
Could you please explain bit elaborate on updating the form definitions. The
last update on the form .def was happened on June month.
Today, I have captured few logs and it shown the timestamp as yesterday.
My unix admin has explained me on this error like the funtions starts with
00237544 defined in runmacro are not executed because of some memory issue
(smalloc, malloc)...
Thanks,
Govind M
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Wednesday, December 04, 2013 2:29 AM
To: arslist@ARSLIST.ORG
Subject: Re: Runmacro fails
Hi,
Apparently the tool tries to export the definitions (exp) of HPD:Help Desk, and
consequently crashes...
The vfc apparently compares your currrent def-version-timestamp to the one of
the server, and finds it necessary to get the definjition again. You have
probably updated the form since it was retrieved the last time some 7 days
ago...
Best Regards - Misi, RRR AB, http://rrr.se
Hi,
\$NULL\$ worked out and got results. On the otherhand, captured
arapires and cmd logs after executing the runmacro with recorded macro
files. I need assistance on troubleshooting these logs, since I
didn’t see any Error messages in these logs. Unfortunately, no links
found in communities as of now.
In cmd_1, after validate form cache, the below entry was logged and
Segmentation fault error displayed in putty.
# ARValidateFormCache
#
vfc
HPD:Help Desk
1385469149
1385469149
1385469149
#
# ARExport
#
exp
1
1
2
HPD:Help Desk
0
** FILE NAME **
Any simple way to understand what went wrong
Regards,
Govind M
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Wednesday, November 27, 2013 6:03 PM
To: arslist@ARSLIST.ORG
Subject: Re: Runmacro fails
Hi,
...$NULL$... will be expanded by the shell to ...$..., which
explains that problem.
Try ...\$NULL\$... instead.
Then you can set environment ARAPILOGGING=1 and check the resulting
arapicmd* and arapires* files to see how far the tool gets when you
try to run the Macro you were talking about earlier.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP
2011)
Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
Misi,
I have used ftp as well as scp. But still no results.
Also, the below format throws the error as Unknown reference fields
when the parser intercepts the $ symbol.
runmacro -x servername -U username -P password -o
/App1/report.csv -f HPD:Help Desk -t csv -q ('UAN GO Number'
!= $NULL$ OR 'VAS exists flag'
!= $NULL$) AND 'Status*' 4
Accessing server - servername...
Processing form - HPD:Help Desk ...
Unknown field reference - position 47 (...ists flag' != $^) AND
'Status*'...) [ARERR 2297]
Server - servername access complete with total matches of 0 record(s).
Thanks,
Govind M
+91 8123458366
Atheeb Remedy Team
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Tuesday, November 26, 2013 9:18 PM
To: arslist@ARSLIST.ORG
Subject: Re: Runmacro fails
Hi,
Copy/paste seems to be a bad idea, as there are some special control
characters in the file.
I suggest you use ftp or scp instead, and see if that helps.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP
2011)
Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
Hi listers,
I was trying to execute the below command in Putty.
./runmacro -d path of macrofile -x servername -U username -P
password -e reportsavedname
It gives the below statement and exist. As a prequisite, I have
updated the path of macrofile and runmacro binary in LD_LIBRARY_PATH.
Also added
LoadSchemaFromCache: F in conf. But no result.
Action Request System Unix Runmacro Version 7.1.00 Copyright (c)
BMC Software, Inc. 1991-2007. All rights reserved.
Executing macro - UANVASReport. Please wait...
Segmentation Fault (core dumped)
But I still have a doubt on the format of *.arq file which was
recorded in windows client and copy pasted into unix directory with
permissions. I just changed the to file: path adjusting to Unix format.
Is there something I am missing to do.? Appreciate any suggestion.
Solaris 10, ARS 7.1 Patch 8
Thanks,
Govind
Please do not print
Re: Runmacro fails
Hi,
The error might not be related to the ARExport-call at all, but that is the
last API call that is done.
The ARValidateFormCache that is called will compare the date to the FORM and
all related ACTL:s, ACTL-GUIDE:s and MENU:s. If any of these has been updated,
a new version needs to be retrieved.
If runmacro indeed uses cached files, I would suspect they ar named .arf/.arv
as the old user tool did. Have you tried to find these files? Maybe you can
delete them before you run it again?
The most likely problem to me would seem to be the macro itself. Does other
macros work for you? Have you tried to record any other simple macro against a
small regular form to see if it works?
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
Hi Misi,
Could you please explain bit elaborate on updating the form definitions. The
last update on the form .def was happened on June month.
Today, I have captured few logs and it shown the timestamp as yesterday.
My unix admin has explained me on this error like the funtions starts with
00237544 defined in runmacro are not executed because of some memory issue
(smalloc, malloc)...
Thanks,
Govind M
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Wednesday, December 04, 2013 2:29 AM
To: arslist@ARSLIST.ORG
Subject: Re: Runmacro fails
Hi,
Apparently the tool tries to export the definitions (exp) of HPD:Help Desk,
and consequently crashes...
The vfc apparently compares your currrent def-version-timestamp to the one of
the server, and finds it necessary to get the definjition again. You have
probably updated the form since it was retrieved the last time some 7 days
ago...
Best Regards - Misi, RRR AB, http://rrr.se
Hi,
\$NULL\$ worked out and got results. On the otherhand, captured
arapires and cmd logs after executing the runmacro with recorded macro
files. I need assistance on troubleshooting these logs, since I
didn’t see any Error messages in these logs. Unfortunately, no links
found in communities as of now.
In cmd_1, after validate form cache, the below entry was logged and
Segmentation fault error displayed in putty.
# ARValidateFormCache
#
vfc
HPD:Help Desk
1385469149
1385469149
1385469149
#
# ARExport
#
exp
1
1
2
HPD:Help Desk
0
** FILE NAME **
Any simple way to understand what went wrong
Regards,
Govind M
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Wednesday, November 27, 2013 6:03 PM
To: arslist@ARSLIST.ORG
Subject: Re: Runmacro fails
Hi,
...$NULL$... will be expanded by the shell to ...$..., which
explains that problem.
Try ...\$NULL\$... instead.
Then you can set environment ARAPILOGGING=1 and check the resulting
arapicmd* and arapires* files to see how far the tool gets when you
try to run the Macro you were talking about earlier.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP
2011)
Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
Misi,
I have used ftp as well as scp. But still no results.
Also, the below format throws the error as Unknown reference fields
when the parser intercepts the $ symbol.
runmacro -x servername -U username -P password -o
/App1/report.csv -f HPD:Help Desk -t csv -q ('UAN GO Number'
!= $NULL$ OR 'VAS exists flag'
!= $NULL$) AND 'Status*' 4
Accessing server - servername...
Processing form - HPD:Help Desk ...
Unknown field reference - position 47 (...ists flag' != $^) AND
'Status*'...) [ARERR 2297]
Server - servername access complete with total matches of 0 record(s).
Thanks,
Govind M
+91 8123458366
Atheeb Remedy Team
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Tuesday, November 26, 2013 9:18 PM
To: arslist@ARSLIST.ORG
Subject: Re: Runmacro fails
Hi,
Copy/paste seems to be a bad idea, as there are some special control
characters in the file.
I suggest you use ftp or scp instead, and see if that helps.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP
2011)
Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR
Re: Runmacro fails
Hi Misi,
You are right...!
The problem is with macro file format of opening the .arq file. In windows,
.arq file content would be readable only when we open it in notepad, word pad
etc...
In such cases, if unknowingly, we checked the option Always open using the
selected program then it will start open all .arq files in notepad window.
Once removing that file type assosiation with the selected program and FTP it
to unix box, works as expected ;-)
Small thing.. taken a while figure it out.
My next challenge would be how to encrypt the password / to find is there any
way to avoid giving direct password in command...
Thanks,
Govind
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Friday, December 06, 2013 2:01 PM
To: arslist@ARSLIST.ORG
Subject: Re: Runmacro fails
Hi,
The error might not be related to the ARExport-call at all, but that is the
last API call that is done.
The ARValidateFormCache that is called will compare the date to the FORM and
all related ACTL:s, ACTL-GUIDE:s and MENU:s. If any of these has been updated,
a new version needs to be retrieved.
If runmacro indeed uses cached files, I would suspect they ar named .arf/.arv
as the old user tool did. Have you tried to find these files? Maybe you can
delete them before you run it again?
The most likely problem to me would seem to be the macro itself. Does other
macros work for you? Have you tried to record any other simple macro against a
small regular form to see if it works?
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
Hi Misi,
Could you please explain bit elaborate on updating the form definitions. The
last update on the form .def was happened on June month.
Today, I have captured few logs and it shown the timestamp as yesterday.
My unix admin has explained me on this error like the funtions starts with
00237544 defined in runmacro are not executed because of some memory issue
(smalloc, malloc)...
Thanks,
Govind M
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Wednesday, December 04, 2013 2:29 AM
To: arslist@ARSLIST.ORG
Subject: Re: Runmacro fails
Hi,
Apparently the tool tries to export the definitions (exp) of HPD:Help Desk,
and consequently crashes...
The vfc apparently compares your currrent def-version-timestamp to the one of
the server, and finds it necessary to get the definjition again. You have
probably updated the form since it was retrieved the last time some 7 days
ago...
Best Regards - Misi, RRR AB, http://rrr.se
Hi,
\$NULL\$ worked out and got results. On the otherhand, captured
arapires and cmd logs after executing the runmacro with recorded macro
files. I need assistance on troubleshooting these logs, since I
didn’t see any Error messages in these logs. Unfortunately, no links
found in communities as of now.
In cmd_1, after validate form cache, the below entry was logged and
Segmentation fault error displayed in putty.
# ARValidateFormCache
#
vfc
HPD:Help Desk
1385469149
1385469149
1385469149
#
# ARExport
#
exp
1
1
2
HPD:Help Desk
0
** FILE NAME **
Any simple way to understand what went wrong
Regards,
Govind M
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Wednesday, November 27, 2013 6:03 PM
To: arslist@ARSLIST.ORG
Subject: Re: Runmacro fails
Hi,
...$NULL$... will be expanded by the shell to ...$..., which
explains that problem.
Try ...\$NULL\$... instead.
Then you can set environment ARAPILOGGING=1 and check the resulting
arapicmd* and arapires* files to see how far the tool gets when you
try to run the Macro you were talking about earlier.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP
2011)
Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
Misi,
I have used ftp as well as scp. But still no results.
Also, the below format throws the error as Unknown reference fields
when the parser intercepts the $ symbol.
runmacro -x servername -U username -P password -o
/App1/report.csv -f HPD:Help Desk -t csv -q ('UAN GO Number'
!= $NULL$ OR 'VAS exists flag'
!= $NULL$) AND 'Status*' 4
Accessing server - servername...
Processing
Re: Runmacro fails
Hi,
Apparently the tool tries to export the definitions (exp) of HPD:Help Desk,
and consequently crashes...
The vfc apparently compares your currrent def-version-timestamp to the one of
the server, and finds it necessary to get the definjition again. You have
probably updated the form since it was retrieved the last time some 7 days
ago...
Best Regards - Misi, RRR AB, http://rrr.se
Hi,
\$NULL\$ worked out and got results. On the otherhand, captured arapires and
cmd logs after executing the runmacro with recorded macro files. I need
assistance on troubleshooting these logs, since I didn’t see any Error
messages in these logs. Unfortunately, no links found in communities as of
now.
In cmd_1, after validate form cache, the below entry was logged and
Segmentation fault error displayed in putty.
# ARValidateFormCache
#
vfc
HPD:Help Desk
1385469149
1385469149
1385469149
#
# ARExport
#
exp
1
1
2
HPD:Help Desk
0
** FILE NAME **
Any simple way to understand what went wrong
Regards,
Govind M
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Wednesday, November 27, 2013 6:03 PM
To: arslist@ARSLIST.ORG
Subject: Re: Runmacro fails
Hi,
...$NULL$... will be expanded by the shell to ...$..., which explains that
problem.
Try ...\$NULL\$... instead.
Then you can set environment ARAPILOGGING=1 and check the resulting arapicmd*
and arapires* files to see how far the tool gets when you try to run the Macro
you were talking about earlier.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
Misi,
I have used ftp as well as scp. But still no results.
Also, the below format throws the error as Unknown reference fields
when the parser intercepts the $ symbol.
runmacro -x servername -U username -P password -o
/App1/report.csv -f HPD:Help Desk -t csv -q ('UAN GO Number' !=
$NULL$ OR 'VAS exists flag'
!= $NULL$) AND 'Status*' 4
Accessing server - servername...
Processing form - HPD:Help Desk ...
Unknown field reference - position 47 (...ists flag' != $^) AND
'Status*'...) [ARERR 2297]
Server - servername access complete with total matches of 0 record(s).
Thanks,
Govind M
+91 8123458366
Atheeb Remedy Team
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Tuesday, November 26, 2013 9:18 PM
To: arslist@ARSLIST.ORG
Subject: Re: Runmacro fails
Hi,
Copy/paste seems to be a bad idea, as there are some special control
characters in the file.
I suggest you use ftp or scp instead, and see if that helps.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP
2011)
Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
Hi listers,
I was trying to execute the below command in Putty.
./runmacro -d path of macrofile -x servername -U username -P
password -e reportsavedname
It gives the below statement and exist. As a prequisite, I have
updated the path of macrofile and runmacro binary in LD_LIBRARY_PATH.
Also added
LoadSchemaFromCache: F in conf. But no result.
Action Request System Unix Runmacro Version 7.1.00 Copyright (c) BMC
Software, Inc. 1991-2007. All rights reserved.
Executing macro - UANVASReport. Please wait...
Segmentation Fault (core dumped)
But I still have a doubt on the format of *.arq file which was
recorded in windows client and copy pasted into unix directory with
permissions. I just changed the to file: path adjusting to Unix format.
Is there something I am missing to do.? Appreciate any suggestion.
Solaris 10, ARS 7.1 Patch 8
Thanks,
Govind
Please do not print this email unless it is absolutely necessary.
The information contained in this electronic message and any
attachments to this message are intended for the exclusive use of the
addressee(s) and may contain proprietary, confidential or privileged
information. If you are not the intended recipient, you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately and destroy all copies of this message and any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient
should check this email and any attachments for the presence of
viruses. The company accepts no liability for any damage caused by
any virus
Re: Runmacro fails
Hi,
\$NULL\$ worked out and got results. On the otherhand, captured arapires and
cmd logs after executing the runmacro with recorded macro files. I need
assistance on troubleshooting these logs, since I didn’t see any Error messages
in these logs. Unfortunately, no links found in communities as of now.
In cmd_1, after validate form cache, the below entry was logged and
Segmentation fault error displayed in putty.
# ARValidateFormCache
#
vfc
HPD:Help Desk
1385469149
1385469149
1385469149
#
# ARExport
#
exp
1
1
2
HPD:Help Desk
0
** FILE NAME **
Any simple way to understand what went wrong
Regards,
Govind M
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Wednesday, November 27, 2013 6:03 PM
To: arslist@ARSLIST.ORG
Subject: Re: Runmacro fails
Hi,
...$NULL$... will be expanded by the shell to ...$..., which explains that
problem.
Try ...\$NULL\$... instead.
Then you can set environment ARAPILOGGING=1 and check the resulting arapicmd*
and arapires* files to see how far the tool gets when you try to run the Macro
you were talking about earlier.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
Misi,
I have used ftp as well as scp. But still no results.
Also, the below format throws the error as Unknown reference fields
when the parser intercepts the $ symbol.
runmacro -x servername -U username -P password -o
/App1/report.csv -f HPD:Help Desk -t csv -q ('UAN GO Number' != $NULL$
OR 'VAS exists flag'
!= $NULL$) AND 'Status*' 4
Accessing server - servername...
Processing form - HPD:Help Desk ...
Unknown field reference - position 47 (...ists flag' != $^) AND
'Status*'...) [ARERR 2297]
Server - servername access complete with total matches of 0 record(s).
Thanks,
Govind M
+91 8123458366
Atheeb Remedy Team
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Tuesday, November 26, 2013 9:18 PM
To: arslist@ARSLIST.ORG
Subject: Re: Runmacro fails
Hi,
Copy/paste seems to be a bad idea, as there are some special control
characters in the file.
I suggest you use ftp or scp instead, and see if that helps.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP
2011)
Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
Hi listers,
I was trying to execute the below command in Putty.
./runmacro -d path of macrofile -x servername -U username -P
password -e reportsavedname
It gives the below statement and exist. As a prequisite, I have
updated the path of macrofile and runmacro binary in LD_LIBRARY_PATH.
Also added
LoadSchemaFromCache: F in conf. But no result.
Action Request System Unix Runmacro Version 7.1.00 Copyright (c) BMC
Software, Inc. 1991-2007. All rights reserved.
Executing macro - UANVASReport. Please wait...
Segmentation Fault (core dumped)
But I still have a doubt on the format of *.arq file which was
recorded in windows client and copy pasted into unix directory with
permissions. I just changed the to file: path adjusting to Unix format.
Is there something I am missing to do.? Appreciate any suggestion.
Solaris 10, ARS 7.1 Patch 8
Thanks,
Govind
Please do not print this email unless it is absolutely necessary.
The information contained in this electronic message and any
attachments to this message are intended for the exclusive use of the
addressee(s) and may contain proprietary, confidential or privileged
information. If you are not the intended recipient, you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately and destroy all copies of this message and any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient
should check this email and any attachments for the presence of
viruses. The company accepts no liability for any damage caused by
any virus transmitted by this email.
www.wipro.com
_
_ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
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
Re: Runmacro fails
Misi,
I have used ftp as well as scp. But still no results.
Also, the below format throws the error as Unknown reference fields when the
parser intercepts the $ symbol.
runmacro -x servername -U username -P password -o /App1/report.csv -f
HPD:Help Desk -t csv -q ('UAN GO Number' != $NULL$ OR 'VAS exists flag' !=
$NULL$) AND 'Status*' 4
Accessing server - servername...
Processing form - HPD:Help Desk ...
Unknown field reference - position 47 (...ists flag' != $^) AND
'Status*'...) [ARERR 2297]
Server - servername access complete with total matches of 0 record(s).
Thanks,
Govind M
+91 8123458366
Atheeb Remedy Team
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Tuesday, November 26, 2013 9:18 PM
To: arslist@ARSLIST.ORG
Subject: Re: Runmacro fails
Hi,
Copy/paste seems to be a bad idea, as there are some special control characters
in the file.
I suggest you use ftp or scp instead, and see if that helps.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
Hi listers,
I was trying to execute the below command in Putty.
./runmacro -d path of macrofile -x servername -U username -P
password -e reportsavedname
It gives the below statement and exist. As a prequisite, I have
updated the path of macrofile and runmacro binary in LD_LIBRARY_PATH.
Also added
LoadSchemaFromCache: F in conf. But no result.
Action Request System Unix Runmacro Version 7.1.00 Copyright (c) BMC
Software, Inc. 1991-2007. All rights reserved.
Executing macro - UANVASReport. Please wait...
Segmentation Fault (core dumped)
But I still have a doubt on the format of *.arq file which was
recorded in windows client and copy pasted into unix directory with
permissions. I just changed the to file: path adjusting to Unix format.
Is there something I am missing to do.? Appreciate any suggestion.
Solaris 10, ARS 7.1 Patch 8
Thanks,
Govind
Please do not print this email unless it is absolutely necessary.
The information contained in this electronic message and any
attachments to this message are intended for the exclusive use of the
addressee(s) and may contain proprietary, confidential or privileged
information. If you are not the intended recipient, you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately and destroy all copies of this message and any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient
should check this email and any attachments for the presence of
viruses. The company accepts no liability for any damage caused by any
virus transmitted by this email.
www.wipro.com
__
_ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
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
The information contained in this electronic message and any attachments to
this message are intended for the exclusive use of the addressee(s) and may
contain proprietary, confidential or privileged information. If you are not the
intended recipient, you should not disseminate, distribute or copy this e-mail.
Please notify the sender immediately and destroy all copies of this message and
any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient should
check this email and any attachments for the presence of viruses. The company
accepts no liability for any damage caused by any virus transmitted by this
email.
www.wipro.com
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years
Re: Runmacro fails
Hi,
...$NULL$... will be expanded by the shell to ...$..., which explains that
problem.
Try ...\$NULL\$... instead.
Then you can set environment ARAPILOGGING=1 and check the resulting arapicmd*
and arapires* files to see how far the tool gets when you try to run the Macro
you were talking about earlier.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
Misi,
I have used ftp as well as scp. But still no results.
Also, the below format throws the error as Unknown reference fields when the
parser intercepts the $ symbol.
runmacro -x servername -U username -P password -o /App1/report.csv -f
HPD:Help Desk -t csv -q ('UAN GO Number' != $NULL$ OR 'VAS exists flag'
!= $NULL$) AND 'Status*' 4
Accessing server - servername...
Processing form - HPD:Help Desk ...
Unknown field reference - position 47 (...ists flag' != $^) AND
'Status*'...) [ARERR 2297]
Server - servername access complete with total matches of 0 record(s).
Thanks,
Govind M
+91 8123458366
Atheeb Remedy Team
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Tuesday, November 26, 2013 9:18 PM
To: arslist@ARSLIST.ORG
Subject: Re: Runmacro fails
Hi,
Copy/paste seems to be a bad idea, as there are some special control
characters in the file.
I suggest you use ftp or scp instead, and see if that helps.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
Hi listers,
I was trying to execute the below command in Putty.
./runmacro -d path of macrofile -x servername -U username -P
password -e reportsavedname
It gives the below statement and exist. As a prequisite, I have
updated the path of macrofile and runmacro binary in LD_LIBRARY_PATH.
Also added
LoadSchemaFromCache: F in conf. But no result.
Action Request System Unix Runmacro Version 7.1.00 Copyright (c) BMC
Software, Inc. 1991-2007. All rights reserved.
Executing macro - UANVASReport. Please wait...
Segmentation Fault (core dumped)
But I still have a doubt on the format of *.arq file which was
recorded in windows client and copy pasted into unix directory with
permissions. I just changed the to file: path adjusting to Unix format.
Is there something I am missing to do.? Appreciate any suggestion.
Solaris 10, ARS 7.1 Patch 8
Thanks,
Govind
Please do not print this email unless it is absolutely necessary.
The information contained in this electronic message and any
attachments to this message are intended for the exclusive use of the
addressee(s) and may contain proprietary, confidential or privileged
information. If you are not the intended recipient, you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately and destroy all copies of this message and any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient
should check this email and any attachments for the presence of
viruses. The company accepts no liability for any damage caused by any
virus transmitted by this email.
www.wipro.com
__
_ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
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
The information contained in this electronic message and any attachments to
this message are intended for the exclusive use of the addressee(s) and may
contain proprietary, confidential or privileged information. If you are not
the intended recipient, you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately and destroy all copies of this
message and any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient should
check this email and any attachments for the presence of viruses. The company
accepts no liability for any damage caused by any virus transmitted by this
email.
www.wipro.com
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years
Runmacro fails
Hi listers, I was trying to execute the below command in Putty. ./runmacro -d path of macrofile -x servername -U username -P password -e reportsavedname It gives the below statement and exist. As a prequisite, I have updated the path of macrofile and runmacro binary in LD_LIBRARY_PATH. Also added LoadSchemaFromCache: F in conf. But no result. Action Request System Unix Runmacro Version 7.1.00 Copyright (c) BMC Software, Inc. 1991-2007. All rights reserved. Executing macro - UANVASReport. Please wait... Segmentation Fault (core dumped) But I still have a doubt on the format of *.arq file which was recorded in windows client and copy pasted into unix directory with permissions. I just changed the to file: path adjusting to Unix format. Is there something I am missing to do.? Appreciate any suggestion. Solaris 10, ARS 7.1 Patch 8 Thanks, Govind Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Runmacro fails
Hi, Copy/paste seems to be a bad idea, as there are some special control characters in the file. I suggest you use ftp or scp instead, and see if that helps. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Hi listers, I was trying to execute the below command in Putty. ./runmacro -d path of macrofile -x servername -U username -P password -e reportsavedname It gives the below statement and exist. As a prequisite, I have updated the path of macrofile and runmacro binary in LD_LIBRARY_PATH. Also added LoadSchemaFromCache: F in conf. But no result. Action Request System Unix Runmacro Version 7.1.00 Copyright (c) BMC Software, Inc. 1991-2007. All rights reserved. Executing macro - UANVASReport. Please wait... Segmentation Fault (core dumped) But I still have a doubt on the format of *.arq file which was recorded in windows client and copy pasted into unix directory with permissions. I just changed the to file: path adjusting to Unix format. Is there something I am missing to do.? Appreciate any suggestion. Solaris 10, ARS 7.1 Patch 8 Thanks, Govind Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 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
Re: Runmacro
Duh! You should have said Read the documentation dummy! Thanks for the response. I got arexport.bat working and everythings happy. Gordon - Original Message - From: Sylvain YVON sylvain.y...@gmail.com To: arslist@ARSLIST.ORG Sent: Thursday, November 1, 2012 4:00:48 PM Subject: Re: Runmacro ** Hi, You still have runmacro. You also have a arexport.sh that exports data which uses the artools java class (didn't try it yet). And, if it's not enough, you also have Data Integration (Pentaho Spoon+Kettle) that is nice for this kind of jobs. :) On Thu, Nov 1, 2012 at 7:54 PM, Gordon Frank gjj...@comcast.net wrote: ** What is the replacement for runmacro in 8.0? I use it in Command Line dumps from forms. It makes it real easy to integrate it into scheduled jobs Gordon Frank _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Runmacro
What is the replacement for runmacro in 8.0? I use it in Command Line dumps from forms. It makes it real easy to integrate it into scheduled jobs Gordon Frank ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Runmacro
Hi, You still have runmacro. You also have a arexport.sh that exports data which uses the artools java class (didn't try it yet). And, if it's not enough, you also have Data Integration (Pentaho Spoon+Kettle) that is nice for this kind of jobs. :) On Thu, Nov 1, 2012 at 7:54 PM, Gordon Frank gjj...@comcast.net wrote: ** What is the replacement for runmacro in 8.0? I use it in Command Line dumps from forms. It makes it real easy to integrate it into scheduled jobs Gordon Frank _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Runmacro is not returning the stdout error
Since you are not calling the runmacro program from inside ARS I would not expect it to be listed in arfork (I assume you are calling it from the TEC/Ominbus system/app). The arfork log file is for external processes called from ARS (using $PROCESS$ or a Run Process action). What do you see if you call it directly from a shell session? Do you see the error? Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of D Dussie Sent: Thursday, August 09, 2012 6:27 PM To: arslist@ARSLIST.ORG Subject: Re: Runmacro is not returning the stdout error 7.5 filter logs does capture the error, but does not do the stdout nor log to the arfork.log. Error while performing filter action: Error 653258 -- FLTR TID: 001563 RPC ID: 004085 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 19:15:47.9647 */ Filter Level:1 Number Of Filters:77 Checking *FP-SM 340 SM Validate CPI 1 (340) FLTR TID: 001563 RPC ID: 004085 Queue: Fast Client-RPC: 390620USER: tivoli -- Failed qualification FLTR TID: 001563 RPC ID: 004085 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 19:15:47.9647 */ Filter Level:1 Number Of Filters:78 Checking *FP-SM 350 SM Validate CPI 2 (350) FLTR TID: 001563 RPC ID: 004085 Queue: Fast Client-RPC: 390620USER: tivoli -- Passed -- perform actions FLTR TID: 001563 RPC ID: 004085 Queue: Fast Client-RPC: 390620USER: tivoli0: Message FLTR TID: 001563 RPC ID: 004085 Queue: Fast Client-RPC: 390620USER: tivoli You have selected a CPI that is not valid, please re-select a CPI to continue. If you need to request a new CPI, Submit a Remedy Request with the following CPI: Sched./Planned Work -- Desktop Software -- Remedy-Request New CPI FLTR TID: 001563 RPC ID: 004085 Queue: Fast Client-RPC: 390620USER: tivoli Error while performing filter action: Error 653258 FLTR TID: 001563 RPC ID: 004085 Queue: Fast Client-RPC: 390620USER: tivoli Filter *FP-SM 350 SM Validate CPI 2: No enabled error handler FLTR TID: 001563 RPC ID: 004085 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 19:15:47.9648 */ End of filter processing (phase 1) -- Operation - CREATE on FP-SM Svc Management System - NULL FLTR TID: 001563 RPC ID: 004085 Queue: Fast Client-RPC: 390620USER: tivoli0: Push Fields - FP-RA 750 S Submit Request (ARERR 326) FLTR TID: 001563 RPC ID: 004085 Queue: Fast Client-RPC: 390620USER: tivoli Error while performing filter action: Error 326 FLTR TID: 001563 RPC ID: 004085 Queue: Fast Client-RPC: 390620USER: tivoli Filter FP-RA 750 S Submit Request: No enabled error handler FLTR TID: 001563 RPC ID: 004085 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 19:15:47.9649 */ End of filter processing (phase 2) -- Operation - CREATE on FP-RA Svc Request Automation - AUTO0467618 FLTR TID: 001563 RPC ID: 004085 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 19:15:47.9774 */Canceled filter processing due to error ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Runmacro is not returning the stdout error
That is correct, it is being called externally. The tec/onmibus server ssh/rsh to the remedy server to executed the script. This is what I'm simulating, running it local on server (commandline), which should do the stdout of arerrors but this is not occurring with 7.5 runmacro, but does work with the 6.3 runmacro. This is what seen from shell and no error stdout. BMC Remedy Action Request System Unix Runmacro Version 7.5.00 Copyright (c) BMC Software, Inc. 1991-2009. All rights reserved. Executing macro - Automation. Please wait... Macro - Automation processing complete. Verses. Action Request System Unix Runmacro Version 6.3 Copyright (c) BMC Software, Inc. 1991-2005. All rights reserved. Executing macro - Automation. Please wait... - You have selected a CPI that is not valid, please re-select a CPI to continue. If you need to request a new CPI, Submit a Remedy Request with the following CPI: Sched./Planned Work -- Desktop Software -- Remedy-Request New CPI [ARERR 653258] Macro - Automation processing complete. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Runmacro is not returning the stdout error
Hello List, Hoping someone can assist. With further investigation, I have found that filters are not being executed with 7.5 Runmacro executes. The errors are not being written to arfork.log. With Runmacro 6.3, Arfilter.log logs this entry, which is reflected in the stdout error for runmacro 6.3 version, FLTR TID: 001563 RPC ID: 13 Queue: Fast Client-RPC: 390600USER: tivoli/* Thu Aug 09 2012 11:32:16.9885 */ Filter Level:1 Number Of Filters:78 Checking *FP-SM 350 SM Validate CPI 2 (350) FLTR TID: 001563 RPC ID: 13 Queue: Fast Client-RPC: 390600USER: tivoli -- Passed -- perform actions FLTR TID: 001563 RPC ID: 13 Queue: Fast Client-RPC: 390600USER: tivoli0: Message FLTR TID: 001563 RPC ID: 13 Queue: Fast Client-RPC: 390600USER: tivoli You have selected a CPI that is not valid, please re-select a CPI to continue. If you need to request a new CPI, Submit a Remedy Request with the following CPI: Sched./Planned Work -- Desktop Software -- Remedy-Request New CPI FLTR TID: 001563 RPC ID: 13 Queue: Fast Client-RPC: 390600USER: tivoli Error while performing filter action: Error 653258 FLTR TID: 001563 RPC ID: 13 Queue: Fast Client-RPC: 390600USER: tivoli Filter *FP-SM 350 SM Validate CPI 2: No enabled error handler FLTR TID: 001563 RPC ID: 13 Queue: Fast Client-RPC: 390600USER: tivoli/* Thu Aug 09 2012 11:32:16.9886 */ End of filter processing (phase 1) -- Operation - CREATE on FP-SM Svc Management System - NULL server:/usr/ar/remedy/db $/usr/ar/remedy/bin/runmacro -x server-a port-d /home/remedy/arHome/arcmds -e Automation -p Automation_Tag=D774_EVENT -p SRD=Testing_Psl_Ups -p wo Action Request System Unix Runmacro Version 6.3 Copyright (c) BMC Software, Inc. 1991-2005. All rights reserved. Executing macro - Automation. Please wait... - You have selected a CPI that is not valid, please re-select a CPI to continue. If you need to request a new CPI, Submit a Remedy Request with the following CPI: Sched./Planned Work -- Desktop Software -- Remedy-Request New CPI [ARERR 653258] Macro - Automation processing complete. server:/usr/ar/remedy/db $/usr/ar/remedy/bin/runmacro7.5 -x server-a port-d /home/remedy/arHome/arcmds -e Automation -p Automation_Tag=D774_EVENT -p SRD=Testing_Psl_Ups -p BMC Remedy Action Request System Unix Runmacro Version 7.5.00 Copyright (c) BMC Software, Inc. 1991-2009. All rights reserved. Executing macro - Automation. Please wait... Macro - Automation processing complete. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Runmacro is not returning the stdout error
D, What sort of API/etc logs do you get when you execute the 7.5 version? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of D Dussie Sent: Thursday, August 09, 2012 11:44 AM To: arslist@ARSLIST.ORG Subject: Re: Runmacro is not returning the stdout error Hello List, Hoping someone can assist. With further investigation, I have found that filters are not being executed with 7.5 Runmacro executes. The errors are not being written to arfork.log. With Runmacro 6.3, Arfilter.log logs this entry, which is reflected in the stdout error for runmacro 6.3 version, FLTR TID: 001563 RPC ID: 13 Queue: Fast Client-RPC: 390600USER: tivoli/* Thu Aug 09 2012 11:32:16.9885 */ Filter Level:1 Number Of Filters:78 Checking *FP-SM 350 SM Validate CPI 2 (350) FLTR TID: 001563 RPC ID: 13 Queue: Fast Client-RPC: 390600USER: tivoli -- Passed -- perform actions FLTR TID: 001563 RPC ID: 13 Queue: Fast Client-RPC: 390600USER: tivoli0: Message FLTR TID: 001563 RPC ID: 13 Queue: Fast Client-RPC: 390600USER: tivoli You have selected a CPI that is not valid, please re-select a CPI to continue. If you need to request a new CPI, Submit a Remedy Request with the following CPI: Sched./Planned Work -- Desktop Software -- Remedy-Request New CPI FLTR TID: 001563 RPC ID: 13 Queue: Fast Client-RPC: 390600USER: tivoli Error while performing filter action: Error 653258 FLTR TID: 001563 RPC ID: 13 Queue: Fast Client-RPC: 390600USER: tivoli Filter *FP-SM 350 SM Validate CPI 2: No enabled error handler FLTR TID: 001563 RPC ID: 13 Queue: Fast Client-RPC: 390600USER: tivoli/* Thu Aug 09 2012 11:32:16.9886 */ End of filter processing (phase 1) -- Operation - CREATE on FP-SM Svc Management System - NULL server:/usr/ar/remedy/db $/usr/ar/remedy/bin/runmacro -x server-a port-d /home/remedy/arHome/arcmds -e Automation -p Automation_Tag=D774_EVENT -p SRD=Testing_Psl_Ups -p wo Action Request System Unix Runmacro Version 6.3 Copyright (c) BMC Software, Inc. 1991-2005. All rights reserved. Executing macro - Automation. Please wait... - You have selected a CPI that is not valid, please re-select a CPI to continue. If you need to request a new CPI, Submit a Remedy Request with the following CPI: Sched./Planned Work -- Desktop Software -- Remedy-Request New CPI [ARERR 653258] Macro - Automation processing complete. server:/usr/ar/remedy/db $/usr/ar/remedy/bin/runmacro7.5 -x server-a port-d /home/remedy/arHome/arcmds -e Automation -p Automation_Tag=D774_EVENT -p SRD=Testing_Psl_Ups -p BMC Remedy Action Request System Unix Runmacro Version 7.5.00 Copyright (c) BMC Software, Inc. 1991-2009. All rights reserved. Executing macro - Automation. Please wait... Macro - Automation processing complete. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Runmacro is not returning the stdout error
Thank you for responding, api.log shows the marco is being executed, however that stdout of the error is not occuring, when it registers Unidentified Client -- the stdout of the error occurs. when it registers runmacro is fails.. What does it mean to be an Unidentified Client? API TID: 001563 RPC ID: 000411 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:02.5327 */+GSIARGetServerInfo -- as user tivoli from runmacro (protocol 14) at IP address ARSERVERIP API TID: 001563 RPC ID: 000411 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:02.5385 */-GSI OK API TID: 001820 RPC ID: 000412 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:02.5489 */+GSIARGetServerInfo -- as user tivoli from runmacro (protocol 14) at IP address ARSERVERIP API TID: 001820 RPC ID: 000412 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:02.5832 */-GSI OK API TID: 001563 RPC ID: 000413 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:02.5937 */+VERARVerifyUser -- user tivoli from runmacro (protocol 14) at IP address ARSERVERIP API TID: 001563 RPC ID: 000413 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:02.5945 */-VER OK API TID: 001820 RPC ID: 000414 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:02.6027 */+VERARVerifyUser -- user tivoli from runmacro (protocol 14) at IP address ARSERVERIP API TID: 001820 RPC ID: 000414 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:02.6038 */-VER OK API TID: 001563 RPC ID: 000415 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:02.6305 */+VFCARValidateFormCache -- form FP-RA Svc Request Automation from runmacro (protocol 14) at IP address ARSERVERIP API TID: 001563 RPC ID: 000415 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:02.6714 */-VFC OK API TID: 002077 RPC ID: 000416 Queue: List Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:02.6799 */+EXPARExport -- as user tivoli from runmacro (protocol 14) at IP address ARSERVERIP API TID: 002077 RPC ID: 000416 Queue: List Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:02.9796 */-EXP OK API TID: 002334 RPC ID: 000417 Queue: List Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:02.9963 */+EXPARExport -- as user tivoli from runmacro (protocol 14) at IP address ARSERVERIP API TID: 002334 RPC ID: 000417 Queue: List Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:03.2139 */-EXP OK API TID: 001820 RPC ID: 000418 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:03.2301 */+CE ARCreateEntry -- schema FP-RA Svc Request Automation from runmacro (protocol 14) at IP address ARSERVERIP API TID: 001820 RPC ID: 000418 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:04.1499 */-CE FAIL API TID: 001820 RPC ID: 000420 Queue: Fast Client-RPC: 390600USER: ARSERVERIP /* Thu Aug 09 2012 15:30:13.7207 */+GEIARGetEncryptInfo -- as user from Unidentified Client (protocol 11) at IP address API TID: 001820 RPC ID: 000420 Queue: Fast Client-RPC: 390600USER: ARSERVERIP /* Thu Aug 09 2012 15:30:13.7208 */-GEI OK API TID: 001563 RPC ID: 000421 Queue: Fast Client-RPC: 390600USER: tivoli/* Thu Aug 09 2012 15:30:13.7290 */+GSIARGetServerInfo -- as user tivoli from Unidentified Client (protocol 11) at IP address ARSERVERIP API TID: 001563 RPC ID: 000421 Queue: Fast Client-RPC: 390600USER: tivoli/* Thu Aug 09 2012 15:30:13.7294 */-GSI OK API TID: 001820 RPC ID: 000422 Queue: Fast Client-RPC: 390600USER: tivoli/* Thu Aug 09
Re: Runmacro is not returning the stdout error
Well...quite simply unidentified client means that the client isn't registering itself with a client id when it connects to the server. Why/if that would be preventing the server from returning errors is really not my expertise..I also notice that it's using a different protocol #. If you aren't experiencing 'issues' with your datameaning when you try to do this with datasets that aren't returning error...does it actually work for you, or is it completely non-functional? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of D Dussie Sent: Thursday, August 09, 2012 1:40 PM To: arslist@ARSLIST.ORG Subject: Re: Runmacro is not returning the stdout error Thank you for responding, api.log shows the marco is being executed, however that stdout of the error is not occuring, when it registers Unidentified Client -- the stdout of the error occurs. when it registers runmacro is fails.. What does it mean to be an Unidentified Client? API TID: 001563 RPC ID: 000411 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:02.5327 */+GSIARGetServerInfo -- as user tivoli from runmacro (protocol 14) at IP address ARSERVERIP API TID: 001563 RPC ID: 000411 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:02.5385 */-GSI OK API TID: 001820 RPC ID: 000412 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:02.5489 */+GSIARGetServerInfo -- as user tivoli from runmacro (protocol 14) at IP address ARSERVERIP API TID: 001820 RPC ID: 000412 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:02.5832 */-GSI OK API TID: 001563 RPC ID: 000413 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:02.5937 */+VERARVerifyUser -- user tivoli from runmacro (protocol 14) at IP address ARSERVERIP API TID: 001563 RPC ID: 000413 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:02.5945 */-VER OK API TID: 001820 RPC ID: 000414 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:02.6027 */+VERARVerifyUser -- user tivoli from runmacro (protocol 14) at IP address ARSERVERIP API TID: 001820 RPC ID: 000414 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:02.6038 */-VER OK API TID: 001563 RPC ID: 000415 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:02.6305 */+VFCARValidateFormCache -- form FP-RA Svc Request Automation from runmacro (protocol 14) at IP address ARSERVERIP API TID: 001563 RPC ID: 000415 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:02.6714 */-VFC OK API TID: 002077 RPC ID: 000416 Queue: List Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:02.6799 */+EXPARExport -- as user tivoli from runmacro (protocol 14) at IP address ARSERVERIP API TID: 002077 RPC ID: 000416 Queue: List Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:02.9796 */-EXP OK API TID: 002334 RPC ID: 000417 Queue: List Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:02.9963 */+EXPARExport -- as user tivoli from runmacro (protocol 14) at IP address ARSERVERIP API TID: 002334 RPC ID: 000417 Queue: List Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:03.2139 */-EXP OK API TID: 001820 RPC ID: 000418 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:03.2301 */+CE ARCreateEntry -- schema FP-RA Svc Request Automation from runmacro (protocol 14) at IP address ARSERVERIP API TID: 001820 RPC ID: 000418 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 15:30:04.1499 */-CE FAIL API TID: 001820 RPC ID: 000420 Queue: Fast Client-RPC: 390600USER: ARSERVERIP /* Thu Aug 09 2012 15:30:13.7207 */+GEIARGetEncryptInfo -- as user from Unidentified Client (protocol 11) at IP address API TID: 001820 RPC ID: 000420 Queue: Fast
Re: Runmacro is not returning the stdout error
Exactly, using a data that should not return an error and execute to create a incident ticket, this works fine for both versions 6.3/7.5. BMC is request recreating the macro in 7.5. vs the current which was created in probably 6.3 version at max. However, since this is a flatfile , i'm waiting on there response to why! What is the protocol# relevance? (protocol 11) - 6.3 version (protocol 14) - 7.5 version This seems to be consistent. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Runmacro is not returning the stdout error
Ok, found the protocol definition, its just defining the verison you are running.. Protocol: Version Protocol 11:6.3 Protocol 12:7.0.1 Protocol 13:7.1 Protocol 14:7.5 Protocol 17:7.6.03 Protocol 18:7.6.04 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Runmacro is not returning the stdout error
When you were giving logs on the differences you posted a Filter log when running with runmacro 6.3, but you posted an API log when running with runmacro 7.5. Can you post a filter log when running with runmacro 7.5? Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of D Dussie Sent: Thursday, August 09, 2012 5:05 PM To: arslist@ARSLIST.ORG Subject: Re: Runmacro is not returning the stdout error Exactly, using a data that should not return an error and execute to create a incident ticket, this works fine for both versions 6.3/7.5. BMC is request recreating the macro in 7.5. vs the current which was created in probably 6.3 version at max. However, since this is a flatfile , i'm waiting on there response to why! What is the protocol# relevance? (protocol 11) - 6.3 version (protocol 14) - 7.5 version This seems to be consistent. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Runmacro is not returning the stdout error
7.5 filter logs does capture the error, but does not do the stdout nor log to the arfork.log. Error while performing filter action: Error 653258 -- FLTR TID: 001563 RPC ID: 004085 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 19:15:47.9647 */ Filter Level:1 Number Of Filters:77 Checking *FP-SM 340 SM Validate CPI 1 (340) FLTR TID: 001563 RPC ID: 004085 Queue: Fast Client-RPC: 390620USER: tivoli -- Failed qualification FLTR TID: 001563 RPC ID: 004085 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 19:15:47.9647 */ Filter Level:1 Number Of Filters:78 Checking *FP-SM 350 SM Validate CPI 2 (350) FLTR TID: 001563 RPC ID: 004085 Queue: Fast Client-RPC: 390620USER: tivoli -- Passed -- perform actions FLTR TID: 001563 RPC ID: 004085 Queue: Fast Client-RPC: 390620USER: tivoli0: Message FLTR TID: 001563 RPC ID: 004085 Queue: Fast Client-RPC: 390620USER: tivoli You have selected a CPI that is not valid, please re-select a CPI to continue. If you need to request a new CPI, Submit a Remedy Request with the following CPI: Sched./Planned Work -- Desktop Software -- Remedy-Request New CPI FLTR TID: 001563 RPC ID: 004085 Queue: Fast Client-RPC: 390620USER: tivoli Error while performing filter action: Error 653258 FLTR TID: 001563 RPC ID: 004085 Queue: Fast Client-RPC: 390620USER: tivoli Filter *FP-SM 350 SM Validate CPI 2: No enabled error handler FLTR TID: 001563 RPC ID: 004085 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 19:15:47.9648 */ End of filter processing (phase 1) -- Operation - CREATE on FP-SM Svc Management System - NULL FLTR TID: 001563 RPC ID: 004085 Queue: Fast Client-RPC: 390620USER: tivoli0: Push Fields - FP-RA 750 S Submit Request (ARERR 326) FLTR TID: 001563 RPC ID: 004085 Queue: Fast Client-RPC: 390620USER: tivoli Error while performing filter action: Error 326 FLTR TID: 001563 RPC ID: 004085 Queue: Fast Client-RPC: 390620USER: tivoli Filter FP-RA 750 S Submit Request: No enabled error handler FLTR TID: 001563 RPC ID: 004085 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 19:15:47.9649 */ End of filter processing (phase 2) -- Operation - CREATE on FP-RA Svc Request Automation - AUTO0467618 FLTR TID: 001563 RPC ID: 004085 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 19:15:47.9774 */Canceled filter processing due to error FLTR TID: 001820 RPC ID: 004086 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 19:15:47.9879 */ Start filter processing (phase 1) -- Operation - DELETE on AR System Current License Usage - 0113932 FLTR TID: 001820 RPC ID: 004086 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 19:15:47.9880 */ End of filter processing (phase 1) -- Operation - DELETE on AR System Current License Usage - 0113932 FLTR TID: 001820 RPC ID: 004086 Queue: Fast Client-RPC: 390620USER: tivoli/* Thu Aug 09 2012 19:15:47.9949 */ Start filter processing (phase 1) -- Operation - CREATE on AR System Historical License Usage - NULL END OF LOG FILE ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Runmacro is not returning the stdout error
Hello Everyone, Environment, AIX 6.1. with ARS 7.5P4 on 11g (local) Websphere 6.1, MT 7.5P4 32bit install. History, we have been using runmacro to create automated tickets for a long time. So it is bridge between TEC/Ominbus and Remedy. Occasionally and lately we have been experiencing this issue: The runmacro executes successfully, but one of the parameter (variable) of the runmacro is incorrect and should have issued an error (stdout) which is piped to a file and logic written against. Nothing has changed, this works for other parameters populating the runmacro format. I look at the filter logging to see if it captures the error that should be stdout, but no error in logs. Is there a better way to trouble shoot this? Successful Example: $s -e Automation -p Automation_Tag=REMEDY_TEST -p SRD=Testing, Please ignore -p work_desc=Testing Please ignore -p Cust_Iden=ValidCustomer -p Severity=4 -p * BMC Remedy Action Request System Unix Runmacro Version 7.5.00 Copyright (c) BMC Software, Inc. 1991-2009. All rights reserved. Executing macro - Automation. Please wait... Request AUTO0473341 was successfully created. - [ARNOTE 1100] Macro - Automation processing complete. UnSuccessful Example: $s -e Automation -p Automation_Tag=REMEDY_TEST -p SRD=Testing, Please ignore -p work_desc=Testing Please ignore -p Cust_Iden=InvalidCust -p Severity=4 -p* BMC Remedy Action Request System Unix Runmacro Version 7.5.00 Copyright (c) BMC Software, Inc. 1991-2009. All rights reserved. Executing macro - Automation. Please wait... (STDOUT ERROR SHOULD EXIST HERE, FOR INVALID CUSTOMER) Macro - Automation processing complete. Successful UnSuccessful Example: $/usr/ar/remedy/bin/runmacro.6.3 -x rmdyprod -a 59500 -d /home/remedy/arHome/arcmds -e Automation -p Automation_Tag=REMEDY_TEST -p SRD=Testing, Please ig Action Request System Unix Runmacro Version 6.3 Copyright (c) BMC Software, Inc. 1991-2005. All rights reserved. Executing macro - Automation. Please wait... - The Phone # you have entered is not in a valid format. Please use either (###)###- or (###)###-x [ARERR 27000] Macro - Automation processing complete. DEE ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
runmacro date prompt OK in ARuser, but fails in runmacro
I built a macro in ARuser that prompts for a date. When I run the macro in ARuser, it accepts my typing in: 04/04/2012 A runmacro execution (from a filter or in a CMD window) fails with: -p StartDate=04/03/2012 also fails with: -p StartDate=04/03/2012 also fails with: -p StartDate=04/03/2012 00:00:00 also fails with: -p StartDate=04/03/2012 00:00:00 AR versions 7.0 have accepted: -p StartDate=04/03/2012 Anyone know of a 'new' trick I'm missing? (under a bit of a time crunch here ...) THANKS, Joel ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: runmacro date prompt OK in ARuser, but fails in runmacro
Do you have an ARDATE (or is it ARDATEONLY) environment variable changing the format of a date? What happens if you use the numeric value for the date? Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joel D. Sender Sent: Thursday, April 12, 2012 1:36 PM To: arslist@ARSLIST.ORG Subject: runmacro date prompt OK in ARuser, but fails in runmacro I built a macro in ARuser that prompts for a date. When I run the macro in ARuser, it accepts my typing in: 04/04/2012 A runmacro execution (from a filter or in a CMD window) fails with: -p StartDate=04/03/2012 also fails with: -p StartDate=04/03/2012 also fails with: -p StartDate=04/03/2012 00:00:00 also fails with: -p StartDate=04/03/2012 00:00:00 AR versions 7.0 have accepted: -p StartDate=04/03/2012 Anyone know of a 'new' trick I'm missing? (under a bit of a time crunch here ...) THANKS, Joel ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: runmacro date prompt OK in ARuser, but fails in runmacro
We have not set ARDATE or ARDATEONLY. Using the defaults. ARERR 1590 says the date format is invalid. Thanks, Joel ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: runmacro date prompt OK in ARuser, but fails in runmacro
I just tried the date value in seconds (i.e. 1334257637) and it, too failed. sigh Joel ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Weekly report using Runmacro
Hi Howard, The -o option for runmacro is a special mode of operation that is used to dump the data from one or more forms quickly. It ignores the query in the macro in favour of one passed via the -q or -Q options, depending on the format of the query. There is another paramtere for passing the formname also so the macro is completely redundent with -o. I guess this has probably arrived a little too late for you. Rod On 24 September 2010 08:57, Howard how...@homesteadbound.com wrote: I am trying to generate a weekly report in a CSV format and want to use the server runmacro utility to accomplish this. When I try to run the following in the command line: /u01/app/bmc/v55/bin/runmacro -d /u01/app/bmc/ -o /u01/app/bmc/macro -x testserver -e testmacro -U user -P password -f formName -t csv I do get a CSV file as the output, however, the file contains all the records from the formName and it doesn't take the qualification in my testmacro into consideration. Does anybody know why? Also, how would I apply the .arr style to the command or does it just know because the file is located in the same directory as the macro? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Weekly report using Runmacro
1. May be you forget -a protNo, or you need to set environment variables such as ARHOME=? REMEDY_DIR=? AR_CONF=? AR_SERVER_ID=? ARMON_DIR=? ARTCPPORT=? PATH=? 2. For .arr once define in the macro then the file should be in the same directory, -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rod Harris Sent: Tuesday, March 08, 2011 2:46 PM To: arslist@ARSLIST.ORG Subject: Re: Weekly report using Runmacro Hi Howard, The -o option for runmacro is a special mode of operation that is used to dump the data from one or more forms quickly. It ignores the query in the macro in favour of one passed via the -q or -Q options, depending on the format of the query. There is another paramtere for passing the formname also so the macro is completely redundent with -o. I guess this has probably arrived a little too late for you. Rod On 24 September 2010 08:57, Howard how...@homesteadbound.com wrote: I am trying to generate a weekly report in a CSV format and want to use the server runmacro utility to accomplish this. When I try to run the following in the command line: /u01/app/bmc/v55/bin/runmacro -d /u01/app/bmc/ -o /u01/app/bmc/macro -x testserver -e testmacro -U user -P password -f formName -t csv I do get a CSV file as the output, however, the file contains all the records from the formName and it doesn't take the qualification in my testmacro into consideration. Does anybody know why? Also, how would I apply the .arr style to the command or does it just know because the file is located in the same directory as the macro? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: (SOLVED)Runmacro issue
Thanks Misi! Hugo Ruesga P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. Date: Thu, 10 Feb 2011 08:21:17 +0100 From: m...@rrr.se Subject: Re: Runmacro issue To: arslist@ARSLIST.ORG Hi, The problem is the command line argument conversion. You should write the following if you run it at the command prompt: 'Incident Id' = \R2:70032012\ You can also do this via RRR|Chive ;-) C:\rrrchive export.cfg R2:70032012 ### export.cfg ### source_server = myserver source_tcp = 22000 source_user = My User source_password = mypassword target_arx = C:\test.arx multipleforms = Incident Management qual = '1' = %s transfertype = COPY ### export.cfg ### Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Listers - I'm using runmacro utility (on a windows machine) to create an ARX file, but I'm facing an issue: The command I'm using is: C:\Program Files\AR System\Adminrunmacro.exe -o C:\test.arx -x myserver -U My User -P mypassword -f Incident Management -t arx -q 'Incident Id'=R2:70032012 -a 22000 But recurring i've been facing errors on the qualification I've already tried multiple alternatives but I'm stuck rigth now, any help will be highly appreciated Other qualifications i've used: 'Incident Id'=R2:70032012 'Incident Id'=R2:70032012 'Incident Id' = R2:70032012 'Incident Id' = R2:70032012 Incident Id=R2:70032012 ''Incident Id''=R2:70032012 'Incident Id'=R2:70032012 Thanks Hugo Ruesga P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Runmacro issue
I used another utility RunWithoutMacro Utility; that has in addition to RUNMACRO a GUI functionality (.NET) that provide you with precise means of investigating and debugging the problem. The utility posted at: http://communities.bmc.com/communities/docs/DOC-12218 Please be aware that I am not competing BMC-REMEDY Utility they are the ones from whom we learned. Overview: Run-Without-Macro is .NET Window-Utility that allows you to submit modifies, delete or get BMC-REMEDY data without the need to use MACRO. .NET Run-without-Macro (runwomacro) is similar in functionality to the BMC-REMEDY runmacro utility. Run-Without-Macro can be executed for BMC-REMEDY AR3-7.xx using GUI or Batch process. The utility is developed using C# window-tools [rwomacDotNet.exe]. New features have been added to enable a selection of fields and entering their values using a combo box dialogue. In addition to that the utility has been facilitated with drop-down list to select the schema after being extracted from AR-Server using GetList button. You can try it. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hyunkel v2.0 Sent: Thursday, February 10, 2011 4:41 AM To: arslist@ARSLIST.ORG Subject: Runmacro issue ** Listers - I'm using runmacro utility (on a windows machine) to create an ARX file, but I'm facing an issue: The command I'm using is: C:\Program Files\AR System\Adminrunmacro.exe -o C:\test.arx -x myserver -U My User -P mypassword -f Incident Management -t arx -q 'Incident Id'=R2:70032012 -a 22000 But recurring i've been facing errors on the qualification I've already tried multiple alternatives but I'm stuck rigth now, any help will be highly appreciated Other qualifications i've used: 'Incident Id'=R2:70032012 'Incident Id'=R2:70032012 'Incident Id' = R2:70032012 'Incident Id' = R2:70032012 Incident Id=R2:70032012 ''Incident Id''=R2:70032012 'Incident Id'=R2:70032012 Thanks Hugo Ruesga P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Runmacro issue
Listers - I'm using runmacro utility (on a windows machine) to create an ARX file, but I'm facing an issue: The command I'm using is: C:\Program Files\AR System\Adminrunmacro.exe -o C:\test.arx -x myserver -U My User -P mypassword -f Incident Management -t arx -q 'Incident Id'=R2:70032012 -a 22000 But recurring i've been facing errors on the qualification I've already tried multiple alternatives but I'm stuck rigth now, any help will be highly appreciated Other qualifications i've used: 'Incident Id'=R2:70032012 'Incident Id'=R2:70032012 'Incident Id' = R2:70032012 'Incident Id' = R2:70032012 Incident Id=R2:70032012 ''Incident Id''=R2:70032012 'Incident Id'=R2:70032012 Thanks Hugo Ruesga P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Runmacro issue
Hi, The problem is the command line argument conversion. You should write the following if you run it at the command prompt: 'Incident Id' = \R2:70032012\ You can also do this via RRR|Chive ;-) C:\rrrchive export.cfg R2:70032012 ### export.cfg ### source_server = myserver source_tcp = 22000 source_user = My User source_password = mypassword target_arx = C:\test.arx multipleforms = Incident Management qual= '1' = %s transfertype= COPY ### export.cfg ### Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Listers - I'm using runmacro utility (on a windows machine) to create an ARX file, but I'm facing an issue: The command I'm using is: C:\Program Files\AR System\Adminrunmacro.exe -o C:\test.arx -x myserver -U My User -P mypassword -f Incident Management -t arx -q 'Incident Id'=R2:70032012 -a 22000 But recurring i've been facing errors on the qualification I've already tried multiple alternatives but I'm stuck rigth now, any help will be highly appreciated Other qualifications i've used: 'Incident Id'=R2:70032012 'Incident Id'=R2:70032012 'Incident Id' = R2:70032012 'Incident Id' = R2:70032012 Incident Id=R2:70032012 ''Incident Id''=R2:70032012 'Incident Id'=R2:70032012 Thanks Hugo Ruesga P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
RunMacro List of Fields
I am trying to create a weekly report using the runmacro utility with a cronjob. The issue that I am running into is that the dump shows all the fields of a form, is there a way to limit what fields get displayed? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: RunMacro List of Fields
Howard, You need to create a macro which has the required qualification and the fields required. You need to select the fields you require in the report style and save the reporting format in the home folder. All this has to be done while recording the macro. Regards Rajesh -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Howard Sent: Friday, October 08, 2010 4:50 AM To: arslist@ARSLIST.ORG Subject: RunMacro List of Fields I am trying to create a weekly report using the runmacro utility with a cronjob. The issue that I am running into is that the dump shows all the fields of a form, is there a way to limit what fields get displayed? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are Important notice: This e-mail and any attachment there to contains corporate proprietary information. If you have received it by mistake, please notify us immediately by reply e-mail and delete this e-mail and its attachments from your system. Thank You. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: RunMacro List of Fields
Howard, Create a join form or a view form of the original form, with only the fields you want to report from.. Report from that join or view form.. Joe -- From: Howard how...@homesteadbound.com Sent: Thursday, October 07, 2010 7:19 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: RunMacro List of Fields I am trying to create a weekly report using the runmacro utility with a cronjob. The issue that I am running into is that the dump shows all the fields of a form, is there a way to limit what fields get displayed? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Fw: RunMacro List of Fields
Howard, Looks like my previous attempt to post a response to this got rejected from the list so here it is again.. If it did make it to the list I apologize, I got a rejection alert a few seconds after the distribution alert.. Cheers Joe -- From: Joe Martin D'Souza jdso...@shyle.net Sent: Thursday, October 14, 2010 12:43 PM To: arslist@ARSLIST.ORG Subject: Re: RunMacro List of Fields Howard, Create a join form or a view form of the original form, with only the fields you want to report from.. Report from that join or view form.. Joe -- From: Howard how...@homesteadbound.com Sent: Thursday, October 07, 2010 7:19 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: RunMacro List of Fields I am trying to create a weekly report using the runmacro utility with a cronjob. The issue that I am running into is that the dump shows all the fields of a form, is there a way to limit what fields get displayed? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
RUNMACRO ARS
Hi, I am trying to run runmacro on server side... it is running fine but i was wondering is there any option available through which i can append the export data to an existing file in output directory. currently i am using following command. time runmacro -x Server Name -U User Name -P Password -o OUTPUT file name -f form name -q qualification is there any option to append exported data to the same output file genrated previously? thanks a lot in advance. Peeyush -- View this message in context: http://old.nabble.com/RUNMACRO-ARS-tp29941854p29941854.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Weekly report using Runmacro
Howard, Out of curiosity, what was your qualification? Maybe the way the qualification was written might have made the ARS return the whole set of records? Joe -- From: Howard how...@homesteadbound.com Sent: Thursday, September 23, 2010 11:30 PM To: arsl...@listserv.rbugs.com; Joe DeSouza jdso...@shyle.net Cc: Howard Cheung how...@homesteadbound.com Subject: Re: Weekly report using Runmacro Hi Joe, Yes, that would be a workaround but I plan on creating several different reports using this method and it would be better if I could get this to work. I also tried using the -q flag to set the qualification but wasn't able to get it working this way either. Did anybody else experienced this before? Any suggestions would be greatly appreciated. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Weekly report using Runmacro
We are doing the same thing like running report every for night etc as per the
requirement
We create a macro and made it run through windows scheduler
Its written something like this
D:
cd D:\Program Files\AR System
runmacro -x serveranme -h C:\Documents and Settings\Administrator\Application
Data\AR System\Home\ARCmds -e macroname -U username -P password
D:
cd the path where you need to store the result
for /f Tokens=1-4 Delims=/ %%i in ('date /t') do set dt=%%k%%j%%l
for /f Tokens=1 %%i in ('time /t') do set tm=-%%i
set tm=%tm::=.%
set dtt=%dt%%tm%
exit
hope this can help you
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Howard
Sent: Friday, September 24, 2010 5:27 AM
To: arslist@ARSLIST.ORG
Subject: Weekly report using Runmacro
I am trying to generate a weekly report in a CSV format and want to use
the server runmacro utility to accomplish this. When I try to run the
following in the command line:
/u01/app/bmc/v55/bin/runmacro -d /u01/app/bmc/ -o /u01/app/bmc/macro -x
testserver -e testmacro -U user -P password -f formName -t csv
I do get a CSV file as the output, however, the file contains all the
records from the formName and it doesn't take the qualification in
my testmacro into consideration. Does anybody know why?
Also, how would I apply the .arr style to the command or does it just
know because the file is located in the same directory as the macro?
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Important notice: This e-mail and any attachment there to contains corporate
proprietary information. If you have received it by mistake, please notify us
immediately by reply e-mail and delete this e-mail and its attachments from
your system.
Thank You.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Weekly report using Runmacro
I am trying to generate a weekly report in a CSV format and want to use the server runmacro utility to accomplish this. When I try to run the following in the command line: /u01/app/bmc/v55/bin/runmacro -d /u01/app/bmc/ -o /u01/app/bmc/macro -x testserver -e testmacro -U user -P password -f formName -t csv I do get a CSV file as the output, however, the file contains all the records from the formName and it doesn't take the qualification in my testmacro into consideration. Does anybody know why? Also, how would I apply the .arr style to the command or does it just know because the file is located in the same directory as the macro? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Weekly report using Runmacro
Howard, I can't imagine why its doing that, but as a workaround you could do the same thing to a form view, that pulls a view of the same form with the qualification defined in the creation of that view.. CREATE VIEW ReportView AS SELECT Col1, Col2, etc FROM Form WHERE the qualification; Then create a view form against that view... Create a macro to report from that view form. So since the macro runs a report across the form ignoring the qualification, you wouldn't care here as the view restricts the records to that qualification anyways... Joe -- From: Howard how...@homesteadbound.com Sent: Thursday, September 23, 2010 7:57 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Weekly report using Runmacro I am trying to generate a weekly report in a CSV format and want to use the server runmacro utility to accomplish this. When I try to run the following in the command line: /u01/app/bmc/v55/bin/runmacro -d /u01/app/bmc/ -o /u01/app/bmc/macro -x testserver -e testmacro -U user -P password -f formName -t csv I do get a CSV file as the output, however, the file contains all the records from the formName and it doesn't take the qualification in my testmacro into consideration. Does anybody know why? Also, how would I apply the .arr style to the command or does it just know because the file is located in the same directory as the macro? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Weekly report using Runmacro
Hi Joe, Yes, that would be a workaround but I plan on creating several different reports using this method and it would be better if I could get this to work. I also tried using the -q flag to set the qualification but wasn't able to get it working this way either. Did anybody else experienced this before? Any suggestions would be greatly appreciated. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Runmacro - UNIX Server Group
Hi Listers; Does anybody has experienced issues with runmacro command on an ARS Server Group? I have to ARS Servers one with NAT address and the other one without NAT; both servers are managed due a Load Balancer, but before i installed the second ARS Server the script with the call for a submit action using runmacro utility was working fine, but now it doesn't work; I'm trying to figure why this could happen, or how can i perform a troubleshooting on this. Best Regards Hugo Ruesga US 972.577.7000 MX +52 (33) 3332.3868 P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. _ Prefiero un día sin coche que sin Messenger www.vivirmessenger.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Runmacro issue (RESOLVED)
Thanks every you! Actually the macro was fine, and also the call for runmacro command on unix also was working fine. Some hints in case you face something like this: 1.- If you generate the macro with the Windows client, and then you upload the macro to an UNIX server (binary call, not using UNIX client), upload as text only, since the format is different, this could make your macro fail. 2.- There some actions or fields that your macro WON'T push into remedy, like Attachment fields. Thanks everybody and have a nice weekend. Hugo Ruesga perotsystems® US 972.577.7000 MX +52 (33) 3332.3868 P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. Date: Thu, 7 Jan 2010 21:20:36 -0800 From: mahendra.mahal...@gmail.com Subject: Re: Runmacro issue To: arslist@ARSLIST.ORG Hi Hugo, Can I have the details related to the unix shell, how you are running the mocro ? I am quite doubtful as remedy doesn;t support the unix client ? Cheers, Mahendra Mahalkar On Jan 7, 12:52 am, Hyunkel v2.0 lord_dyna...@hotmail.com wrote: I'm trying to generate a macro to create a new record on an specific form, I'm performing this via Unix shell, I'm seeing the runmacro process being triggered by the script and no error code is returned, but I'm not seeing any record created on the ARS side... This is what I have on my macro push Set-schema: HR_FIT_MACRO delldevopas Submit: HR_FIT_MACRO delldevopas| 8=Default submit value 7=0 4=Hugo Ruesga 2=Hugo Ruesga end It's very simple, but i don't have any idea why the record is not being created. Any help will be greatly appreciated. Hugo Ruesga perotsystems® US972.577.7000972.577.7000 MX +52 (33) 3332.3868+52 (33) 3332.3868 P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. _ Juega y gana con Samsung y Windows Livehttp://www.equipatucasa.com.mx ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are _ Compra seguro con Otto http://www.ie8.com.mx ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Runmacro issue
Any login information within the macro? From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Hyunkel v2.0 Sent: Wednesday, January 06, 2010 2:53 PM To: arslist@ARSLIST.ORG Subject: Runmacro issue ** I'm trying to generate a macro to create a new record on an specific form, I'm performing this via Unix shell, I'm seeing the runmacro process being triggered by the script and no error code is returned, but I'm not seeing any record created on the ARS side... This is what I have on my macro push Set-schema: HR_FIT_MACRO delldevopas Submit: HR_FIT_MACRO delldevopas| 8=Default submit value 7=0 4=Hugo Ruesga 2=Hugo Ruesga end It's very simple, but i don't have any idea why the record is not being created. Any help will be greatly appreciated. Hugo Ruesga perotsystems® US 972.577.7000 MX +52 (33) 3332.3868 P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. Windows 7 te la pone aún más fácil a ti, que eres estudiantehttp://www.windows7paraestudiantes.com.mx _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Runmacro issue
You may want to consider using arimportcmd (command-line import utility). Your script creates the input file. You can use arguments or a pre-built map file for field mappings. Most important, you can specify a log file to record the execution - normal termination, errors, whatever. Depending on the error that you got, there may be something in your Remedy server error log. Mike White EMail michael.wh...@verizon.com Office 813.978.2192 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Shellman, David Sent: Thursday, January 07, 2010 8:38 AM To: arslist@ARSLIST.ORG Subject: Re: Runmacro issue ** Any login information within the macro? From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Hyunkel v2.0 Sent: Wednesday, January 06, 2010 2:53 PM To: arslist@ARSLIST.ORG Subject: Runmacro issue ** I'm trying to generate a macro to create a new record on an specific form, I'm performing this via Unix shell, I'm seeing the runmacro process being triggered by the script and no error code is returned, but I'm not seeing any record created on the ARS side... This is what I have on my macro push Set-schema: HR_FIT_MACRO delldevopas Submit: HR_FIT_MACRO delldevopas| 8=Default submit value 7=0 4=Hugo Ruesga 2=Hugo Ruesga end It's very simple, but i don't have any idea why the record is not being created. Any help will be greatly appreciated. Hugo Ruesga perotsystems® US 972.577.7000 MX +52 (33) 3332.3868 P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. Windows 7 te la pone aún más fácil a ti, que eres estudiante http://www.windows7paraestudiantes.com.mx _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Runmacro issue
Hi Hugo, Can I have the details related to the unix shell, how you are running the mocro ? I am quite doubtful as remedy doesn;t support the unix client ? Cheers, Mahendra Mahalkar On Jan 7, 12:52 am, Hyunkel v2.0 lord_dyna...@hotmail.com wrote: I'm trying to generate a macro to create a new record on an specific form, I'm performing this via Unix shell, I'm seeing the runmacro process being triggered by the script and no error code is returned, but I'm not seeing any record created on the ARS side... This is what I have on my macro push Set-schema: HR_FIT_MACRO delldevopas Submit: HR_FIT_MACRO delldevopas| 8=Default submit value 7=0 4=Hugo Ruesga 2=Hugo Ruesga end It's very simple, but i don't have any idea why the record is not being created. Any help will be greatly appreciated. Hugo Ruesga perotsystems® US972.577.7000972.577.7000 MX +52 (33) 3332.3868+52 (33) 3332.3868 P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. _ Juega y gana con Samsung y Windows Livehttp://www.equipatucasa.com.mx ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Runmacro issue
I'm trying to generate a macro to create a new record on an specific form, I'm performing this via Unix shell, I'm seeing the runmacro process being triggered by the script and no error code is returned, but I'm not seeing any record created on the ARS side... This is what I have on my macro push Set-schema: HR_FIT_MACRO delldevopas Submit: HR_FIT_MACRO delldevopas| 8=Default submit value 7=0 4=Hugo Ruesga 2=Hugo Ruesga end It's very simple, but i don't have any idea why the record is not being created. Any help will be greatly appreciated. Hugo Ruesga perotsystems® US 972.577.7000 MX +52 (33) 3332.3868 P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. _ Juega y gana con Samsung y Windows Live http://www.equipatucasa.com.mx ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Need Help with syntax for Runmacro from escalation, works from dos cmd:RESOLVED
Thank you all so much for helping me resolve this issue, I did use quotes around the path and also I had to place the report in a file where everyone had permission. Now I have automated report running!!! Thanks! Manjari R. Shrestha Programmer Analyst SAIC 12530 Parklawn Drive, Suite 350 Rockville, MD 20852 Office: (301) 998-7364 ranj...@saic.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Tuesday, February 17, 2009 1:31 PM To: arslist@ARSLIST.ORG Subject: Re: Need Help with syntax for Runmacro from escalation, works from dos cmd Try putting quotes around all arguments that have spaces in them. Otherwise it will treat those arguments as multiple separate arguments rather than one argument with a space in it: C:\Program Files\AR System\runmacro.exe -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Shrestha, Manjari R. Sent: Thursday, February 05, 2009 9:40 AM To: arslist@ARSLIST.ORG Subject: Need Help with syntax for Runmacro from escalation, works from dos cmd ** Hi, I am able to run the following command from cmd prompt: C:\Program Files\AR System\runmacro.exe -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password However when I try the same syntax from an escalation through Run Process, it does not work. I am using the following syntax in RUN PROCESS: C:\Program Files\AR System\runmacro.exe -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password Thanks in advance. Manjari R. Shrestha Programmer Analyst SAIC 12530 Parklawn Drive, Suite 350 Rockville, MD 20852 Office: (301) 998-7364 ranj...@saic.com __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are image001.jpg
Re: Need Help with syntax for Runmacro from escalation, works from dos cmd
Try putting quotes around all arguments that have spaces in them. Otherwise it will treat those arguments as multiple separate arguments rather than one argument with a space in it: C:\Program Files\AR System\runmacro.exe -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Shrestha, Manjari R. Sent: Thursday, February 05, 2009 9:40 AM To: arslist@ARSLIST.ORG Subject: Need Help with syntax for Runmacro from escalation, works from dos cmd ** Hi, I am able to run the following command from cmd prompt: C:\Program Files\AR System\runmacro.exe -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password However when I try the same syntax from an escalation through Run Process, it does not work. I am using the following syntax in RUN PROCESS: C:\Program Files\AR System\runmacro.exe -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password Thanks in advance. Manjari R. Shrestha Programmer Analyst SAIC 12530 Parklawn Drive, Suite 350 Rockville, MD 20852 Office: (301) 998-7364 ranj...@saic.commailto:ranj...@saic.com __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are inline: image001.jpg
Re: Need Help with syntax for Runmacro from escalation, works from dos cmd
Manjari, I am running a macro via an escalation but my command syntax is a little different from yours. First off, I don't use the -h (home directory), instead I'm using the -d (macro directory). Also, I have the directory enclosed in double quotes. And, the path I'm using definitely doesn't have any security on it. All Users shouldn't, but you never know. I'm using C:\Program Files\AR System\Macros (on the server, of course). Another difference is that I'm using the -e to provide the name of the macro as opposed to the -i, not sure how they differ. Manual doesn't explain, so it's probably nothing. Good luck and hope something here might help. Curt Curt A. Schryver Action Request System Administrator Tyco Electronics 100 AMP Drive MS 161-043 Harrisburg, PA 17105 717-810-2109 tel 717-810-2124 fax cschry...@tycoelectronics.com From: Shrestha, Manjari R. manjari.r.shres...@saic.com Subject: Need Help with syntax for Runmacro from escalation, works from dos cmd To: arslist@ARSLIST.ORG Date: Thursday, February 5, 2009, 4:40 PM ** Hi, I am able to run the following command from cmd prompt: C:\Program Files\AR System\runmacro.exe -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password However when I try the same syntax from an escalation through Run Process, it does not work. I am using the following syntax in RUN PROCESS: C:\Program Files\AR System\runmacro.exe -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password Thanks in advance. Manjari R. Shrestha Programmer Analyst SAIC 12530 Parklawn Drive, Suite 350 Rockville, MD 20852 Office: (301) 998-7364 ranj...@saic.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Need Help with syntax for Runmacro from escalation, works from dos cmd
Thank you all for replying. From the escalation log I see that the escalation is running but it is not creating the output files, I am thinking that this might be something to do with permissions, as the user that will be writing the file looks like AR_ESCALATER, and that user will not have in our Network. I am thinking I will need to create the Output file within a folder where Remedy will have permission to write. Thanks! Manjari R. Shrestha Programmer Analyst SAIC 12530 Parklawn Drive, Suite 350 Rockville, MD 20852 Office: (301) 998-7364 ranj...@saic.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ron Gehring Sent: Thursday, February 05, 2009 3:13 PM To: arslist@ARSLIST.ORG Subject: Re: Need Help with syntax for Runmacro from escalation, works from dos cmd Here's something to try, put cmd /c before the statement like so: cmd /c C:\Program Files\AR System\runmacro.exe -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password Ron Gehring -Original Message- From: Mark Lev [mailto:mark@rightstarsystems.com] Sent: Thursday, February 05, 2009 2:58 PM To: arslist@ARSLIST.ORG Subject: Re: Need Help with syntax for Runmacro from escalation, works from dos cmd Without the aid of error message, I would suggest a few trial and error experiments, if you will. What about changing the path names in the escalation to the windows short names. (DIR /X will give you short name in cmd window) Program Files -- progra~1 for example. Perhaps it's a translation error in the CMD process. Mark From: Action Request System discussion list(ARSList) on behalf of Shrestha, Manjari R. Sent: Thu 2/5/2009 2:31 PM To: arslist@ARSLIST.ORG Subject: Re: Need Help with syntax for Runmacro from escalation, works from dos cmd Hello Mark and Joe, Thanks for your reply. I am trying to run the macro from an escalation. I copied the macro file to the server and I can again run the command from the prompt successfully but when I use this in escalation it does not do anything, there is no error messages either. Yikes! Thanks! Manjari R. Shrestha Programmer Analyst SAIC 12530 Parklawn Drive, Suite 350 Rockville, MD 20852 Office: (301) 998-7364 ranj...@saic.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mark Lev Sent: Thursday, February 05, 2009 12:06 PM To: arslist@ARSLIST.ORG Subject: Re: Need Help with syntax for Runmacro from escalation, works from dos cmd Are you running the cmd line version on the server or desktop? The escalation will run on server, so the C: in escalation is referring to server c: not local c: You may need to move the macro to the server and adjust path accordingly where Remedy has permissions to. Thanks, Mark Mark Lev Sr. Systems Consultant 703-672-4390 732-859-5827 (cell) mark@rightstarsystems.com --- RightStar Systems, Inc. 100 East Street SE, Suite 202 Vienna, VA 22180 USA --- From: Action Request System discussion list(ARSList) on behalf of Shrestha, Manjari R. Sent: Thu 2/5/2009 11:40 AM To: arslist@ARSLIST.ORG Subject: Need Help with syntax for Runmacro from escalation, works from dos cmd ** https://owa.mailstreet2003.net/exchange/mark.levrightstarsystems.com/Dr afts/image001.jpg Hi, I am able to run the following command from cmd prompt: C:\Program Files\AR System\runmacro.exe -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password However when I try the same syntax from an escalation through Run Process, it does not work. I am using the following syntax in RUN PROCESS: C:\Program Files\AR System\runmacro.exe -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password Thanks in advance. Manjari R. Shrestha Programmer Analyst SAIC 12530 Parklawn Drive, Suite 350 Rockville, MD 20852 Office: (301) 998-7364 ranj...@saic.com __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where
Re: Need Help with syntax for Runmacro from escalation, works from dos cmd
AR_ESCALATOR is the user within Remedy, but the filesystem permissions you need are the ones that Remedy is running as on your box, so if your Remedy is running as 'Local System', you can change it to an actual user and have that user have permissions to a network location. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Shrestha, Manjari R. Sent: Friday, February 06, 2009 8:11 AM To: arslist@ARSLIST.ORG Subject: Re: Need Help with syntax for Runmacro from escalation, works from dos cmd Thank you all for replying. From the escalation log I see that the escalation is running but it is not creating the output files, I am thinking that this might be something to do with permissions, as the user that will be writing the file looks like AR_ESCALATER, and that user will not have in our Network. I am thinking I will need to create the Output file within a folder where Remedy will have permission to write. Thanks! Manjari R. Shrestha Programmer Analyst SAIC 12530 Parklawn Drive, Suite 350 Rockville, MD 20852 Office: (301) 998-7364 ranj...@saic.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ron Gehring Sent: Thursday, February 05, 2009 3:13 PM To: arslist@ARSLIST.ORG Subject: Re: Need Help with syntax for Runmacro from escalation, works from dos cmd Here's something to try, put cmd /c before the statement like so: cmd /c C:\Program Files\AR System\runmacro.exe -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password Ron Gehring -Original Message- From: Mark Lev [mailto:mark@rightstarsystems.com] Sent: Thursday, February 05, 2009 2:58 PM To: arslist@ARSLIST.ORG Subject: Re: Need Help with syntax for Runmacro from escalation, works from dos cmd Without the aid of error message, I would suggest a few trial and error experiments, if you will. What about changing the path names in the escalation to the windows short names. (DIR /X will give you short name in cmd window) Program Files -- progra~1 for example. Perhaps it's a translation error in the CMD process. Mark From: Action Request System discussion list(ARSList) on behalf of Shrestha, Manjari R. Sent: Thu 2/5/2009 2:31 PM To: arslist@ARSLIST.ORG Subject: Re: Need Help with syntax for Runmacro from escalation, works from dos cmd Hello Mark and Joe, Thanks for your reply. I am trying to run the macro from an escalation. I copied the macro file to the server and I can again run the command from the prompt successfully but when I use this in escalation it does not do anything, there is no error messages either. Yikes! Thanks! Manjari R. Shrestha Programmer Analyst SAIC 12530 Parklawn Drive, Suite 350 Rockville, MD 20852 Office: (301) 998-7364 ranj...@saic.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mark Lev Sent: Thursday, February 05, 2009 12:06 PM To: arslist@ARSLIST.ORG Subject: Re: Need Help with syntax for Runmacro from escalation, works from dos cmd Are you running the cmd line version on the server or desktop? The escalation will run on server, so the C: in escalation is referring to server c: not local c: You may need to move the macro to the server and adjust path accordingly where Remedy has permissions to. Thanks, Mark Mark Lev Sr. Systems Consultant 703-672-4390 732-859-5827 (cell) mark@rightstarsystems.com --- RightStar Systems, Inc. 100 East Street SE, Suite 202 Vienna, VA 22180 USA --- From: Action Request System discussion list(ARSList) on behalf of Shrestha, Manjari R. Sent: Thu 2/5/2009 11:40 AM To: arslist@ARSLIST.ORG Subject: Need Help with syntax for Runmacro from escalation, works from dos cmd ** https://owa.mailstreet2003.net/exchange/mark.levrightstarsystems.com/Dr afts/image001.jpg Hi, I am able to run the following command from cmd prompt: C:\Program Files\AR System\runmacro.exe -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password However when I try the same syntax from an escalation through Run Process, it does not work. I am using the following syntax in RUN PROCESS: C:\Program Files\AR System\runmacro.exe -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password Thanks in advance. Manjari R. Shrestha Programmer Analyst SAIC 12530 Parklawn Drive, Suite 350 Rockville, MD 20852 Office: (301) 998-7364 ranj...@saic.com __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___
Need Help with syntax for Runmacro from escalation, works from dos cmd
Hi, I am able to run the following command from cmd prompt: C:\Program Files\AR System\runmacro.exe -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password However when I try the same syntax from an escalation through Run Process, it does not work. I am using the following syntax in RUN PROCESS: C:\Program Files\AR System\runmacro.exe -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password Thanks in advance. Manjari R. Shrestha Programmer Analyst SAIC 12530 Parklawn Drive, Suite 350 Rockville, MD 20852 Office: (301) 998-7364 ranj...@saic.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are image001.jpg
Re: Need Help with syntax for Runmacro from escalation, works from dos cmd
Are you running the cmd line version on the server or desktop? The escalation will run on server, so the C: in escalation is referring to server c: not local c: You may need to move the macro to the server and adjust path accordingly where Remedy has permissions to. Thanks, Mark Mark Lev Sr. Systems Consultant 703-672-4390 732-859-5827 (cell) mark@rightstarsystems.com --- RightStar Systems, Inc. 100 East Street SE, Suite 202 Vienna, VA 22180 USA --- From: Action Request System discussion list(ARSList) on behalf of Shrestha, Manjari R. Sent: Thu 2/5/2009 11:40 AM To: arslist@ARSLIST.ORG Subject: Need Help with syntax for Runmacro from escalation, works from dos cmd ** https://owa.mailstreet2003.net/exchange/mark.levrightstarsystems.com/Drafts/image001.jpg Hi, I am able to run the following command from cmd prompt: C:\Program Files\AR System\runmacro.exe -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password However when I try the same syntax from an escalation through Run Process, it does not work. I am using the following syntax in RUN PROCESS: C:\Program Files\AR System\runmacro.exe -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password Thanks in advance. Manjari R. Shrestha Programmer Analyst SAIC 12530 Parklawn Drive, Suite 350 Rockville, MD 20852 Office: (301) 998-7364 ranj...@saic.com __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Need Help with syntax for Runmacro from escalation, works from dos cmd
** I'm assuming the path is the same for all the users if you are using this in an Active Link? Try using the 8.3 format in the DOS path Joe From: "Shrestha, Manjari R." manjari.r.shres...@saic.comTo: arslist@ARSLIST.ORGSent: Thursday, February 5, 2009 11:40:03 AMSubject: Need Help with syntax for Runmacro from escalation, works from dos cmd** Hi, I am able to run the following command from cmd prompt: “C:\Program Files\AR System\runmacro.exe" -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password However when I try the same syntax from an escalation through Run Process, it does not work. I am using the following syntax in RUN PROCESS: “C:\Program Files\AR System\runmacro.exe" -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password Thanks in advance. Manjari R. Shrestha Programmer Analyst SAIC 12530 Parklawn Drive, Suite 350 Rockville, MD 20852 Office: (301) 998-7364 ranj...@saic.com __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___
Re: Need Help with syntax for Runmacro from escalation, works from dos cmd
Hello Mark and Joe, Thanks for your reply. I am trying to run the macro from an escalation. I copied the macro file to the server and I can again run the command from the prompt successfully but when I use this in escalation it does not do anything, there is no error messages either. Yikes! Thanks! Manjari R. Shrestha Programmer Analyst SAIC 12530 Parklawn Drive, Suite 350 Rockville, MD 20852 Office: (301) 998-7364 ranj...@saic.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mark Lev Sent: Thursday, February 05, 2009 12:06 PM To: arslist@ARSLIST.ORG Subject: Re: Need Help with syntax for Runmacro from escalation, works from dos cmd Are you running the cmd line version on the server or desktop? The escalation will run on server, so the C: in escalation is referring to server c: not local c: You may need to move the macro to the server and adjust path accordingly where Remedy has permissions to. Thanks, Mark Mark Lev Sr. Systems Consultant 703-672-4390 732-859-5827 (cell) mark@rightstarsystems.com --- RightStar Systems, Inc. 100 East Street SE, Suite 202 Vienna, VA 22180 USA --- From: Action Request System discussion list(ARSList) on behalf of Shrestha, Manjari R. Sent: Thu 2/5/2009 11:40 AM To: arslist@ARSLIST.ORG Subject: Need Help with syntax for Runmacro from escalation, works from dos cmd ** https://owa.mailstreet2003.net/exchange/mark.levrightstarsystems.com/Dr afts/image001.jpg Hi, I am able to run the following command from cmd prompt: C:\Program Files\AR System\runmacro.exe -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password However when I try the same syntax from an escalation through Run Process, it does not work. I am using the following syntax in RUN PROCESS: C:\Program Files\AR System\runmacro.exe -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password Thanks in advance. Manjari R. Shrestha Programmer Analyst SAIC 12530 Parklawn Drive, Suite 350 Rockville, MD 20852 Office: (301) 998-7364 ranj...@saic.com __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Need Help with syntax for Runmacro from escalation, works from dos cmd
I do something similar, but I put it in a batch file (*.bat) and then my escalation does a run process like this E:\Batch\Vendors.bat Doug -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Shrestha, Manjari R. Sent: Thursday, February 05, 2009 2:32 PM To: arslist@ARSLIST.ORG Subject: Re: Need Help with syntax for Runmacro from escalation, works from dos cmd Hello Mark and Joe, Thanks for your reply. I am trying to run the macro from an escalation. I copied the macro file to the server and I can again run the command from the prompt successfully but when I use this in escalation it does not do anything, there is no error messages either. Yikes! Thanks! Manjari R. Shrestha Programmer Analyst SAIC 12530 Parklawn Drive, Suite 350 Rockville, MD 20852 Office: (301) 998-7364 ranj...@saic.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mark Lev Sent: Thursday, February 05, 2009 12:06 PM To: arslist@ARSLIST.ORG Subject: Re: Need Help with syntax for Runmacro from escalation, works from dos cmd Are you running the cmd line version on the server or desktop? The escalation will run on server, so the C: in escalation is referring to server c: not local c: You may need to move the macro to the server and adjust path accordingly where Remedy has permissions to. Thanks, Mark Mark Lev Sr. Systems Consultant 703-672-4390 732-859-5827 (cell) mark@rightstarsystems.com --- RightStar Systems, Inc. 100 East Street SE, Suite 202 Vienna, VA 22180 USA --- From: Action Request System discussion list(ARSList) on behalf of Shrestha, Manjari R. Sent: Thu 2/5/2009 11:40 AM To: arslist@ARSLIST.ORG Subject: Need Help with syntax for Runmacro from escalation, works from dos cmd ** https://owa.mailstreet2003.net/exchange/mark.levrightstarsystems.com/Dr afts/image001.jpg Hi, I am able to run the following command from cmd prompt: C:\Program Files\AR System\runmacro.exe -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password However when I try the same syntax from an escalation through Run Process, it does not work. I am using the following syntax in RUN PROCESS: C:\Program Files\AR System\runmacro.exe -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password Thanks in advance. Manjari R. Shrestha Programmer Analyst SAIC 12530 Parklawn Drive, Suite 350 Rockville, MD 20852 Office: (301) 998-7364 ranj...@saic.com __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are DISCLAIMER Important! This message is intended for the above named person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient of this e-mail and have received it in error, please immediately notify the sender by return email and then delete it from your mailbox. This message may be protected by the attorney-client privilege and/or work product doctrine. Accessing, copying, disseminating or re-using any of the information contained in this e-mail by anyone other than the intended recipient is strictly prohibited. Finally, you should check this email and any attachments for the presence of viruses, as the sender accepts no liability for any damage caused by any virus transmitted by this email. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Need Help with syntax for Runmacro from escalation, works from dos cmd
Without the aid of error message, I would suggest a few trial and error experiments, if you will. What about changing the path names in the escalation to the windows short names. (DIR /X will give you short name in cmd window) Program Files -- progra~1 for example. Perhaps it's a translation error in the CMD process. Mark From: Action Request System discussion list(ARSList) on behalf of Shrestha, Manjari R. Sent: Thu 2/5/2009 2:31 PM To: arslist@ARSLIST.ORG Subject: Re: Need Help with syntax for Runmacro from escalation, works from dos cmd Hello Mark and Joe, Thanks for your reply. I am trying to run the macro from an escalation. I copied the macro file to the server and I can again run the command from the prompt successfully but when I use this in escalation it does not do anything, there is no error messages either. Yikes! Thanks! Manjari R. Shrestha Programmer Analyst SAIC 12530 Parklawn Drive, Suite 350 Rockville, MD 20852 Office: (301) 998-7364 ranj...@saic.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mark Lev Sent: Thursday, February 05, 2009 12:06 PM To: arslist@ARSLIST.ORG Subject: Re: Need Help with syntax for Runmacro from escalation, works from dos cmd Are you running the cmd line version on the server or desktop? The escalation will run on server, so the C: in escalation is referring to server c: not local c: You may need to move the macro to the server and adjust path accordingly where Remedy has permissions to. Thanks, Mark Mark Lev Sr. Systems Consultant 703-672-4390 732-859-5827 (cell) mark@rightstarsystems.com --- RightStar Systems, Inc. 100 East Street SE, Suite 202 Vienna, VA 22180 USA --- From: Action Request System discussion list(ARSList) on behalf of Shrestha, Manjari R. Sent: Thu 2/5/2009 11:40 AM To: arslist@ARSLIST.ORG Subject: Need Help with syntax for Runmacro from escalation, works from dos cmd ** https://owa.mailstreet2003.net/exchange/mark.levrightstarsystems.com/Dr afts/image001.jpg Hi, I am able to run the following command from cmd prompt: C:\Program Files\AR System\runmacro.exe -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password However when I try the same syntax from an escalation through Run Process, it does not work. I am using the following syntax in RUN PROCESS: C:\Program Files\AR System\runmacro.exe -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password Thanks in advance. Manjari R. Shrestha Programmer Analyst SAIC 12530 Parklawn Drive, Suite 350 Rockville, MD 20852 Office: (301) 998-7364 ranj...@saic.com __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Need Help with syntax for Runmacro from escalation, works from dos cmd
Here's something to try, put cmd /c before the statement like so: cmd /c C:\Program Files\AR System\runmacro.exe -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password Ron Gehring -Original Message- From: Mark Lev [mailto:mark@rightstarsystems.com] Sent: Thursday, February 05, 2009 2:58 PM To: arslist@ARSLIST.ORG Subject: Re: Need Help with syntax for Runmacro from escalation, works from dos cmd Without the aid of error message, I would suggest a few trial and error experiments, if you will. What about changing the path names in the escalation to the windows short names. (DIR /X will give you short name in cmd window) Program Files -- progra~1 for example. Perhaps it's a translation error in the CMD process. Mark From: Action Request System discussion list(ARSList) on behalf of Shrestha, Manjari R. Sent: Thu 2/5/2009 2:31 PM To: arslist@ARSLIST.ORG Subject: Re: Need Help with syntax for Runmacro from escalation, works from dos cmd Hello Mark and Joe, Thanks for your reply. I am trying to run the macro from an escalation. I copied the macro file to the server and I can again run the command from the prompt successfully but when I use this in escalation it does not do anything, there is no error messages either. Yikes! Thanks! Manjari R. Shrestha Programmer Analyst SAIC 12530 Parklawn Drive, Suite 350 Rockville, MD 20852 Office: (301) 998-7364 ranj...@saic.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mark Lev Sent: Thursday, February 05, 2009 12:06 PM To: arslist@ARSLIST.ORG Subject: Re: Need Help with syntax for Runmacro from escalation, works from dos cmd Are you running the cmd line version on the server or desktop? The escalation will run on server, so the C: in escalation is referring to server c: not local c: You may need to move the macro to the server and adjust path accordingly where Remedy has permissions to. Thanks, Mark Mark Lev Sr. Systems Consultant 703-672-4390 732-859-5827 (cell) mark@rightstarsystems.com --- RightStar Systems, Inc. 100 East Street SE, Suite 202 Vienna, VA 22180 USA --- From: Action Request System discussion list(ARSList) on behalf of Shrestha, Manjari R. Sent: Thu 2/5/2009 11:40 AM To: arslist@ARSLIST.ORG Subject: Need Help with syntax for Runmacro from escalation, works from dos cmd ** https://owa.mailstreet2003.net/exchange/mark.levrightstarsystems.com/Dr afts/image001.jpg Hi, I am able to run the following command from cmd prompt: C:\Program Files\AR System\runmacro.exe -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password However when I try the same syntax from an escalation through Run Process, it does not work. I am using the following syntax in RUN PROCESS: C:\Program Files\AR System\runmacro.exe -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password Thanks in advance. Manjari R. Shrestha Programmer Analyst SAIC 12530 Parklawn Drive, Suite 350 Rockville, MD 20852 Office: (301) 998-7364 ranj...@saic.com __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Need Help with syntax for Runmacro from escalation, works from dos cmd
Did you try the path in a DOS 8.3 format? Joe From: Shrestha, Manjari R. manjari.r.shres...@saic.com To: arslist@ARSLIST.ORG Sent: Thursday, February 5, 2009 2:31:42 PM Subject: Re: Need Help with syntax for Runmacro from escalation, works from dos cmd Hello Mark and Joe, Thanks for your reply. I am trying to run the macro from an escalation. I copied the macro file to the server and I can again run the command from the prompt successfully but when I use this in escalation it does not do anything, there is no error messages either. Yikes! Thanks! Manjari R. Shrestha Programmer Analyst SAIC 12530 Parklawn Drive, Suite 350 Rockville, MD 20852 Office: (301) 998-7364 ranj...@saic.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mark Lev Sent: Thursday, February 05, 2009 12:06 PM To: arslist@ARSLIST.ORG Subject: Re: Need Help with syntax for Runmacro from escalation, works from dos cmd Are you running the cmd line version on the server or desktop? The escalation will run on server, so the C: in escalation is referring to server c: not local c: You may need to move the macro to the server and adjust path accordingly where Remedy has permissions to. Thanks, Mark Mark Lev Sr. Systems Consultant 703-672-4390 732-859-5827 (cell) mark@rightstarsystems.com --- RightStar Systems, Inc. 100 East Street SE, Suite 202 Vienna, VA 22180 USA --- From: Action Request System discussion list(ARSList) on behalf of Shrestha, Manjari R. Sent: Thu 2/5/2009 11:40 AM To: arslist@ARSLIST.ORG Subject: Need Help with syntax for Runmacro from escalation, works from dos cmd ** https://owa.mailstreet2003.net/exchange/mark.levrightstarsystems.com/Drafts/image001.jpg Hi, I am able to run the following command from cmd prompt: C:\Program Files\AR System\runmacro.exe -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password However when I try the same syntax from an escalation through Run Process, it does not work. I am using the following syntax in RUN PROCESS: C:\Program Files\AR System\runmacro.exe -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password Thanks in advance. Manjari R. Shrestha Programmer Analyst SAIC 12530 Parklawn Drive, Suite 350 Rockville, MD 20852 Office: (301) 998-7364 ranj...@saic.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Need Help with syntax for Runmacro from escalation, works from dos cmd
** Manjariit would be helpful if you state what the error message is, if any, or what the problem is.thanksshafqat ayaz--- On Thu, 2/5/09, Shrestha, Manjari R. manjari.r.shres...@saic.com wrote:From: Shrestha, Manjari R. manjari.r.shres...@saic.comSubject: Need Help with syntax for Runmacro from escalation, works from dos cmdTo: arslist@ARSLIST.ORGDate: Thursday, February 5, 2009, 4:40 PM** Hi, I am able to run the following command from cmd prompt: “C:\Program Files\AR System\runmacro.exe" -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password However when I try the same syntax from an escalation through Run Process, it does not work. I am using the following syntax in RUN PROCESS: “C:\Program Files\AR System\runmacro.exe" -h C:\Documents and Settings\All Users\Application Data\AR System\home\arcmds -i Reporting -x MyServer -U username -P password Thanks in advance. Manjari R. Shrestha Programmer Analyst SAIC 12530 Parklawn Drive, Suite 350 Rockville, MD 20852 Office: (301) 998-7364 ranj...@saic.com __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___
Re: RUNMACRO
The armaced program is available on the BMC Developer Network http://developer.bmc.com/communities/docs/DOC-2141 Grab the program and put it in its own folder. Save your macro to the same folder. Open a command prompt to that folder and run the program. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frex Popo Sent: Thursday, November 27, 2008 8:10 AM To: arslist@ARSLIST.ORG Subject: RUNMACRO ** Hello all, ARS: 7.1 patch04 I am using the runmacro to dump some data from a form. All done in a batch script which I run from the command line. The following command does more or less what I want. %ARDIR%\runmacro.exe -x %ARSVR% -U %ARUSER% -P %ARPASS% -a %ARPORT% -o %TARGDIR%\%TARGFILE% -f %ARFORM% -t csv -q '100161' != $NULL$ AND '7' = 0 Now I am trying to change this to extract only certain columns from the form. I have tried to do this by going to the user tool switch the macro button, run a search, then generate a report skeleton and write the data to some file. However, I want to be able to write to the file specified by -o rather than the file specified within the macro. There are other issues also when copying the script to a different machine etc etc.. My question is, is there a way I can edit a file (.arq) manually and tell it to dump columnA and colunB from a particular form etc and then include the -e option in the command above? Rather than having to go to the user tool and create everything from there!!! anywayone has done this and wants to share his macro? Thanks in advance frex
Re: RUNMACRO
Will give it a go :) Thanks Fred, --- En date de : Lun 1.12.08, Grooms, Frederick W [EMAIL PROTECTED] a écrit : De: Grooms, Frederick W [EMAIL PROTECTED] Objet: Re: RUNMACRO À: arslist@ARSLIST.ORG Date: Lundi 1 Décembre 2008, 15h37 The armaced program is available on the BMC Developer Network http://developer.bmc.com/communities/docs/DOC-2141 Grab the program and put it in its own folder. Save your macro to the same folder. Open a command prompt to that folder and run the program. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frex Popo Sent: Thursday, November 27, 2008 8:10 AM To: arslist@ARSLIST.ORG Subject: RUNMACRO ** Hello all, ARS: 7.1 patch04 I am using the runmacro to dump some data from a form. All done in a batch script which I run from the command line. The following command does more or less what I want. %ARDIR%\runmacro.exe -x %ARSVR% -U %ARUSER% -P %ARPASS% -a %ARPORT% -o %TARGDIR%\%TARGFILE% -f %ARFORM% -t csv -q '100161' != $NULL$ AND '7' = 0 Now I am trying to change this to extract only certain columns from the form. I have tried to do this by going to the user tool switch the macro button, run a search, then generate a report skeleton and write the data to some file. However, I want to be able to write to the file specified by -o rather than the file specified within the macro. There are other issues also when copying the script to a different machine etc etc.. My question is, is there a way I can edit a file (.arq) manually and tell it to dump columnA and colunB from a particular form etc and then include the -e option in the command above? Rather than having to go to the user tool and create everything from there!!! anywayone has done this and wants to share his macro? Thanks in advance frex ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: RUNMACRO
The truth is, I did not have too much time to fix it and the matter was slightly urgent. So all I did was, after I dump the data to a temp file, I run it through a FOR /F loop which in one line filters the columns I need and then writes them to the final nice looking csv file. :) When I have more time I will look into it and let you know if I manage to fix it. Thanks for your assistance :) frex --- En date de : Ven 28.11.08, Kaïs Albassir [EMAIL PROTECTED] a écrit : De: Kaïs Albassir [EMAIL PROTECTED] Objet: Re: RUNMACRO À: arslist@ARSLIST.ORG Date: Vendredi 28 Novembre 2008, 12h28 Hi Frex, May you send us your macro and the definition (.def file) of the form you want to extract data from. We shall see what we can do for you Visit www.arsmarts.com and discover a brand new third party product to enhance your productivity ** Hello all, ARS: 7.1 patch04 I am using the runmacro to dump some data from a form. All done in a batch script which I run from the command line. The following command does more or less what I want. %ARDIR%runmacro.exe -x %ARSVR% -U %ARUSER% -P %ARPASS% -a %ARPORT% -o %TARGDIR%%TARGFILE% -f %ARFORM% -t csv -q '100161' != $NULL$ AND '7' = 0 Now I am trying to change this to extract only certain columns from the form. I have tried to do this by going to the user tool switch the macro button, run a search, then generate a report skeleton and write the data to some file. However, I want to be able to write to the file specified by -o rather than the file specified within the macro. There are other issues also when copying the script to a different machine etc etc.. My question is, is there a way I can edit a file (.arq) manually and tell it to dump columnA and colunB from a particular form etc and then include the -e option in the command above? Rather than having to go to the user tool and create everything from there!!! anywayone has done this and wants to share his macro? Thanks in advance frex __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: RUNMACRO
Hi Frex, May you send us your macro and the definition (.def file) of the form you want to extract data from. We shall see what we can do for you Visit www.arsmarts.com and discover a brand new third party product to enhance your productivity ** Hello all, ARS: 7.1 patch04 I am using the runmacro to dump some data from a form. All done in a batch script which I run from the command line. The following command does more or less what I want. %ARDIR%runmacro.exe -x %ARSVR% -U %ARUSER% -P %ARPASS% -a %ARPORT% -o %TARGDIR%%TARGFILE% -f %ARFORM% -t csv -q '100161' != $NULL$ AND '7' = 0 Now I am trying to change this to extract only certain columns from the form. I have tried to do this by going to the user tool switch the macro button, run a search, then generate a report skeleton and write the data to some file. However, I want to be able to write to the file specified by -o rather than the file specified within the macro. There are other issues also when copying the script to a different machine etc etc.. My question is, is there a way I can edit a file (.arq) manually and tell it to dump columnA and colunB from a particular form etc and then include the -e option in the command above? Rather than having to go to the user tool and create everything from there!!! anywayone has done this and wants to share his macro? Thanks in advance frex __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RUNMACRO
Hello all, ARS: 7.1 patch04 I am using the runmacro to dump some data from a form. All done in a batch script which I run from the command line. The following command does more or less what I want. %ARDIR%\runmacro.exe -x %ARSVR% -U %ARUSER% -P %ARPASS% -a %ARPORT% -o %TARGDIR%\%TARGFILE% -f %ARFORM% -t csv -q '100161' != $NULL$ AND '7' = 0 Now I am trying to change this to extract only certain columns from the form. I have tried to do this by going to the user tool switch the macro button, run a search, then generate a report skeleton and write the data to some file. However, I want to be able to write to the file specified by -o rather than the file specified within the macro. There are other issues also when copying the script to a different machine etc etc.. My question is, is there a way I can edit a file (.arq) manually and tell it to dump columnA and colunB from a particular form etc and then include the -e option in the command above? Rather than having to go to the user tool and create everything from there!!! anywayone has done this and wants to share his macro? Thanks in advance frex ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Runmacro for export in an escalation
Here is the command that I got to work executing from a filter: D:\Program Files\AR System\runmacro.exe -o D:\Program Files\AR System\User\testexport.csv -x $SERVER$ -U USERNAME -P PASSWORD -f FORM_NAME -t csv -q '300984400'=3000 As you can see the extra quotes are necessary. Two double-quotes together within a set of double-quote translates into a single double-quote within the double quotes. The best suggestion I can make is to turn filter logging on, copy the runmacro command and past it into a command prompt to test. The information in the log will give you how the system translates your filter. Then you can play with the single and double quotes until you get it to work the way you want. Best of luck. James Ward Cellular: 469-338-7185 EMail: [EMAIL PROTECTED] --- On Tue, 7/15/08, Suster, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: From: Suster, [EMAIL PROTECTED] [EMAIL PROTECTED] Subject: Runmacro for export in an escalation To: arslist@ARSLIST.ORG Date: Tuesday, July 15, 2008, 11:57 AM I'm attempting to use the runmacro command from an escalation to do an export. I've followed the Integrating with Plug-ins and Third-Party Products guide as best I can. The command simply doesn't work in the escalation. When I run it from a command window in Windows I get the following error: DTS:CMDB-SDS:Transactions is not a regular form and is not processed. The listed form is a regular form, however. The command as written: runmacro -o D:\Remedy\SDS_File_Exchange\SDS_nightly_batch_data\cmdb2sdsnew.csv -d D:\Remedy\SDS_File_Exchange\Macros -x ms-res-devrm -e expxcmdb.arq -U USER -P PASSWORD -s DTS:CMDB-SDS:Transactions -t csv Any input is appreciated. Thank you. Ron Suster State of California ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Runmacro for export in an escalation
I'm attempting to use the runmacro command from an escalation to do an export. I've followed the Integrating with Plug-ins and Third-Party Products guide as best I can. The command simply doesn't work in the escalation. When I run it from a command window in Windows I get the following error: DTS:CMDB-SDS:Transactions is not a regular form and is not processed. The listed form is a regular form, however. The command as written: runmacro -o D:\Remedy\SDS_File_Exchange\SDS_nightly_batch_data\cmdb2sdsnew.csv -d D:\Remedy\SDS_File_Exchange\Macros -x ms-res-devrm -e expxcmdb.arq -U USER -P PASSWORD -s DTS:CMDB-SDS:Transactions -t csv Any input is appreciated. Thank you. Ron Suster State of California ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Runmacro for export in an escalation
I to have been running into a similar problemI do not have an answer for you, but I thought I would point out that in your command line you define (with the -t csv) a CSV export, but your file name has a .arx extension. James Ward ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Runmacro not working correctly
Hi All, I am going through a very strange problem while using the AR Utility 'runmacro' present on Unix server at location /opt/remedy/ar/ardevki/bin. When i call this command by passing certain parameters to it, It doesn't insert the required DestID into my ARS Form although it shows that the command is properly executed. Here is command: /opt/remedy/ar/ardevki/bin/runmacro -e FeedbackFromClick -d /opt/resolution/click/etc -x ardevki -a 8245 -U B2B -P B2B -p RequestId=0006388 -p State=3 -p Server=ardevki -p DestId=CUST_00039 Output: Result from runmacro process error output: Action Request System Unix Runmacro Version 7.0.01Copyright (c) BMC Software, Inc. 1991-2006. All rights reserved.Result from runmacro process output: Executing macro - FeedbackFromClick. Please wait...Macro - FeedbackFromClick processing complete I am using ARS Server Version : ARS 7.0.0.1 patch 5. Also this problem had never come in past. Don't know what happend instantly. Any Help or suggestion would be highly appreciated. or someone can help me to debug the problem. Thanks Regards, -Vikas Kapoor ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Debugging runmacro in ARS 6.3
Hello Listers, ARS 6.3 Patch 21 MS SQLServer 2000 I am trying to update a runmacro used in an Escalation Run Process. Is there anyway to debug the runmacro to see why it stopped working? The macro logs in as a valid user. Performs a query passed in by the -p parameter and Reports To File a simple tab delimited ARS Report. This newly recorded macro works in the WUT but will not produce any output when executed with runmacro. I have all of the paths specified. and the servername is fully qualified in the macro as well as with the -x parameter. Workflow.log doesn't get activated by the runmacro and there is little to see in the API, SQL and Escalation logs. I guess I'm looking for the verbose switch? TIA, John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: runmacro problem
Hi Niklas You could try DSO - which is a cost option for BMC. Or you could try something like reporting to ARX based on the unique reference (Entry-ID). I guess it all depends on the target remote system and what format you need the data. You may even try going down the route of web-services (XML). Regards Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Niklas Asplund Sent: 15 February 2008 06:56 To: arslist@ARSLIST.ORG Subject: Re: runmacro problem --=_Part_3423_4232836.1203058538709 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi David Good to hear that I'm not the only one with this problem. Maybe I should have a look at another transfer method... Any suggestions that would be as easy as runmacro?? // Niklas On 14/02/2008, David Morgan [EMAIL PROTECTED] wrote: Hi Niklas I have recently seen exactly this with 6.3 runmacro.exe (patch 17 I think) - we got around it by having the called perl script replace the '=' with the 'eq'. I tried escaping the '=' with '\=' and various other attempts but nothing seems to work. I'd be interested in seeing if there are other results from this question. Regards Dave Morgan -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Niklas Asplund Sent: 14 February 2008 14:45 To: arslist@ARSLIST.ORG Subject: runmacro problem --=_Part_891_23742306.1203000320065 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi all I have a problem with a runmacro command that we are issuing in order to transfer an entry from our server to a remote system. As soon as I include an equal sign ( = ) in on of the fields that I'm trying to transfer, the field on the remote system ends up blank. So if I try to transfer the description field from our server to another server via runmacro. And the description text includes an equal sign, the transfer fails. Anyone seen this before?? Any ideas how to get around the problem?? // Niklas Asplund Siemens IT Sweden Windows 2003 SQL Server 2000 ARS 7.0.1 Patch 1 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are --=_Part_891_23742306.1203000320065 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline ** divHi all/div divI have a problem with a runmacro command that we are issuing in order to transfer an entry from our server to anbsp;remote system./div divnbsp;/div divAs soon as I include an equal signnbsp;( = ) in on of the fields that I#39;m trying to transfer, the field on the remote system ends up blank./div divnbsp;/div divSo if I try to transfer the description field from our server to another server via runmacro./div divAnd the description text includes an equal sign, the transfer fails./div divnbsp;/div divAnyone seen this before??/div divAny ideas how to get around the problem??/div divnbsp;/div div// Niklas Asplund/div divSiemens IT Sweden/div divnbsp;/div divWindows 2003/div divSQL Server 2000/div divARS 7.0.1 Patch 1/div __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ --=_Part_891_23742306.1203000320065-- ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are --=_Part_3423_4232836.1203058538709 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline ** divHi David/div divGood to hear that I#39;m not the only one with this problem./div divnbsp;/div divMaybe I should have a look at another transfer method.../div divAny suggestions that would be as easy as runmacro??/div divnbsp;/div div// Niklasbrbrnbsp;/div divspan class=gmail_quoteOn 14/02/2008, b class=gmail_sendernameDavid Morgan/b lt;a href=mailto:[EMAIL PROTECTED][EMAIL PROTECTED]/agt; wrote:/span blockquote class=gmail_quote style=PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solidHi NiklasbrbrI have recently seen exactly this with 6.3 runmacro.exe (patch 17 Ibrthink) - we got around it by having the called perl script replace thebr #39;=#39; with the #39;eq#39;.brbrI tried escaping the #39;=#39; with #39;\=#39; and various other attempts butbrnothing seems to work.brbrI#39;d be interested in seeing if there are other results from thisbr question.brbrRegardsbrDave
Re: runmacro problem
Hi Niklas I have recently seen exactly this with 6.3 runmacro.exe (patch 17 I think) - we got around it by having the called perl script replace the '=' with the 'eq'. I tried escaping the '=' with '\=' and various other attempts but nothing seems to work. I'd be interested in seeing if there are other results from this question. Regards Dave Morgan -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Niklas Asplund Sent: 14 February 2008 14:45 To: arslist@ARSLIST.ORG Subject: runmacro problem --=_Part_891_23742306.1203000320065 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi all I have a problem with a runmacro command that we are issuing in order to transfer an entry from our server to a remote system. As soon as I include an equal sign ( = ) in on of the fields that I'm trying to transfer, the field on the remote system ends up blank. So if I try to transfer the description field from our server to another server via runmacro. And the description text includes an equal sign, the transfer fails. Anyone seen this before?? Any ideas how to get around the problem?? // Niklas Asplund Siemens IT Sweden Windows 2003 SQL Server 2000 ARS 7.0.1 Patch 1 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are --=_Part_891_23742306.1203000320065 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline ** divHi all/div divI have a problem with a runmacro command that we are issuing in order to transfer an entry from our server to anbsp;remote system./div divnbsp;/div divAs soon as I include an equal signnbsp;( = ) in on of the fields that I#39;m trying to transfer, the field on the remote system ends up blank./div divnbsp;/div divSo if I try to transfer the description field from our server to another server via runmacro./div divAnd the description text includes an equal sign, the transfer fails./div divnbsp;/div divAnyone seen this before??/div divAny ideas how to get around the problem??/div divnbsp;/div div// Niklas Asplund/div divSiemens IT Sweden/div divnbsp;/div divWindows 2003/div divSQL Server 2000/div divARS 7.0.1 Patch 1/div __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ --=_Part_891_23742306.1203000320065-- ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: runmacro problem
Hi David Good to hear that I'm not the only one with this problem. Maybe I should have a look at another transfer method... Any suggestions that would be as easy as runmacro?? // Niklas On 14/02/2008, David Morgan [EMAIL PROTECTED] wrote: Hi Niklas I have recently seen exactly this with 6.3 runmacro.exe (patch 17 I think) - we got around it by having the called perl script replace the '=' with the 'eq'. I tried escaping the '=' with '\=' and various other attempts but nothing seems to work. I'd be interested in seeing if there are other results from this question. Regards Dave Morgan -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Niklas Asplund Sent: 14 February 2008 14:45 To: arslist@ARSLIST.ORG Subject: runmacro problem --=_Part_891_23742306.1203000320065 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi all I have a problem with a runmacro command that we are issuing in order to transfer an entry from our server to a remote system. As soon as I include an equal sign ( = ) in on of the fields that I'm trying to transfer, the field on the remote system ends up blank. So if I try to transfer the description field from our server to another server via runmacro. And the description text includes an equal sign, the transfer fails. Anyone seen this before?? Any ideas how to get around the problem?? // Niklas Asplund Siemens IT Sweden Windows 2003 SQL Server 2000 ARS 7.0.1 Patch 1 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are --=_Part_891_23742306.1203000320065 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline ** divHi all/div divI have a problem with a runmacro command that we are issuing in order to transfer an entry from our server to anbsp;remote system./div divnbsp;/div divAs soon as I include an equal signnbsp;( = ) in on of the fields that I#39;m trying to transfer, the field on the remote system ends up blank./div divnbsp;/div divSo if I try to transfer the description field from our server to another server via runmacro./div divAnd the description text includes an equal sign, the transfer fails./div divnbsp;/div divAnyone seen this before??/div divAny ideas how to get around the problem??/div divnbsp;/div div// Niklas Asplund/div divSiemens IT Sweden/div divnbsp;/div divWindows 2003/div divSQL Server 2000/div divARS 7.0.1 Patch 1/div __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ --=_Part_891_23742306.1203000320065-- ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Modifying a record via RunMacro on the command line
Hi Julie,
You are right about Modify-All being the only way to uptade a ticket.
1. Start Macro Recording
2. Open your form in search mode
3. Enter an advanced search of ('1' = $Reguest$)
4. Choose Action - Modify All
5. Enter valus or $xxx$ in the fields you want to update
6. Press Save
7. Save your Macro
Before the days of Push-Fields, we did this all the time. We created a
filter that executed the user-tool on the server, which in turn executed a
macro that updated whatever we wanted to update... I like Push-Fields ;-)
Best Regards - Misi, RRR AB, http://rrr.se
Hi Gary,
I believe you need a Modify-bulk command to actually perform the
modify. I am not sure how necessary those hex '01' characters
peppered throughout the macro are.
TEST
Set-schema: SchemaServer
Query: 1=$Request$
Modify-bulk: 536871039=$Title$
end
Good luck!
Julie Rockwood
At 02:25 PM 1/22/2008, you wrote:
**
I'm trying to modify a ticket via command line.
Here is my call on the command line:
C:\Program Files\AR System\RUNMACRO.EXE
-d C:\Documents and Settings\All Users\Application Data\AR
System\HOME\ARCmds
-e TEST -x Server -U User -P Password -p
Request=CUST000
4854 = -p Title=Mr.
I'm not even sure if the above is correct, but I'm trying to pass a
parameter called 'Request' as part of the qualification on the
macro, and then a parameter for 'Title' as the value that is being
updated. So, it will look up 'Request' and modify 'Title.'
So, I did some experimenting. A SUBMIT macro for this particular
schema looks like the following:
TEST
Set-schema: SchemaServer
Submit:
SchemaServer|[EMAIL PROTECTED]
end
And a QUERY macro looks like the following:
TEST
Set-schema: SchemaServer
Query: 1=CUST0004854[1]
Form-open:
Form-entry-list: 0
Form-final: modify@
end
So, I merged the two and came up with the below:
TEST
Set-schema: SchemaServer
Query: 1=$Request$Server|536871039=$Title$
Form-final: modify@
End
The hopes are that the above macro will pull up ticket number
$Request$ (as passed in via the command line call above), and update
536871069 to 'Mr.' as passed via the command line call above).
Unfortunately, this isn't working. Do you all have any tips on
creating a macro that, when run via command line, does a query, then
updates the resulting record(s)? I tried to just go into the user
tool and record a query/modify action, but remedy won't commit to
the DB, so it won't record the update in the macro either. It will,
however, let you create a submit macro and create the proper
commands in the macro file, just not submit to database.
Any help is greatly appreciated!
Thanks,
Gary Opela, Jr
Sr. Remedy Developer
Leader Communications, Inc.
__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers
Are html___
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
--
This message was scanned by ESVA and is believed to be clean.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Modifying a record via RunMacro on the command line
Thanks Julie and Misi, your solution worked great!
Now I just have to go in and turn on Modify-All so it will work (since
it sounds like you cannot do a single modify operation within the macro,
which kind of makes sense).
Thanks,
Gary Opela, Jr
Sr. Remedy Developer
Leader Communications, Inc.
405 736 3211
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Misi Mladoniczky
Sent: Wednesday, January 23, 2008 2:53 AM
To: arslist@ARSLIST.ORG
Subject: Re: Modifying a record via RunMacro on the command line
Hi Julie,
You are right about Modify-All being the only way to uptade a ticket.
1. Start Macro Recording
2. Open your form in search mode
3. Enter an advanced search of ('1' = $Reguest$)
4. Choose Action - Modify All
5. Enter valus or $xxx$ in the fields you want to update
6. Press Save
7. Save your Macro
Before the days of Push-Fields, we did this all the time. We created a
filter that executed the user-tool on the server, which in turn executed
a
macro that updated whatever we wanted to update... I like Push-Fields
;-)
Best Regards - Misi, RRR AB, http://rrr.se
Hi Gary,
I believe you need a Modify-bulk command to actually perform the
modify. I am not sure how necessary those hex '01' characters
peppered throughout the macro are.
TEST
Set-schema: SchemaServer
Query: 1=$Request$
Modify-bulk: 536871039=$Title$
end
Good luck!
Julie Rockwood
At 02:25 PM 1/22/2008, you wrote:
**
I'm trying to modify a ticket via command line.
Here is my call on the command line:
C:\Program Files\AR System\RUNMACRO.EXE
-d C:\Documents and Settings\All Users\Application Data\AR
System\HOME\ARCmds
-e TEST -x Server -U User -P Password -p
Request=CUST000
4854 = -p Title=Mr.
I'm not even sure if the above is correct, but I'm trying to pass a
parameter called 'Request' as part of the qualification on the
macro, and then a parameter for 'Title' as the value that is being
updated. So, it will look up 'Request' and modify 'Title.'
So, I did some experimenting. A SUBMIT macro for this particular
schema looks like the following:
TEST
Set-schema: SchemaServer
Submit:
SchemaServer|536871039=Mr.536870985=asdf536870938=1536870936=15368
70935=1536870934=1536870929=336-3211536870925=Bob536870918=Smith53687091
[EMAIL PROTECTED]
end
And a QUERY macro looks like the following:
TEST
Set-schema: SchemaServer
Query: 1=CUST0004854[1]
Form-open:
Form-entry-list: 0
Form-final: modify@
end
So, I merged the two and came up with the below:
TEST
Set-schema: SchemaServer
Query: 1=$Request$Server|536871039=$Title$
Form-final: modify@
End
The hopes are that the above macro will pull up ticket number
$Request$ (as passed in via the command line call above), and update
536871069 to 'Mr.' as passed via the command line call above).
Unfortunately, this isn't working. Do you all have any tips on
creating a macro that, when run via command line, does a query, then
updates the resulting record(s)? I tried to just go into the user
tool and record a query/modify action, but remedy won't commit to
the DB, so it won't record the update in the macro either. It will,
however, let you create a submit macro and create the proper
commands in the macro file, just not submit to database.
Any help is greatly appreciated!
Thanks,
Gary Opela, Jr
Sr. Remedy Developer
Leader Communications, Inc.
__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers
Are html___
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
--
This message was scanned by ESVA and is believed to be clean.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Modifying a record via RunMacro on the command line
I'm trying to modify a ticket via command line. Here is my call on the command line: C:\Program Files\AR System\RUNMACRO.EXE -d C:\Documents and Settings\All Users\Application Data\AR System\HOME\ARCmds -e TEST -x Server -U User -P Password -p Request=CUST000 4854 = -p Title=Mr. I'm not even sure if the above is correct, but I'm trying to pass a parameter called 'Request' as part of the qualification on the macro, and then a parameter for 'Title' as the value that is being updated. So, it will look up 'Request' and modify 'Title.' So, I did some experimenting. A SUBMIT macro for this particular schema looks like the following: TEST Set-schema: SchemaServer Submit: SchemaServer|536871039=Mr.536870985=asdf536870938=1536870936=1536870 935=1536870934=1536870929=336-3211536870925=Bob536870918=Smith536870916= [EMAIL PROTECTED] end And a QUERY macro looks like the following: TEST Set-schema: SchemaServer Query: 1=CUST0004854[1] Form-open: Form-entry-list: 0 Form-final: modify@ end So, I merged the two and came up with the below: TEST Set-schema: SchemaServer Query: 1=$Request$Server|536871039=$Title$ Form-final: modify@ End The hopes are that the above macro will pull up ticket number $Request$ (as passed in via the command line call above), and update 536871069 to 'Mr.' as passed via the command line call above). Unfortunately, this isn't working. Do you all have any tips on creating a macro that, when run via command line, does a query, then updates the resulting record(s)? I tried to just go into the user tool and record a query/modify action, but remedy won't commit to the DB, so it won't record the update in the macro either. It will, however, let you create a submit macro and create the proper commands in the macro file, just not submit to database. Any help is greatly appreciated! Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Modifying a record via RunMacro on the command line
Hi Gary, I believe you need a Modify-bulk command to actually perform the modify. I am not sure how necessary those hex '01' characters peppered throughout the macro are. TEST Set-schema: SchemaServer Query: 1=$Request$ Modify-bulk: 536871039=$Title$ end Good luck! Julie Rockwood At 02:25 PM 1/22/2008, you wrote: ** I'm trying to modify a ticket via command line. Here is my call on the command line: C:\Program Files\AR System\RUNMACRO.EXE -d C:\Documents and Settings\All Users\Application Data\AR System\HOME\ARCmds -e TEST -x Server -U User -P Password -p Request=CUST000 4854 = -p Title=Mr. I'm not even sure if the above is correct, but I'm trying to pass a parameter called 'Request' as part of the qualification on the macro, and then a parameter for 'Title' as the value that is being updated. So, it will look up 'Request' and modify 'Title.' So, I did some experimenting. A SUBMIT macro for this particular schema looks like the following: TEST Set-schema: SchemaServer Submit: SchemaServer|[EMAIL PROTECTED] end And a QUERY macro looks like the following: TEST Set-schema: SchemaServer Query: 1=CUST0004854[1] Form-open: Form-entry-list: 0 Form-final: modify@ end So, I merged the two and came up with the below: TEST Set-schema: SchemaServer Query: 1=$Request$Server|536871039=$Title$ Form-final: modify@ End The hopes are that the above macro will pull up ticket number $Request$ (as passed in via the command line call above), and update 536871069 to 'Mr.' as passed via the command line call above). Unfortunately, this isn't working. Do you all have any tips on creating a macro that, when run via command line, does a query, then updates the resulting record(s)? I tried to just go into the user tool and record a query/modify action, but remedy won't commit to the DB, so it won't record the update in the macro either. It will, however, let you create a submit macro and create the proper commands in the macro file, just not submit to database. Any help is greatly appreciated! Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
runmacro issue/question
Folks, We just upgraded to 7.0.1 p3 and now runmacro will not run. We call our support vendor and they say we need cmdb to get the libraries for 7.0.1 p3 runmacro. Has anyone heard of this? Does this make any since at all? So just a straight BMC ars server 7.x on solaris does not come with the runmacro libraries. What is the use of having it the doc and on the server if it can not be used. This is something that has been available since version 2.3. -- *Rocky* Rocky Rockwell eMA Team – Remedy Developer [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Ph#1: 214-567-8874 Ph#2: 325-884-1263 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: runmacro issue/question
Rocky, Call tech support. Get them to fix your problem. ( You might have to ask several times, and fight with them to actually get them to admit that a command line tool is actually covered by your support contract. But do not take no for an answer.) I would also impress upon them that if Patch 2 (or any other v7 ARS server patch level) came with the files, but Patch 3 did not... well.. tell me that is a design feature and not a bug. :) Good luck. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 7/18/07, Rocky Rockwell [EMAIL PROTECTED] wrote: Folks, We just upgraded to 7.0.1 p3 and now runmacro will not run. We call our support vendor and they say we need cmdb to get the libraries for 7.0.1 p3 runmacro. Has anyone heard of this? Does this make any since at all? So just a straight BMC ars server 7.x on solaris does not come with the runmacro libraries. What is the use of having it the doc and on the server if it can not be used. This is something that has been available since version 2.3. -- *Rocky* Rocky Rockwell eMA Team – Remedy Developer [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Ph#1: 214-567-8874 Ph#2: 325-884-1263 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: set runmacro to use a private server
Roger, I take that you mean private server thread? Actually that is a pretty good question, there is a -r switch for the rpc port number for arimportcmd but there does not seem to be one for runmacro. I guess it should be pretty straight-forward for BMC to incorporate that in the program... I'm afraid there is no possibility for you right now to specify an RPC port. -- Met vriendelijke groet / Kind regards Michiel Beijen __ MANSOLUTIONS Energieweg 60-62 3771 NA Barneveld The Netherlands Tel. +31-(0)612968592 Mail [EMAIL PROTECTED] Internet http://bsm.mansolutions.nl On 4/4/07, Roger Walls [EMAIL PROTECTED] wrote: Hi, How do I set a runmacro command line to use a private arserver? Thanks in advance, Roger Walls ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: set runmacro to use a private server
I think you can set an environemnt vaiable called ARRPC=??? before you the program. On 4/5/07, Michiel Beijen [EMAIL PROTECTED] wrote: Roger, I take that you mean private server thread? Actually that is a pretty good question, there is a -r switch for the rpc port number for arimportcmd but there does not seem to be one for runmacro. I guess it should be pretty straight-forward for BMC to incorporate that in the program... I'm afraid there is no possibility for you right now to specify an RPC port. -- Met vriendelijke groet / Kind regards Michiel Beijen __ MANSOLUTIONS Energieweg 60-62 3771 NA Barneveld The Netherlands Tel. +31-(0)612968592 Mail [EMAIL PROTECTED] Internet http://bsm.mansolutions.nl On 4/4/07, Roger Walls [EMAIL PROTECTED] wrote: Hi, How do I set a runmacro command line to use a private arserver? Thanks in advance, Roger Walls ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified www.specificintegration.com 703-376-1249 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
set runmacro to use a private server
Hi, How do I set a runmacro command line to use a private arserver? Thanks in advance, Roger Walls ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
RunMacro versus macro in client
Hi all, I want a automaticaly generate export csv file with some fields in file. So I create macro. When I run it from user client, everything is OK and macro generates file. Because I want use it in filter (like as RUN-PROCESS), I tested it under command runmacro. But macro didnt create the file. Is the differences between macro for client and macro for runmacro command? - this is my macro --- report Set-schema: HPD:HelpDeskars01 Query: '3' = 1.1.2007 AND '536870964' LIKE %to Supp% Report: 21=AR System1=13=repGE4=5=6=13=23=07=7710=958=19=111=012=020=716=-17=18=119=72=1Case ID+02020003Category02020004Type02020005Item0208Summary020536870977Last Name+020536870978First Name02020012Region02020007POS02020006Department02026126Priority02026130Case Type02026128Source02024006Group+02024015Individual+02024007Description02026100Summary02026503Details02024008Work Log020 to-file: c:\tmp\report.csvO end Thanks for advice. /Tomas Stevove ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: RunMacro versus macro in client
Thomas, What does your runmacro command look like? Thanks, Bruce Scott Application Developer - Remedy PetSmart, Inc. _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Števove Tomáš Sent: Wednesday, January 17, 2007 5:09 AM To: arslist@ARSLIST.ORG Subject: RunMacro versus macro in client Hi all, I want a automaticaly generate export csv file with some fields in file. So I create macro. When I run it from user client, everything is OK and macro generates file. Because I want use it in filter (like as RUN-PROCESS), I tested it under command runmacro. But macro didnt create the file. Is the differences between macro for client and macro for runmacro command? - this is my macro --- report Set-schema: HPD:HelpDeskars01 Query: [1] '3' = 1.1.2007 AND '536870964' LIKE %to Supp% Report: 21=AR System1=13=repGE4=5=6=13=23=07=7710=958=19=111=012=020=716=-17=18=119=72=1 _ _ Case ID+ _ 0 _ 20[1]20003 _ _ Category _ 0 _ 20[1]20004 _ _ Type _ 0 _ 20[1]20005 _ _ Item _ 0 _ 20[1]8 _ _ Summary _ 0 _ 20[1]536870977 _ _ Last Name+ _ 0 _ 20[1]536870978 _ _ First Name _ 0 _ 20[1]20012 _ _ Region _ 0 _ 20[1]20007 _ _ POS _ 0 _ 20[1]20006 _ _ Department _ 0 _ 20[1]26126 _ _ Priority _ 0 _ 20[1]26130 _ _ Case Type _ 0 _ 20[1]26128 _ _ Source _ 0 _ 20[1]24006 _ _ Group+ _ 0 _ 20[1]24015 _ _ Individual+ _ 0 _ 20[1]24007 _ _ Description _ 0 _ 20[1]26100 _ _ Summary _ 0 _ 20[1]26503 _ _ Details _ 0 _ 20[1]24008 _ _ Work Log _ 0 _ 20[1] to-file: c:\tmp\report.csvO end Thanks for advice. /Tomas Stevove __20060125___This posting was submitted with HTML in it___ # The information contained in this electronic mail message, including attachments, if any, is PetSmart confidential information. It is intended only for the use of the person(s) named above. If the reader of this message is not the intended recipient, or has received this message in error, you are hereby notified that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you are not the intended recipient or have received this message in error, please notify the sender via e-mail and promptly delete the original message. # ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: RunMacro versus macro in client
Bruce, runmacro command looks like this: C:\Program Files\AR System\Adminrunmacro.exe -h c:\u00\ar\macro -d c:\u00\ar\ma cro -x ars01 -e repGE I try macro with login infromation, but the result is the same - no file was created. When I try this command: C:\Program Files\AR System\Adminrunmacro.exe -o c:\tmp\report.csv -x ars01 -U user -P password -f HPD:HelpDesk -z c:\u00\ar\macro\repGE.qbe -t CSV File is created, but with all fields from HPD:HelpDesk and I need only some fields (as you can see in macro - command Report:) Maybe is I have error in macro? But, why macro is OK under client? Tomas Stevove Software Specialist Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Scott Sent: Wednesday, January 17, 2007 3:35 PM To: arslist@ARSLIST.ORG Subject: Re: RunMacro versus macro in client ** Thomas, What does your runmacro command look like? Thanks, Bruce Scott Application Developer - Remedy PetSmart, Inc. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Števove Tomáš Sent: Wednesday, January 17, 2007 5:09 AM To: arslist@ARSLIST.ORG Subject: RunMacro versus macro in client Hi all, I want a automaticaly generate export csv file with some fields in file. So I create macro. When I run it from user client, everything is OK and macro generates file. Because I want use it in filter (like as RUN-PROCESS), I tested it under command runmacro. But macro didnt create the file. Is the differences between macro for client and macro for runmacro command? - this is my macro --- report Set-schema: HPD:HelpDeskars01 Query: [1] '3' = 1.1.2007 AND '536870964' LIKE %to Supp% Report: 21=AR System1=13=repGE4=5=6=13=23=07=7710=958=19=111=012=020=716=-17=18=119=72=1 Case ID+ 0 20[1]20003 Category 0 20[1]20004 Type 0 20[1]20005 Item 0 20[1]8 Summary 0 20[1]536870977 Last Name+ 0 20[1]536870978 First Name 0 20[1]20012 Region 0 20[1]20007 POS 0 20[1]20006 Department 0 20[1]26126 Priority 0 20[1]26130 Case Type 0 20[1]26128 Source 0 20[1]24006 Group+ 0 20[1]24015 Individual+ 0 20[1]24007 Description 0 20[1]26100 Summary 0 20[1]26503 Details 0 20[1]24008 Work Log
Re: RunMacro versus macro in client
Thomas, I recently did something very similar and encounter some of the issues you are seeing. What I have is an escalation (because the report is needed on a reoccurring basis to meet audit requirements) which has a Run Process action. The command line of the Run Process looks like: c:\\progra~1\\remedy\\reports\\report.bat $zTmpDate$ where $zTmpDate$ is a variable I pass to the file being generated to make it unique. The batch file (report.bat) looks like: @Echo Off copycmd=/Y Set filedate=%1 C:\Progra~1\ARSyst~1\runmacro.exe -x remedydev01 -U Username -P password -d C:\Progra~1\Remedy\Reports -e ChangeCo copy c:\\progra~1\\remedy\\reports\\weekly\\changecontrolmeeting_.csv c:\\progra~1\\remedy\\reports\\weekly\\ChangeControlMeeting_%filedate%.csv Finally, my macro looks like this: ChangeCo Set-schema: PETM:ISChangeControlRequestremedyapp01 Query: 1707200=true1707100=true1707000=false1706900=true(( '7' = Approved AND '536871106' = Open) OR ( '7' = Pending AND '536871106' != Closed)) AND '536870921' = $-4$ AND '536870921' ($-4$+7*24*60*60) Report: 21=11=13=Change Control Meeting4=5=6=13=23=07=7210=968=19=111=012=020=716=-17=18=119=72=1Change Req ID050536870921Implementation Start045536870923Change Type02520004Type040536870914Change Owner0407Approval0308Short Description0100536870919Risk Lvl015536870920Outage015 report-sort: 0|2|536870921\1|1\1| Statistics: to-file: C:\Progra~1\Remedy\Reports\Weekly\ChangeControlMeeting_.csvO end Part of the no file issue you are seeing seems to be related to the way the command line interface treats the DOS-like commands, which is why there are doubled slashes in the batch and command line of the run process. Make sure that the name of the macro (seen above, first line of the macro) matches the macro name in the runmacro command (end of the third line of the batch file above). Thanks, Bruce _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Števove Tomáš Sent: Wednesday, January 17, 2007 9:02 AM To: arslist@ARSLIST.ORG Subject: Re: RunMacro versus macro in client ** Bruce, runmacro command looks like this: C:\Program Files\AR System\Adminrunmacro.exe -h c:\u00\ar\macro -d c:\u00\ar\ma cro -x ars01 -e repGE I try macro with login infromation, but the result is the same - no file was created. When I try this command: C:\Program Files\AR System\Adminrunmacro.exe -o c:\tmp\report.csv -x ars01 -U user -P password -f HPD:HelpDesk -z c:\u00\ar\macro\repGE.qbe -t CSV File is created, but with all fields from HPD:HelpDesk and I need only some fields (as you can see in macro - command Report:) Maybe is I have error in macro? But, why macro is OK under client? Tomas Stevove Software Specialist Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] # The information contained in this electronic mail message, including attachments, if any, is PetSmart confidential information. It is intended only for the use of the person(s) named above. If the reader of this message is not the intended recipient, or has received this message in error, you are hereby notified that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you are not the intended recipient or have received this message in error, please notify the sender via e-mail and promptly delete the original message. # ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Runmacro on Linux gives catalog error
Hi, I have problems when I am executing the runmacro command in the Linux Server , it gives me Cannot open catalog but no arerror number.I found the runmacro.cat in the /home/remedy/arsystem/locale/C directory , I included this as my NLSPATH in the .profile but still I am getting the same error. Is there any other path I need to set on my .profile or copy the runmacro.cat file. Thanks, Salehjee Ahmed. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Runmacro and runmacro.cat file on Linux - can not open catalog file
Why if you use the RunWoMacro api in the user community that does not need all the configuration setup. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michiel Beijen Sent: 10-17-2006 03:25 PM To: arslist@ARSLIST.ORG Subject: Re: Runmacro and runmacro.cat file on Linux - can not open catalog file You have to copy the api directory from the linux server installation file to this machine. This will allow you to use runmacro. There used to be a KB entry for this as well but due to the current problems with the BMC support website I guess it might be difficult to get to that. Kind regards, Michiel On 10/16/06, sssrae [EMAIL PROTECTED] wrote: Hi, Trying to run runmacro from a Linux ES3 box. Took the binary and cat files from installation archive. Having problems with runmacro binary not able to locate the runmacro.cat file. Can anyone maybe help me of what Im doing wrong?! Thanks!! Best regards, Rasmus Adding a scenario showing my problem: # locale LANG=C LC_CTYPE=C LC_NUMERIC=C LC_TIME=C LC_COLLATE=C LC_MONETARY=C LC_MESSAGES=C LC_PAPER=C LC_NAME=C LC_ADDRESS=C LC_TELEPHONE=C LC_MEASUREMENT=C LC_IDENTIFICATION=C LC_ALL= # ls /arsystem/linux/locale/C arsystem.cat runmacro.cat # export NLSPATH=/arsystem/linux/locale/C # ./runmacro -h /dummy-to-test-if-bin-can-find-cat-file Action Request System Unix Runmacro Version 6.3 Copyright (c) BMC Software, Inc. 1991-2005. All rights reserved. Can not open catalog file runmacro.cat. -- View this message in context: http://www.nabble.com/Runmacro-and-runmacro.cat-file-on-Linux---can-not- open-catalog-file-tf2451833.html#a6833360 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org Disclaimer: The information in this email and in any files transmitted with it, is intended only for the addressee and may contain confidential and/or privileged material. Access to this email by anyone else is unauthorized. If you receive this in error, please contact the sender immediately and delete the material from any computer. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is strictly prohibited. Statement and opinions expressed in this e-mail are those of the sender, and do not necessarily reflect those of STC. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Runmacro and runmacro.cat file on Linux - can not open catalog file
Hi, Trying to run runmacro from a Linux ES3 box. Took the binary and cat files from installation archive. Having problems with runmacro binary not able to locate the runmacro.cat file. Can anyone maybe help me of what Im doing wrong?! Thanks!! Best regards, Rasmus Adding a scenario showing my problem: # locale LANG=C LC_CTYPE=C LC_NUMERIC=C LC_TIME=C LC_COLLATE=C LC_MONETARY=C LC_MESSAGES=C LC_PAPER=C LC_NAME=C LC_ADDRESS=C LC_TELEPHONE=C LC_MEASUREMENT=C LC_IDENTIFICATION=C LC_ALL= # ls /arsystem/linux/locale/C arsystem.cat runmacro.cat # export NLSPATH=/arsystem/linux/locale/C # ./runmacro -h /dummy-to-test-if-bin-can-find-cat-file Action Request System Unix Runmacro Version 6.3 Copyright (c) BMC Software, Inc. 1991-2005. All rights reserved. Can not open catalog file runmacro.cat. -- View this message in context: http://www.nabble.com/Runmacro-and-runmacro.cat-file-on-Linux---can-not-open-catalog-file-tf2451833.html#a6833360 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
runmacro questions
Hello All, Questions about runmacro, and making an external app create a Remedy record: I'm supposed to record a macro that runmacro will call. What should be in my macro def? All the matching fields? Should there be field values in the macro def?? Do the parameter-value pairs in the runmacro statement have to be in the same order that the fields appear in the macro def? I can make runmacro work as long as it calls a macro that has the field values in the def. But I can't seem to make the windows command window accept anything within the runmacro statement that starts with -p which is, ironically, the flag that tells runmacro that a parameter-value pair is forthcoming. I even tried the runmacro statement in a batch file, but windows doesn't like the -p. Runmacro runs, but it's not passing any values and I get a workflow error telling me that a required field doesn't have a value. Any help out there from the runmacro experts? Drew ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
