if this is your pawn, and if the actor is first person, you are not going to see any spark.
instead, try do like in Epic’s blueprint tutorials, first get a location that is fixed(ie just input some number that was above ground and near your PlayerStart), and then find a way to get/generate location that you want.
second, when you spawn emitter, if you checked auto destroy, that means they only emit once and then self destruct, and if you want to destroy emitter you need to connect “return value” from spawn node to destroy node’s “target” input, otherwise it will try to destroy whatever this current Blueprint’s instance(which is “self”).