If I'm understanding what you are saying properly, the cmd prompt shows up, but if you 'wait' it closes automatically right?....that's proper procedure....the cmd /c tells the command prompt to start and execute the command after it....it should start, execute it, then close out. If you do 'nothing' and it all ends up the way you want, then there is nothing more to tune. If your problem is with the fact that the window is open for too long, the only option for you is to get faster machines :).
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of gok's Sent: Monday, July 11, 2011 4:31 PM To: arslist@ARSLIST.ORG Subject: Re: I need assitance in passing input parameter from RUN PROCESS command line Hi LJ, Thanks for helping me on this I think I have wrongly written ...after executing the run process command ....the command prompt dialogue box is seen on the client for milliseconds which I don't want it to be like that....what I have to do it. thanks G LJ LongWing (Head) wrote: > > G, > I'm not familiar with a way to execute a command prompt on the client > machine that doesn't show it on the task bar. > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of gok's > Sent: Monday, July 11, 2011 3:50 PM > To: arslist@ARSLIST.ORG > Subject: Re: I need assitance in passing input parameter from RUN PROCESS > command line > > Hi All, > > I want to thank you every one from here wholeheartedly...............I > have > created this Java API first time successfully it is updating the records I > have to work more on it > My process command line is > CMD.exe /c C:\temp\MigrateDataForChangeID.bat $1$ (as Doug > described.....BRAVO...BRAVO :clap::clap: ) > > I have written the .bat file as > > @echo off > Set ChangeID= %1 > Set JAVA_HOME= "C:\Program Files\Java\jdk1.5.0_05\bin\" > > Echo %ChangeID% > Echo %JAVA_HOME% > > "C:\Program Files\Java\jdk1.5.0_05\bin\" -jar RemedyDataMigrator.jar > %ChangeID% > > It worked like charm....one small doubt in this one ....when I am > executing > the workflow on client side I am still able to see the cmd prompt dialogue > box how to get rid of this............. > > > > > > > > > Mueller, Doug wrote: >> >> 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:arslist@ARSLIST.ORG] On Behalf Of gok's >> Sent: Monday, July 11, 2011 11:02 AM >> To: arslist@ARSLIST.ORG >> 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:arslist@ARSLIST.ORG] On Behalf Of gok's >>> Sent: Friday, July 08, 2011 3:28 PM >>> To: arslist@ARSLIST.ORG >>> 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" >> >> > > -- > View this message in context: > http://old.nabble.com/I-need-assitance-in-passing-input-parameter--from-RUN- > PROCESS-command-line-tp32025056p32041687.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-tp32025056p32041952.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"
