Database Handicapping Software- JCapper

JCapper Message Board

          JCapper 101
                      -- Error Message in SQL Data Window

Home Register
Log In
By Error Message in SQL Data Window
NYMike
4/19/2014
10:05:29 AM
I am getting an error message when I try to start a new data window query in SQL mode. It reads: 2147467259 Not a valid bookmark.

Sometimes it works and sometimes it errors out but it is happening more now. It doesn't happen if I run an existing UDM.

Thanks,

Mike

Reply
jeff
4/19/2014
11:08:05 AM
Can you email me a cut and paste of a query you are trying to run that results in the error message?


-jp

.



Reply
jeff
4/21/2014
10:21:55 AM

--quote:
"------ Original message------
From: jeff @ jcapper . com
Date: Sat, 4/19/2014 1:08 PM
To: ......... ;
Subject:Re: Screen Prints of Error Message

Two possibles...
1. What happens if you first run a Compact and Repair on the JCapper2 file? (Do you still get the error msg afterwards?)
2. How many core processors does the machine have? If it has 8 processors, you might google the phrase "set affinity" (without the quotes) - and from there, try going into Task Manager and setting affinity for the Data Window so that it runs on a single processor only.
Let me know...
Jeff
--quote:
"



-jp

.


Reply
jeff
4/21/2014
10:24:44 AM

--quote:
"Jeff
So far the compact and repair is working which is odd because I have been running a build in mode 5 each day. If it zots out I will change the affinity. Will that slow anything or have a negative impact?

Thanks,"
--end quote


No (apparent to the human eye) loss in speed.

Let me know if the problem pops up again.


-jp

.


Reply
Reply

Copyright 2018 JCapper Software              back to the JCapper Message Board              www.JCapper.com