April 4, 2017 at 6:35 am
Hi All,
I am slightly confused by an error I am getting during a cube build.
The error is "Errors in the back-end database access module. OLE DB was unable to convert a value to the data type requested for column 9"
No problem I thought when I first saw this but after investigation I cannot find the issue.
I extracted the SQL from the error and determined which column it was referring to as column 9. I checked the data type in the table which was varchar(10). I then checked the analysis services database and every instance of that column i could find had a data type of string and a length of 10. The data in the source database for this column is all text data.
In fact I checked every column in the table with the analysis services database ( checked in the data source view, in the Cube, in the dimensions etc. ) every place I can see a referece to columns in this table the data type and length are a match for the source table.
Is there something I am missing here?
Thanks
April 5, 2017 at 9:38 am
This usually happens if a data type changes in the source data. Try downloading and installing BIDS Helper and then trying the Dimension Data Datype Discrepancy Check: https://bidshelper.codeplex.com/wikipage?title=Dimension%20Data%20Type%20Discrepancy%20Check&referringTitle=Documentation
This will root out any discrepancies and give you the option to change them.
Is it by any chance a column that is somehow calculated at query time, like in a view? If it's not specifically casted to something it may be the victim of an implicit conversion due to new data, which is why it would occur even though it would seem that nothing had changed.
April 5, 2017 at 1:01 pm
Hi,
Yes I use the BIDS helper already and it isn't showing any issues.
It is a view. I will try and add an explicit cast for that column or change it to be a table, see if that helps.
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply