If you are unable to create a new account, please email support@bspsoftware.com

 

unable to resolve transformer cube build error - UDA-SOR-0005 Unable to write

Started by damzI, 11 Feb 2017 04:25:34 PM

Previous topic - Next topic

damzI

Hello Geeks - I have been struggling with the Transformer error during cube build. I have tried everything in the configuration. Tried even to increase the temp space from 500gb to 3TB but am still getting the following error

(TR3311) An error occurred during data retrieval from the database.

Here are the details from the logs...

'Fact3'.
Sat 11 Feb 2017 2:55:43 PM   4   00000000   Reading source data.
Sat 11 Feb 2017 2:55:44 PM   4   00000000   Timing, OPEN DATA SOURCE,00:00:01
Sat 11 Feb 2017 3:59:48 PM   2   00000000   RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-237'.
Sat 11 Feb 2017 3:59:48 PM   2   00000000   UDA-SOR-0005 Unable to write the file.
Sat 11 Feb 2017 3:59:54 PM   4   00000000   End processing 0 records from data source 'Fact3'.
Sat 11 Feb 2017 3:59:54 PM   4   00000000   Timing, READ DATA SOURCE,01:04:11
Sat 11 Feb 2017 4:00:09 PM   4   00000000   0 records have been read; 1 categories have been created.
Sat 11 Feb 2017 4:00:13 PM   4   00000000   End cube update.
Sat 11 Feb 2017 4:00:13 PM   4   00000000   Timing, TOTAL TIME (CREATE CUBE),02:31:28
Sat 11 Feb 2017 4:10:09 PM   2   00000000   (TR3311) An error occurred during data retrieval from the database. [->OK]

Any ideas on where to look ?
The is a large cube with 130 m in the transaction table and I am using Hadoop. I have successfully built the same cube with the same data set without any issues. In the current build I have added a calculated column (Case Statement) to the "rough" transaction query 'Fact3'.

Thanks, D