Error: missing IDX file

gschaefer

Hi,

We have a job that runs daily, comparing the data between two databases and then processing the differences.  Lately, we have been getting the following error during the run:

Error: Comparison of 'server\ecom.Puritan_Catalog' and

'server\ecomxt.Puritan_Catalog' failed: Could not find file

'C:\Windows\TEMP\Red Gate\SDC_d0a2c175d12449eaa61e7f430d53bcab.D.idx'.

(null)

Any ideas on what could be causing this?

We are running SQL Data Compare v. 11.3.0.7 professional

Thanks for your help!
--Greg

sam.blackburn

This is a temporary file which is normally deleted when SQL Data Compare exits (or when you close the project when using the GUI).  My guess would be that a cleanup utility running on the same machine has deleted the file while it was in use. 

If you have difficulty identifying the process that is doing this, an alternative solution would be to set an environment variable called RGTEMP, which will tell SQL Data Compare where to store such temporary files. 

gschaefer

Thank you - so far it is looking good!

Regards,
--Greg