Hi,
We have a Transformer mdl model file , which is building a cube on windows, successfully.
IQD is built on FM which has Cognos SQL.
The same model when run on AIX, its throwing below error :
(TR0220) The temporary file for PowerCube 'sample' is empty. Check that your source file contains data. [->OK]
Does anyone have idea ....like is it not returning becuase of null values ?
nulls could be the case.
Check this link and see if it helps:
https://www-304.ibm.com/support/docview.wss?q1=TR0220&rs=0&uid=swg21386460&context=SWQ10&cs=utf-8&lang=en&loc=en_US&cc=us
Also, have you checked where Transformer is creating the temporary file on Unix and whether that Unix location has enough privileges and/or space?