SmartView timeout crashes GP
doncarver asked 7 years ago
The same search in SmartList takes the same or longer time to process, but it doesn't time-out, and it does return the few rows expected.
I didn't see anything meaningful using the GP Support Debugging Tool.
Please help; looking forward to purchasing and using SmartView successfully,
Don.
Nicole answered 7 years ago
DonCarver replied 7 years ago The SQL trace does not show a time-out. And the only error in the event log is an Unhandled Exception in the Application Log:
Faulting application name: Dynamics.exe, version: 11.0.349.0, time stamp: 0x4d9b8c91
Faulting module name: KERNELBASE.dll, version: 6.1.7601.18409, time stamp: 0x53159a86
Exception code: 0xe0434f4d
Fault offset: 0x0000c42d
Faulting process id: 0x1744
Faulting application start time: 0x01cf6f757655e0eb
Faulting application path: C:Program FilesMicrosoft DynamicsGP2010Dynamics.exe
Faulting module path: C:Windowssyswow64KERNELBASE.dll
Report Id: 6a2379a6-db69-11e3-ae4d-bc305bba15d6
After a few attempts, probably due to SQL optimization during the repeated queries, SV does return results without faulting.
Nicole answered 7 years ago
DonCarver replied 7 years ago The SQL statements from the Trace return appropriately when copy/pasted into SSMS. I phoned support and never got a callback from whom they referred my issue…I'll try the support email. Thanks for the suggestions!
Nicole replied 7 years ago We have contacted you through the support case.
For others reading this forum, we will post the resolution when complete.
Billc replied 7 years ago Hello, I am having similar issue. Has this been resolved? Thank you,
Bill
doncarver replied 7 years ago No. From the prior forum response, EOne evidently opened a support case for this, but I haven't been contacted by them.
We did go ahead an purchase SV…it works most of the time…we still crash out of GP if the search runs long. All my SQL traces showed no errors on the SQL side, and the queries run to completion if copied/pasted/executed in SSMS, so it would appear that it crash is caused by SV. If I repeat the query a couple times, such that SQL Server has optimized/cached data to the point where subsequent calls are "more efficient", SV does not crash.
Billc replied 7 years ago I think you are correct about timeout issue. I have one that returns top 1000. That causes the issue. Reduced that to 10, and no issue. Changed it to 100, and issue returns.
Look forward to the answer.
Thanks,
Bill
wahlga replied 7 years ago Has this been resolved yet? We have several smartlists that cause GP to crash and these seem to be either ones that return a lot of rows or ones that may take some processing before returning any results. I have been in contact with support but I saw this thread and wondered if it may have been resolved.
doncarver replied 7 years ago Unfortunately, I have never received any resolution to this.
billc replied 7 years ago Our vendor has requested the fix, whatever that is, and eOne has not responded yet.
Jared replied 7 years ago We are currently working on the issue. At this time we do not have a fix, but we will let you know as soon as we do. Thank You.
Jim replied 4 years ago I know this issue is old, but is there any update on a resolution? We’re still running into this with GP2015 and SV 14.0.6
Patrick Roth Staff replied 4 years ago Assuming the issue is really a query timeout, then think we can resolve:
In your dex.ini, add the line:
SMARTVIEW_COMMAND_TIMEOUT=xxxx
where xxxx is the number of seconds you want to allow long running queries to run.
You could be able to set it to 0 which means “infinite”. Not desirable necessarily since a long running query will run and run. But it does beat crashing GP I suspect.
Reply back and let me know if that fixes it.