Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Issue Summary:

S1T00: [Microsoft][ODBC SQL Server Driver]Timeout expired

Issue Detail:

Description:"FRx Reporting Engine: S1T00: [Microsoft][ODBC SQL Server Driver]Timeout expired" followed by "FRx Reporting Engine: This report yielded no data." received generating FRx report(s).



Reported on Version: 6.5.152



Steps to recreate:
1. Restore the following Solomon application and system db’s: mlb_7447177app and mlb_7447177sys.

2. In FRx 6.5.152 setup a company as follows: FRx Company Code = BVHA Company Name=BVHA Natural Account Length=8 Company ID=BVHA

3. Set the above company as default.

4. Import the TDB file into the spec set used by the BVHA company.

5. Open Catalog ID: 17465 and make sure the report date is set to 8/31/2002.

6. Generate the report.




Expected Results: A timeout error should not occur for queries that run for 30,000 milliseconds; we need to increase this limit if possible to accommodate clients that want to run larger reports.



Actual Results: Receive the following errors during report generation... "FRx Reporting Engine: S1T00: [Microsoft][ODBC SQL Server Driver]Timeout expired" ...followed by... "FRx Reporting Engine: This report yielded no data." In the SQL trace it is noted that the errors are received when queries take longer than 30,000 milliseconds to run.



Work Arounds:


Put the Solomon databases on a SQL server with more resources and the query time will not exceed 30,000 milliseconds.




Status of Resolution:

This issue has been addressed in FRx 6.5.184 (sp5).

This article was TechKnowledge Document ID:5154

TechKnowledge Content

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×