Intermittent error related to analytics plugin in the logs

[reshmabidikar]

The KB logs some time show the following error related to the analytics plugin:

2025-10-15T01:27:40,810+0000 lvl='INFO', log='MetaImpl', th='Thread-13', xff='', rId='', tok='', aRId='', tRId='', Cannot parse default expression: 0000-00-00 00:00:00
org.jooq.impl.ParserException: Unexpected content after end of field input: [1:12] 0000-00-00 [*]00:00:00
	at org.jooq.impl.DefaultParseContext.exception(ParserImpl.java:13544)
	at org.jooq.impl.DefaultParseContext.done(ParserImpl.java:13704)
	at org.jooq.impl.DefaultParseContext.parseField0(ParserImpl.java:563)
	at org.jooq.impl.ParserImpl.parseField(ParserImpl.java:428)
	at org.jooq.impl.ParserImpl.parseField(ParserImpl.java:423)
	at org.jooq.impl.MetaImpl$MetaTable.initColumns(MetaImpl.java:1084)
	at org.jooq.impl.MetaImpl$MetaTable.<init>(MetaImpl.java:679)
	at org.jooq.impl.MetaImpl$MetaSchema.lambda$getTables$2(MetaImpl.java:425)
	at org.jooq.impl.Tools.map(Tools.java:2020)
	at org.jooq.impl.MetaImpl$MetaSchema.getTables(MetaImpl.java:397)
	at org.killbill.billing.plugin.analytics.reports.sql.Metadata.getTable(Metadata.java:140)
	at org.killbill.billing.plugin.analytics.reports.sql.Metadata.getTable(Metadata.java:87)
	at org.killbill.billing.plugin.analytics.reports.sql.Metadata$3.run(Metadata.java:234)
2025-10-15T01:27:40,850+0000 lvl='INFO', log='MetaImpl', th='Thread-13', xff='', rId='', tok='', aRId='', tRId='', Cannot parse default expression: 0000-00-00 00:00:00
org.jooq.impl.ParserException: Unexpected content after end of field input: [1:12] 0000-00-00 [*]00:00:00
	at org.jooq.impl.DefaultParseContext.exception(ParserImpl.java:13544)
	at org.jooq.impl.DefaultParseContext.done(ParserImpl.java:13704)
	at org.jooq.impl.DefaultParseContext.parseField0(ParserImpl.java:563)
	at org.jooq.impl.ParserImpl.parseField(ParserImpl.java:428)
	at org.jooq.impl.ParserImpl.parseField(ParserImpl.java:423)
	at org.jooq.impl.MetaImpl$MetaTable.initColumns(MetaImpl.java:1084)
	at org.jooq.impl.MetaImpl$MetaTable.<init>(MetaImpl.java:679)
	at org.jooq.impl.MetaImpl$MetaSchema.lambda$getTables$2(MetaImpl.java:425)
	at org.jooq.impl.Tools.map(Tools.java:2020)
	at org.jooq.impl.MetaImpl$MetaSchema.getTables(MetaImpl.java:397)
	at org.killbill.billing.plugin.analytics.reports.sql.Metadata.getTable(Metadata.java:140)
	at org.killbill.billing.plugin.analytics.reports.sql.Metadata.getTable(Metadata.java:87)
	at org.killbill.billing.plugin.analytics.reports.sql.Metadata$3.run(Metadata.java:234)
2025-10-15T01:27:40,852+0000 lvl='INFO', log='Metadata', th='Thread-13', xff='', rId='', tok='', aRId='', tRId='', Caching metadata for table report_accounts_summary

This needs to be investigated and addressed.