Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to combine two JSON array list into single array list

Kannan SekarMar 2 2022

We are using Oracle 19C version. we have json like below,
{ "tktKey": "123456", "attlist1": [ { "attkey": "123", "attval": "abc" }, { "attkey": "456","attval": "def" } ], "attlist2": [{"attkey": "098", "attval": "xyz" } ]}
form above json i need to combine attlist1 and attlist2 and make it to single attlist.
The Excepted output should be like below,
{ "tktKey": "123456", "attlist": [ { "attkey": "123", "attval": "abc" }, { "attkey": "456", "attval": "def" }, { "attkey": "098", "attval": "xyz" } ]}

Comments

ReportsToolsComponent is not a Server, it contains backing files for Reports Builder, font files.
Repeat your steps with below command.
createReportsServerInstance(instanceName='frm_rep_servr_hostname',machine='AdminServerMachine')
Thanks, Suresh

Tony007

./wlst.sh

Initializing WebLogic Scripting Tool (WLST) ...

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands

wls:/offline> connect("weblogic","ofrwls12","hostname:7001")
Connecting to t3://hostname:7001 with userid weblogic ...
Successfully connected to Admin Server "AdminServer" that belongs to domain "Fr_domain".

Warning: An insecure protocol was used to connect to the server.
To ensure on-the-wire security, the SSL port or Admin port should be used instead.

wls:/Fr_domain/serverConfig/> createReportsServerInstance(instanceName='frm_rep_servr_hostname02',machine='AdminServerMachine')
Location changed to edit custom tree. This is a writable tree with No root.
For more help, use help('editCustom')

Starting an edit session ...
Started edit session, be sure to save and activate your changes once you are done.
Saving all your changes ...
Saved all your changes successfully.
Activating all your changes, this may take a while ...
The edit lock associated with this edit session is released once the activation is completed.
Activation completed
Reports Server instance "frm_rep_servr_hostname02" was successfully created.

/rwdiag.sh -FindAll

Reading the rwnetwork.conf from :/usr1/Oracle/Middleware/Oracle_Home/user_projects/domains/Fr_domain/config/fmwconfig/components/ReportsToolsComponent/frm_rep_servr_hostname01/rwnetwork.conf
Broadcast mechanism used to locate servers
------------------------------------------
Channel address = 228.5.6.7
Channel port = 14021

/usr1/Oracle/Middleware/Oracle_Home/user_projects/domains/Fr_domain/bin/startComponent.sh frm_rep_servr_hostname02
Rerun /rwdiag.sh -FindAll

Tony007

i did that still empty

rwdiag.sh can never return empty. The script should exit with REP-50503 or REP-50504
The script reads rwnetwork from frm_rep_servr_hostname01, so COMPONENT_NAME is correctly configured.
Double check if rwdiag.sh is running from /usr1/Oracle/Middleware/Oracle_Home/user_projects/domains/Fr_domain/reports/bin
Do you see the linux process for frm_rep_servr_hostname02?
What do you get when you run below.
http://<hostname>:<wls_reports_port>/reports/rwservlet/showjobs?server=frm_rep_servr_hostname02

Tony007

am geting

http://<hostname>:<wls_reports_port>/reports/rwservlet/showjobs?server=frm_rep_servr_hostname02

Did this answer the question? Yes No
REP-51002: Bind to Reports Server frm_rep_servr_hostname02 failed.

1 - 6

Post Details

Added on Mar 2 2022
#plsql, #sql, #sqldeveloper
11 comments
5,825 views