Debugging tools for production

Read BLOB data from Database

To read the binary large object (BLOB) data from the database, perform the following procedures:

    Procedure
  1. For PostgreSQL, run the following command:

    select encode(<column name>, 'escape') from <table name>;

  2. For Oracle, perform the following steps:

    a) Run the upgrade script which creates a function used to read BLOB data.

    b) Run the following command to read the BLOB data:

    select blob_to_clob(<column name>) from<table name> where filename='<file name>'

GET REST APIs in Catalog Service and AOPD

Through these APIs, you can verify the models that you have published.

GET APIs in Catalog: Fetch data from the database (Relational)

Endpoint: http://<host_address>:<port_address>/v1/<actionModel>/bulk or <planFragmentModel>/bulk or <productModel>/bulk

Method: GET

Fill the actionModelIdList, planFragmentModelIdList, or productModelIdList fields and click Execute.

All the models are retrieved from the database (Redis or Relational) that are published.

GET APIs in AOPD: Fetch data from the in-memory cache.

Endpoint: http://<host_address>:<port_address>/<actionModels> or <productModels>

Method: GET

Fill the actionModelIdList or productModelIdList fields and click Execute.

All the models are retrieved from the in-memory cache and displayed.

GET API in Orchestrator: Fetch data from the in-memory cache.

Endpoint: http://<host_address>:<port_address>/<planFragments>

Method: GET

Fill the planFragmentIdList field and click Execute. All the models are retrieved from the in-memory cache and displayed.

Note: If the enableProductModelGlobalCache, enableActionModelGlobalCache, and enablePlanFragmentGlobalCache flag values are true, then only this GET API works.