Eclipse Community Forums: Newcomers » SQL error #1:Invalid object name 'T

Home » Newcomers » Newcomers » SQL error #1:Invalid object name 'T_TRIRIGATABLE.(SQL statement does not return a ResultSet object.)

Show: Today's Messages :: Show Polls :: Message Navigator

SQL error #1:Invalid object name 'T_TRIRIGATABLE. [message #1715051]

Wed, 18 November 2015 19:17

latronda Washington

Messages: 11
Registered: March 2014

Junior Member

Hi All, We have upgraded from Version 2.6.2 to 4.4.2 on a IBM TRIRIGA Platform. The connection has been successful under Windows>Preference>IBM TRIRIGA BIRT Preferences and also, our data source tests for a successful connection. However, when I try to create a simple report with the query such as Select * from TABLE, and look at the output, I get the below error. PLEASE HELP with any suggestions:

org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot get the result set metadata.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
SQL error #1:Invalid object name 'T_TRICOSTCODEINTERMEDIATE'.
;
java.sql.SQLException: Invalid object name 'T_TRICOSTCODEINTERMEDIATE'.

at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.newException(ExceptionHandler.java:52)

at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.throwException(ExceptionHandler.java:108)

at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.throwException(ExceptionHandler.java:84)

at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getRuntimeMetaData(PreparedStatement.java:414)

at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getProjectedColumns(PreparedStatement.java:377)

at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.doGetMetaData(PreparedStatement.java:347)

at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.execute(PreparedStatement.java:563)

at org.eclipse.birt.data.engine.executor.DataSourceQuery.execute(DataSourceQuery.java:970)

at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:503)

at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1222)

at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:233)

at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:178)

at org.eclipse.birt.data.engine.impl.QueryResults.getResultMetaData(QueryResults.java:132)

at org.eclipse.birt.report.data.adapter.impl.DataSetMetaDataHelper.getRuntimeMetaData(DataSetMetaDataHelper.java:194)

at org.eclipse.birt.report.data.adapter.impl.DataSetMetaDataHelper.getRealMetaData(DataSetMetaDataHelper.java:153)

at org.eclipse.birt.report.data.adapter.impl.DataSetMetaDataHelper.getDataSetMetaData(DataSetMetaDataHelper.java:115)

at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.getDataSetMetaData(DataRequestSessionImpl.java:240)

at org.eclipse.birt.report.designer.data.ui.util.DataSetProvider.populateAllOutputColumns(DataSetProvider.java:221)

at org.eclipse.birt.report.designer.data.ui.dataset.OutputColumnsPage.populateOutputColums(OutputColumnsPage.java:417)

at org.eclipse.birt.report.designer.data.ui.dataset.OutputColumnsPage.updateOutputColumns(OutputColumnsPage.java:361)

at org.eclipse.birt.report.designer.data.ui.dataset.OutputColumnsPage.pageActivated(OutputColumnsPage.java:245)

at org.eclipse.birt.report.designer.data.ui.property.AbstractPropertyDialog.showPage(AbstractPropertyDialog.java:588)

at org.eclipse.birt.report.designer.data.ui.property.AbstractPropertyDialog.showSelectionPage(AbstractPropertyDialog.java:482)

at org.eclipse.birt.report.designer.data.ui.dataset.DataSetEditor.showSelectionPage(DataSetEditor.java:913)

at org.eclipse.birt.report.designer.data.ui.property.AbstractPropertyDialog$2$1.run(AbstractPropertyDialog.java:438)

at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)

at org.eclipse.birt.report.designer.data.ui.property.AbstractPropertyDialog$2.selectionChanged(AbstractPropertyDialog.java:433)

at org.eclipse.jface.viewers.Viewer$2.run(Viewer.java:163)

at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)

at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:50)

at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:178)

at org.eclipse.jface.viewers.Viewer.fireSelectionChanged(Viewer.java:160)

at org.eclipse.jface.viewers.StructuredViewer.updateSelection(StructuredViewer.java:2171)

at org.eclipse.jface.viewers.StructuredViewer.handleSelect(StructuredViewer.java:1202)

at org.eclipse.jface.viewers.StructuredViewer$4.widgetSelected(StructuredViewer.java:1231)

at org.eclipse.jface.util.OpenStrategy.fireSelectionEvent(OpenStrategy.java:242)

