Artifacts
https://git.ftc-llc.com/CCRS/CaseManagement/blob/master/Deployment/defect-932487-analysisflow_mq_config.in
https://git.ftc-llc.com/CCRS/CaseManagement/blob/master/Deployment/scripts/ccrs_ro_deploy_scripts/sql/AFRUNControlTable.sql
https://git.ftc-llc.com/CCRS/CaseManagement/blob/master/Deployment/Defect-932487-AF-Events.sql
https://git.ftc-llc.com/CCRS/CaseManagement/blob/master/Deployment/scripts/ccrs_ro_deploy_scripts/sql/SP_VA_RETRIEVE_INVOICES.sql
https://git.ftc-llc.com/CCRS/CaseManagement/blob/master/Deployment/EARs/ccrs_ro_analysis_ear.ear.zip
https://git.ftc-llc.com/CCRS/CaseManagement/blob/master/Deployment/doc/README_IAMUrlUpdateSteps.txt 



Process:

Replace Stored Procedure - 
1.	On FCI Master Node: cd /u01/fci-exports/fci-primaryds/scripts/sql (on Master)
2.	backup SP_VA_RETRIEVE_INVOICES.sql
3.	cp  new SP_VA_RETRIEVE_INVOICES.sql to /u01/fci-exports/fci-primaryds/scripts/sql  (replace if prompted)
4.	On FCI Worker Node ==> cd to /u01/fci-exports/fci-primaryds/scripts  
5.	run  ./ro_fciafconfig_wrapper.sh

Add DB2 Table

Linux Command Line FCI - 
1.	On FCI Master Node: cp AFRUNControlTable.sql to /u01/fci-exports/fci-primaryds/scripts/sql
2.	cp Defect-932487-AF-Events.sql to /u01/fci-exports/fci-primaryds/scripts/sql
3       chmod ugo+rx on both files
4.	On FCI Worker Node: cd /u01/fci-exports/fci-primaryds/scripts
5.	run ./fci-db-update-wrapper.sh AFRUNControlTable.sql
6.	run ./fci-db-update-wrapper.sh Defect-932487-AF-Events.sql

Add the following two queues using the 
	AF.CCRS.RO.CLAIMS.PROCESSOR
	AF.CCRS.RO.CLAIMLINES.PROCESSOR
1.	cp ./defect-932487-analysisflow_mq_config.in  /u01/fci-exports/kubernetes-scripts
2.	chmod +x /u01/fci-exports/kubernetes-scripts/defect-932487-analysisflow_mq_config.in
3.	kubectl -it exec $(kubectl get pods | grep fci-messaging | awk '{print $1}') -i -t --  /opt/mqm/bin/runmqsc FCIQM </u01/fci-exports/kubernetes-scripts/defect-932487-analysisflow_mq_config.in


b
CCRS Analysis Ear update - FCI Master Node
1.	copy  ccrs_ro_analysis_ear.ear.zip to /u01/fci-exports/fci-analytics/servers/analyticsServer/apps
2.	cd /u01/fci-exports/fci-analytics/servers/analyticsServer/apps
3.	backup ccrs_ro_analysis_ear.ear
4.	unzip/replace  ccrs_ro_analysis_ear.ear

Update server_ccrs_ro_analysis_ear.xml
1.	Cd /u01/fci-exports/fci-analytics/servers/analyticsServer
2.	Vi server_ccrs_ro_analysis_ear.xml
3.	Insert the following just before the </server> tag

<jmsActivationSpec authDataRef="FCIMQUser"		id="jms/CCRSAnalysisFlowClaimProcessorSpec">		
<properties.wmqJms destinationRef="AF.CCRS.RO.CLAIMS.PROCESSOR"	destinationType="javax.jms.Queue" hostName="${env.com_fci_mq_server}"	
port="${env.com_fci_mq_port}" queueManager="${env.com_fci_mq_qmgr}" />	
</jmsActivationSpec>
	
<!-- -->	
<jmsQueue id="AF.CCRS.RO.CLAIMS.PROCESSOR" jndiName="/AF.CCRS.RO.CLAIMS.PROCESSOR">	
<properties.wmqJms baseQueueManagerName="${env.com_fci_mq_qmgr}"
baseQueueName="AF.CCRS.RO.CLAIMS.PROCESSOR" targetClient="JMS" />	
</jmsQueue>       

<jmsActivationSpec authDataRef="FCIMQUser" id="jms/CCRSAnalysisFlowClaimlineProcessorSpec">		
<properties.wmqJms destinationRef="AF.CCRS.RO.CLAIMLINES.PROCESSOR" 
destinationType="javax.jms.Queue" hostName="${env.com_fci_mq_server}"	
port="${env.com_fci_mq_port}" queueManager="${env.com_fci_mq_qmgr}" />	
</jmsActivationSpec>	

<!-- -->	
<jmsQueue id="AF.CCRS.RO.CLAIMLINES.PROCESSOR" jndiName="/AF.CCRS.RO.CLAIMLINES.PROCESSOR">		
<properties.wmqJms baseQueueManagerName="${env.com_fci_mq_qmgr}"			
baseQueueName="AF.CCRS.RO.CLAIMLINES.PROCESSOR" targetClient="JMS" />	
</jmsQueue>



Restart the Analytics server:

a)kubectl -it exec $(kubectl get pods | grep fci-ana | awk '{print $1}') -i -t --  /tmp/stop.sh	
b)kubectl -it exec $(kubectl get pods | grep fci-sol | awk '{print $1}') -i -t  bash	
c)From container command prompt execute the following commands:	 /opt/ibm/wlp/bin/server start analyticsServer --clean
d)exit

FCI Configuration Change:
https://git.ftc-llc.com/CCRS/CaseManagement/blob/master/Deployment/doc/README_IAMUrlUpdateSteps.txt 

