We are experiencing the following error when querying data from the dimension view. The data gets loaded into dimension without any problem.
ORA-33674: Data block exceeds the maximum size of 100 bytes.
33674. 00000 - "(FTCODE00) Data block exceeds the maximum size of %d bytes."
I have searched this forum and looked at bug 7579305 and note 751511.1 but it does not seem to apply to our case. I have already increase the attribute size to 200 (max length of data in our case is 196). I even tried to reduce the size of data loaded into the dimension to only 50 characters but still the same problem (although this time the error occurred on a different row). We have international characters in our data and there are about 64,000 rows in the dimension. Not sure that if matters. Any help is appreciated.
The dimension key size in 188.8.131.52 is limited to 60 characters, so if any of your members has more than this, then you will run into the problem. Did you clear the dimension before reloading the data? If not, then existing members (longer than 60 characters) would remain in the dimension even if they are no longer in the source table.
Yes I did clear the dimension data before reloading. The issue turned out to be multi byte characters in the data. I was using substr(column,1,100) to create the dimension key. It seems like the dimension key is limited to 100 bytes, not characters. Using substrb(column,1,100) for the key fixed the issue.
I think this problem may have been addressed with a fix to Bug 14167351 - ORA-33674: DATA BLOCK EXCEEDS THE MAXIMUM SIZE OF 100 BYTES. This fix went into the OLAP D patch for 11.203 of the database.