Point tot point distance gives error message

Question

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

curtvprice · Answer

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.)

PuzhenWang · Answer

that works, thank you!

PhilippeVan_De_Vreken1 · Answer

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