at org.eclipse.jface.util.OpenStrategy.access$4(OpenStrategy.java:236)

at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:408)

at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)

at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4353)

at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1061)

at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4172)

at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3761)

at org.eclipse.jface.window.Window.runEventLoop(Window.java:832)

at org.eclipse.jface.window.Window.open(Window.java:808)

at org.eclipse.birt.report.designer.ui.dialogs.BaseDialog.open(BaseDialog.java:111)

at org.eclipse.birt.report.designer.data.ui.providers.EditableDataSetNodeProvider.performEdit(EditableDataSetNodeProvider.java:102)

at org.eclipse.birt.report.designer.internal.ui.views.DefaultNodeProvider.performRequest(DefaultNodeProvider.java:472)

at org.eclipse.birt.report.designer.internal.ui.views.actions.EditAction.doAction(EditAction.java:85)

at org.eclipse.birt.report.designer.internal.ui.views.actions.AbstractElementAction.run(AbstractElementAction.java:70)

at org.eclipse.birt.report.designer.internal.ui.views.RenameListener.doubleClick(RenameListener.java:214)

at org.eclipse.jface.viewers.StructuredViewer$1.run(StructuredViewer.java:831)

at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)

at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:50)

at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:178)

at org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(StructuredViewer.java:828)

at org.eclipse.jface.viewers.AbstractTreeViewer.handleDoubleSelect(AbstractTreeViewer.java:1472)

at org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSelected(StructuredViewer.java:1237)

at org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEvent(OpenStrategy.java:252)

at org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.java:249)

at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:311)

at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)

at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4353)

at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1061)

at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4172)

at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3761)

at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1151)

at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)

at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1032)

at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:148)

at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:636)

at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)

at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:579)

at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)

at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:135)

at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)

at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)

at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:235)

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:648)

at org.eclipse.equinox.launcher.Main.basicRun(Main.java:603)

at org.eclipse.equinox.launcher.Main.run(Main.java:1465)

at org.eclipse.equinox.launcher.Main.main(Main.java:1438)

Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
SQL error #1:Invalid object name 'T_TRICOSTCODEINTERMEDIATE'.
;
java.sql.SQLException: Invalid object name 'T_TRICOSTCODEINTERMEDIATE'.

at org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery(Statement.java:481)

at org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaUsingDefaultPolicy(Statement.java:388)

at org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaData(Statement.java:330)

at org.eclipse.birt.report.data.oda.jdbc.bidi.BidiStatement.getMetaData(BidiStatement.java:56)

at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.doGetMetaData(OdaQuery.java:423)

at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.getMetaData(OdaQuery.java:390)

at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getRuntimeMetaData(PreparedStatement.java:407)

... 84 more

Caused by: java.sql.SQLException: Invalid object name 'T_TRICOSTCODEINTERMEDIATE'.

at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)

at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2894)

at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2334)

at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:643)

at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:506)

at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:979)

at org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery(Statement.java:477)

... 90 more

Report message to a moderator

Re: SQL error #1:Invalid object name 'T_TRIRIGATABLE. [message #1715057 is a reply to message #1715051]

Wed, 18 November 2015 21:38

Russell Bateman

Messages: 3798
Registered: July 2009
Location: Provo, Utah, USA

Senior Member

(There's a separate Eclipse BIRT forum.)

Report message to a moderator

Re: SQL error #1:Invalid object name 'T_TRIRIGATABLE. [message #1715058 is a reply to message #1715057]

Wed, 18 November 2015 21:52

latronda Washington

Messages: 11
Registered: March 2014

Junior Member

I apologize, which forum should I post this in?

Again, my apologies.

Report message to a moderator

Re: SQL error #1:Invalid object name 'T_TRIRIGATABLE. [message #1715061 is a reply to message #1715058]

Wed, 18 November 2015 22:33

Russell Bateman

Messages: 3798
Registered: July 2009
Location: Provo, Utah, USA

Senior Member

On 11/18/2015 02:52 PM, latronda Washington wrote:
> I apologize, which forum should I post this in?
>
> Again, my apologies.

Sorry, yes, in the Eclipse BIRT forum. It's under Eclipse Projects at
eclipse.org.

Report message to a moderator

Previous Topic:	Error code 143
Next Topic:	Eclipse Sandboxed // Green border?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 19:07:05 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter