SOLVED Troubleshooting "No Response Captured" Issue with New Generic DevOps MBean

[wlcommunityusers]

Hi,

Do you know why I keep getting the no response captured ?

New Generic DevOps MBEAN

I did this before but now it just keeps giving the no response captured.

[can.sahin-wlsdmteam]

@wlcommunityusers

Hi,

You need to make sure the SQL result set is not dynamic. Horizontal or Vertical options are available. Please put your sql result from sql editor, then let us know what is missing in your DevOps MBean transformation.

 Please add result…
SELECT COUNT(*) AS COUNT_NO, SERVER_ID
FROM $TABLENAME.SEAT_ASSIGNMENT
GROUP BY SERVER_ID
ORDER BY COUNT_NO

[can.sahin-wlsdmteam]

This post is deleted!

[can.sahin-wlsdmteam]

@wlcommunityusers

Hi,

The output of your query should be 1 attribute and 1 value. You can follow the tutorial below as an example.

Link: https://www.youtube.com/watch?v=6RVqB-KXiWE&ab_channel=WLSDMNativeWebLogicMonitoringandDiagnostics

Best Regards.

[wlcommunityusers]

@can-sahin-wlsdmteam

Followed your video and as soon as I hit the transform it says no response captured.

Doing the same as your video just the transform doesn’t put the attribute in here.

[can.sahin-wlsdmteam]

@wlcommunityusers

Hi,

You need to make sure the SQL result set is not dynamic. Horizontal or Vertical options are available. Please put your sql result from sql editor, then let us know what is missing in your DevOps MBean transformation.

 Please add result…
SELECT COUNT(*) AS COUNT_NO, SERVER_ID
FROM $TABLENAME.SEAT_ASSIGNMENT
GROUP BY SERVER_ID
ORDER BY COUNT_NO

[wlcommunityusers]

@can-sahin-wlsdmteam

I think it works this time. Thanks