[SOLVED] use al_engine.exe to import ATL file - Logs?

dataservices administration
1

Hi all,

I tried to use the al_engine.exe to import an ATL file into my repository.

I used this syntaxe:

al_engine -Uuser -Ppassword -Ssqlservername -NMicrosoft_SQL_Server –Qsqlserverdatabasename -f/location/file_name.atl

It’s working great.

My question is about the log. When I execute my command, I have no message to see if the import of my atl file was successfull…
Do you know if I can find this information? If yes, Where? Is there a specific parameter to define the output path of the log file?

Do you use this command line? How do you deal with that??

Thanks in advance for your help/inputs!

cedrickb :fr: (BOB member since 2005-08-19)

2

I think it prints a message on the stdout, if there are errors or warning while importing the obejct, these will be logged indefault log files %DS_COMMON_DIR% or LINK_DIR%\log folder in tracelog.txt and errorlog.txt

manoj_d (BOB member since 2009-01-02)

3

Yes we do that and we redirect both stdout and stderr to a txt file and it works great (we do that for about 1000 jobs)

Regards

Armando

amanzali (BOB member since 2013-07-24)

4

Hi everyone,

Thanks for your reply!

Amanzali, how do you redirect the stdout??

thanks in advance!

cedrickb :fr: (BOB member since 2005-08-19)

5

I’m sorry, i get confused with the upgrade command which does not have a standard log.

For importing we use this sintax

al_engine -Uuser -Ppassword -Ssqlservername -NMicrosoft_SQL_Server –Qsqlserverdatabasename -T-1 -l"logfile.log"  -z"errorfiel.log"

The “-T” parameter sets the trace level.

You can redirect stdout and stderr by adding

> "stdout_stderr.log" 2>&1

For a list of al_engine parameters simply run “al_engine” from command line without arguments

Hope this helps

Regards

Armando

amanzali (BOB member since 2013-07-24)

6

Thanks Amanzali!!

I tried to run the command al_engine.exe but could not find what I was looking for :oops:

thanks for your help!

Have a great week end ! :cheers:

cedrickb :fr: (BOB member since 2005-08-19)