Kaltura CE 10.13.0 released - DWH Trouble

Here it is:

log_events_events.log:2015/07/30 16:38:55 - Parse date time to DWH timezone.0 - ERROR (version 4.2.1-stable, build 15952 from 2011- 10-25 15.27.10 by buildguy) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:376)
log_events_events.log:2015/07/30 16:38:55 - Parse date time to DWH timezone.0 - ERROR (version 4.2.1-stable, build 15952 from 2011- 10-25 15.27.10 by buildguy) : … 3 more
log_events_events.log:2015/07/30 16:38:55 - parse bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.2 7.10 by buildguy) : Unexpected error
log_events_events.log:2015/07/30 16:38:55 - parse bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.2 7.10 by buildguy) : org.pentaho.di.core.exception.KettleValueException:
log_events_events.log:2015/07/30 16:38:55 - parse bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.2 7.10 by buildguy) : Javascript error:
log_events_events.log:2015/07/30 16:38:55 - parse bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.2 7.10 by buildguy) : Could not apply the given format dd/MMM/yyyy:HH:mm:ss on the string for 30/Jul/2015:15:54:39 : Format.parseObje ct(String) failed (script#14)
log_events_events.log:2015/07/30 16:38:55 - parse bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.2 7.10 by buildguy) :
log_events_events.log:2015/07/30 16:38:55 - parse bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.2 7.10 by buildguy) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:457)

Thanks

OK, this is progress:) Can you please paste the full error block from the log?

Yes it is;-)

etl_hourly-20150730-16.log:ERROR 30-07 16:38:55,804 -
Parse date time to DWH timezone - Unexpected error
etl_hourly-20150730-16.log:ERROR 30-07 16:38:55,806 - Parse date time to DWH
timezone - org.pentaho.di.core.exception.KettleValueException: 

etl_hourly-20150730-16.log:ERROR 30-07 16:38:55,861 -
parse bandwidth lines - Unexpected error etl_hourly-20150730-16.log:ERROR 30-07
16:38:55,871 - parse bandwidth lines -
org.pentaho.di.core.exception.KettleValueException: 

etl_hourly-20150730-16.log:ERROR 30-07 16:38:55,881 -
process file - Errors detected!

etl_hourly-20150730-16.log:ERROR 30-07 16:38:55,888 -
process file - Errors detected!

log_events_events.log:2015/07/30 16:38:55 - Parse date
time to DWH timezone.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25
15.27.10 by buildguy) : Unexpected error

log_events_events.log:2015/07/30 16:38:55 - Parse date
time to DWH timezone.0 - ERROR (version 4.2.1-stable, build 15952 from
2011-10-25 15.27.10 by buildguy) :
org.pentaho.di.core.exception.KettleValueException: 

log_events_events.log:2015/07/30 16:38:55 - Parse date
time to DWH timezone.0 - ERROR (version 4.2.1-stable, build 15952 from
2011-10-25 15.27.10 by buildguy) : Javascript error: 

log_events_events.log:2015/07/30 16:38:55 - Parse date
time to DWH timezone.0 - ERROR (version 4.2.1-stable, build 15952 from
2011-10-25 15.27.10 by buildguy) : Could not apply the given format
dd/MMM/yyyy:HH:mm:ss on the string for 30/Jul/2015:13:54:40 :
Format.parseObject(String) failed (script#7)

log_events_events.log:2015/07/30 16:38:55 - Parse date
time to DWH timezone.0 - ERROR (version 4.2.1-stable, build 15952 from
2011-10-25 15.27.10 by buildguy) : 

log_events_events.log:2015/07/30 16:38:55 - Parse date
time to DWH timezone.0 - ERROR (version 4.2.1-stable, build 15952 from
2011-10-25 15.27.10 by buildguy) :       at
org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:457)

log_events_events.log:2015/07/30 16:38:55 - Parse date
time to DWH timezone.0 - ERROR (version 4.2.1-stable, build 15952 from
2011-10-25 15.27.10 by buildguy) :       at
org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.processRow(ScriptValuesMod.java:688)

log_events_events.log:2015/07/30 16:38:55 - Parse date
time to DWH timezone.0 - ERROR (version 4.2.1-stable, build 15952 from
2011-10-25 15.27.10 by buildguy) :       at
org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)

log_events_events.log:2015/07/30 16:38:55 - Parse date
time to DWH timezone.0 - ERROR (version 4.2.1-stable, build 15952 from
2011-10-25 15.27.10 by buildguy) :       at
java.lang.Thread.run(Thread.java:745)

log_events_events.log:2015/07/30 16:38:55 - Parse date
time to DWH timezone.0 - ERROR (version 4.2.1-stable, build 15952 from
2011-10-25 15.27.10 by buildguy) : Caused by: org.mozilla.javascript.EvaluatorException:
Could not apply the given format dd/MMM/yyyy:HH:mm:ss on the string for
30/Jul/2015:13:54:40 : Format.parseObject(String) failed (script#7)

log_events_events.log:2015/07/30 16:38:55 - Parse date
time to DWH timezone.0 - ERROR (version 4.2.1-stable, build 15952 from
2011-10-25 15.27.10 by buildguy) :       at
org.mozilla.javascript.DefaultErrorReporter.runtimeError(DefaultErrorReporter.java:109)

log_events_events.log:2015/07/30 16:38:55 - Parse date
time to DWH timezone.0 - ERROR (version 4.2.1-stable, build 15952 from
2011-10-25 15.27.10 by buildguy) :       at
org.mozilla.javascript.Context.reportRuntimeError(Context.java:938)

log_events_events.log:2015/07/30 16:38:55 - Parse date
time to DWH timezone.0 - ERROR (version 4.2.1-stable, build 15952 from
2011-10-25 15.27.10 by buildguy) :       at
org.mozilla.javascript.Context.reportRuntimeError(Context.java:994)

log_events_events.log:2015/07/30 16:38:55 - Parse date
time to DWH timezone.0 - ERROR (version 4.2.1-stable, build 15952 from
2011-10-25 15.27.10 by buildguy) :       at
org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesAddedFunctions.str2date(ScriptValuesAddedFunctions.java:909)

log_events_events.log:2015/07/30 16:38:55 - Parse date
time to DWH timezone.0 - ERROR (version 4.2.1-stable, build 15952 from
2011-10-25 15.27.10 by buildguy) :       at
sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)

log_events_events.log:2015/07/30 16:38:55 - Parse date
time to DWH timezone.0 - ERROR (version 4.2.1-stable, build 15952 from
2011-10-25 15.27.10 by buildguy) :       at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

log_events_events.log:2015/07/30 16:38:55 - Parse date
time to DWH timezone.0 - ERROR (version 4.2.1-stable, build 15952 from
2011-10-25 15.27.10 by buildguy) :       at
java.lang.reflect.Method.invoke(Method.java:606)

log_events_events.log:2015/07/30 16:38:55 - Parse date
time to DWH timezone.0 - ERROR (version 4.2.1-stable, build 15952 from
2011-10-25 15.27.10 by buildguy) :       at
org.mozilla.javascript.MemberBox.invoke(MemberBox.java:161)

log_events_events.log:2015/07/30 16:38:55 - Parse date
time to DWH timezone.0 - ERROR (version 4.2.1-stable, build 15952 from
2011-10-25 15.27.10 by buildguy) :       at
org.mozilla.javascript.FunctionObject.call(FunctionObject.java:413)

log_events_events.log:2015/07/30 16:38:55 - Parse date
time to DWH timezone.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25
15.27.10 by buildguy) :       at
org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:97)

log_events_events.log:2015/07/30 16:38:55 - Parse date
time to DWH timezone.0 - ERROR (version 4.2.1-stable, build 15952 from
2011-10-25 15.27.10 by buildguy) :       at
org.mozilla.javascript.gen.c21._c0(script:7)

log_events_events.log:2015/07/30 16:38:55 - Parse date
time to DWH timezone.0 - ERROR (version 4.2.1-stable, build 15952 from
2011-10-25 15.27.10 by buildguy) :       at
org.mozilla.javascript.gen.c21.call(script)

log_events_events.log:2015/07/30 16:38:55 - Parse date
time to DWH timezone.0 - ERROR (version 4.2.1-stable, build 15952 from
2011-10-25 15.27.10 by buildguy) :       at
org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:398)

log_events_events.log:2015/07/30 16:38:55 - Parse date
time to DWH timezone.0 - ERROR (version 4.2.1-stable, build 15952 from
2011-10-25 15.27.10 by buildguy) :       at
org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3065)

log_events_events.log:2015/07/30 16:38:55 - Parse date
time to DWH timezone.0 - ERROR (version 4.2.1-stable, build 15952 from
2011-10-25 15.27.10 by buildguy) :       at
org.mozilla.javascript.gen.c21.call(script)

log_events_events.log:2015/07/30 16:38:55 - Parse date
time to DWH timezone.0 - ERROR (version 4.2.1-stable, build 15952 from
2011-10-25 15.27.10 by buildguy) :       at
org.mozilla.javascript.gen.c21.exec(script)

log_events_events.log:2015/07/30 16:38:55 - Parse date
time to DWH timezone.0 - ERROR (version 4.2.1-stable, build 15952 from
2011-10-25 15.27.10 by buildguy) :       at
org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:376)

log_events_events.log:2015/07/30 16:38:55 - Parse date
time to DWH timezone.0 - ERROR (version 4.2.1-stable, build 15952 from
2011-10-25 15.27.10 by buildguy) :       ...
3 more

log_events_events.log:2015/07/30 16:38:55 - parse
bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25
15.27.10 by buildguy) : Unexpected error

log_events_events.log:2015/07/30 16:38:55 - parse
bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25
15.27.10 by buildguy) : org.pentaho.di.core.exception.KettleValueException: 

log_events_events.log:2015/07/30 16:38:55 - parse
bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25
15.27.10 by buildguy) : Javascript error: 

log_events_events.log:2015/07/30 16:38:55 - parse
bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25
15.27.10 by buildguy) : Could not apply the given format dd/MMM/yyyy:HH:mm:ss
on the string for 30/Jul/2015:15:54:39 : Format.parseObject(String) failed
(script#14)

log_events_events.log:2015/07/30 16:38:55 - parse
bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10
by buildguy) : 

log_events_events.log:2015/07/30 16:38:55 - parse
bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25
15.27.10 by buildguy) :          at
org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:457)

log_events_events.log:2015/07/30 16:38:55 - parse
bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25
15.27.10 by buildguy) :          at
org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.processRow(ScriptValuesMod.java:688)

log_events_events.log:2015/07/30 16:38:55 - parse
bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25
15.27.10 by buildguy) :          at
org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)

log_events_events.log:2015/07/30 16:38:55 - parse
bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25
15.27.10 by buildguy) :          at
java.lang.Thread.run(Thread.java:745)

log_events_events.log:2015/07/30 16:38:55 - parse
bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25
15.27.10 by buildguy) : Caused by: org.mozilla.javascript.EvaluatorException:
Could not apply the given format dd/MMM/yyyy:HH:mm:ss on the string for
30/Jul/2015:15:54:39 : Format.parseObject(String) failed (script#14)

log_events_events.log:2015/07/30 16:38:55 - parse
bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25
15.27.10 by buildguy) :          at
org.mozilla.javascript.DefaultErrorReporter.runtimeError(DefaultErrorReporter.java:109)

log_events_events.log:2015/07/30 16:38:55 - parse
bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25
15.27.10 by buildguy) :          at
org.mozilla.javascript.Context.reportRuntimeError(Context.java:938)

log_events_events.log:2015/07/30 16:38:55 - parse
bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25
15.27.10 by buildguy) :          at
org.mozilla.javascript.Context.reportRuntimeError(Context.java:994)

log_events_events.log:2015/07/30 16:38:55 - parse
bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25
15.27.10 by buildguy) :          at
org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesAddedFunctions.str2date(ScriptValuesAddedFunctions.java:909)

log_events_events.log:2015/07/30 16:38:55 - parse
bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25
15.27.10 by buildguy) :          at
sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)

log_events_events.log:2015/07/30 16:38:55 - parse
bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25
15.27.10 by buildguy) :          at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

log_events_events.log:2015/07/30 16:38:55 - parse
bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25
15.27.10 by buildguy) :          at
java.lang.reflect.Method.invoke(Method.java:606)

log_events_events.log:2015/07/30 16:38:55 - parse
bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25
15.27.10 by buildguy) :          at
org.mozilla.javascript.MemberBox.invoke(MemberBox.java:161)

log_events_events.log:2015/07/30 16:38:55 - parse
bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25
15.27.10 by buildguy) :          at
org.mozilla.javascript.FunctionObject.call(FunctionObject.java:413)

log_events_events.log:2015/07/30 16:38:55 - parse
bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25
15.27.10 by buildguy) :          at
org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:97)

log_events_events.log:2015/07/30 16:38:55 - parse
bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25
15.27.10 by buildguy) :          at
org.mozilla.javascript.gen.c17._c0(script:14)

log_events_events.log:2015/07/30 16:38:55 - parse
bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25
15.27.10 by buildguy) :          at
org.mozilla.javascript.gen.c17.call(script)

log_events_events.log:2015/07/30 16:38:55 - parse bandwidth
lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by
buildguy) :          at
org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:398)

log_events_events.log:2015/07/30 16:38:55 - parse
bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25
15.27.10 by buildguy) :          at
org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3065)

log_events_events.log:2015/07/30 16:38:55 - parse
bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25
15.27.10 by buildguy) :          at
org.mozilla.javascript.gen.c17.call(script)

log_events_events.log:2015/07/30 16:38:55 - parse
bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25
15.27.10 by buildguy) :          at
org.mozilla.javascript.gen.c17.exec(script)

log_events_events.log:2015/07/30 16:38:55 - parse
bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25
15.27.10 by buildguy) :          at
org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:376)

log_events_events.log:2015/07/30 16:38:55 - parse
bandwidth lines.1 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25
15.27.10 by buildguy) :          ... 3
more

log_events_events.log:2015/07/30 16:38:55 - process file
- ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by
buildguy) : Errors detected!

log_events_events.log:2015/07/30 16:38:55 - process file
- ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by
buildguy) : Errors detected!

Thanks, Mathieu,

Will consult our Analytics dev and get back to you on this one.

Especially thank you to you.

Mathieu

Hello Mathieu,

We THINK we have a solution that might work:)
edit /opt/kaltura/dwh/etlsource/common/parse_date_to_dwh_timezone.ktr and replace line 298:

