Saturday, September 16, 2017

B2B DataExchange Upgrade from 9.1.0 to 9.5.1


Informatica B2B DataExchange Upgrade Steps from 9.1.0 to 9.5.1



/softwares/B2BDataExchange9.5.1/Solaris_sparc>>./Install.bin -i console
Preparing to install...
Extracting the JRE from the installer archive...
Unpacking the JRE...
Extracting the installation resources from the installer archive...
Configuring the installer for this system's environment...

Launching installer...

===============================================================================
                                                 (created with InstallAnywhere)
-------------------------------------------------------------------------------

Preparing CONSOLE Mode Installation...




===============================================================================
Introduction
------------

This installer will guide you through the installation of B2B Data Exchange
9.5.1.

It is strongly recommended that you quit all programs before you continue with
this installation.

In this and all succeeding screens, respond to each prompt to proceed to the
next step, type Back to make changes to the previous entry, type Quit to cancel
the installation at any time.

PRESS TO CONTINUE:



===============================================================================
Install or Upgrade
------------------

Select whether to install B2B Data Exchange 9.5.1 and any of its components, or to upgrade an existing installation. You can upgrade from version 9.1 or 9.5 to 9.5.1.
If you select to add components or to upgrade B2B Data Exchange, stop all B2B Data Exchange services before you continue.

  ->1- Install B2B Data Exchange 9.5.1 or any of its components
    2- Upgrade to B2B Data Exchange 9.5.1

ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS TO ACCEPT THE DEFAULT:: 2




===============================================================================
Installation Directory
----------------------

Enter the installation directory:

  Default Install Folder: /infa/informatica/B2BDataExchange9.0.1

ENTER AN ABSOLUTE PATH, OR PRESS TO ACCEPT THE DEFAULT
      :



===============================================================================
Installation Components
-----------------------

Select the components to install.

Select B2B Data Exchange to install the B2B Data Exchange application.
Select B2B Data Exchange Dashboard and Reports to install this component on the
machine hosting B2B Data Exchange server. The B2B Data Exchange Dashboard and
Reports component supports only Oracle databases.
Select Data Exchange server plug-in for PowerCenter to install the Data
Exchange server plug-in on the machine hosting the PowerCenter services. This
option also configures the PowerCenter services to work with B2B Data Exchange.
Register the server plug-in to a PowerCenter Repository Service after
installation.
Select B2B Managed File Transfer to install this component on the machine
hosting B2B Data Exchange server.


  ->1- B2B Data Exchange
    2- B2B Data Exchange Dashboard and Reports
  ->3- Data Exchange server plug-in for PowerCenter
  ->4- B2B Managed File Transfer

ENTER A COMMA-SEPARATED LIST OF NUMBERS REPRESENTING THE DESIRED CHOICES, OR
   PRESS TO ACCEPT THE DEFAULT:



===============================================================================
Configure Database
------------------

The installer can create a B2B Data Exchange 9.5.1 repository or use an existing B2B Data Exchange 9.5.1 repository. If you use an existing repository, all data in the repository will be preserved and all user accounts will remain valid in the new installation.


  ->1- Create a B2B Data Exchange repository
    2- Use an existing B2B Data Exchange repository

ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS TO ACCEPT THE DEFAULT:: 2




===============================================================================
Database Connection
-------------------

Enter the database connection details below.


Enter database type:

  ->1- Oracle
    2- SQLServer

ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS TO ACCEPT THE DEFAULT::




===============================================================================


Enter database connection type:

    1- Database URL
  ->2- Custom connection string

ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS TO ACCEPT THE DEFAULT::




===============================================================================




