Hitachi Vantara Pentaho Community Forums
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Getting error while creating crosstab report

  1. #1
    Join Date
    Jan 2007
    Posts
    20

    Default Getting error while creating crosstab report

    I have created a crosstab report following the tech tip below... http://community.pentaho.org/techtip...tab_report.php.
    I am getting the following error while testing this.

    Error: RuntimeContext.ERROR_0012 - ActionDefinition for SubActionComponent did not execute successfully (org.pentaho.core.runtime.RuntimeContext)
    Debug: Starting execute of samples/test/techtip/CrossTabSetup.xaction (org.pentaho.core.solution.SolutionEngine)
    Debug: Getting runtime context and data (org.pentaho.core.solution.SolutionEngine)
    Debug: Loading action sequence definition file (org.pentaho.core.solution.SolutionEngine)
    Debug: SolutionRepository.DEBUG_FILE_PATH - getFile path=C:\Pentaho\pentaho-demo\pentaho-solutions\samples\test\techtip\CrossTabSetup.xaction (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding default value of "datasource7" to parameter jndiName (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding default value of "CAMP_NAME" to parameter col_name (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding default value of "CAMP_NAME" to parameter col_alias (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding default value of "FROM SCC_SM_SYS_SESS_STATISTIC join SCC_CAMPAIGN SCC_CAMPAIGN on (SCC_SM_SYS_SESS_STATISTIC.CAMP_ID = SCC_CAMPAIGN.CAMP_ID)" to parameter col_from (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding variable source request to parameter type_out (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding default value of "html" to parameter type_out (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding default value of "org.pentaho.core.connection.memory.M...ultSet@1c9912f" to parameter type_outRS (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding variable source request to parameter col_value (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding default value of "WRAP_UP_SECS" to parameter col_value (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding default value of "org.pentaho.core.connection.memory.M...sultSet@5ae219" to parameter measures_list (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding variable source request to parameter columns (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding default value of "Unassigned" to parameter columns (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding variable source request to parameter row_name (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding default value of "SESS_TYPE_DESC" to parameter row_name (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding variable source request to parameter row_from (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding default value of "FROM SCC_SM_SYS_SESS_STATISTIC join SCC_SM_SESSION_TYPE SCC_SM_SESSION_TYPE on (SCC_SM_SYS_SESS_STATISTIC.SESS_TYPE_ID = SCC_SM_SESSION_TYPE.SESS_TYPE_ID) GROUP BY SESS_TYPE_DESC" to parameter row_from (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding variable source runtime to parameter xtabRS (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: audit: instanceId=d255508d-cafb-11db-a7ee-71ac71f23284, objectId=org.pentaho.core.runtime.RuntimeContext, messageType=action_sequence_start (org.pentaho.core.runtime.RuntimeContext)
    Debug: validateComponent validating component SQLLookupRule (org.pentaho.core.runtime.RuntimeContext)
    Debug: Validating component for action CrossTabSetup.xaction (org.pentaho.plugin.sql.SQLLookupRule)
    Debug: validateComponent validating component SecureFilterComponent (org.pentaho.core.runtime.RuntimeContext)
    Debug: Validating component for action CrossTabSetup.xaction (org.pentaho.plugin.core.SecureFilterComponent)
    Debug: validateComponent validating component SubActionComponent (org.pentaho.core.runtime.RuntimeContext)
    Debug: Validating component for action CrossTabSetup.xaction (org.pentaho.plugin.core.SubActionComponent)
    Debug: Executing action sequence (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "jndiName" (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "col_name" (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "col_alias" (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "col_from" (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "type_outRS" (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "measures_list" (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "row_name" (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "row_from" (org.pentaho.core.runtime.RuntimeContext)
    Debug: Executing action definition: Iteration 0 (org.pentaho.core.runtime.RuntimeContext)
    Debug: audit: instanceId=d255508d-cafb-11db-a7ee-71ac71f23284, objectId=SQLLookupRule, messageType=component_execution_started (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "jndi" (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "col_name" (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "col_alias" (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "col_from" (org.pentaho.core.runtime.RuntimeContext)
    Debug: execute pre-audit (org.pentaho.core.runtime.RuntimeContext)
    Debug: Setting component log level to TRACE (org.pentaho.core.runtime.RuntimeContext)
    Debug: Initializing component (org.pentaho.core.runtime.RuntimeContext)
    Debug: executeComponent starting audited execute (org.pentaho.core.runtime.RuntimeContext)
    Debug: execute validation=true (org.pentaho.plugin.sql.SQLLookupRule)
    Debug: Running query - select distinct CAMP_NAME as name, CAMP_NAME as alias FROM SCC_SM_SYS_SESS_STATISTIC join SCC_CAMPAIGN SCC_CAMPAIGN on (SCC_SM_SYS_SESS_STATISTIC.CAMP_ID = SCC_CAMPAIGN.CAMP_ID) (org.pentaho.plugin.sql.SQLLookupRule)
    Debug: executeComponent finished audited execute (org.pentaho.core.runtime.RuntimeContext)
    Debug: execute post-audit (org.pentaho.core.runtime.RuntimeContext)
    Debug: audit: instanceId=d255508d-cafb-11db-a7ee-71ac71f23284, objectId=SQLLookupRule, messageType=component_execution_ended (org.pentaho.core.runtime.RuntimeContext)
    Debug: audit: instanceId=d255508d-cafb-11db-a7ee-71ac71f23284, objectId=SecureFilterComponent, messageType=component_execution_started (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "type_outRS" (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "measures_list" (org.pentaho.core.runtime.RuntimeContext)
    Debug: !RuntimeContext.TRACE_INFO_USING_CURRENT_PARAMETER_VALUEXTabCol_RS! (org.pentaho.core.runtime.RuntimeContext)
    Debug: execute pre-audit (org.pentaho.core.runtime.RuntimeContext)
    Debug: Setting component log level to TRACE (org.pentaho.core.runtime.RuntimeContext)
    Debug: Initializing component (org.pentaho.core.runtime.RuntimeContext)
    Debug: executeComponent starting audited execute (org.pentaho.core.runtime.RuntimeContext)
    Debug: execute validation=true (org.pentaho.plugin.core.SecureFilterComponent)
    Debug: executeComponent finished audited execute (org.pentaho.core.runtime.RuntimeContext)
    Debug: execute post-audit (org.pentaho.core.runtime.RuntimeContext)
    Debug: audit: instanceId=d255508d-cafb-11db-a7ee-71ac71f23284, objectId=SecureFilterComponent, messageType=component_execution_ended (org.pentaho.core.runtime.RuntimeContext)
    Debug: audit: instanceId=d255508d-cafb-11db-a7ee-71ac71f23284, objectId=SubActionComponent, messageType=component_execution_started (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "col_name" (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "col_alias" (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "row_name" (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "row_from" (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "jndiName" (org.pentaho.core.runtime.RuntimeContext)
    Debug: execute pre-audit (org.pentaho.core.runtime.RuntimeContext)
    Debug: Setting component log level to TRACE (org.pentaho.core.runtime.RuntimeContext)
    Debug: Initializing component (org.pentaho.core.runtime.RuntimeContext)
    Debug: executeComponent starting audited execute (org.pentaho.core.runtime.RuntimeContext)
    Debug: execute validation=true (org.pentaho.plugin.core.SubActionComponent)
    Debug: SolutionRepository.DEBUG_FILE_PATH - getFile path=C:\Pentaho\pentaho-demo\pentaho-solutions (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: executeComponent finished audited execute (org.pentaho.core.runtime.RuntimeContext)
    Error: RuntimeContext.ERROR_0012 - ActionDefinition for SubActionComponent did not execute successfully (org.pentaho.core.runtime.RuntimeContext)
    Debug: audit: instanceId=d255508d-cafb-11db-a7ee-71ac71f23284, objectId=org.pentaho.core.runtime.RuntimeContext, messageType=action_sequence_failed (org.pentaho.core.runtime.RuntimeContext)
    Error: SolutionEngine.ERROR_0007 - Action sequence execution failed (org.pentaho.core.solution.SolutionEngine)

  2. #2
    phart Guest

    Default

    The link you posted did not work, heres the full url:

    Dynamically Generating a Cross Tab Report, Part 1

  3. #3
    Join Date
    Mar 2007
    Posts
    7

    Default Error: RuntimeContext.ERROR_0012 - ActionDefinition for SubActionComponent did not ex

    hi phart n rpayyavula,

    i have the same problem with rpayyavula. I have done exactly the same as the sample, however it never work.

    to phart, could you help us on this matter.

    Thanks so much n cheers.

  4. #4
    Join Date
    Oct 2005
    Posts
    94

    Default

    Can you post you .xaction and the error message that you are seeing?

  5. #5
    Join Date
    Mar 2007
    Posts
    7

    Default error generating crosstab report

    Hi kcruzada,
    here is my result after running the report. it it because i'm using oracle...but im success in generating 1step which is viewing list report...
    Failed Error: RuntimeContext.ERROR_0012 - ActionDefinition for SubActionComponent did not execute successfully (org.pentaho.core.runtime.RuntimeContext) Debug: Starting execute of samples/techtip/CrossTabSetup.xaction (org.pentaho.core.solution.SolutionEngine)
    Debug: Getting runtime context and data (org.pentaho.core.solution.SolutionEngine)
    Debug: Loading action sequence definition file (org.pentaho.core.solution.SolutionEngine)
    Debug: SolutionRepository.DEBUG_FILE_PATH - getFile path=D:\Pentaho\pentaho-demo\pentaho-solutions\samples\techtip\CrossTabSetup.xaction (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding variable source request to parameter jndiName (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding default value of "SampleData" to parameter jndiName (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding variable source request to parameter col_name (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding default value of "POSITIONTITLE" to parameter col_name (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding variable source request to parameter col_from (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding default value of "FROM QUADRANT_ACTUALS" to parameter col_from (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding variable source request to parameter type_outRS (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding default value of "org.pentaho.core.connection.memory.MemoryResultSet@17f4804" to parameter type_outRS (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding variable source request to parameter type_out (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding default value of "html" to parameter type_out (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding variable source request to parameter columns (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding default value of "CEO" to parameter columns (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding variable source request to parameter row_name (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding default value of "REGION" to parameter row_name (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding variable source request to parameter row_from (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding default value of "FROM QUADRANT_ACTUALS GROUP BY REGION" to parameter row_from (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding variable source request to parameter col_value (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding default value of "ACTUAL" to parameter col_value (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding variable source request to parameter Measure_List (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding default value of "org.pentaho.core.connection.memory.MemoryResultSet@151037b" to parameter Measure_List (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding variable source request to parameter col_alias (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: Adding default value of "POSITIONTITLE" to parameter col_alias (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: audit: instanceId=d434120b-04eb-11dc-90f0-4f4f9022ec9a, objectId=org.pentaho.core.runtime.RuntimeContext, messageType=action_sequence_start (org.pentaho.core.runtime.RuntimeContext)
    Debug: validateComponent validating component SQLLookupRule (org.pentaho.core.runtime.RuntimeContext)
    Debug: Validating component for action CrossTabSetup.xaction (org.pentaho.plugin.sql.SQLLookupRule)
    Debug: validateComponent validating component SecureFilterComponent (org.pentaho.core.runtime.RuntimeContext)
    Debug: Validating component for action CrossTabSetup.xaction (org.pentaho.plugin.core.SecureFilterComponent)
    Debug: validateComponent validating component SubActionComponent (org.pentaho.core.runtime.RuntimeContext)
    Debug: Validating component for action CrossTabSetup.xaction (org.pentaho.plugin.core.SubActionComponent)
    Debug: Executing action sequence (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "jndiName" (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "col_name" (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "col_from" (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "type_outRS" (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "type_out" (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "row_name" (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "row_from" (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "Measure_List" (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "col_alias" (org.pentaho.core.runtime.RuntimeContext)
    Debug: Executing action definition: Iteration 0 (org.pentaho.core.runtime.RuntimeContext)
    Debug: audit: instanceId=d434120b-04eb-11dc-90f0-4f4f9022ec9a, objectId=SQLLookupRule, messageType=component_execution_started (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "col_name" (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "col_from" (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "jndi" (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "col_alias" (org.pentaho.core.runtime.RuntimeContext)
    Debug: execute pre-audit (org.pentaho.core.runtime.RuntimeContext)
    Debug: Setting component log level to TRACE (org.pentaho.core.runtime.RuntimeContext)
    Debug: Initializing component (org.pentaho.core.runtime.RuntimeContext)
    Debug: executeComponent starting audited execute (org.pentaho.core.runtime.RuntimeContext)
    Debug: execute validation=true (org.pentaho.plugin.sql.SQLLookupRule)
    Debug: Running query - select distinct POSITIONTITLE, POSITIONTITLE as name FROM QUADRANT_ACTUALS (org.pentaho.plugin.sql.SQLLookupRule)
    Debug: executeComponent finished audited execute (org.pentaho.core.runtime.RuntimeContext)
    Debug: execute post-audit (org.pentaho.core.runtime.RuntimeContext)
    Debug: audit: instanceId=d434120b-04eb-11dc-90f0-4f4f9022ec9a, objectId=SQLLookupRule, messageType=component_execution_ended (org.pentaho.core.runtime.RuntimeContext)
    Debug: audit: instanceId=d434120b-04eb-11dc-90f0-4f4f9022ec9a, objectId=SecureFilterComponent, messageType=component_execution_started (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "type_out" (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "type_outRS" (org.pentaho.core.runtime.RuntimeContext)
    Debug: !RuntimeContext.TRACE_INFO_USING_CURRENT_PARAMETER_VALUEXTabCol_RS! (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "Measure_List" (org.pentaho.core.runtime.RuntimeContext)
    Debug: execute pre-audit (org.pentaho.core.runtime.RuntimeContext)
    Debug: Setting component log level to TRACE (org.pentaho.core.runtime.RuntimeContext)
    Debug: Initializing component (org.pentaho.core.runtime.RuntimeContext)
    Debug: executeComponent starting audited execute (org.pentaho.core.runtime.RuntimeContext)
    Debug: execute validation=true (org.pentaho.plugin.core.SecureFilterComponent)
    Debug: executeComponent finished audited execute (org.pentaho.core.runtime.RuntimeContext)
    Debug: execute post-audit (org.pentaho.core.runtime.RuntimeContext)
    Debug: audit: instanceId=d434120b-04eb-11dc-90f0-4f4f9022ec9a, objectId=SecureFilterComponent, messageType=component_execution_ended (org.pentaho.core.runtime.RuntimeContext)
    Debug: audit: instanceId=d434120b-04eb-11dc-90f0-4f4f9022ec9a, objectId=SubActionComponent, messageType=component_execution_started (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "col_name" (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "row_name" (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "row_from" (org.pentaho.core.runtime.RuntimeContext)
    Debug: using the default value of "jndiName" (org.pentaho.core.runtime.RuntimeContext)
    Debug: execute pre-audit (org.pentaho.core.runtime.RuntimeContext)
    Debug: Setting component log level to TRACE (org.pentaho.core.runtime.RuntimeContext)
    Debug: Initializing component (org.pentaho.core.runtime.RuntimeContext)
    Debug: executeComponent starting audited execute (org.pentaho.core.runtime.RuntimeContext)
    Debug: execute validation=true (org.pentaho.plugin.core.SubActionComponent)
    Debug: SolutionRepository.DEBUG_FILE_PATH - getFile path=D:\Pentaho\pentaho-demo\pentaho-solutions (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: executeComponent finished audited execute (org.pentaho.core.runtime.RuntimeContext)
    Error: RuntimeContext.ERROR_0012 - ActionDefinition for SubActionComponent did not execute successfully (org.pentaho.core.runtime.RuntimeContext)
    Debug: audit: instanceId=d434120b-04eb-11dc-90f0-4f4f9022ec9a, objectId=org.pentaho.core.runtime.RuntimeContext, messageType=action_sequence_failed (org.pentaho.core.runtime.RuntimeContext)
    Error: SolutionEngine.ERROR_0007 - Action sequence execution failed (org.pentaho.core.solution.SolutionEngine)

    Server Version 1.2.0 build 534 GA

  6. #6
    Join Date
    Mar 2007
    Posts
    7

    Default

    dear kcruzada,

    actually my .xaction is exactly the same as the sample from that link.thanks.

  7. #7
    Join Date
    Oct 2005
    Posts
    94

    Default

    If you grab the next milestone release 1.5.4, we have a crosstab component attached is the .xaction as an example. This will greatly shorten your steps.
    Attached Files Attached Files

  8. #8
    Join Date
    Oct 2005
    Posts
    94

    Default

    BTW... this might work in 1.5.3.

  9. #9
    Join Date
    Jun 2007
    Posts
    4

    Default

    does this mean that doing it the other way doesnt work at all? becuase i went through and did all of part 1 of the article and it worked and then when i got to the testing part of part 2 it didnt work, it asks me for a report-definition input after i have selected to column fields, first i fcant figure out why its even asking me this and then anything i put in it gives the error

    "[Ljava.lang.String;@8aee0" is not a valid selection for "columns"


    So does this mean that doing crosstabs this way doesnt work and that i have to us the crosstab action instead? and if so is there some sort of tutorial i can get to figure out how to use it? thank you

  10. #10
    Join Date
    Feb 2007
    Posts
    230

    Default Similar problems running crosstab report

    Hi,

    I am having the similar problem in running crosstab report. It asks me for a report definition although I have the line:

    <report-definition type="string" mapping="myReportSpec"/>

    in CrossTabSetup.xaction file. Forunatelly (or maybe not), I am not getting any error in server.log

    Any help?

    regards, dejan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.