|| Error Message in SQL Data Window
|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.
|Can you email me a cut and paste of a query you are trying to run that results in the error message?|
"------ Original message------
From: jeff @ jcapper . com
Date: Sat, 4/19/2014 1:08 PM
To: ......... ;
Subject:Re: Screen Prints of Error Message
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...
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?
No (apparent to the human eye) loss in speed.
Let me know if the problem pops up again.