Steps:
1. Make sure you have copy and backup of existing TIBCO project from already working environment. (.dat format or .zip format)
2. Make sure that new TIBCO versions are installed and configured using MICU (Middleware Install and Configure Utility) CDs from 11.0
3. On new TIBCO environment, convert existing TIBCO project.
a. In case you have .dat file then first convert dat file into multi file project and open that project into TIBCO designer
b. In case you have exported zip file then create empty project in TIBCO designer and then import zip archive into newly created TIBCO project.
4. Global Variable: ESIOMAdapter\JDBCURL is now must to have following values:
jdbc:tibcosoftwareinc:oracle://<<ERP DB Host Name>>:<<ERP DB PORT>>;SID=<<ERP DB SID>>
Where <<ERP DB Host Name>> ,<<ERP DB PORT>> and <<ERP DB SID>> values are to be replaced with actual values. In previous version of ADB Adapter these values were used to form an ODBC DSN.
5. Create a new Global Variable inside ESIOMADapter Global Variable group. Name: SubSrvThreadCounts, Default Value set to “1”.
6. Map ESIOMAdapter\ SubSrvThreadCounts to Number of Subscription Service Thread option at Configuration tab on each Subscription Service configured under Existing Adapter Configuration. For e.g. Out of the box , BOM Subscription service is configured under <<Project>>/ADB/ESIOMConfiguration
7. Convert out of the box 11.0 project and copy following process file and replace it in customer’s customized project. (Here it is assumed that this is very common process and customer has not customized this process at all. If this process is already customized then open source and target project in TIBCO designer and manually check and compare the differences and incorporate changes into target project. <<ProjectFolder>>\ProcessDefinitions\Services\Oracle\Query_Service.process
8. Make sure that whenever Query string (SQL query) is being mapped there is no need to pass “;”. Sometimes Adapter throws an exception stating that “unsupported character”. Out of the box project has been modified for following activities inputs where SQL queries where passed:
|
Activity Name
|
Process Name
|
|
CALL_Query_OracleTime
|
<<Project Folder>>\ProcessDefinitions\ERPCommunication\Oracle\Part\ Start_CBOPart_ORACreateChange_PD.process
|
|
CALL_QueryLogTable
|
<<Project Folder>>\ProcessDefinitions\ERPCommunication\Oracle\Part\ Start_CBOPart_ORACreateChange_PD.process
|
|
CallProcess_QueryService_F or_OracleTime
|
<<Project Folder>>\ProcessDefinitions\ERPCommunication\Oracle\BOM\ Start_CBOBOM_ORACreateChange_PD.process
|
|
CallProcess_QueryService_ QueryOracleTime
|
<<Project Folder>>\ProcessDefinitions\ERPCommunication\Oracle\ECN\Start_CBOECN_ORACreateUpdate_PD.process
|
|
CallProcess_QueryService_ QueryAllMessages
|
<<Project Folder>>\ProcessDefinitions\ERPCommunication\Oracle\ECN\Start_CBOECN_ORACreateUpdate_PD.process
|
9. Following script has been modified:
MasterConfiguration_TIBCOLogTablePublisher_all_Mods.sql
Compare this script with customer’s deployed and/or customized script and incorporate differences.
10. Save the project and test the project in identical TEST environment