Question
Proximus
BE
Last activity: 8 Apr 2024 3:56 EDT
Decisioning > Infrastructure > Services > Stream: Where's stored this info?
Hello, I would like to know where's stored stream node info.
- This is what you can see in Decisioning > Infrastructure > Services > Stream
When we refresh one environment with DB from another environment, for some PEGA versions, Stream nodes from source are not automatically cleared and system complaints and sometimes blocked.
Before starting the env, all Stream tables are cleared same for the whole pega temp dir (which contains kafka content) but still the reference of Stream Node from source remains.
Any idea where this info is kept?
Thank you
Regards
Anthony
Accepted Solution
Updated: 8 Apr 2024 3:56 EDT
Pegasystems Inc.
BR
When performing a DB clone from another instance, you need to truncate the below tables which contain references from previous nodes from the cloned instance:
truncate table pegadata.pr_data_stream_node_updates;
truncate table pegadata.pr_data_stream_nodes;
truncate table pegadata.pr_data_stream_sessions;
truncate table pegadata.pr_sys_statusnodes;
truncate table pegadata.pr_sys_statusdetails;
truncate table pegadata.pr_sys_serviceregistry;
truncate table pegadata.pr_sys_serviceregistry_kvs;
You should also remove Kafka-data and Kafka distribution folders as they contain metadata information (stream node ID and cluster ID) from the cloned system.
Proximus
BE
thanks !
Seems I was missing the service_registry tables.
Rest was already done
I'll check when possible and I'll let you know
Regards
Anthony