Hello everybody,

We're a couple of students who are working on a trainee-program to make a data warehouse and a BI-solution.

We haven't really gotten a lot of experience, but we're trying. We've succesfully created a couple of dimensions. We are able to refill and update them using pan.

BUT ...

some dimensions are acting really strange. (2 dimensions I think). I've been given the following error message:

ERROR 13-04 12:27:46,328 - Dimension lookup/update.0 - Unexpected error :
ERROR 13-04 12:27:46,328 - Dimension lookup/update.0 - java.lang.RuntimeExceptio
n: Error serializing row to byte array
at org.pentaho.di.core.row.RowMeta.extractData(RowMeta.java:765)
at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.addToCache
(DimensionLookup.java:1022)
at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.lookupValu
es(DimensionLookup.java:470)
at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.processRow
(DimensionLookup.java:183)
at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2664)
at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.run(Dimens
ionLookup.java:1267)
Caused by: java.lang.RuntimeException: ACCCFSIGN BigNumber : There was a data ty
pe error: the data type of java.lang.Double object [-10.0] does not correspond t
o value meta [BigNumber]
at org.pentaho.di.core.row.ValueMeta.writeData(ValueMeta.java:2020)
at org.pentaho.di.core.row.RowMeta.writeData(RowMeta.java:442)
at org.pentaho.di.core.row.RowMeta.extractData(RowMeta.java:758)
... 5 more


The problem is, there isn't a BigNumber in the dimension OR in the database (oracle). An other error (the other dimension) is the following:

ERROR 13-04 12:33:34,984 - Dimension lookup/update.0 - Unexpected error :
ERROR 13-04 12:33:34,984 - Dimension lookup/update.0 - java.lang.RuntimeExceptio
n: Error serializing row to byte array
at org.pentaho.di.core.row.RowMeta.extractData(RowMeta.java:765)
at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.addToCache
(DimensionLookup.java:1022)
at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.lookupValu
es(DimensionLookup.java:470)
at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.processRow
(DimensionLookup.java:183)
at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2664)
at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.run(Dimens
ionLookup.java:1267)
Caused by: java.lang.RuntimeException: ENTSEQNR BigNumber : There was a data typ
e error: the data type of java.lang.Double object [105.0] does not correspond to
value meta [BigNumber]
at org.pentaho.di.core.row.ValueMeta.writeData(ValueMeta.java:2020)
at org.pentaho.di.core.row.RowMeta.writeData(RowMeta.java:442)
at org.pentaho.di.core.row.RowMeta.extractData(RowMeta.java:758)
... 5 more


There also isn't a big number in here. Could somebody please explain why this is happening to these dimensions, and not to the other? And what the possible solution could be?

Kind Regards

Svekke