AX2009 AOS Trace --> AX2012 Trace Parser wont show SQL tab?

(0) Share

Report

Posted on by Manu Laakkonen

100

When taking AX2009 AOS traces and importing those to AX2012 Trace Parser, it wont show any SQL-commands from any sessions? AOS account belong to Performance Log Users and all rest stuff (X++ call tree) is working okay in Trace. Tried to enable all check boxes on AOS-configuration and verify that those exist on registry also. Restarted AOS-server. Still no luck. Any ideas how to get it working?

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Martin Dráb 237,990 Most Valuable Professional on at

Like (0)

Report

Have you switched the display to a server session (ax32Serv.exe)?

Was this reply helpful? Yes No
Manu Laakkonen 100 on at

Like (0)

Report

Cannot see any server sessions... For some reason, trace files are only 3072 KB, even taking long time trace.

Was this reply helpful? Yes No
Martin Dráb 237,990 Most Valuable Professional on at

Like (0)

Report

If you don't have any trace from AOS, you won't see any SQL tab.

It seems to be a problem with the trace file, not with Trace Parser. You said it's a trace from AOS, but are you sure? If so, review your trace configuration on AOS.

Was this reply helpful? Yes No
Manu Laakkonen 100 on at

Like (0)

Report

Yeah, everything seems to be okay. Trace just does not contain any DB-call information from any sessions. I never faced problem like this before. Maybe I'll need to contact MS support.

Was this reply helpful? Yes No
Martin Dráb 237,990 Most Valuable Professional on at

Like (0)

Report

No. you said that it doesn't contain server sessions at all, not just SQL queries. Or do you want to update what you said before?

Was this reply helpful? Yes No
Manu Laakkonen 100 on at

Like (0)

Report

To clarify, I can see user sessions from trace, but no SQL-call information from any sessions. I can see X++ code tree, but no SQL-sended from AOS to SQL-server.

Was this reply helpful? Yes No
Manu Laakkonen 100 on at

Like (0)

Report

And here is trace settings..

Was this reply helpful? Yes No
Martin Dráb 237,990 Most Valuable Professional on at

Like (0)

Report

SQL tab is shown for server sessions (ax32Serv.exe) only. If you don't have server sessions in your trace file, you won't ever see any SQL. If it's the case, stop bothering about SQL and start solving the real problem - why you haven't collected any server traces. It's a very different problem than if you had server sessions without SQL (which can happen as well, but it's not your case if you say that you "cannot see any server sessions").

Ensure yourself that you've loaded both the client and the server trace. Also check this article for a setup checklist and troubleshooting advice.

Was this reply helpful? Yes No
Manu Laakkonen 100 on at

Like (0)

Report

AX2009 trace looks a bit different than trace taken from AX2012. There is no ax32serv.exe process sessions or ax32.exe sessions directly seen like AX2012 trace file has.

For this issue it looks like now I'am getting a trace with SQL. Problem seems related to registry values of current active server configuration and (default) configuration. Just saving AOS trace depended registry entries with same settings as those are already set by AOS Server config Tool I can get Trace with SQL-tab on on this environment. (traceallowclient=1,traceeventsenabled=1;100;101;202;203;204;205,tracemaxfilesize=1024 and switching once sqltrace=0-->1)

Was this reply helpful? Yes No