Post reply

Errors in the back-end database access module. OLE DB reported an overflow of the data type for column 7

  • December 2, 2011 at 8:37 am

    #149763

    Hi All,

    I had an issue that started with dimension processing failing due to 4GB limit on the .asstore file :w00t: . Working around it :cool:, I got the dimension to process and got over the error (changed the key column to int from bigint). Now I can process this dimension successfully and 5 out of 6 measure groups also process successfully :hehe:.

    The sixth one is trying to get cute with my development :w00t: . It throws up the error "Errors in the back-end database access module. OLE DB reported an overflow of the data type for column 7". I have verified that there is no value in the table that overshoots the data type limit.

    Request any help on how to deal with this error with given conditions

  • December 10, 2011 at 8:10 am

    #1419714

    Resolved the issue. The data type of the joining column between dimension base table and measure group base fact table, had difference in data type with INT in dim base table and BIGINT in measure group base fact table. Changed the data type to be same in both, and issue resolved :hehe:

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply