Yes, this looks fine.
Can you try to play a file via an embed and then run /opt/kaltura/bin/kaltura-run-dwh.sh?
Then look for the string ‘ERROR’ in /opt/kaltura/dwh/logs and let me know what you see?
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, 'dd/MMM/yyyy:HH:mm:ss');</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:
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('DataTimeZone', 'America/New_York'));
dateFormat = java.text.SimpleDateFormat('[dd/MMM/yyyy:HH:mm:ssZ]',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('[dd/MMM/yyyy:HH:mm:ssZ]',java.util.Locale.ENGLISH);
in
dateFormat = java.text.SimpleDateFormat('[dd;MMM;yyyy:HH:mm:ssZ]',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.
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.
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.