You still seem to have a syntax error in your command line. The log file will show you the EXACT command line that is being performed.
In your case, it is showing the following: CMD.exe /c " C:\temp\MigrateDataForChangeID.bat " + 'CHG000000076079' First, you are not building a Set Fields arithmetic syntax command here. You are entering the command in the definition exactly as you want it. Your definition is CMD.exe /c " C:\temp\MigrateDataForChangeID.bat " + '$1$' There are lots of extra pieces of syntax here that you should not need. Why do you have the double quotes around the program name? They should not be needed. Why do you have the extra couple of spaces before the program name and after the program name? Why do you have the + sign? You don't want that in the final command. Look at the command that is generated (the first string above that I cut and pasted. Is that what you would type at the command line to execute? That is what the system is attempting to execute. I would expect the definition to look more like this CMD.exe /c C:\temp\MigrateDataForChangeID.bat $1$ Notice all the extra quotes and the plus signs and such are not there. This is the command line you are going to execute. The system will substitute for any parameter in $$ that it recognizes. IF you run the command by hand from the command line and get it to work, use that exact same syntax. If your parameter requires surrounding single quotes, put them in. If it requires surrounding double quotes, put them in. Whatever would be needed from the command line. Note that the Run Process and the SQL syntax is just to type the command as you want it executed and put in parameters as you wish. No extra quotes. No extra plus signs. No extra anything. You can see from the command that the system is attempting to execute in your log, lots of extra bits of things that is just confusing the heck out of your program. A Set Fields or Push Fields where you are constructing a value and where you can add numbers or subtract or use functions or whatever needs the syntax of an arithmetic operation. But, Run Process does not. I hope this helps solve the rest of the problem. Doug Mueller -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of gok's Sent: Monday, July 11, 2011 11:02 AM To: [email protected] Subject: Re: I need assitance in passing input parameter from RUN PROCESS command line Hi Mueller, I am looking to this mail from Friday because I got a feeling that if Mueller and LJ responds to a mail it will be resolved no matter what.....and to day morning..I started breathing again....thanks for response.... As you mentioned I have noticed that the "$Change_ID+$" is not getting recognized so what I did is I have changed my Change ID to simple like ChangeID. The log file is capturing the change id perfectly so I debugged it as you mentioned me it worked....the log file is like this <ACTL> /* Mon Jul 11 2011 10:50:18 */ <ACTL> Start active link processing -- Operation - On Return <ACTL> For Schema - CHG:Change_History <ACTL> Linked to field - Change ID+ (1) <ACTL> On screen type - QUERY <ACTL> Checking TEST Active Link 4 (0) <ACTL> -> Passed qualification -- perform if actions <ACTL> 0: Run Process <ACTL> CMD.exe /c " C:\temp\MigrateDataForChangeID.bat " + '$1$' <ACTL> Process: CMD.exe /c " C:\temp\MigrateDataForChangeID.bat " + 'CHG000000076079' <ACTL> Return Code: 1l <ACTL> /* Mon Jul 11 2011 10:50:18 */ <ACTL> Stop active link processing - On Return 1)Do I need to put the ChangeID in single quotes or double quotes... 2)My .bat file is like this can you suggest me do I need to modify any thing.... @echo off set ChangeID=%1 Echo %ChangeID% set Java_Home="C:\Program Files\Java\jdk1.5.0_05\bin\" %JAVA_HOME%\Java -jar RemedyDataMigrator.jar %ChangeID% Pause.. this is giving error in the cmd prompt like this http://old.nabble.com/file/p32039891/07-11-2011%2B10-58-35%2BAM.png My doubt is the ChangeID is passing or not ......can you help me in writing the bat file.... Mueller, Doug wrote: > > From the output you are seeing in the log, the system has not recognized > the > parameter. I suspect if you look at an export file, you will find > $Change_ID+$ > in the definition. You should not see that. If the system recognized > this as > a field, it would have translated the name to an ID in the stored > definition. > > A couple of different possibilities: > > 1) There seems to be an inconsistency in capitalization in your > discsussion > below. > > At the start you show the command line to be ..... $change_id+$ > > In the run example, it echos $Change_ID+$ > > Depending on your database and case sensitivity, these are two > different > names. Do you have your capitalization right? > > 2) The fact that the word is Change_ID+ leads me to believe that this is a > label. Is the DB name of the field you are trying to map the same as > the > label? Definitions in workflow key off the field NAME not the LABEL. > > 3) Have you tried using the field ID instead of a label/name for the field > in question. Something like $988203489$ (whatever the ID is of > course). > > This eliminates all possible confusion about case, name/label, > spelling, or > whatever. > > I hope these offer some pointers to what might be the issue for you. > > Doug > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of gok's > Sent: Friday, July 08, 2011 3:28 PM > To: [email protected] > Subject: I need assitance in passing input parameter from RUN PROCESS > command line > > Hi All, > > I am trying to pass an input parameter from RUN Process which I am using > like this > > CMD.exe/c "C:\temp\MigrateDataForChangeID.bat" $change_id+$ > > I have written the Bat file like this > > @echo off > Set ChangeID= %1 > Set ChangeID = %Change_ID+%(If I hard code the change id here and start > the > bat file it is working) > Echo %Change_ID+% > > set Java_home="C:\Program Files\Java\jdk1.5.0_05\bin\" > %Java_Home%\java -jar RemedyDataMigrator.jar %Change_ID+% > > > > But if I am trying to pass it from RUNPROCESS it is not working as it > should > be. If I check the log file it is like this > > <ACTL> /* Fri Jul 08 2011 15:17:11 */ > <ACTL> Start active link processing -- Operation - On Return > <ACTL> For Schema - CHG:Change_History > <ACTL> Linked to field - Change ID+ (1) > <ACTL> On screen type - QUERY > <ACTL> Checking TEST Active Link 4 (0) > <ACTL> -> Passed qualification -- perform if actions > <ACTL> 0: Run Process > <ACTL> CMD.exe /c " C:\temp\MigrateDataForChangeID.bat" > $Change_ID+$ > <ACTL> Process: CMD.exe /c " > C:\temp\MigrateDataForChangeID.bat" $Change_ID+$ > <ACTL> Return Code: 1 > > can any one suggest me how to pass the input parameter and am I wrote the > correct bat file. > > Thanks > G > > > > -- > View this message in context: > http://old.nabble.com/I-need-assitance-in-passing-input-parameter--from-RUN-PROCESS-command-line-tp32025056p32025056.html > Sent from the ARS (Action Request System) mailing list archive at > Nabble.com. > > _______________________________________________________________________________ > 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" > > -- View this message in context: http://old.nabble.com/I-need-assitance-in-passing-input-parameter--from-RUN-PROCESS-command-line-tp32025056p32039891.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ 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"
