Transformer error: TR0120 can't write to file ...

Troubleshooting

Problem

PowerPlay Transformer 7.0 Windows NT 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 without sufficient 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.

Resolving The Problem

This error may occur even when the Temporary Directories in the Configuration Manager have been set to a drive without sufficient 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.

[{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Transformer","Platform":[{"code":"PF025","label":"Platform Independent"},{"code":"PF033","label":"Windows"}],"Version":"Cognos 8 BI Transformer 7.3;PowerPlay Transformer 7.0;PowerPlay Transformer 7.1;PowerPlay Transformer 7.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"Transformer","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"","label":""}},{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Transformer","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

123601

Was this topic helpful?

Document Information

Modified date:
28 November 2022

UID

swg21337924

Tips