I am glad you are getting the ID into your batch file now. From the screenshot of the error is looks like it can't find your .jar file.
In the batch file you may need to change to the directory where the .jar file is located (or put the full path of the .jar file in the java command line) @echo off set ChangeID=%1 Echo %ChangeID% set Java_Home="C:\Program Files\Java\jdk1.5.0_05\bin\" cd "location of .jar file" %JAVA_HOME%\Java -jar RemedyDataMigrator.jar %ChangeID% Pause.. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of gok's Sent: Monday, July 11, 2011 1:02 PM 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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
