INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

S1T00Timeout

S1T00Timeout

(OP)
I have a VB.net application with 9 forms. They all pull Data from multiple Pervasive Databases on the Same Server using PCC V10.
I'm Using the ODBC.
When Retrieving all data from one table I get a time out error.
I should also tell you that all the databases except the one that contains the table causing the error were not created by me, the other DB belong from another application.
The Only difference the tables I created has an indexed Column and the tables from the other DB don't.
This is error I'm receiving.

RE: S1T00Timeout

Does the table have any indexes? What type of query are you running? Does it have any restrictions (WHERE clauses)?
One thing you can try is to change the Command and Connection Timeout options. The default is 30 seconds. Changing the option to 0 will disable it and let the query run to completion regardless of how long it takes.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: S1T00Timeout

(OP)
Thanks Mirtheil for your reply.
Yes it has one column index, and yes it has many restrictions.
Can the timeout be altered with code if it can how can I do it.

here is the query I'm using
SELECT log.OE,log.Link,log.userini,log.process_Value,log.process,log.Log_Date,Log_time,live.ORDD_Description,
SOH.CUST_PO_NO ,wb.Mask as Lot,log.department,w.ORDfrmServ,w.reqdaterev
FROM PcLog.PROcess_LOG AS Log,CWLIVE.SALES_ORDER_DETAIL AS Live,CwLiveWB.ORDE_WB_MASK AS WB,cwlivewb.ORDE_WB_Main AS w,
CWLIVE.Sales_Order_Header AS SOH
WHERE Live.BV_GUID=log.Link AND wb.Field_Name='Lot' and wb.ORD_ORDER_NO=Log.OE AND w.ord_Order_NO=log.OE AND SOH.Number=LOG.OE
ORDER BY Department

RE: S1T00Timeout

What field is the index on? Ideally you would at least have an index on the Live.BV_GUID and log.Link fields.

How long does the query take using Pervasive Control Center executing into "Text"?

The connection and command timeouts are properties of the Connection and Command objects you are using in code (PsqlConnection / PsqlCommand, OdbcConnection / OdbcCommand, etc).

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: S1T00Timeout

(OP)
The only table that has Indexes is the Log table and it isn't in the query.
Regarding the time it takes for PCC to execute the query into text I will reply tomorrow when I try.

RE: S1T00Timeout

(OP)
PCC takes 2min to exe the query into text.
The application Times Out at 31sec.

RE: S1T00Timeout

It's the COnnection or COmmand timeout. You need to set those in your code to something either higher or 0. I would start with the Command Timeout and then the COnnection Timeout.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close