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
-
For PostgreSQL, run the following command:
select encode(<column name>, 'escape') from <table name>;
-
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.
enableProductModelGlobalCache
, enableActionModelGlobalCache
, and
enablePlanFragmentGlobalCache
flag values are true, then only this GET API works.