I use basting spray for every quilt... going on 80 quilts...I've used 505 a few times, but keep going back to June Taylor. I think it's a little stickier, and I can use less spray to get the same outcome. I use a poly blend batting, and spray the batting, not the quilt top or back. I've noticed problems when I use smooth-backed minky for my backing. I simply won't stick sometimes. Then extra pins are needed.
Several months ago, I started a new can of spray and it simply wouldn't stick. I tried spraying some on my hand, and found it cold from the propellant, and oily, but not sticky at all. I returned this can to the store, and they happily replaced it with a new can from the shelf.
I hope you figure out what combination of fabric, batting and pray caused your problems. I love basting with spray. If I had to pin every quilt, I'd probably quit quilting.