Enter custom JDBC connection string (DEFAULT:
   jdbc:informatica:oracle://oracdev:1521;Servicename=infa;):




===============================================================================




Enter database user ID (DEFAULT: B2BDX):




===============================================================================



Enter database user password:



===============================================================================
Web Server
----------

Specify Web Server (Tomcat) port numbers and HTTPS settings.

In case both HTTP and HTTPS ports are selected, HTTPS will always be used and HTTP request will be redirected to HTTPS.

    1- Enable HTTPS
  ->2- Enable HTTP

ENTER A COMMA-SEPARATED LIST OF NUMBERS REPRESENTING THE DESIRED CHOICES, OR
   PRESS TO ACCEPT THE DEFAULT:




===============================================================================




HTTP connector port number (DEFAULT: 18080):




===============================================================================




Web server shutdown listener port number (DEFAULT: 18005):




===============================================================================
Port Number
-----------

Specify the JMX listener port number for the B2B Data Exchange JMS Broker.

JMX listener port number (DEFAULT: 18098):




===============================================================================
PowerCenter Directory
---------------------

Set up the PowerCenter domain information in Data Exchange.

Enter the PowerCenter directory.

PowerCenter directory (DEFAULT: /infa/informatica/PowerCenter9.6.1):




===============================================================================
PowerCenter Web Services Hub
----------------------------

Specify whether to connect to PowerCenter Web Services Hub.

  ->1- Connect Web Services Hub
    2- Skip Web Services Hub

ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS TO ACCEPT THE DEFAULT::




===============================================================================
PowerCenter WebServices URL
---------------------------

Specify the PowerCenter WebServices URL.

WebServices URL (DEFAULT: http://infa:7600/wsh):




===============================================================================
PowerCenter Repository Service
------------------------------

Specify the PowerCenter Repository service to use for the Data Exchange workflow.


Repository Service (DEFAULT: rs_stg_repo):




===============================================================================




Repository user name (DEFAULT: Administrator):




===============================================================================



Repository password::



===============================================================================
PowerCenter Domain
------------------

Specify the PowerCenter domain.

Domain name: domain_stg


PRESS TO CONTINUE:



===============================================================================




Node name (DEFAULT: stg_node1):




===============================================================================
PowerCenter Domain
------------------

Specify the PowerCenter administrator user account.

User name (DEFAULT: Administrator):




===============================================================================



Password::



===============================================================================
PowerCenter Integration Service
-------------------------------

Integration Service name: is_stg_bbb


PRESS TO CONTINUE:



===============================================================================
Pre-Installation Summary
------------------------

Review the following installation information before continue:

Product Name:
    B2B Data Exchange

Install Folder:
    /infa/informatica/B2BDataExchange9.0.1

Installation Components:
    B2B Data Exchange
    Data Exchange server plug-in for PowerCenter
    B2B Managed File Transfer

Disk Space Information (for installation Target):
    Required:  799,022,409 bytes
    Available: 31,568,395,264 bytes

PRESS TO CONTINUE:




===============================================================================
Installing...
-------------

 [==================|==================|==================|==================]
 [------------------|------------------|------------------|------------------]



===============================================================================
Post-Installation Actions
-------------------------

Use the PowerCenter Administration Console to unregister and register the Data
Exchange plug-in to the Repository Service. The Data Exchange plug-in file is /
infa/informatica/B2BDataExchange9.0.1/DataExchange/powercenter/pluginN>/dxplugin.xml.
You must restart the Repository Service and the Integration Service after
registering the Data Exchange plug-in.

PRESS TO CONTINUE:



===============================================================================
Installation Complete
---------------------

B2B Data Exchange 9.5.1 has been successfully installed in the following
directory:

    /infa/informatica/B2BDataExchange9.0.1

PRESS TO EXIT THE INSTALLER:





Register Plugin:


/infa/informatica/B2BDataExchange9.0.1/DataExchange>>pmrep registerplugin -i /infa/informatica/B2BDataExchange9.0.1/DataExchange/powercenter/plugin951/dxplugin.xml -e -N


 [08/21/2017 14:17:57-The requested resilience timeout of 180 second(s) exceeded the Repository Service [rs_stg_repo] limit on resilience timeouts. The new resilience timeout is 0 second(s).]
Register Plug-in operation on repository [rs_stg_repo] started at 08/21/2017 14:18:00.

Importing plugin: DX ...
Importing template: DX Add Document To Event ...
Importing templateattribute: Class Name ...
Importing templateattribute: Generate Transaction ...
Importing templateattribute: Is Partitionable ...
Importing templateattribute: Inputs Must Block ...
Importing templateattribute: Is Active ...
Importing templateattribute: Language ...
Importing templateattribute: Output Is Repeatable ...
Importing templateattribute: Output Is Deterministic ...
Importing templateattribute: Requires Single Thread Per Partition ...
Importing templateattribute: Transformation Scope ...
Importing templateattribute: Update Strategy Transformation ...
Importing library: DXPlugin ...
Importing template: DX Aggregate ...
Importing templateattribute: Class Name ...
Importing templateattribute: Generate Transaction ...
Importing templateattribute: Is Partitionable ...
Importing templateattribute: Inputs Must Block ...
Importing templateattribute: Is Active ...
Importing templateattribute: Language ...
Importing templateattribute: Output Is Repeatable ...
Importing templateattribute: Output Is Deterministic ...
Importing templateattribute: Requires Single Thread Per Partition ...
Importing templateattribute: Transformation Scope ...
Importing templateattribute: Update Strategy Transformation ...
Importing library: DXPlugin ...
Importing template: DX Complete Correlation ...
Importing templateattribute: Class Name ...
Importing templateattribute: Generate Transaction ...
Importing templateattribute: Is Partitionable ...
Importing templateattribute: Inputs Must Block ...
Importing templateattribute: Is Active ...
Importing templateattribute: Language ...
Importing templateattribute: Output Is Repeatable ...
Importing templateattribute: Output Is Deterministic ...
Importing templateattribute: Requires Single Thread Per Partition ...
Importing templateattribute: Transformation Scope ...
Importing templateattribute: Update Strategy Transformation ...
Importing library: DXPlugin ...
Importing template: DX Create Event ...
Importing templateattribute: Class Name ...
Importing templateattribute: Generate Transaction ...
Importing templateattribute: Is Partitionable ...
Importing templateattribute: Inputs Must Block ...
Importing templateattribute: Is Active ...
Importing templateattribute: Language ...
Importing templateattribute: Output Is Repeatable ...
Importing templateattribute: Output Is Deterministic ...
Importing templateattribute: Requires Single Thread Per Partition ...
Importing templateattribute: Transformation Scope ...
Importing templateattribute: Update Strategy Transformation ...
Importing library: DXPlugin ...
Importing template: DX Event Attribute ...
Importing templateattribute: Class Name ...
Importing templateattribute: Generate Transaction ...
Importing templateattribute: Is Partitionable ...
Importing templateattribute: Inputs Must Block ...
Importing templateattribute: Is Active ...
Importing templateattribute: Language ...
Importing templateattribute: Output Is Repeatable ...
Importing templateattribute: Output Is Deterministic ...
Importing templateattribute: Requires Single Thread Per Partition ...
Importing templateattribute: Transformation Scope ...
Importing templateattribute: Update Strategy Transformation ...
Importing library: DXPlugin ...
Importing template: DX Event Details ...
Importing templateattribute: Class Name ...
Importing templateattribute: Generate Transaction ...
Importing templateattribute: Is Partitionable ...
Importing templateattribute: Inputs Must Block ...
Importing templateattribute: Is Active ...
Importing templateattribute: Language ...
Importing templateattribute: Output Is Repeatable ...
Importing templateattribute: Output Is Deterministic ...
Importing templateattribute: Requires Single Thread Per Partition ...
Importing templateattribute: Transformation Scope ...
Importing templateattribute: Update Strategy Transformation ...
Importing library: DXPlugin ...
Importing template: DX Generate Temporary File ...
Importing templateattribute: Class Name ...
Importing templateattribute: Generate Transaction ...
Importing templateattribute: Is Partitionable ...
Importing templateattribute: Inputs Must Block ...
Importing templateattribute: Is Active ...
Importing templateattribute: Language ...
Importing templateattribute: Output Is Repeatable ...
Importing templateattribute: Output Is Deterministic ...
Importing templateattribute: Requires Single Thread Per Partition ...
Importing templateattribute: Transformation Scope ...
Importing templateattribute: Update Strategy Transformation ...
Importing library: DXPlugin ...
Importing template: DX Get Document File Path ...
Importing templateattribute: Class Name ...
Importing templateattribute: Generate Transaction ...
Importing templateattribute: Is Partitionable ...
Importing templateattribute: Inputs Must Block ...
Importing templateattribute: Is Active ...
Importing templateattribute: Language ...
Importing templateattribute: Output Is Repeatable ...
Importing templateattribute: Output Is Deterministic ...
Importing templateattribute: Requires Single Thread Per Partition ...
Importing templateattribute: Transformation Scope ...
Importing templateattribute: Update Strategy Transformation ...
Importing library: DXPlugin ...
Importing template: DX Increment Profile Parameter ...
Importing templateattribute: Class Name ...
Importing templateattribute: Generate Transaction ...
Importing templateattribute: Is Partitionable ...
Importing templateattribute: Inputs Must Block ...
Importing templateattribute: Is Active ...
Importing templateattribute: Language ...
Importing templateattribute: Output Is Repeatable ...
Importing templateattribute: Output Is Deterministic ...
Importing templateattribute: Requires Single Thread Per Partition ...
Importing templateattribute: Transformation Scope ...
Importing templateattribute: Update Strategy Transformation ...
Importing library: DXPlugin ...
Importing template: DX Initiate Correlation ...
Importing templateattribute: Class Name ...
Importing templateattribute: Generate Transaction ...
Importing templateattribute: Is Partitionable ...
Importing templateattribute: Inputs Must Block ...
Importing templateattribute: Is Active ...
Importing templateattribute: Language ...
Importing templateattribute: Output Is Repeatable ...
Importing templateattribute: Output Is Deterministic ...
Importing templateattribute: Requires Single Thread Per Partition ...
Importing templateattribute: Transformation Scope ...
Importing templateattribute: Update Strategy Transformation ...
Importing library: DXPlugin ...
Importing template: DX Release Delayed Events ...
Importing templateattribute: Class Name ...
Importing templateattribute: Generate Transaction ...
Importing templateattribute: Is Partitionable ...
Importing templateattribute: Inputs Must Block ...
Importing templateattribute: Is Active ...
Importing templateattribute: Language ...
Importing templateattribute: Output Is Repeatable ...
Importing templateattribute: Output Is Deterministic ...
Importing templateattribute: Requires Single Thread Per Partition ...
Importing templateattribute: Transformation Scope ...
Importing templateattribute: Update Strategy Transformation ...
Importing library: DXPlugin ...
Importing template: DX Resolve Profile ...
Importing templateattribute: Class Name ...
Importing templateattribute: Generate Transaction ...
Importing templateattribute: Is Partitionable ...
Importing templateattribute: Inputs Must Block ...
Importing templateattribute: Is Active ...
Importing templateattribute: Language ...
Importing templateattribute: Output Is Repeatable ...
Importing templateattribute: Output Is Deterministic ...
Importing templateattribute: Requires Single Thread Per Partition ...
Importing templateattribute: Transformation Scope ...
Importing templateattribute: Update Strategy Transformation ...
Importing library: DXPlugin ...
Importing template: DX Throw Error ...
Importing templateattribute: Class Name ...
Importing templateattribute: Generate Transaction ...
Importing templateattribute: Is Partitionable ...
Importing templateattribute: Inputs Must Block ...
Importing templateattribute: Is Active ...
Importing templateattribute: Language ...
Importing templateattribute: Output Is Repeatable ...
Importing templateattribute: Output Is Deterministic ...
Importing templateattribute: Requires Single Thread Per Partition ...
Importing templateattribute: Transformation Scope ...
Importing templateattribute: Update Strategy Transformation ...
Importing library: DXPlugin ...
Importing template: DX Profile Parameters ...
Importing templateattribute: Class Name ...
Importing templateattribute: Generate Transaction ...
Importing templateattribute: Is Partitionable ...
Importing templateattribute: Inputs Must Block ...
Importing templateattribute: Is Active ...
Importing templateattribute: Language ...
Importing templateattribute: Output Is Repeatable ...
Importing templateattribute: Output Is Deterministic ...
Importing templateattribute: Requires Single Thread Per Partition ...
Importing templateattribute: Transformation Scope ...
Importing templateattribute: Update Strategy Transformation ...
Importing library: DXPlugin ...

Post validation on imported plug-ins...
The number of plug-ins that registered successfully is 1.
The number of plug-ins that failed to register is 0.
Register Plug-in operation on repository [rs_stg_repo] ended at 08/21/2017 14:18:03. Elapsed time is 0:00:03.
registerplugin completed successfully.


Completed at Mon Aug 21 14:18:07 2017



verifyContents 


/infa/informatica/B2BDataExchange9.0.1/DataExchange/dx-tools>>./repoutil.sh -c verifyContents -l "jdbc:informatica:oracle://oracdev:1521;Servicename=infa" --authMode Native -u B2BDX -p password
14:19:19 INFO  Executing DX Repository command [VerifyContentAction]
14:19:19 INFO  Found DX Repository version [9.5.1.0 - 220]
14:19:19 INFO  Executing rule [Event Associations]...
14:19:19 INFO  Executing rule [Event History Associations]...
14:19:19 INFO  Executing rule [Event Type Privilege Association]...
14:19:19 INFO  Executing rule [Profile Associations]...
14:19:19 INFO  Executing rule [Account Number Uniqueness]...
14:19:19 INFO  Executing rule [Object Names Lower Case Unique]...
14:19:19 INFO  Executing rule [Partner/Profile Have Account]...
14:19:19 INFO  Executing rule [Profile Event Attributes match Flow Template Event Attributes]...
14:19:19 INFO  Executing rule [Schedule Cron Expression Verification]...
14:19:19 INFO  Executing rule [User Login Names Lower Case Unique]...
14:19:19 INFO  Finished DX Repository command [VerifyContentAction]
::/infa/informatica/B2BDataExchange9.0.1/DataExchange/dx-tools>>