Sterling OMS Random Useful Query and Tips

By | 01/12/2018

Sterling OMS Random Useful Query and Tips

Sterling OMS Random Useful Query and Tips

Wish you happy new year every one. After long break we are coming with post. Here is few useful tips. Please share your feedback.

Sterling OMS Random Useful Query and Tips

How to find associated transactions to given agent server ?

select distinct yt.TRANNAME,yt.PROCESS_TYPE_KEY from YFS_AGENT_CRITERIA yac, yfs_server ys, yfs_transaction yt
where
ys.server_key=yac.server_key and
ys.SERVER_NAME=’SearchAgent’ and
yt.TRANSACTION_KEY = yac.TRANSACTION_KEY and
ys.server_type=’01’; — agent server

How to find associated service names to given integration server ?

select yf.flow_name, yf.FLOW_GROUP_NAME from yfs_flow yf, yfs_sub_flow ysf, yfs_server ys
where
ys.server_key=ysf.server_key and
yf.flow_key = ysf.flow_key and
ys.SERVER_NAME=’CreateOrderServer’ and –server name
ys.server_type=’00’; –integration server

How to find all the integration servers ?

select server_name, transport_type_key from yfs_server where server_type=’00’;

How to find all the agent servers ?

select server_name, transport_type_key from yfs_server where server_type=’01’;

How to find all the active running servers ?

select * from YFS_HEARTBEAT where status=’00’;

  • 00 — Running
  • 01 — Stopped
  • 02 –Terminated

Note : To get correct result make sure heartbeat monitor is running

How to find the services calls createOrder standard API ?

select yf.flow_name, yf.FLOW_GROUP_NAME from yfs_flow yf, yfs_sub_flow ysf where ysf.config_xml like ‘%createOrder%’
and ysf.FLOW_KEY = yf.FLOW_KEY;

Note: You can use the same query to find which are all the services uses your email address.

What is the use of YFS_GRAPH_UI table ?

This table stores X, Y position information of service (SFD) components. When service opened, places the components same place as saved.

YFS_GRAPH_UI

How to give more memory to Java Applet and make configuration load faster ?

Sterling OMS Random Useful Query and Tips

How to check applet loading status and error details ?

  1. Enable Tracing
  2. Enable logging
  3. Show Console

Java Control Panel Enable Trace

How to find which Java version used to compile jar file ?

Open the Jar file Jar decompiler and look for Manifest file, this file holds Java version used for creating jar file

If manifest file not present you can move the jar file to Linux environment and type command file <File name>

Linux File Command

From Google

If you have any question or suggestion please email to : support@activekite.com

To get more OMS related updates register with us

Sterling OMS Interview Questions

9 thoughts on “Sterling OMS Random Useful Query and Tips

    1. ActiveKite-Admin

      Thanks pls keep sharing your feedback

      Reply
  1. Prathap

    Happy new year Sir ji, Very use ful info. Thank you so much !!!

    Reply
    1. admin Post author

      You are welcome. Please keep sharing your feedback to improve as better. Thanks once again

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *