Skip to content

Instantly share code, notes, and snippets.

@cmiles74
Created June 15, 2020 20:26
Show Gist options
  • Save cmiles74/effa6817a2d62f87ae9d830b43883287 to your computer and use it in GitHub Desktop.
Save cmiles74/effa6817a2d62f87ae9d830b43883287 to your computer and use it in GitHub Desktop.
ON2 Error
2020-06-15 04:31:58,854 INFO [scheduleWorkerFactory] c.w.n.p.c.BaseWnosJaxbPlugin [PerformICISSubmission.ja
va:123] ...The method name (getPretreatmentPerformanceSummaryData) does not equal the method we were plann
ing to invoke (setPermitReissuanceData), skipping...
/Exception
...skipping
2020-06-15 04:31:59,360 INFO [scheduleWorkerFactory] c.w.n.p.c.BaseWnosJaxbPlugin [PerformICISSubmission.ja
va:84] ...Found the UnpermittedFacilityData class for operation UNPERMITTED_FACILITY_SUBMISSION
2020-06-15 04:31:59,366 INFO [scheduleWorkerFactory] c.w.n.p.c.BaseWnosJaxbPlugin [PerformICISSubmission.ja
va:93] ...Found 0 records in the database.
2020-06-15 04:31:59,912 WARN [scheduleWorkerFactory] o.h.e.j.s.SqlExceptionHelper [SqlExceptionHelper.java:
144] SQL Error: 0, SQLState: S1009
2020-06-15 04:31:59,913 ERROR [scheduleWorkerFactory] o.h.e.j.s.SqlExceptionHelper [SqlExceptionHelper.java
:146] Value '0000-00-00' can not be represented as java.sql.Date
2020-06-15 04:31:59,913 WARN [scheduleWorkerFactory] c.w.n.p.c.BaseWnosJaxbPlugin [AbstractIcisNpdesSubmiss
ion.java:346] Problem generating document!
com.windsor.node.plugin.icisnpdes.submission.exception.XmlGenerationException: Error while generating docum
ent: /var/opennode2_home/tmp/ICIS-NPDES_PerformICISSubmission_7BFB59F5-B474-4F68-90D7-81F3A3EFEC81.xml
at com.windsor.node.plugin.icisnpdes.submission.AbstractIcisNpdesSubmission.generateNodeDocument(Ab
stractIcisNpdesSubmission.java:511)
at com.windsor.node.plugin.icisnpdes.submission.AbstractIcisNpdesSubmission.process(AbstractIcisNpd
esSubmission.java:331)
at com.windsor.node.plugin.WnosPluginHelper.processTransaction(WnosPluginHelper.java:352)
at com.windsor.node.worker.schedule.processor.LocalServiceDataProcessor.getAndSaveData(LocalService
DataProcessor.java:139)
at com.windsor.node.worker.schedule.ScheduleExecutionWorker.processSchedule(ScheduleExecutionWorker
.java:245)
at com.windsor.node.worker.schedule.ScheduleExecutionWorker.run(ScheduleExecutionWorker.java:137)
at java.util.TimerThread.mainLoop(Timer.java:555)
at java.util.TimerThread.run(Timer.java:505)
Caused by: org.hibernate.exception.GenericJDBCException: Could not read entity state from ResultSet : Entit
yKey[com.windsor.node.plugin.icisnpdes.generated.ComplianceScheduleEvent#505fcad4-aad4-11ea-9376-12fb65f264
8a]
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConve
rter.java:54)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
at org.hibernate.loader.plan.exec.process.internal.EntityReferenceInitializerImpl.loadFromResultSet
(EntityReferenceInitializerImpl.java:339)
at org.hibernate.loader.plan.exec.process.internal.EntityReferenceInitializerImpl.hydrateEntityStat
e(EntityReferenceInitializerImpl.java:251)
at org.hibernate.loader.plan.exec.process.internal.AbstractRowReader.readRow(AbstractRowReader.java
:107)
at org.hibernate.loader.plan.exec.process.internal.ResultSetProcessorImpl.extractResults(ResultSetP
rocessorImpl.java:129)
at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlan
BasedLoader.java:138)
at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlan
BasedLoader.java:102)
at org.hibernate.loader.collection.plan.AbstractLoadPlanBasedCollectionInitializer.initialize(Abstr
actLoadPlanBasedCollectionInitializer.java:100)
at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPers
ister.java:693)
at org.hibernate.event.internal.DefaultInitializeCollectionEventListener.onInitializeCollection(Def
aultInitializeCollectionEventListener.java:92)
at org.hibernate.internal.SessionImpl.initializeCollection(SessionImpl.java:1933)
at org.hibernate.collection.internal.AbstractPersistentCollection$4.doWork(AbstractPersistentCollec
tion.java:559)
at org.hibernate.collection.internal.AbstractPersistentCollection.withTemporarySessionIfNeeded(Abst
ractPersistentCollection.java:261)
at org.hibernate.collection.internal.AbstractPersistentCollection.initialize(AbstractPersistentColl
ection.java:555)
at org.hibernate.collection.internal.AbstractPersistentCollection.read(AbstractPersistentCollection
.java:143)
at org.hibernate.collection.internal.PersistentBag.iterator(PersistentBag.java:294)
at com.sun.xml.bind.v2.runtime.reflect.Lister$CollectionLister.iterator(Lister.java:282)
at com.sun.xml.bind.v2.runtime.reflect.Lister$CollectionLister.iterator(Lister.java:269)
at com.sun.xml.bind.v2.runtime.property.ArrayElementProperty.serializeListBody(ArrayElementProperty
.java:133)
at com.sun.xml.bind.v2.runtime.property.ArrayERProperty.serializeBody(ArrayERProperty.java:159)
at com.sun.xml.bind.v2.runtime.ClassBeanInfoImpl.serializeBody(ClassBeanInfoImpl.java:361)
at com.sun.xml.bind.v2.runtime.XMLSerializer.childAsXsiType(XMLSerializer.java:696)
at com.sun.xml.bind.v2.runtime.property.SingleElementNodeProperty.serializeBody(SingleElementNodePr
operty.java:158)
at com.sun.xml.bind.v2.runtime.ClassBeanInfoImpl.serializeBody(ClassBeanInfoImpl.java:361)
at com.sun.xml.bind.v2.runtime.XMLSerializer.childAsXsiType(XMLSerializer.java:696)
at com.sun.xml.bind.v2.runtime.property.ArrayElementNodeProperty.serializeItem(ArrayElementNodeProp
erty.java:69)
at com.sun.xml.bind.v2.runtime.property.ArrayElementProperty.serializeListBody(ArrayElementProperty
.java:172)
at com.sun.xml.bind.v2.runtime.property.ArrayERProperty.serializeBody(ArrayERProperty.java:159)
at com.sun.xml.bind.v2.runtime.ClassBeanInfoImpl.serializeBody(ClassBeanInfoImpl.java:361)
at com.sun.xml.bind.v2.runtime.XMLSerializer.childAsXsiType(XMLSerializer.java:696)
at com.sun.xml.bind.v2.runtime.property.ArrayElementNodeProperty.serializeItem(ArrayElementNodeProp
erty.java:69)
at com.sun.xml.bind.v2.runtime.property.ArrayElementProperty.serializeListBody(ArrayElementProperty
.java:172)
at com.sun.xml.bind.v2.runtime.property.ArrayERProperty.serializeBody(ArrayERProperty.java:159)
at com.sun.xml.bind.v2.runtime.ClassBeanInfoImpl.serializeBody(ClassBeanInfoImpl.java:361)
at com.sun.xml.bind.v2.runtime.XMLSerializer.childAsXsiType(XMLSerializer.java:696)
at com.sun.xml.bind.v2.runtime.ElementBeanInfoImpl$1.serializeBody(ElementBeanInfoImpl.java:156)
at com.sun.xml.bind.v2.runtime.ElementBeanInfoImpl$1.serializeBody(ElementBeanInfoImpl.java:131)
at com.sun.xml.bind.v2.runtime.ElementBeanInfoImpl.serializeBody(ElementBeanInfoImpl.java:333)
at com.sun.xml.bind.v2.runtime.ElementBeanInfoImpl.serializeRoot(ElementBeanInfoImpl.java:340)
at com.sun.xml.bind.v2.runtime.ElementBeanInfoImpl.serializeRoot(ElementBeanInfoImpl.java:76)
at com.sun.xml.bind.v2.runtime.XMLSerializer.childAsRoot(XMLSerializer.java:494)
at com.sun.xml.bind.v2.runtime.MarshallerImpl.write(MarshallerImpl.java:323)
at com.sun.xml.bind.v2.runtime.MarshallerImpl.marshal(MarshallerImpl.java:251)
at javax.xml.bind.helpers.AbstractMarshallerImpl.marshal(AbstractMarshallerImpl.java:95)
at com.windsor.node.plugin.common.BaseWnosJaxbPlugin.writeDocument(BaseWnosJaxbPlugin.java:221)
at com.windsor.node.plugin.icisnpdes.submission.AbstractIcisNpdesSubmission.generateNodeDocument(Ab
stractIcisNpdesSubmission.java:501)
... 7 common frames omitted
Caused by: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date
at com.mysql.jdbc.ResultSetRow.getNativeDateTimeValue(ResultSetRow.java:445)
at com.mysql.jdbc.ByteArrayRow.getNativeDateTimeValue(ByteArrayRow.java:255)
at com.mysql.jdbc.ResultSetImpl.getNativeDate(ResultSetImpl.java:3614)
at com.mysql.jdbc.ResultSetImpl.getDate(ResultSetImpl.java:2006)
at com.mysql.jdbc.ResultSetImpl.getDate(ResultSetImpl.java:1985)
at com.mysql.jdbc.ResultSetImpl.getDate(ResultSetImpl.java:2041)
at org.hibernate.type.descriptor.sql.DateTypeDescriptor$2.doExtract(DateTypeDescriptor.java:74)
at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:64)
at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:267)
at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:263)
at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:253)
at org.hibernate.type.AbstractStandardBasicType.hydrate(AbstractStandardBasicType.java:338)
at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2969
)
at org.hibernate.loader.plan.exec.process.internal.EntityReferenceInitializerImpl.loadFromResultSet
(EntityReferenceInitializerImpl.java:324)
... 51 common frames omitted
2020-06-15 04:31:59,913 ERROR [scheduleWorkerFactory] c.w.n.p.i.s.PerformICISSubmission [BaseWnosPlugin.jav
a:403] ...Problem generating document, returned error: Error while generating document: /var/opennode2_home
/tmp/ICIS-NPDES_PerformICISSubmission_7BFB59F5-B474-4F68-90D7-81F3A3EFEC81.xml.
com.windsor.node.plugin.icisnpdes.submission.exception.XmlGenerationException: Error while generating docum
ent: /var/opennode2_home/tmp/ICIS-NPDES_PerformICISSubmission_7BFB59F5-B474-4F68-90D7-81F3A3EFEC81.xml
at com.windsor.node.plugin.icisnpdes.submission.AbstractIcisNpdesSubmission.generateNodeDocument(Ab
stractIcisNpdesSubmission.java:511)
at com.windsor.node.plugin.icisnpdes.submission.AbstractIcisNpdesSubmission.process(AbstractIcisNpd
esSubmission.java:331)
at com.windsor.node.plugin.WnosPluginHelper.processTransaction(WnosPluginHelper.java:352)
at com.windsor.node.worker.schedule.processor.LocalServiceDataProcessor.getAndSaveData(LocalService
DataProcessor.java:139)
at com.windsor.node.worker.schedule.ScheduleExecutionWorker.processSchedule(ScheduleExecutionWorker
.java:245)
at com.windsor.node.worker.schedule.ScheduleExecutionWorker.run(ScheduleExecutionWorker.java:137)
at java.util.TimerThread.mainLoop(Timer.java:555)
at java.util.TimerThread.run(Timer.java:505)
Caused by: org.hibernate.exception.GenericJDBCException: Could not read entity state from ResultSet : Entit
yKey[com.windsor.node.plugin.icisnpdes.generated.ComplianceScheduleEvent#505fcad4-aad4-11ea-9376-12fb65f264
8a]
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConve
rter.java:54)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
at org.hibernate.loader.plan.exec.process.internal.EntityReferenceInitializerImpl.loadFromResultSet
(EntityReferenceInitializerImpl.java:339)
at org.hibernate.loader.plan.exec.process.internal.EntityReferenceInitializerImpl.hydrateEntityStat
e(EntityReferenceInitializerImpl.java:251)
at org.hibernate.loader.plan.exec.process.internal.AbstractRowReader.readRow(AbstractRowReader.java
:107)
at org.hibernate.loader.plan.exec.process.internal.ResultSetProcessorImpl.extractResults(ResultSetP
rocessorImpl.java:129)
at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlan
BasedLoader.java:138)
at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlan
BasedLoader.java:102)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment