ExecuteError: ERROR 999999 with “PointsToLine” function with a Point Feature class created by “MakeRouteEventLayer_lr”

Question

I have an issue with the "PointsToLine" function in Python arcpy and in the tool dialog, the problem comes everytimes I use a POINT Feature Class (FC) created from the "Make Route Event Layer" function (Linear Referencing).

All the properties seem to be the same as a regular (working) POINT class, but the error keeps prompting with such created FC. Is there something I am missing? Is this a known issue? Is there a workaround for this?

Here is my simplified code to generate the Point FC used for the "PointToLine" function:

import arcpy

table_points_TEST = "C:\\ArcGIS\\Test.gdb\\TEST_TABLE_TO_LINE"
axe_repere = "C:\\ArcGIS\\Test.gdb\\AXE_REPERE"
table_points_TEST_TEMP = "C:\\ArcGIS\\Test.gdb\\TEST_TABLE_TO_LINE_TEMP"
FC_point = "C:\\ArcGIS\\Test.gdb\\FC_POINT"
FC_line = "C:\\ArcGIS\\Test.gdb\\FC_LINE"

arcpy.MakeRouteEventLayer_lr(axe_repere , "AXIS_NAME", table_points_TEST, "AXE POINT M_POINT", table_points_TEST_TEMP)
arcpy.CopyFeatures_management(table_points_TEST_TEMP, FC_point)

arcpy.PointsToLine_management(FC_point,FC_line)

If I use the Point layer generated by the "CopyFeatures" in the "PointToLine" tool dialog, the same error occurs.

Answer 1

If you look at the SYNTAX section of the help file for this tool the fifth parameter is a "layer stored in memory".

In your code you have given a location for a FeatureClass using the variable table_points_TEST_TEMP and not an in memory layer name.

If you scroll down to the CODE SAMPLE section you can see examples of how to run this tool and the correct parameters. In your case I believe you need only provide a layer name (you are not defining a source), you create a permanent copy of this using the Copy Feature tool.