Performance analysis get ERROR [-2003] (at 508): Output columns too long

[Former Member]

Hi,

using Performance Analysis from Database Studio é get follow error after click on Get Bottleneck Candidates button.

MaxDB server version is 7.6.06.03 running at Linux x86_64

Database Studio version is 7.7.06.09 running at Windows XP

------------------------------------------------------------------------------------------------------------------------
21/10/2009      09:12:08
------------------------------------------------------------------------------------------------------------------------
ERROR           Could not retrieve bottlenecks. Internal Error occured.
------------------------------------------------------------------------------------------------------------------------
Component     : Performance Analysis
Detail Message: com.sap.sdb.tools.analysis.performance.model.sql.PaMdlSqlInternalException: Could not retrieve bottleneck candidates for database 'bi.abracy.com.br:ABRACY'. Invalid filter expression
	at com.sap.sdb.tools.analysis.performance.model.sql.monitoring.internal.MonitoringController.getBottleneckCandidates(MonitoringController.java:216)
	at com.sap.sdb.tools.analysis.performance.model.sql.analysis.internal.Analysis.getBottleneckCandidates(Analysis.java:102)
	at com.sap.sdb.tools.resources.performance.sql.internal.SqlPerformanceAnalysis.getBottleneckCandidates(SqlPerformanceAnalysis.java:177)
	at com.sap.sdb.tools.ui.performance.sql.BottleneckCandidatesComposite$TableContentProvider.getChildren(BottleneckCandidatesComposite.java:831)
	at com.sap.sdb.tools.ui.performance.sql.BottleneckCandidatesComposite$TableContentProvider.getElements(BottleneckCandidatesComposite.java:892)
	at org.eclipse.jface.viewers.StructuredViewer.getRawChildren(StructuredViewer.java:937)
	at org.eclipse.jface.viewers.ColumnViewer.getRawChildren(ColumnViewer.java:660)
	at org.eclipse.jface.viewers.AbstractTableViewer.getRawChildren(AbstractTableViewer.java:1066)
	at org.eclipse.jface.viewers.StructuredViewer.getFilteredChildren(StructuredViewer.java:871)
	at org.eclipse.jface.viewers.StructuredViewer.getSortedChildren(StructuredViewer.java:994)
	at org.eclipse.jface.viewers.AbstractTableViewer.internalRefreshAll(AbstractTableViewer.java:682)
	at org.eclipse.jface.viewers.AbstractTableViewer.internalRefresh(AbstractTableViewer.java:630)
	at org.eclipse.jface.viewers.StructuredViewer$8.run(StructuredViewer.java:1460)
	at org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1368)
	at org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1330)
	at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1458)
	at org.eclipse.jface.viewers.ColumnViewer.refresh(ColumnViewer.java:514)
	at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1415)
	at com.sap.sdb.tools.ui.performance.sql.BottleneckCandidatesComposite.refresh(BottleneckCandidatesComposite.java:904)
	at com.sap.sdb.tools.ui.performance.sql.BottleneckCandidatesComposite.analysisEvent(BottleneckCandidatesComposite.java:1087)
	at com.sap.sdb.tools.resources.performance.internal.events.InternalAnalysisEventManager$1.run(InternalAnalysisEventManager.java:233)
	at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:37)
	at org.eclipse.core.runtime.Platform.run(Platform.java:857)
	at com.sap.sdb.tools.resources.performance.internal.events.InternalAnalysisEventManager.notify(InternalAnalysisEventManager.java:224)
	at com.sap.sdb.tools.resources.performance.internal.events.InternalAnalysisEventManager.broadcastEvent(InternalAnalysisEventManager.java:82)
	at com.sap.sdb.tools.resources.performance.AnalysisEventManager.broadcastEvent(AnalysisEventManager.java:37)
	at com.sap.sdb.tools.ui.performance.sql.AnalyseStartComposite.start(AnalyseStartComposite.java:641)
	at com.sap.sdb.tools.ui.performance.sql.AnalyseStartComposite$4.mouseUp(AnalyseStartComposite.java:298)
	at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:206)
	at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
	at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938)
	at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3682)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3293)
	at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2389)
	at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2353)
	at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2219)
	at org.eclipse.ui.internal.Workbench$4.run(Workbench.java:466)
	at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:289)
	at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:461)
	at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
	at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:106)
	at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:153)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:504)
	at org.eclipse.equinox.launcher.Main.basicRun(Main.java:443)
	at org.eclipse.equinox.launcher.Main.run(Main.java:1169)
Caused by: com.sap.sdb.tools.analysis.performance.base.dbaccess.PaDbaDatabaseErrorException: Error accessing resource monitor for database 'bi.abracy.com.br:ABRACY'.
	at com.sap.sdb.tools.analysis.performance.base.dbaccess.query.internal.DbBottleneckCandidates.getBottleneckCandidates(DbBottleneckCandidates.java:271)
	at com.sap.sdb.tools.analysis.performance.model.sql.monitoring.internal.MonitoringController.getBottleneckCandidates(MonitoringController.java:192)
	... 52 more
Caused by: com.sap.dbtech.jdbc.exceptions.DatabaseException: [-2003] (at 508): Output columns too long
	at com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:65)
	at com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:1061)
	at com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:689)
	at com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSapDB.java:1808)
	at com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:913)
	at com.sap.dbtech.jdbc.CallableStatementSapDB.doParse(CallableStatementSapDB.java:231)
	at com.sap.dbtech.jdbc.CallableStatementSapDB.constructor(CallableStatementSapDB.java:184)
	at com.sap.dbtech.jdbc.CallableStatementSapDB.<init>(CallableStatementSapDB.java:95)
	at com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:970)
	at com.sap.dbtech.jdbc.trace.Connection.prepareStatement(Connection.java:316)
	at com.sap.sdb.tools.analysis.performance.base.dbaccess.query.internal.DbBottleneckCandidates.getBottleneckCandidates(DbBottleneckCandidates.java:263)
	... 53 more

any know issue?

best regards

Clóvis

[lbreddemann · Accepted solution]

Hi Clovis,

sorry, but to my knowlegde the performance analysis feature of DB Studio is not yet fully supported for 7.7 databases.

It's still somewhat in development...

When I don't have a SAP NetWeaver CCMS at hand I usually go for running the selects against sysparseid manually as it is described in the [WIKI|http://wiki.sdn.sap.com/wiki/display/MaxDB/Command+Monitor].

regards,

Lars