eventTime = str2date(calculatedDateTime, &apos;dd&#47;MMM&#47;yyyy:HH:mm:ss&apos;);</jsScript_script>

with:

eventTime = str2date(calculatedDateTime,"dd/MMM/yyyy:HH:mm:ss", 'EN');</jsScript_script>

Then rerun the whole cycle and let me know if you still see issues.

Thanks,

Hello Jess,

I think it’s better, but I have an other error and no display on Analytics.
The solution is not far.

Thanks for your help

Mathieu

Here’s the log:

https://amubox.univ-amu.fr/index.php/s/S4KDuEJe9RnW4lF

Hey Mathieu,

Log still says:
2015/08/13 11:25:57 - Write to log.0 - Could not apply the given format dd/MMM/yyyy:HH:mm:ss on the string for 31/Jul/2015:22:45:28 : Format.parseObject(String) failed (script#30)

Can you make sure the file was indeed changed as I indicated above?

Hi Jess,

Yes, I change it

desiredTimeZone = java.util.TimeZone.getTimeZone(getVariable(&apos;DataTimeZone&apos;, &apos;America&#47;New_York&apos;));
dateFormat = java.text.SimpleDateFormat(&apos;[dd&#47;MMM&#47;yyyy:HH:mm:ssZ]&apos;,java.util.Locale.ENGLISH);
dateFormat.setTimeZone(desiredTimeZone);
calculatedDateTime = substr(dateFormat.format(dateFormat.parse(raw_datetime + timezone_offset)), 1, 20);
eventTime = str2date(calculatedDateTime,"dd/MMM/yyyy:HH:mm:ss", 'EN');</jsScript_script>

Perhaps,that I must also change this line before ?:

dateFormat = java.text.SimpleDateFormat(&apos;[dd&#47;MMM&#47;yyyy:HH:mm:ssZ]&apos;,java.util.Locale.ENGLISH);

in

dateFormat = java.text.SimpleDateFormat(&apos;[dd;MMM;yyyy:HH:mm:ssZ]&apos;,java.util.Locale.ENGLISH);

Mathieu

Hi Mathieu,

Not sure I understand the current state of the file:)
Only line I think should be changed is 298. What that done?

Thanks,

Hi Jess,

Only the line 298 has been changed.
I have the same error:
Format.parseObject(String) failed (script#30)

It was only a proposition for the second. :wink:

Mathieu

Hm… interesting issue indeed:)
What do you have set for DataTimeZone in /opt/kaltura/dwh/.kettle/kettle.properties?

Hi Jess,

Sorry for my response in late …

In keetle.properties I’ve this

DataTimeZone = @TIME_ZONE@

I don’t find where the TIME_ZONE is defined …
For information : /etc/timezone on my Ubuntu : Europe/Paris

Thanks

Mathieu

Hi Mathieu,

This is obviously one problem:)
You need to edit it and have it read:
DataTimeZone = ‘Europe/Paris’

I would recommend rerunning:
# dpkg-reconfigure kaltura-base
# dpkg-reconfigure kaltura-front
# dpkg-reconfigure kaltura-batch

as the ‘@.*@’ placeholders are replaced during the postinst scripts

I am suggesting this because if the @TIME_ZONE@ token was not replaced, it is quite possible others were not as well.

Hi Jess,

So I replace the good time zone on kettle.properties for my configuration:

DataTimeZone = 'Europe/Paris'

I do a dpk-reconfigure of the three package:base;front and batch

root@kaltest:/opt/kaltura/dwh/logs# grep -R ERROR

Give me this now

etl_hourly-20150825-15.log:ERROR 25-08 15:44:01,733 - parse bandwidth lines - Unexpected error
etl_hourly-20150825-15.log:ERROR 25-08 15:44:01,734 - parse bandwidth lines - org.pentaho.di.core.exception.KettleValueException:
etl_hourly-20150825-15.log:ERROR 25-08 15:44:01,735 - process file - Errors detected!
etl_hourly-20150825-15.log:ERROR 25-08 15:44:01,735 - process file - Errors detected!

For information, it’s not better on display analytics.

Thanks for your help

Mathieu

I have this one too:

etl_perform_retention_policy-20150825.log:ERROR 25-08 15:57:57,234 - Lock is already seized - Row nr 1 causing abort : [retention_lock], [1], [0], [null]
etl_perform_retention_policy-20150825.log:ERROR 25-08 15:57:57,234 - Lock is already seized - Aborting after having seen 1 rows.
etl_perform_retention_policy-20150825.log:ERROR 25-08 15:57:57,235 - seize_lock_by_name - Errors detected!
etl_perform_retention_policy-20150825.log:ERROR 25-08 15:57:57,235 - seize_lock_by_name - Errors detected!

with

mysql> select * from kalturadw_ds.locks;
+---------+------------------+---------------------+------------+
| lock_id | lock_name        | lock_time           | lock_state |
+---------+------------------+---------------------+------------+
|       1 | daily_lock       | 2015-08-25 16:03:28 |          0 |
|       2 | retention_lock   | 2015-08-13 11:26:21 |          1 |
|       3 | hourly_kaltest   | 2015-08-25 16:03:15 |          0 |
|       4 | update_dims_lock | 2015-08-25 16:03:22 |          0 |
+---------+------------------+---------------------+------------+

I put the lock state to 0 and run the cron.

etl_perform_retention_policy-20150825.log:ERROR 25-08 16:21:12,578 - Move old partitions to archive - An error occurred executing this job entry :
etl_perform_retention_policy-20150825.log:ERROR 25-08 16:21:12,593 - Kitchen - Finished with errors

The lock state is again put on 1 on retention lock.

It displays nothing more.

Hi Mathieu,

Please check the log and paste the errors around that line so its easier to understand the problem.

Hi Jess,

Here it is :wink: :
https://amubox.univ-amu.fr/index.php/s/1mx9L4Y4ckh0SRm

Thanks

Mathieu

Hello Mathieu, I read your problem and I’ve found your problem.

“Couldn’t execute SQL: call register_file(‘kaltest-kaltura_apache_access.log-20150722-06’, 1, 328,9, ‘gz’, ‘’)”

The parameter “328,9” is the size of apache log file in kbytes. I’m from Spain and my language server is LANG=es_ES.UTF-8 (Spanish) and I imagine in your server was French.

If you change the language to English (LANG=en_US.UTF-8) your problem is solved because the size of apache log file was “328.9” and you had 5 parameters and not 6 parameters.

i like it sir … goodjob.