I.T. Discussion Community!
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

October Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardObjectPAL Topic   Print This     

TCursor open errors - random

TCursor open errors - random in ObjectPAL topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: TCursor   TCursor open   TCursor open errors  
Shawn.R
FL USA

Hi, we have a POS application running on Pdox RT version 10 in Win 7 32bit corporate environment and we are running into random TCursor open errors.

The process that runs takes quite some time and is run daily. The tables that we are seeing the issue with are located across the network and are accessed using aliases as you see below. The process works through a couple hundred tables with some tables having roughly 100-200K records. We see the issue on newer, smaller tables as well as older larger tables.

We may not hear from them for a week or 2, then suddenly they start reporting these random TCursor open errors throughout the day during other reporting processes and we have not been able to pinpoint the cause.

We have the same application running on other clients and never see this issue. 

After one of the errors occur, we copy the table over to examine and it opens fine. Table repair also checks out fine as well.

Example:

Nothing fancy, just trying to open a TCursor...

if not gTC.open(":s_gh:gift.db") then

....

endif

Thanks in advance for any input! Let me know if youhave any questions that might help determine the cause.

 Posted 59 months ago (Thread Starter)
Comment Quote
About Shawn.R -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #15261, 1 reply
Thread Started 11/23/2015 5:28:34 AM
View Counter=1301
Last Reply Posted 11/27/2015 8:40:34 AM)
Location=FL USA 
Joined=13 years ago   MB Posts=23  
Most Recent Post
Anonymous Post

Shawn,

My guess would be that the client's networking is dropping the connections to the remote drives over time. 

Do they use WiFi?  A microwave making popcorn in the afternoon can kill this connection

Do they automatically download Windows updates?  If they leave Runtime open overnight, and the server reboots, the clients will have 'unknown' tcusor errors.

What is the specific error you are receiving?  In your open(), do you do an 'errorShow()' right after that?  It will help you narrow down what is wrong.

If this process is only run periodically, you could schedule a Windows backup/zip of the remote files, download them to the Pdox RT computer, unzip them and run your process locally.  This would at least get rid of the network errors, and probably speed up the process considerably.

HTH,

Jim Moseley

---
Jim Moseley
 Posted 59 months ago
Comment Quote

Post ID #15263 (Level 2) and Parent is 15261
Reply Posted 11/27/2015 8:34:27 AM

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P115A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #15261 Counter
1301
Since 11/23/2015

Follow PrestwoodBoards on: 


©1995-2020 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech