update wf_notification_attributes set text_value=replace(text_value,
'http:// prod.domain:8000/pls/prod','http://clone.domain:8036/pls/test') where text_value like '%http://prod.domain:8000/pls/prod%';
select text_value from wf_notification_attributes;
2.
update wf_notification_attributes set text_value=replace(text_value,
'http:// prod.domain:8000','http:// clone.domain:8036') where text_value like '%http://prod.domain:8000%';
select text_value from wf_notification_attributes;
3.
update wf_notification_values set text_value=replace(text_value,'http:// prod.domain:8000','http://clone.domain:8036') where text_value like '%http://umappprod.umniah.com:8000%';
select text_value from wf_notification_values;
4.
update wf_notification_values set text_value=replace(text_value,'prod','clone') where text_value like '%clone%';
5.
update wf_agents set address=replace(address,'prod','clone') where text_value like '%prod%';
select address from wf_agents;
6.
update wf_systems set name='clone', DISPLAY_NAME='clone' where name like '%prod%';
select name,DISPLAY_NAME from wf_systems;
===============================
Even then if you have problems in fixing the Workflow, then recreate the service component containers from the scripts below:
Run these scripts in directory $APPL_TOP/fnd/11.5.0/patch/115/sql
to get the service component containers back up and running in the following order after shutting down the apps after cloning:
wfntfqup.sql
wfqidxc2.sql
wfquec2.sql
wfjmsqc2.sql
wfbesqc.sql
Also Please run cmclean.sql and fnd_conc_clone.setup_clean as APPS before starting the cloning on target server.
'http:// prod.domain:8000/pls/prod','http://clone.domain:8036/pls/test') where text_value like '%http://prod.domain:8000/pls/prod%';
select text_value from wf_notification_attributes;
2.
update wf_notification_attributes set text_value=replace(text_value,
'http:// prod.domain:8000','http:// clone.domain:8036') where text_value like '%http://prod.domain:8000%';
select text_value from wf_notification_attributes;
3.
update wf_notification_values set text_value=replace(text_value,'http:// prod.domain:8000','http://clone.domain:8036') where text_value like '%http://umappprod.umniah.com:8000%';
select text_value from wf_notification_values;
4.
update wf_notification_values set text_value=replace(text_value,'prod','clone') where text_value like '%clone%';
5.
update wf_agents set address=replace(address,'prod','clone') where text_value like '%prod%';
select address from wf_agents;
6.
update wf_systems set name='clone', DISPLAY_NAME='clone' where name like '%prod%';
select name,DISPLAY_NAME from wf_systems;
===============================
Even then if you have problems in fixing the Workflow, then recreate the service component containers from the scripts below:
Run these scripts in directory $APPL_TOP/fnd/11.5.0/patch/115/sql
to get the service component containers back up and running in the following order after shutting down the apps after cloning:
wfntfqup.sql
wfqidxc2.sql
wfquec2.sql
wfjmsqc2.sql
wfbesqc.sql
Also Please run cmclean.sql and fnd_conc_clone.setup_clean as APPS before starting the cloning on target server.
No comments:
Post a Comment