Error Create Pipe Two Points!

Here is my query with my script.

I can place the sprinkler at end of the pipe. Struggling to connect with that pipe.