DataSet using db2 with decimal(12,2) field gives error

I am using IBM Rational? Application Developer for WebSphere? Software
Version: 8.0.2; Build ID: RADO802-I20110302_1155
database: DB2/NT 9.7.0

When I and creating dataset for my table I am getting error.
I have one of the field defined as decinmal(12,2)

BIRT converts it to float, not sure why.

I get the error when I have one fo the field as "Total_Revenue"
Message ID: CRKAB4C41EB03E

An error has occurred. See error log for more details.
com/ibm/db2/jcc/am/io

Here is my table definition
-- Database Version: DB2/NT Version 9.7.0

-- Table definition:
CREATE TABLE "DBA"."DAILY_REVENUE_DATA" (
"BUSINESS_DATE" TIMESTAMP NOT NULL ,
"KK_ID" CHAR(10) NOT NULL ,
"C_ID" CHAR(10) NOT NULL ,
"COLLECTIONTIMESTAMP" TIMESTAMP ,
"CLOSEOUT_TIMESTAMP" TIMESTAMP ,
"SERIAL_NBR" VARCHAR(40) NOT NULL ,
"DISTRICT_NBR" CHAR(3) NOT NULL ,
"AREA_ID" CHAR(2) NOT NULL ,
"TOTAL_REVENUE" DECIMAL(12,2) NOT NULL ,
"TOTAL_TRNSACTION_COUNT" INTEGER NOT NULL ,
"TIME_ON_NON_REVENUE_TRANSACTIONS" INTEGER ,
"TIME_ON_REVENUE_TRANSACTIONS" INTEGER ,
"FIRST_TRANSACTION_TIMESTAMP" TIMESTAMP ,
"LAST_TRANSACTION_TIMESTAMP" TIMESTAMP )
IN "SMLTSP" ;

-- Primary key:
ALTER TABLE "DBA"."DAILY_REVENUE_DATA"
ADD CONSTRAINT "PK_DAILY_REVENUE_DATA" PRIMARY KEY
("BUSINESS_DATE",
"KK_ID");

Find more posts tagged with

Comments

mwilliams

What is the error information in your log file?

Randhir

Thanks for looking into it.
It tells me to See error log for more details. But doesn't tell where the log is.

Another window pops up to report the error as optional I enter my email but it times out
Sorry I am new to BIRT and not sure how to set up email and error log.

Randhir

I was able to locate the error log, I am attaching it here.
Thanks
Randhir

Randhir

