Author Topic: Detail logging for transformer cube build  (Read 131 times)

Offline msudheen

  • Full Member
  • ***
  • Join Date: Dec 2008
  • Posts: 7
  • Forum Citizenship: +0/-0
Detail logging for transformer cube build
« on: 11 May 2018 08:01:12 am »
I am processing large dataset for cube build, more than 15 M, transformer aborts cube build with the following messsage.
Source for the cube is report studio report and it works fine. If I try cube build with additional time filters, it work fine.
I am trying to understand if I can enable detail logging so it can write the exact record causing problem. I tried all options under transformer preferences but it doesn't help. Any thoughts ?

Timing, READ DATA SOURCE,00:45:12
Thu 10 May 2018 5:54:23 PM   4   032C86F5   16681200 records have been read; 1 categories have been created.
Thu 10 May 2018 5:54:26 PM   4   032C86F5   End cube update.
Thu 10 May 2018 5:54:26 PM   4   032C86F5   Timing, TOTAL TIME (CREATE CUBE),02:15:41
Thu 10 May 2018 5:54:26 PM   1   032C86F5   (TR0124) Category generation has quit in row 16681200 of data source 'Inventory Report'. (TR3311) An error occurred during data retrieval from the database. [->OK]

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,284
  • Forum Citizenship: +620/-10
  • Cognos Software Muppet
Re: Detail logging for transformer cube build
« Reply #1 on: 11 May 2018 08:54:42 am »
I am processing large dataset for cube build, more than 15 M, transformer aborts cube build with the following messsage.
Source for the cube is report studio report and it works fine. If I try cube build with additional time filters, it work fine.
I am trying to understand if I can enable detail logging so it can write the exact record causing problem. I tried all options under transformer preferences but it doesn't help. Any thoughts ?

Timing, READ DATA SOURCE,00:45:12
Thu 10 May 2018 5:54:23 PM   4   032C86F5   16681200 records have been read; 1 categories have been created.
Thu 10 May 2018 5:54:26 PM   4   032C86F5   End cube update.
Thu 10 May 2018 5:54:26 PM   4   032C86F5   Timing, TOTAL TIME (CREATE CUBE),02:15:41
Thu 10 May 2018 5:54:26 PM   1   032C86F5   (TR0124) Category generation has quit in row 16681200 of data source 'Inventory Report'. (TR3311) An error occurred during data retrieval from the database. [->OK]

It could well be an issue in the data you are reading. Take a look at the following technote.

http://www-01.ibm.com/support/docview.wss?uid=swg21472708

Cheers!

MF.
Meep!

Offline msudheen

  • Full Member
  • ***
  • Join Date: Dec 2008
  • Posts: 7
  • Forum Citizenship: +0/-0
Re: Detail logging for transformer cube build
« Reply #2 on: 11 May 2018 10:58:18 am »
Thank you , I agree it could be data problem, are there any additional settings for detailed logging in transformer, I have tried everything under preferences

 


       
Twittear