Stream nodes Joining Failed

After restarting the JVM, we are seeing JOINING_FAILED status for Stream nodes. We have only one node acting as stream node too.

Error- Runtime exception: Cannot run program “/java/jdk/jre/bin/java” in directory /public/kafka/bin

error-13, Permission denied.

What should i do to fix it?

@Abhishek_Anand

Is the issue still persist? Removing the Kafka data from Stream node and restarting the node would resolve the issue.

@KishoreSanagapalli Yes that’s correct. Although the error is a bit deceiving. We truncated few tables and cleared the kafka-data folder and node status got back to NORMAL. Thanks

@Abhishek_Anand

Thanks for the update. Please mark the solution as accepted.

@Abhishek_Anand Can you please provide me list of table that you turncated.

@VishantK16773345 Please refer below link for more details.

Operating the Stream service | Pega

truncate table pr_data_stream_nodes

truncate table pr_data_stream_sessions

truncate table pr_data_stream_node_updates