Invalid object name error

I hope this is the right forum for this type of question. [font="arial;"]We have been working on reports for a month, everything was going along okay. A couple days ago, a colleague who had been working on reports, started having problems. Now every report fails, even though couple days ago the same reports were working. The reports work fine for me. [/font] [font="arial;"]Sample of the error message below[/font] [font="calibri;"]Data (id = 1299): [/font][font="calibri;"]+ Cannot get the result set metadata.[/font][font="calibri;"] org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.[/font][font="calibri;"]SQL error #1:Invalid object name 'V_ABORT_TRACKING_REPORT'.[/font][font="calibri;"];[/font][font="calibri;"] com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'V_ABORT_TRACKING_REPORT'. (Element ID:1299) [/font][font="calibri;"]odaconsumer.CannotGetResultSetMetaData ( 1 time(s) )[/font][font="calibri;"]detail : org.eclipse.birt.report.engine.api.EngineException: Cannot get the result set metadata.[/font][font="calibri;"] org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.[/font][font="calibri;"]SQL error #1:Invalid object name 'V_ABORT_TRACKING_REPORT'.[/font][font="calibri;"];[/font][font="calibri;"] com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'V_ABORT_TRACKING_REPORT'. (Element ID:1299)[/font][font="calibri;"] at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1237)[/font][font="calibri;"] at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1216)[/font][font="calibri;"] at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:96)[/font][font="calibri;"] at org.eclipse.birt.report.engine.executor.DataItemExecutor.execute(DataItemExecutor.java:75)[/font][font="calibri;"] at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)[/font][font="calibri;"] at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)[/font][font="calibri;"] at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)[/font][font="calibri;"] at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)[/font][font="calibri;"] at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)[/font][font="calibri;"] at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)[/font][font="calibri;"] at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:111)[/font][font="calibri;"] at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes[/font][font="calibri;"]........[/font] [font="arial;"]The table/views exists; we have authority/permission to view the table[/font] "Preview results" from the Data Set dialog works fine. The error appears when "Preview" is selected. [font="arial;"]Eclipse IDE for Java and Report Developers[/font][font="arial;"]Indigo, Release 2[/font] [font="arial;"]Tried[/font][font="arial;"]New eclipse workspace.[/font][font="arial;"]Using console version of ecipse, eclipsec.exe[/font][font="arial;"]Creating new simple report [/font] Does anyone have any ideas what happened? ThanksBob

Find more posts tagged with

Comments

kclark

Can you attach the rptdesign please?