!ENTRY org.eclipse.jface 4 2 2011-05-02 11:31:05.185
!MESSAGE Problems occurred when invoking code from plug-in: "org.eclipse.jface".
!STACK 0
java.lang.NoClassDefFoundError: com/ibm/db2/jcc/am/io
at com.ibm.db2.jcc.am.bd.a(Unknown Source)
at com.ibm.db2.jcc.am.bd.a(Unknown Source)
at com.ibm.db2.jcc.am.bd.a(Unknown Source)
at com.ibm.db2.jcc.am.km.c(Unknown Source)
at com.ibm.db2.jcc.am.km.d(Unknown Source)
at com.ibm.db2.jcc.am.km.a(Unknown Source)
at com.ibm.db2.jcc.t4.db.g(Unknown Source)
at com.ibm.db2.jcc.t4.db.a(Unknown Source)
at com.ibm.db2.jcc.t4.t.a(Unknown Source)
at com.ibm.db2.jcc.t4.sb.h(Unknown Source)
at com.ibm.db2.jcc.am.km.eb(Unknown Source)
at com.ibm.db2.jcc.am.lm.ic(Unknown Source)
at com.ibm.db2.jcc.am.lm.b(Unknown Source)
at com.ibm.db2.jcc.am.lm.Vb(Unknown Source)
at com.ibm.db2.jcc.am.lm.executeQuery(Unknown Source)
at org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery(Unknown Source)
at org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaUsingDefaultPolicy(Unknown Source)
at org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaData(Unknown Source)
at org.eclipse.birt.report.data.oda.jdbc.bidi.BidiStatement.getMetaData(Unknown Source)
at org.eclipse.birt.report.data.oda.jdbc.ui.editors.MetaDataRetriever.<init>(Unknown Source)
at org.eclipse.birt.report.data.oda.jdbc.ui.editors.SQLDataSetEditorPage.collectDataSetDesign(Unknown Source)
at org.eclipse.datatools.connectivity.oda.design.internal.ui.DataSetWizardPageCore.finishDataSetDesign(Unknown Source)
at org.eclipse.datatools.connectivity.oda.design.internal.ui.DataSetWizardBase.collectDataSetDesignFromPage(Unknown Source)
at org.eclipse.datatools.connectivity.oda.design.internal.ui.DataSetWizardBase.finishDataSetDesign(Unknown Source)
at org.eclipse.datatools.connectivity.oda.design.internal.ui.DataSetWizardBase.getResponseSession(Unknown Source)
at org.eclipse.datatools.connectivity.oda.design.internal.designsession.DataSetDesignSessionBase.finishDataSetDesign(Unknown Source)
at org.eclipse.datatools.connectivity.oda.design.internal.designsession.DataSetDesignSessionBase.flush(Unknown Source)
at org.eclipse.datatools.connectivity.oda.design.ui.designsession.DataSetDesignSession.flush(Unknown Source)
at org.eclipse.birt.report.designer.data.ui.dataset.PropertyPageWrapper.canLeave(Unknown Source)
at org.eclipse.birt.report.designer.data.ui.property.AbstractPropertyDialog.showPage(Unknown Source)
at org.eclipse.birt.report.designer.data.ui.property.AbstractPropertyDialog.showSelectionPage(Unknown Source)
at org.eclipse.birt.report.designer.data.ui.dataset.DataSetEditor.showSelectionPage(Unknown Source)
at org.eclipse.birt.report.designer.data.ui.property.AbstractPropertyDialog$2$1.run(Unknown Source)
at org.eclipse.swt.custom.BusyIndicator.showWhile(Unknown Source)
at org.eclipse.birt.report.designer.data.ui.property.AbstractPropertyDialog$2.selectionChanged(Unknown Source)
at org.eclipse.jface.viewers.Viewer$2.run(Unknown Source)
at org.eclipse.core.runtime.SafeRunner.run(Unknown Source)
at org.eclipse.ui.internal.JFaceUtil$1.run(Unknown Source)
at org.eclipse.jface.util.SafeRunnable.run(Unknown Source)
at org.eclipse.jface.viewers.Viewer.fireSelectionChanged(Unknown Source)
at org.eclipse.jface.viewers.StructuredViewer.updateSelection(Unknown Source)
at org.eclipse.jface.viewers.StructuredViewer.handleSelect(Unknown Source)
at org.eclipse.jface.viewers.StructuredViewer$4.widgetSelected(Unknown Source)
at org.eclipse.jface.util.OpenStrategy.fireSelectionEvent(Unknown Source)
at org.eclipse.jface.util.OpenStrategy.access$4(Unknown Source)
at org.eclipse.jface.util.OpenStrategy$1.handleEvent(Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at org.eclipse.jface.window.Window.runEventLoop(Unknown Source)
at org.eclipse.jface.window.Window.open(Unknown Source)
at org.eclipse.birt.report.designer.ui.dialogs.BaseDialog.open(Unknown Source)
at org.eclipse.birt.report.designer.data.ui.providers.EditableDataSetNodeProvider.performEdit(Unknown Source)
at org.eclipse.birt.report.designer.internal.ui.views.DefaultNodeProvider.performRequest(Unknown Source)
at org.eclipse.birt.report.designer.internal.ui.views.actions.EditAction.doAction(Unknown Source)
at org.eclipse.birt.report.designer.internal.ui.views.actions.AbstractElementAction.run(Unknown Source)
at org.eclipse.birt.report.designer.internal.ui.views.RenameListener.doubleClick(Unknown Source)
at org.eclipse.jface.viewers.StructuredViewer$1.run(Unknown Source)
at org.eclipse.core.runtime.SafeRunner.run(Unknown Source)
at org.eclipse.ui.internal.JFaceUtil$1.run(Unknown Source)
at org.eclipse.jface.util.SafeRunnable.run(Unknown Source)
at org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(Unknown Source)
at org.eclipse.jface.viewers.AbstractTreeViewer.handleDoubleSelect(Unknown Source)
at org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSelected(Unknown Source)
at org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEvent(Unknown Source)
at org.eclipse.jface.util.OpenStrategy.access$0(Unknown Source)
at org.eclipse.jface.util.OpenStrategy$1.handleEvent(Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at org.eclipse.ui.internal.Workbench.runEventLoop(Unknown Source)
at org.eclipse.ui.internal.Workbench.runUI(Unknown Source)
at org.eclipse.ui.internal.Workbench.access$4(Unknown Source)
at org.eclipse.ui.internal.Workbench$7.run(Unknown Source)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Unknown Source)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Unknown Source)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(Unknown Source)
at org.eclipse.ui.internal.ide.application.IDEApplication.start(Unknown Source)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(Unknown Source)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(Unknown Source)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(Unknown Source)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(Unknown Source)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(Unknown Source)
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(Unknown Source)
at org.eclipse.equinox.launcher.Main.basicRun(Unknown Source)
at org.eclipse.equinox.launcher.Main.run(Unknown Source)
at org.eclipse.equinox.launcher.Main.main(Unknown Source)

!ENTRY org.eclipse.jface 4 2 2011-05-02 11:31:50.639
!MESSAGE Problems occurred when invoking code from plug-in: "org.eclipse.jface".
!STACK 0
java.lang.NoClassDefFoundError: com/ibm/db2/jcc/am/io
at com.ibm.db2.jcc.am.bd.a(Unknown Source)
at com.ibm.db2.jcc.am.bd.a(Unknown Source)
at com.ibm.db2.jcc.am.bd.a(Unknown Source)
at com.ibm.db2.jcc.am.lm.e(Unknown Source)
at com.ibm.db2.jcc.am.lm.d(Unknown Source)
at com.ibm.db2.jcc.am.lm.a(Unknown Source)
at com.ibm.db2.jcc.am.lm.setTimestamp(Unknown Source)
at org.eclipse.birt.report.data.oda.jdbc.Statement.setTimestamp(Unknown Source)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.setTimestamp(Unknown Source)
at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.doSetTimestamp(Unknown Source)
at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.setTimestamp(Unknown Source)
at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.setParameterValue(Unknown Source)
at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.setParameterValue(Unknown Source)
at org.eclipse.birt.data.engine.executor.DataSourceQuery.setInputParameterBinding(Unknown Source)
at org.eclipse.birt.data.engine.executor.DataSourceQuery.addParameterDefns(Unknown Source)
at org.eclipse.birt.data.engine.executor.DataSourceQuery.prepare(Unknown Source)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.prepareOdiQuery(Unknown Source)
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(Unknown Source)
at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Unknown Source)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(Unknown Source)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(Unknown Source)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(Unknown Source)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(Unknown Source)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(Unknown Source)
at org.eclipse.birt.report.data.adapter.impl.QueryExecutionHelper.executeQuery(Unknown Source)
at org.eclipse.birt.report.data.adapter.impl.QueryExecutionHelper.executeQuery(Unknown Source)
at org.eclipse.birt.report.data.adapter.impl.QueryExecutionHelper.executeQuery(Unknown Source)
at org.eclipse.birt.report.data.adapter.impl.DataSetMetaDataHelper.getRuntimeMetaData(Unknown Source)
at org.eclipse.birt.report.data.adapter.impl.DataSetMetaDataHelper.getRealMetaData(Unknown Source)
at org.eclipse.birt.report.data.adapter.impl.DataSetMetaDataHelper.getDataSetMetaData(Unknown Source)
at org.eclipse.birt.report.data.adapter.impl.DataSetMetaDataHelper.refreshMetaData(Unknown Source)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.refreshMetaData(Unknown Source)
at org.eclipse.birt.report.designer.data.ui.dataset.ExternalUIUtil.updateColumnCache(Unknown Source)
at org.eclipse.birt.report.designer.data.ui.providers.DefaultDataServiceProvider.updateColumnCache(Unknown Source)
at org.eclipse.birt.report.designer.internal.ui.data.DataService.updateColumnCache(Unknown Source)
at org.eclipse.birt.report.designer.data.ui.dataset.DataSetUIUtil.updateColumnCache(Unknown Source)
at org.eclipse.birt.report.designer.data.ui.dataset.DataSetUIUtil.updateColumnCache(Unknown Source)
at org.eclipse.birt.report.designer.data.ui.dataset.DataSetUIUtil.updateColumnCacheAfterCleanRs(Unknown Source)
at org.eclipse.birt.report.designer.data.ui.util.DTPUtil.updateDataSetHandle(Unknown Source)
at org.eclipse.birt.report.designer.data.ui.dataset.PropertyPageWrapper.canLeave(Unknown Source)
at org.eclipse.birt.report.designer.data.ui.property.AbstractPropertyDialog.showPage(Unknown Source)
at org.eclipse.birt.report.designer.data.ui.property.AbstractPropertyDialog.showSelectionPage(Unknown Source)
at org.eclipse.birt.report.designer.data.ui.dataset.DataSetEditor.showSelectionPage(Unknown Source)
at org.eclipse.birt.report.designer.data.ui.property.AbstractPropertyDialog$2$1.run(Unknown Source)
at org.eclipse.swt.custom.BusyIndicator.showWhile(Unknown Source)
at org.eclipse.birt.report.designer.data.ui.property.AbstractPropertyDialog$2.selectionChanged(Unknown Source)
at org.eclipse.jface.viewers.Viewer$2.run(Unknown Source)
at org.eclipse.core.runtime.SafeRunner.run(Unknown Source)
at org.eclipse.ui.internal.JFaceUtil$1.run(Unknown Source)
at org.eclipse.jface.util.SafeRunnable.run(Unknown Source)
at org.eclipse.jface.viewers.Viewer.fireSelectionChanged(Unknown Source)
at org.eclipse.jface.viewers.StructuredViewer.updateSelection(Unknown Source)
at org.eclipse.jface.viewers.StructuredViewer.handleSelect(Unknown Source)
at org.eclipse.jface.viewers.StructuredViewer$4.widgetSelected(Unknown Source)
at org.eclipse.jface.util.OpenStrategy.fireSelectionEvent(Unknown Source)
at org.eclipse.jface.util.OpenStrategy.access$4(Unknown Source)
at org.eclipse.jface.util.OpenStrategy$1.handleEvent(Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at org.eclipse.jface.window.Window.runEventLoop(Unknown Source)
at org.eclipse.jface.window.Window.open(Unknown Source)
at org.eclipse.birt.report.designer.ui.dialogs.BaseDialog.open(Unknown Source)
at org.eclipse.birt.report.designer.data.ui.providers.EditableDataSetNodeProvider.performEdit(Unknown Source)
at org.eclipse.birt.report.designer.internal.ui.views.DefaultNodeProvider.performRequest(Unknown Source)
at org.eclipse.birt.report.designer.internal.ui.views.actions.EditAction.doAction(Unknown Source)
at org.eclipse.birt.report.designer.internal.ui.views.actions.AbstractElementAction.run(Unknown Source)
at org.eclipse.birt.report.designer.internal.ui.views.RenameListener.doubleClick(Unknown Source)
at org.eclipse.jface.viewers.StructuredViewer$1.run(Unknown Source)
at org.eclipse.core.runtime.SafeRunner.run(Unknown Source)
at org.eclipse.ui.internal.JFaceUtil$1.run(Unknown Source)
at org.eclipse.jface.util.SafeRunnable.run(Unknown Source)
at org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(Unknown Source)
at org.eclipse.jface.viewers.AbstractTreeViewer.handleDoubleSelect(Unknown Source)
at org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSelected(Unknown Source)
at org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEvent(Unknown Source)
at org.eclipse.jface.util.OpenStrategy.access$0(Unknown Source)
at org.eclipse.jface.util.OpenStrategy$1.handleEvent(Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at org.eclipse.ui.internal.Workbench.runEventLoop(Unknown Source)
at org.eclipse.ui.internal.Workbench.runUI(Unknown Source)
at org.eclipse.ui.internal.Workbench.access$4(Unknown Source)
at org.eclipse.ui.internal.Workbench$7.run(Unknown Source)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Unknown Source)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Unknown Source)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(Unknown Source)
at org.eclipse.ui.internal.ide.application.IDEApplication.start(Unknown Source)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(Unknown Source)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(Unknown Source)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(Unknown Source)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(Unknown Source)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(Unknown Source)
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(Unknown Source)
at org.eclipse.equinox.launcher.Main.basicRun(Unknown Source)
at org.eclipse.equinox.launcher.Main.run(Unknown Source)
at org.eclipse.equinox.launcher.Main.main(Unknown Source)

