Hi, all cognos gurus
I've encountered a weird problem when trying to move the content store from machine A to machine B. The problem is after I've exported the content store from machine A and imported it to c8 in machine B, some reports fail to be validated. The error is:
UDA-SQL-0107 A general exception has occurred during the operation "prepare".
ORA-00960: ambiguous column naming in select list
These reports are all working in machine A, some are working in Machine B and others are not. Both machines are using cognos 8.3. The most strange thing is I've unsorted some columns in one of the not working reports, it becomes working. I dont understand why this happen. Does anyone have experienced these before. pls help!
I'd guess the configuration of the Oracle client on machine B is different somehow to the one on Machine A. Perhaps the level of qualification is less on machine B? Feels like an Oracle problem to me...
MF.