TR0120 Generation pb

[karim19]

Does anyone know why i'm having this problem ?

I tried it twice and no file is already in use

Timing, TOTAL TIME (CREATE CUBE),07:38:24
Category generation has quit in row 1926144 of data source 'Gamme_year'. (TR0120) Transformer can't write to a file. [->OK]
PowerPlay Transformer Mon Jun 16 22:45:22 2003


Thanks

 

[canhe]

Hello Karim19,

You are running out of disk space. When you are reading from the database you create files (file naming convention "0D***&quot and you have run out of space and cannot write to these files. Increase you disk space and you should be ok!


canhe

 

[karim19]

Actually i have enough space 6Go in the temporary drive (cer1.ini and environement variables) since the target cube is around 400Mo.

I also have 2Go free space in the target drive (where cube should be generated)

I don't know if transformer also needs the temporary drive of Impromptu with the IQD that the cube uses, this is the only thing i didn't check

 

[canhe]

Hello

I still think it is you disk space. I create cubes that are 10 gb and I need 45 gb temp space to create the cube. I looked at the knowledge base and it gave this explaination :

Description:

When building a large cube, say 500 MB, the following error message is displayed:

Error : TR0120 Transformer can't write to a file.


Solution:

This error may occur even when the Temporary Directories in the Configuration Manager have been set to a drive with a large amount of space. In the Configuration Manager the List of Temporary Directories is set under Services > UDA > General.

If the datasource is an Impromptu Query Definition (IQD) file, the temp space which will be used to execute some functions and/or sorting will be the one defined in user and system environment variables.

To correct this, change the user and system variables in the Control Panel > System > Environment Variables to a drive that has enough space.