Whats your database? MSSQL or Oracle?
I see ORA-00932 in your error message!
Try to limit the length to 4000
Check Repository Builder's guide: http://docs.oracle.com/cd/E28280_01/bi.1111/e10540/physicallayer.htm#BIEMG181
Longvarchar and longvarbinary data types are supported for writing complete Logical SQL statements into usage tracking tables for debugging purposes. They are not supported for general-purpose queries, and cannot be displayed in Presentation Services. Use direct SQL utilities to access columns with these data types.