I could not upload the file, so attaching the exception here.

I thought of looking into more on dataset from my home, to my surprise the dataset
returned the result.

I tried preview of my report just now, the preview is displaying my report.
It must be something to do my some settings between home and work.
I am using my work laptop, from home I am connection to work using vpn.
my database and RAD is installed on my laptop (local).

Thanks
Randhir

mwilliams

Randhir,

So, in what situation is it working? At home with your work computer hooked to VPN, but not at work? It seems to not be finding your class in the error you posted, so you might check and make sure that all the jars you need are in your classpath.

Randhir

Thanks Michael, I really appreciate your help. 
Someone else created these reports using his local data source, they worked fine. 
I imported his project on my RAD (newer version). I added my data source using my 
local database. I added my reports they worked fine. 
 
I wanted to switch the data source (stored in library) with mine. I did not find 
easy way to do except modify each data sets. I got this error when I was replacing 
the data source created by team mate. 
 
When I logged in from home, using VPN I was able to modify all the data sets and 
updated them with my data source. 
 
Since all data sets are updated, I do not see the error at my work either. 
 
Now when I switch these reports from my dev box to test / prod box. What is the best 
practice to change the data source. Data source keeps the id to tag the data source. 
I wonder I might see these issue then. 
 
Thanks, 
Randhir 
 
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="76671" data-time="1304687543" data-date="06 May 2011 - 06:12 AM">
Randhir, 
 
So, in what situation is it working? At home with your work computer hooked to VPN, but not at work? It seems to not be finding your class in the error you posted, so you might check and make sure that all the jars you need are in your classpath. </blockquote>