How to connect TN Assets Db to UI in Webmethods 10.11

November 21, 2022November 21, 2022 Shivani SarthiStudio-ScalaDevops

Table of contents

Reading Time: 2 minutes

Software Ag’s Webmethods suite contains products that broaden your horizon. When it comes to building Integration solutions or integration of cloud-based applications with on-premise systems. Trading Networks assets (TN Assets) like Partners, Business Documents, Processing Rules, TPA, etc. Needs to be migrated from the older version to the latest.

Problem Statement

Imagined you have Installed the latest 10.11 MywebmethodServer for the first time and you are unable to see your Assets. Even though you can view them on your Database by connecting to your TN Schema.

TN Assets

Solution

To see the TN Assets on the UI, you need to follow a few steps-

Go to the TN Server tab (My webmethods-> System Setting-> TN Servers) and add the details about your TN Servers, which include adding the TN Config Name, TN Host and TN Port. Now go back to the Export Asset tab and see if the data is populated or not.
If not go to your Integration Server -> JDBC Pool for TN and check if you are connecting to the right TN Schema.
To resolve the issue check your fixes level also for the Integration Server and MYwebmethods Server.
The main fixes include Trading Partner fixes and Security fixes
Once you have the fixes aligned, you need to migrate a few of the components. For this first go to the Software_Ag_directory/common/db/bin. Now run the below migration commands-

Migration Commands for Migrating TN Assets

a. Migrate TradingNetworks Component

./dbConfigurator.sh –action migrate –dbms oracle –component TradingNetworks –version latest –url “db_url” –user username –password ********

b. Migrate TradingNetworksArchive Component

./dbConfigurator.sh –action migrate –dbms oracle –component TradingNetworksArchive –version latest –url “db_url” –user username –password ********

c. Migrate MywebemthosServer Component

./dbConfigurator.sh –action migrate –dbms oracle –component MywebMethodsServer –version latest –url “db_url” –user username –password ********

d. Migrate ISInternal Component

./dbConfigurator.sh –action migrate –dbms oracle –component ISInternal –version latest –url “db_url” –user username –password ********

e. Migrate CentralConfiguration Component

./dbConfigurator.sh –action migrate –dbms oracle –component CentralConfiguration –version latest –url “db_url” –user username –password ********

f. Migrate CommonDirectoryServices Component

./dbConfigurator.sh –action migrate –dbms oracle –component CommonDirectoryServices –version latest –url “db_url” –user username –password ********

g. Migrate TaskEngine Component

./dbConfigurator.sh –action migrate –dbms oracle –component TaskEngine –version latest –url “db_url” –user username –password ********

6. Once the components are migrated you need to check the version of the component by running the catalog component on the respective Schemas.

Catalog Commands for Migrating TN Assets

For IS Schema, TN Schema, and MW Schema

./dbConfigurator.sh -a catalog -d oracle -l “url” -u username -p *****

where username is the respective schema name

7. Now if you go to the Export Asset tab you will be able to see your TN Assets.

Reference

https://www.softwareag.com/en_corporate/platform/integration-apis/webmethods-integration.html

Written by Shivani Sarthi

Shivani Sarthi is a Software Consultant at Knoldus Software. She has completed her MCA from BCIIT and Bachelors in Electronic Science from Delhi University. She has a keen interest toward learning new technologies. Her practice area is Devops. When not working, you will find her watching anime or with a book.