My Oracle Support Banner

TSAM Query BRIDGE Data Will Get "ORA-00904: "LINKADDRESSES": invalid identifier " Error (Doc ID 1362155.1)

Last updated on FEBRUARY 18, 2019

Applies to:

Oracle Tuxedo System and Applications Monitor (TSAM) - Version 11.1.1.1.0 to 11.1.1.1.0 [Release 11g]
Information in this document applies to any platform.

Symptoms

On the TSAM Manager console "BRIDGE" page, if you select machine with the default value (My master machine) and any Remote Machine, select "Historical" for Monitoring Mode, then click "Submit", you will get the error below in the Weblogic log:

com.oracle.tsam.exception.ExceptionRemote: org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00904: "LINKADDRESSES": invalid identifier
{prepstmnt 25175164 SELECT avg(l.PendNumber), avg(l.PendBytes), sum(l.AccNumber), sum(l.AccBytes) FROM tsam.MON_BRGLINK l, tsam.MON_BRIDGE g WHERE domain =? AND machine =? AND tuxgroup =? AND linkaddresses =? AND LogTime BETWEEN ? AND ? AND l.MON_BRIDGEID = g.ID [params=(Object) simpappmp:mptest:220002, (Object) mptest, (Object) mptest, (Object) mp1, (Object) 2011-09-19 23:00:00.662, (Object) 2011-09-20 00:00:00.662]} [code=904, state=42000]
at com.oracle.tsam.query.MetricServiceImpl.getHistoricalBridgesStat(MetricServiceImpl.java:310)
at com.oracle.tsam.view.explorer.contentview.bridge.BridgeContentView.updateHistoryMonGraphData(BridgeContentView.java:1155)
at com.oracle.tsam.view.explorer.contentview.bridge.BridgeContentView.initData(BridgeContentView.java:1036)
at com.oracle.tsam.view.explorer.contentview.bridge.BridgeContentView.submit(BridgeContentView.java:967)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.