Insights integration - Xflow is not working after restart Jaspersoft

book

Article ID: 107491

calendar_today

Updated On:

Products

CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

Integration between SDM -xFlow -Jaspersoft -Datamart issue.

After restart Jasper services, the Insight integration stop working, when they give click to "Insight" button, nothing happens.

Cause

Customer execute Xflow re-installation process. But but during this process the server name was changed from  <old_servername>  to <new_servername>.

It provokes some Xflow registers keep old servername.

Reviewing the Xflow logs, we can see  Xflow service is not starting rightly.

In the IncidentMS.log file the follow message is found:

WARN - <date> [a.remote.ReliableDeliverySupervisor] - Association with remote system [akka.tcp://[email protected]<old_servername>:<port>] has failed, address is now gated for [5000] ms. Reason: [Association failed with [akka.tcp://[email protected]<old_servername>:<port>]] Caused by: [<old_servername>]

Environment

SDM
Xflow, Insights
Jaspersoft
Datamart



 

Resolution


NOTE: Take backup from mdb database before to do any change!
================================================


1) Select the xflowClusterSystem entries from l1admin_general_config:
 

select * from l1admin_general_config where config_value like '%xflowClusterSystem%'



verify the rows display the right servername.



2) Default entry  for '%xflowClusterSystem%'  should be id=400001, if it has invalid value, it needs to be modified:

update [mdb].[dbo].[l1admin_general_config]
set config_value ='akka.tcp://[email protected]<new_servername>:<port>'
where id =400001





3) If any additional row has invalid name, take the id and delete the invalid reference:

delete
FROM [mdb].[dbo].[l1admin_general_config] where id =XXXXX



where XXXX has the ID of the invalid value, in this case 400051.



4) Restart services and test the integration again.
 

Additional Information

Xflow logs are found in
  • <Install Drive>\CA\xFlow\APPS\logs

Attachments