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