JCapper Message Board

JCapper 101
-- Error Message in SQL Data Window

Home	Register Log In

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

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

.

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

.

JCapper Message Board

JCapper 101 -- Error Message in SQL Data Window

JCapper 101
-- Error Message in SQL Data Window