Point tot point distance gives error message

[PhilippeVan_De_Vreken1]

Hi folks,

I have a problem with the 'Point Distance' tool to determine the distances from input point features to all points in a second point feature layer. After starting the tool, I always get the following error message: "Error 999999: error executing function". Both feature layers have the same projected coordinate system and are rather small (4 records in the input feature layer and 73 records in the near feature layer). I really don't get the problem.

Does anyone know what can cause the error message and how can I solve this?

Many thanks!

Phil

[ViktorZhong]

I had the same problem when I tried 'point distance'. It seems the problem has something to do with where you save the output. I totally have no idea why, but when I created a new file geodatabase under the desired directory and saved the 'point distance' output in the geodatabase, it worked.

[curtvprice]

Sometimes 999999 errors are quite mysterious. However, I have found they often have to do with the output paths or field names being invalid for the output workspace. For example, if you chose dbf output (folder workspace) instead of geodatabase, the field names (which are based on your input) may have not been valid for dbf. (Geodatabase tables  allow longer field names and more 'unusual' table and field names.)

[PhilippeVan_De_Vreken1]

Indeed, now it works! Thank you so much!!!

[PuzhenWang]

that works, thank you!