I am working on a mysql based multi source universe.The environment is BO 4.1 sp6 and this universe is built from scratch.
There are few description objects in mysql 5 database which have been defined as long text in universe and database.
The objects works fine while testing them in IDT however when i try to use them in webi the refresh fails with error:
The following database error occurred(CS) "unexpected behavior".IES 10901 WIS 10901 Bad value for the Field
I know this is due to the database driver and the objects works fine when i do a substring to populate only 40 chars of the description field however i would like to populate all the text.
I am not able to convert or cast the object or make use of BLOB object as it is bnot supported by webi