PDA

View Full Version : Schedule-burst error



rcc
04-01-2007, 07:21 AM
Hello,

I was using Pentaho samples with HSQLb and everythings ok but, when i changed to MySQL some examples didn't work. For example, BurstActionSequence.xaction works very well, but schedule-burst.xaction do not. This gives me the error:

Failed[pt_161] Error: Couldn't store job: Data truncation: Data too long for column 'JOB_DATA' at row 1 (org.pentaho.plugin.quartz.JobSchedulerComponent)[pt_116] Debug: [pt_21] Starting execute of samples/bursting/schedule-burst.xaction (org.pentaho.core.solution.SolutionEngine)
[pt_116] Debug: [pt_30] Getting runtime context and data (org.pentaho.core.solution.SolutionEngine)
[pt_116] Debug: [pt_33] Loading action sequence definition file (org.pentaho.core.solution.SolutionEngine)
[pt_116] Debug: [pt_103] SolutionRepository.DEBUG_FILE_PATH - [pt_35] getFile path=d:\pentaho\pentaho-solutions\samples\bursting\schedule-burst.xaction (org.pentaho.repository.filebased.solution.SolutionRepository)
[pt_116] Debug: [pt_34] audit: instanceId=8dfccdad-e042-11db-973c-a5f9d9c39d8b, objectId=org.pentaho.core.runtime.RuntimeContext, messageType=action_sequence_start (org.pentaho.core.runtime.RuntimeContext)
[pt_116] Debug: [pt_1] validateComponent validating component JobSchedulerComponent (org.pentaho.core.runtime.RuntimeContext)
[pt_116] Debug: [pt_75] Validating component for action schedule-burst.xaction (org.pentaho.plugin.quartz.JobSchedulerComponent)
[pt_116] Debug: [pt_42] Executing action sequence (org.pentaho.core.runtime.RuntimeContext)
[pt_116] Debug: [pt_24] Executing action definition: Iteration 0 (org.pentaho.core.runtime.RuntimeContext)
[pt_116] Debug: [pt_34] audit: instanceId=8dfccdad-e042-11db-973c-a5f9d9c39d8b, objectId=JobSchedulerComponent, messageType=component_execution_started (org.pentaho.core.runtime.RuntimeContext)
[pt_116] Debug: [pt_3] execute pre-audit (org.pentaho.core.runtime.RuntimeContext)
[pt_116] Debug: [pt_21] Setting component log level to DEBUG (org.pentaho.core.runtime.RuntimeContext)
[pt_116] Debug: [pt_11] Initializing component (org.pentaho.core.runtime.RuntimeContext)
[pt_116] Debug: [pt_4] executeComponent starting audited execute (org.pentaho.core.runtime.RuntimeContext)
[pt_116] Debug: [pt_94] execute validation=true (org.pentaho.plugin.quartz.JobSchedulerComponent)
[pt_161] Error: Couldn't store job: Data truncation: Data too long for column 'JOB_DATA' at row 1 (org.pentaho.plugin.quartz.JobSchedulerComponent)
[pt_116] Debug: [pt_15] executeComponent finished audited execute (org.pentaho.core.runtime.RuntimeContext)
[pt_161] Error: [pt_103] RuntimeContext.ERROR_0012 - [pt_33] ActionDefinition for JobSchedulerComponent did not execute successfully (org.pentaho.core.runtime.RuntimeContext)
[pt_116] Debug: [pt_34] audit: instanceId=8dfccdad-e042-11db-973c-a5f9d9c39d8b, objectId=org.pentaho.core.runtime.RuntimeContext, messageType=action_sequence_failed (org.pentaho.core.runtime.RuntimeContext)
[pt_161] Error: [pt_103] SolutionEngine.ERROR_0007 - [pt_27] Action sequence execution failed (org.pentaho.core.solution.SolutionEngine)

[pt_41] Server Version 1.2.0 build 534 GA



Any ideas to cross over this?



Thanks.
Ricardo Cardoso (Portugal)