Originally posted by: johnxp

Hi, anyone can help please.

I turned on all audit and trace log in map, it worked in design studio (v8.3), and I can find all (audit, trace and dbl) logs were created.

However, when I run it under launcher (Event server), only audit and trace logs are created, dbl log is missing. Re-generating msl file does not help.

Originally posted by: paul.brett

The database adapter log is produced with the -T on the adapter command line.  Perhaps you are using an override on the adapter command line in the Integration Flow Designer, and forgot to put the -T in there?

Thank-you.

Paul.

Follow me on Twitter

Originally posted by: johnxp

Hi Paul,

I am using below the command line in first map: Map1, and setup Map1 in MSL file, and it's working fine until I made some changes (not the command line) in Map1 and Map2.

=RUN("Map2.mmc",
             " -IE1S" + NUMBERTOTEXT(SIZE(Data)+2) + " " + PACKAGE(Data) +
             " -ADEB+=..\Logs\Maps -TIO=..\Logs\Maps")

And DBQuery:

DBLOOKUP("SELECT ID from Table1 where ID = 1 ", "-MDQ ..\MDQ\MyDB.MDQ -DBNAME MyDB -TRACE+ ..\Logs\Map2.dbl")

Both Map1.dbl and Map2.dbl were not created, even I re-gened the MSL file.

Any suggestion?

Thanks.

Originally posted by: paul.brett

Why would you expect a Map1.dbl?  Nothing you have shown me indicates that you have activated a database trace for Map1.

I do not like the look of your SIZE calculation for your input echo override:

-IE1S" + NUMBERTOTEXT(SIZE(Data)+2)

What is the +2 for?   This makes no sense.

Could you switch to using the newer ECHOIN() syntax?

=RUN("Map2.mmc",
             ECHOIN(1, PACKAGE(Data)) +
             " -ADEB+=..\Logs\Maps -TIO=..\Logs\Maps")

Thank-you.

Paul.

Follow me on Twitter

Originally posted by: paul.brett

Also, add a LASTERRORMSG + " " + LASTERRORCODE() pair of unctions to both your RUN() call and your DBLOOKUP().

Thank-you.

Paul.

Follow me on Twitter

Originally posted by: johnxp

Thank you for your advice, I changed the code accordingly.

I also used DBLOOKUP in Map1 somewhere, that's why I expected Map1.dbl created.

Whatever I changed the trace flag, dbl logs still not created.

Originally posted by: paul.brett

...and the result of the LASTERRORCODE() and LASTERRORMSG() functions?

My guess is that either the MDQ cannot be read, in which case you'll get:

-10003 Failed to open file

....or perhaps you're using a database adapter for which you do not have the client driver libraries, in which case, you might see:

-1027 Failed to load shared library

Neither of these errors would produce a database adapter trace (because the adapter was not initialised).

Thank-you.

Paul.

Follow me on Twitter

Originally posted by: paul.brett

Also, a 'bad' path/filename combo could result in the database log not being created.  Are you sure you have permissions to either create or append to the file you have specified?

Thank-you.

Paul.

Follow me on Twitter

Originally posted by: johnxp

I am not getting any errors. the maps are working fine, no issues, only the dbl logs were not created.

The only changes I did is I change some mapping rules and rebuild the maps.

Originally posted by: paul.brett

I think you require more help than can be provide here on developerWorks, and I recommend you open a PMR with IBM.

Thank-you.

Paul.

Follow me on Twitter