improve error handling of substreams powered subgraphs #9013

Job	Run time
Clippy linting	3m 12s
Run integration tests	10m 30s
Build in release mode	2m 48s
Subgraph Runner integration tests	8m 13s
Check rustfmt style	4s
Run unit tests	7m 33s
	32m 20s

Provide feedback