Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error 1113 on Requery()
Message
From
29/05/2013 18:20:35
Al Doman (Online)
M3 Enterprises Inc.
North Vancouver, British Columbia, Canada
 
 
To
29/05/2013 16:58:22
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01575077
Message ID:
01575083
Views:
90
>I've got a weird situation. Hoping it'll ring a bell for someone. A client has an application based on the Mere Mortals framework. In the midst of doing a large processing piece (not sure how large overall, but the repro up to the error takes 45-60 minutes), it fails with error 1113.
>
>The line that's triggering the error is a Requery() of a local view. Immediately before the Requery(), I've added code that confirms that the view itself is open. (And I just checked: the error that shows up when you try to Requery() a view that's not open isn't 1113.)
>
>This error occurs after processing tens of thousands of records from a cursor. It's reproducible, always failing on the same record. But as I said, it's a cursor, so table corruption seems extremely unlikely. Also, the client says that it reproduces only with the EXE, not in the IDE. I haven't tested this case because I don't know the app well enough.
>
>Anybody ever run into 1113 and have any ideas?

As you point out, the symptoms seem somewhat contradictory so I'll just throw some ideas out there - no particular order.

Is real-time antivirus scanning running? If so, can you test with it disabled, or set to not scan VFP data and temp file folders?

If it repeatedly falls over on the same data, I'd take a hard look for corruption in the underlying tables and/or indices. I've seen weird problems caused by CHR( 0 )s in table fields, especially if index tags depend on those fields.

Are there any database triggers etc. in place?

Any intermediate or other cursors being used that are SELECTed without NOFILTER?

Tried using SYS( 1104 )?

IDE vs. EXE - are those tests being run on the same machine with the same user account? If a different account, maybe different permissions to temp file folders etc. Speaking of temp files, are Windows and VFP temp file folders clean? I've seen weird problems when thousands of orphaned temp files build up in those folders.

ISTR Thomas Ganss has done a lot of very heavy munging with VFP, and that he has found it's necessary to limit VFP's use of RAM, especially on machines that have a lot. I faintly recall he recommended a figure that seemed rather low - maybe 512MB for foreground ( ? ) - Thomas, can you confirm? UPDATE: Message#1554862 but I think he found reliability reasons too.

Some network connections with some versions of Windows will time out after a certain period of disuse. If you have a process that's running 45 - 60 minutes is that a possibility?
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Reply
Map
View

Click here to load this message in the networking platform