Added support for Dynamics 365 Local Business Data (aka On-Premise ) - Doesn't work!

[macchinettid]

Hi,

I'm trying the new PERF version on a F&O LBD Implementation.

I notice that the SYSTRACETABLESQL table from the AXDB Database are not filled out.
I run the script "DynamicsAX Client Tracing" and set the a low QUERY_TIME_LIMIT, like 500 ms.

So, it seems that the AX Queries are not triggered.

Any insights?

Thank you

[Alexander-Weurding]

Let me check it! Best Regards Alexander www.perfxit.com

…

On Sat, Mar 16, 2019, 18:02 macchinettid ***@***.***> wrote: Hi, I'm trying the new PERF version on a F&O LBD Implementation. I notice that the SYSTRACETABLESQL table from the AXDB Database are not filled out. I run the script "DynamicsAX Client Tracing" and set the a low QUERY_TIME_LIMIT, like 500 ms. So, it seems that the AX Queries are not triggered. Any insights? Thank you — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#10>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AFrlpAenoK1zxpNVtiwG19Oi37J9eAgRks5vXSORgaJpZM4b36ng> .

[macchinettid]

Thank you Alexander!

[Alexander-Weurding]

No problem! always glad to help. What outcome did you have when running the " DynamicsAX Client Tracing" script ?

…

On Sat, Mar 16, 2019 at 7:19 PM macchinettid ***@***.***> wrote: Thank you Alexander! — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#10 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AFrlpBhxparqV4FMKUFJnOA6KJAOLiR7ks5vXTXBgaJpZM4b36ng> .

-- Groeten Alexander

[macchinettid]

any particular message.
Usually message like:

(1 row(s) affected)
UPDATE [XXXXX].[AXDB].dbo.USERINFO
SET QUERYTIMELIMIT = 1,
DEBUGINFO = DEBUGINFO | 256,
TRACEINFO = TRACEINFO | 2048 WHERE ID = 'XXXX'

(1 row(s) affected)

[macchinettid]

As you see, I had set 1 ms in order to check if some lines was triggered on SYSTRACETABLESQL table, but nothing.

[Alexander-Weurding]

That's not good! let me check.

…

On Sat, Mar 16, 2019 at 9:53 PM macchinettid ***@***.***> wrote: any particular message. Usually message like: (1 row(s) affected) UPDATE [XXXXX].[AXDB].dbo.USERINFO SET QUERYTIMELIMIT = 1, DEBUGINFO = DEBUGINFO | 256, TRACEINFO = TRACEINFO | 2048 WHERE ID = 'XXXX' (1 row(s) affected) — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#10 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AFrlpNRHxKbru5rl6hkSXNg3ECapgJjyks5vXVnAgaJpZM4b36ng> .

-- Groeten Alexander

[Alexander-Weurding]

My skype = alexander.weurding just add me. I always love a good challenge!

…

On Sat, Mar 16, 2019 at 9:54 PM macchinettid ***@***.***> wrote: As you see, I had set 1 ms in order to check if some lines was triggered on SYSTRACETABLESQL table, but nothing. — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#10 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AFrlpP9suho01Zuz24wqCcVbxdpM_8KUks5vXVoBgaJpZM4b36ng> .

-- Groeten Alexander

[macchinettid]

Added

[Alexander-Weurding]

Perfect! Time for some ninja troubleshooting :P

…

On Sat, Mar 16, 2019 at 10:00 PM macchinettid ***@***.***> wrote: Added — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#10 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AFrlpN1SoZzj3vmM911S1q4dwEiriqo7ks5vXVtggaJpZM4b36ng> .

-- Groeten Alexander