DSXchange

Any idea what changed to make this start, O/S patches perhaps? Another suspect might be anti-virus. But I would think in either case a re-install would get you back on track. I would try it one more time but this time nuke it from orbit, it's the only way to be certain. :wink: Specifically: 1. Unin...

My installation always worked very well, from a few days to here DataStage Designer opens the job, I can open some stage, I edit that and when I give ok to compile the datastage it close and the job stay lock. Has anyone had this problem? I already uninstall and re-install and it did'nt fix the prob...

Let's do that! :D

Just use the number, don't include the word 'event' on the command line. ... Thanks a lot Chullet, now work! :D dsjob -server myserver -user myuser -password mypassword -logdetail DWProjetoDBM Load_FTP_DSwitch 2 Now, my problem is make a routine that get all log entries and put it in a txt file. Re...

Forget about 'jobid', it is not needed and only useful if you've assigned a job an 'alias/id' which not many peoples do, I'd wager. You missed the eventid which caused the syntax error. AFAIK, you need to get a list of event ids and then loop thru them getting the detail for each one. Now, I've nev...

That should be - as already noted - that you are using logsum rather than logdetail... yes? ... Yes, I was using -logsum! But .. My Project = DWProjetoDBM My Job = Load_FTP_DSwitch When i tryed to use the command: dsjob -server myserver -user myuser -password mypassword -logdetail DWProjetoDBM Load...

Just leave out (omit) the -type option to get all types. ... Hi Ray! Worked, but omitting the -type option I haven't the complete Message, for example: The complete message for the event 10 is: Load_FTP_DSwitch..D_SWITCH: SELECT S.SWITCH_KEY SWITCH_KEY, S.DESCRIPTION DESCRIPTION, S.CNL CNL, S.SWITC...

Use the following command and fill in the server name, user and password and remove the << and >>. C:\Ascential\DataStage\Engine\bin\dsjob -server <<Your Server>> ...[/quote] Now, worded with the following command: C:\Ascential\DataStage\Engine\bin>dsjob -server myserver -user myuser -password mypa...

DSguru2B wrote:Try giving the server name, user name and password explicitly in the command. ...

Sorry, but looking the dsjob sintax I did'nt see where i need to put server name, user name and password.

Regards,

Fernando

Hi, I'm trying to copy the complete(INFO | WARNING | FATAL | REJECT | STARTED | RESET | BATCH) log into a txt file and I'm having the following error: ERROR: Failed to open project Status code = 39204 My Project = DWProjetoDBM My Job = Load_FTP_DSwitch My Txt_target = C:\temp\test\DWProjetoDBMLog.tx...

chulett wrote:From a Routine Activity stage, sure. Inside the routine use DSExecute and then remove any @FM before returning the result. ...

:D now is working!!!

Thanks a lot!!

Fernando

Probably an issue because you are still running 7.1. :cry: Since you can't do this directly in the Sequence job, you'll need to do all of this work inside a routine and make sure what you pass back as the 'Ans' has been properly cleansed there. Weel, is it possible from a "Job Activity Stage&q...

Thanks a lot, but it doesn't work to me!

The only thing that I'm able to see is:

Job parameter names must begin with an alphabetic character and consist of alpha-numerics and underscores only. If you wish to use a literal value, these must be quoted(").

Fernando

The Power of Search can help! Search for "ParamValue/Limitvalue is not appropriate" and all will be revealed. :wink: ... I saw that I need to use something like Field(Execute_Command_4.$CommandOutput,@FM,1,1) but anything different from Execute_Command_4.$CommandOutput the datastage give ...

You don't "store" it, the next job can pick up the $CommandOutput variable from the Execute Command stage for example. ... To try this solution I: 1 - create 2 files - file1.txt -In file1.txt I have writed "worked" - file2.txt -In file2.txt I do not have anything writed. 2 - cre...