Decisioning > Infrastructure > Services > Stream: Where's stored this info?

General
, , ,
1

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

2

@Anthony_Gourtay

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.

3

@corrb

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