Saturday, September 16, 2017

B2B DataExchange Upgrade from 9.5.1 to 9.6.1


Informatica B2B DataExchange Upgrade Steps from 9.5.1 to 9.6.1




infa/infaabc/softwares/B2BDataExchange9.6.1>>./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
------------

The installer will guide you through the installation of B2B Data Exchange
9.6.1 HF1.

It is strongly recommended that you close all programs before you continue with
the installation.

In all installation stages, respond to each prompt to proceed to the next step,
type Back to make changes to the previous stage, or type Quit to cancel the
installation at any time.



PRESS TO CONTINUE:



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

Select whether to install B2B Data Exchange 9.6.1 HF1 and any of its
components, or to upgrade an existing installation. You can upgrade from
version 9.5, 9.5.1, or 9.6.1 to version 9.6.1 HF1.
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.6.1 HF1 or any of the installation components
    2- Upgrade to B2B Data Exchange 9.6.1 HF1

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




===============================================================================
PowerCenter Version
-------------------

Select the PowerCenter version for which B2B Data Exchange should be installed.


  ->1- PowerCenter version 9.6 and above
    2- PowerCenter version earlier than 9.6

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



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

Enter the installation directory:

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

ENTER AN ABSOLUTE PATH, OR PRESS TO ACCEPT THE DEFAULT
      : /infa/informatica/B2BDataExchange9.0.1

INSTALL FOLDER IS: /infa/informatica/B2BDataExchange9.0.1
   IS THIS CORRECT? (Y/N): Y



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

Select components to install.

- B2B Data Exchange. B2B Data Exchange application.
- Partners Portal. Partners Portal application.
- Dashboard and Reports. Installed on the machine hosting the B2B Data Exchange
server.
- Server plug-in for PowerCenter. Installed on the machine hosting the
PowerCenter services.
- Managed File Transfer. Installed on the machine hosting the B2B Data Exchange
server.


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

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



===============================================================================
Metadata Repository
-------------------

The installer can create a B2B Data Exchange 9.6.1 HF1 repository or use an
existing repository. All data in the repository will be preserved and all user
accounts will remain valid in the new installation.
If you upgrade and select to use an existing repository from an earlier B2B
Data Exchange version, the installer will upgrade the repository to version
9.6.1 HF1.

  ->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




===============================================================================
Metadata Repository Connection
------------------------------

The repository you specify will store information about Operation Console
objects.

Enter the database type:

  ->1- Oracle
    2- SQLServer

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




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


Enter the database connection type:

  ->1- Database URL
    2- Custom connection string

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




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



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




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



Enter the database username (DEFAULT: B2BDX):




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



Enter the database user password:



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

Specify the Web Server (Tomcat) port numbers and connection details.

If you select HTTP and HTTPS ports, HTTPS will always be used and HTTP requests
will be redirected to the HTTPS port.

  ->1- Enable HTTPS
  ->2- Enable HTTP

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




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



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
---------------------

Define the PowerCenter domain information in Data Exchange.

Enter the PowerCenter directory.

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




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

Choose whether to connect to the PowerCenter Web Services Hub or skip this
step.

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

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




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

Specify the PowerCenter Web Services Hub URL.

Web Services Hub URL (DEFAULT: http://infa:7600/wsh):




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

Specify the PowerCenter Repository Service to use for the Data Exchange
workflows.


Repository Service name (DEFAULT: rs_stg_repo):




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

Specify the PowerCenter Repository Node host to use for B2B Data Exchange
workflows.

Node host: stg_node1



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

Specify the PowerCenter Repository Node port to use for B2B Data Exchange
workflows.

Node port: 6305



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



Repository username (DEFAULT: Administrator):




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



Repository password:



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



Repository security domain (optional): Native



===============================================================================
Informatica Domain
------------------

Specify the Informatica domain.

Domain name (DEFAULT: domain_stg):




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



Node name (DEFAULT: stg_node1):




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

Specify the PowerCenter administrator user account.

Username (DEFAULT: Administrator):




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



Password:



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

Specify the PowerCenter Integration Service to run the Data Exchange workflows.

Integration Service name (DEFAULT: is_stg_bbb):




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

Review the following installation information before you continue:

Product Name:
    B2B Data Exchange

Installation Directory:
    /infa/informatica/B2BDataExchange9.0.1

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

Disk Space Information (for installation Target):
    Required:  1,243,351,205 bytes
    Available: 26,645,999,616 bytes

PRESS TO CONTINUE:



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

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



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

The installation of B2B Data Exchange is complete. You must now take the
following steps:

* Use the Administrator tool to unregister and register the B2B Data Exchange
server plug-in for PowerCenter. The B2B Data Exchange plug-in file is located
in the following directory: /infa/informatica/B2BDataExchange9.0.1/DataExcha
nge/powercenter/plugin/dxplugin.xml.
* Restart the following PowerCenter services, in the following order:
* Repository Service
* Integration Service
   * Web Service Hub Service

PRESS TO CONTINUE:



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

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

    /infa/informatica/B2BDataExchange9.0.1

PRESS TO EXIT THE INSTALLER:
You have new mail in /usr/mail/b2buata1
infa/infaabc/softwares/B2BDataExchange9.6.1>>



Register Plugin:


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

Copyright (c) Informatica Corporation 1994 - 2014
All Rights Reserved.
This Software is protected by U.S. Patent Numbers 5,794,246; 6,014,670; 6,016,501; 6,029,178; 6,032,158; 6,035,307; 6,044,374; 6,092,086; 6,208,990; 6,339,775; 6,640,226; 6,789,096; 6,820,077; 6,823,373; 6,850,947; 6,895,471; 7,117,215; 7,162,643; 7,243,110; 7,254,590; 7,281,001; 7,421,458; 7,496,588; 7,523,121; 7,584,422; 7,676,516; 7,720,842; 7,721,270; 7,774,791; 8,065,266; 8,150,803; 8,166,048; 8,166,071; 8,200,622; 8,224,873; 8,271,477; 8,327,419; 8,386,435; 8,392,460; 8,453,159; 8,458,230; and RE44,478, International Patents and other Patents Pending.

Invoked at Mon Aug 21 18:54:55 2017

 [08/21/2017 18:54:56-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 18:54:59.

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 ...
Importing template: DX Notification ...
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 Start Publication ...
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 Publication 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 18:55:01. Elapsed time is 0:00:02.
registerplugin completed successfully.


verifyContents 


infa/infa/informatica/B2BDataExchange9.0.1/DataExchange/dx-tools>>./repoutil.sh -c verifyContents -t dx
19:07:18 INFO  Default system locale: English
19:07:20 INFO  Executing command [VerifyContentAction]
19:07:20 INFO  Found version [9.6.1.0 - 620] for [DX_REPOSITORY]
19:07:20 INFO  Executing rule [Event Associations]...
19:07:20 INFO  Executing rule [Event History Associations]...
19:07:20 INFO  Executing rule [Event Type Privilege Association]...
19:07:20 INFO  Executing rule [Profile Associations]...
19:07:20 INFO  Executing rule [Account Number Uniqueness]...
19:07:20 INFO  Executing rule [Object Names Lower Case Unique]...
19:07:20 INFO  Executing rule [Partner/Profile Have Account]...
19:07:20 INFO  Executing rule [Profile Event Attributes match Flow Template Event Attributes]...
19:07:20 INFO  Executing rule [Schedule Cron Expression Verification]...
19:07:20 INFO  Executing rule [User Login Names Lower Case Unique]...
19:07:20 INFO  Finished command [VerifyContentAction]