Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
User Experience
Lawson Add-Ins for Microsoft Office
Timeout in ADDINS
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Jessica
Past 24 Hours:
2
Prev. 24 Hours:
0
Overall:
5164
People Online:
Visitors:
255
Members:
0
Total:
255
Online Now:
New Topics
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson Add-Ins for Microsoft Office
Timeout in ADDINS
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Jim Howerton
New Member
Posts: 6
8/8/2007 1:48 PM
The size of our tables seems to have reached a point where most queries run through ADDINS times out. Does anyone know of a setting that controls the amount of time a query may run before it fails with a timeout?
This also occurs using the OLEDB drivers and Crystal.
John Henley
Senior Member
Posts: 3348
8/8/2007 6:08 PM
You can set a timeout for the Addins by clicking the button with the green/yellow arrows
Attachments
18884394071.jpg
John Henley
Senior Member
Posts: 3348
8/8/2007 6:25 PM
You should be able to control the OLEDB timeout in Crystal when setting up the Data Source, but I haven't tested that this actually works...
Attachments
188255192471.jpg
Jim Howerton
New Member
Posts: 6
8/9/2007 1:44 PM
My thanks. I suppose a user guide might be of some help.
k-rock
Veteran Member
Posts: 142
8/10/2007 5:10 PM
Try setting the timeout value to 0. In access, that means that there is no timeout. This will eliminate guessing as to what an acceptable time limit is. It may allow queries to run forever also.
John Henley
Senior Member
Posts: 3348
8/10/2007 5:37 PM
I think in the Excel Query Wizard you can't enter 0 for the timeout--it is a minimum of 30 and max of 9999, which should be good enough. If you can't get results in that time, something must be wrong...
martingibbs
Basic Member
Posts: 18
12/6/2010 1:50 PM
Our users are having issues with saved queries not keeping the timeout value. Has anyone seen this? They set it to, say 500, but when they save the query and re-open, the value is gone.
stephanie
Veteran Member
Posts: 330
12/6/2010 3:02 PM
Although it's not the same issue, when microsoft updates are applied to my machine, I always have to repair my add-ins. For whatever reason, my upload wizard won't display product lines. When I repair the software, all of my time out settings disappear. Are you possibly sharing the dme's? Or do your users have their own?
Greg Moeller
Veteran Member
Posts: 1498
5/20/2011 7:53 PM
Stephanie: (and others)
I found by almost opening a case with GSC an article that says to set the timeout somewhere between 1 and 999. Save Preferences. Exit Add-Ins. Re-launch. Product lines then appear in the Upload wizard.
Maybe repairing the software may be easier for you, but our users are running off of Citrix servers and there is no way for them to repair the software.
Funny thing is, it didn't show up in the KB until I "almost" opened a case. Must be more articles available to you through the CASE tool than just regular myLawson??
You are not authorized to post a reply.