How can we help you today? How can we help you today?

Error: missing IDX file

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
Greg
0

Comments

2 comments

Sort by
  • 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.
    sam.blackburn
    0
  • gschaefer
    Thank you - so far it is looking good!

    Regards,
    --Greg
    gschaefer
    0

Add comment

Please sign in to leave a comment.