ReportServer Forum

mkrause

Member

Registered: 2018-07-01

3.71 bug with scheduled SFTP drops

I believe this may be a bug.  Using new SFTP functionality.

We run some automated reports (BIRT templates) that work fine when emailed, but in the context of automated SFTP drop,  we have a problem.

The report will run manually after the tomcat server starts, just fine. And even the first scheduled instance or two (which gets us working for a day or two).  After that, however, we get persistent erroring out/failure with attempted SFTP drop of the same scheduled item:

org.hibernate.InstantiationException: Cannot instantiate abstract class or interface:  : net.datenwerke.scheduler.service.scheduler.entities.AbstractAction
    at org.hibernate.tuple.PojoInstantiator.instantiate(PojoInstantiator.java:78)
    at org.hibernate.tuple.PojoInstantiator.instantiate(PojoInstantiator.java:100)
    at org.hibernate.tuple.entity.AbstractEntityTuplizer.instantiate(AbstractEntityTuplizer.java:631)
    at org.hibernate.persister.entity.AbstractEntityPersister.instantiate(AbstractEntityPersister.java:4614)
    at org.hibernate.internal.SessionImpl.instantiate(SessionImpl.java:1412)
    at org.hibernate.internal.SessionImpl.instantiate(SessionImpl.java:1396)
    at org.hibernate.loader.plan.exec.process.internal.EntityReferenceInitializerImpl.hydrateEntityState(EntityReferenceInitializerImpl.java:221)
    at org.hibernate.loader.plan.exec.process.internal.AbstractRowReader.readRow(AbstractRowReader.java:90)
    at org.hibernate.loader.plan.exec.process.internal.ResultSetProcessorImpl.extractResults(ResultSetProcessorImpl.java:112)
    at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:121)
    at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:85)
    at org.hibernate.loader.collection.plan.AbstractLoadPlanBasedCollectionInitializer.initialize(AbstractLoadPlanBasedCollectionInitializer.java:82)
    at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:682)
    at org.hibernate.event.internal.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:75)
    at org.hibernate.internal.SessionImpl.initializeCollection(SessionImpl.java:1933)
    at org.hibernate.collection.internal.AbstractPersistentCollection$4.doWork(AbstractPersistentCollection.java:546)
    at org.hibernate.collection.internal.AbstractPersistentCollection.withTemporarySessionIfNeeded(AbstractPersistentCollection.java:248)
    at org.hibernate.collection.internal.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:542)
    at org.hibernate.collection.internal.AbstractPersistentCollection.read(AbstractPersistentCollection.java:133)
    at org.hibernate.collection.internal.PersistentBag.toArray(PersistentBag.java:283)
    at java.util.ArrayList.<init>(ArrayList.java:178)
    at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.executeActions(SchedulerTask.java:499)
    at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.safeCall(SchedulerTask.java:211)
    at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.call(SchedulerTask.java:103)
    at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.call(SchedulerTask.java:1)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)

Restarting tomcat gets things working ok for a day or two, then this happens.

mkrause

Member

Registered: 2018-07-01

Re: 3.71 bug with scheduled SFTP drops

https://www.dropbox.com/s/nearto8x686ds … t.PNG?dl=0

This is a link to what the scheduler history looks like.

eduardo

Administrator

Registered: 2016-11-01

Website

Re: 3.71 bug with scheduled SFTP drops

Hi mkrause,

thanks for letting us know. If you schedule the same report e.g. every 3 minutes (for easier testing), does this also happen after some executions?

Regards,
Eduardo

mkrause

Member

Registered: 2018-07-01

Re: 3.71 bug with scheduled SFTP drops

It doesn't let me schedule same day like this.. only t+1 (10/23) will it start doing more frequent tests. My guess is it fails by then.

eduardo

Administrator

Registered: 2016-11-01

Website

Re: 3.71 bug with scheduled SFTP drops

It doesn't let me schedule same day like this.. only t+1 (10/23) will it start doing more frequent tests. My guess is it fails by then.

Hi mkrause,

why not? With the following configuration I scheduled a report to run today (to the same day I created the schedule), every 1 minute:

Until now, all tests run correctly, so we currently cannot reproduce the issue. If you schedule it every 1 or 2 minutes, does it stop after some executions too ?

Regards,
Eduardo

mkrause

Member

Registered: 2018-07-01

Re: 3.71 bug with scheduled SFTP drops

Not sure why it wouldn't schedule same day. Maybe another bug.  I would set the begin date to same day, yet the system would choose tommorow after I selected today.  Anyway,  we get fail with higher frequency runs the same way:

https://www.dropbox.com/s/z0xx8i641vyol … 2.PNG?dl=0

eduardo

Administrator

Registered: 2016-11-01

Website

Re: 3.71 bug with scheduled SFTP drops

Hi mkrause,

we cannot reproduce this, but this may be because of your specific configuration.
Does this happen too if you schedule a simple dynamic list based on the internal reportserver datasource, with a simple query e.g. "select * from rs_user" ? can you pls test this?

Regards,
Eduardo

mkrause

Member

Registered: 2018-07-01

Re: 3.71 bug with scheduled SFTP drops

I tried that, and even that simple dynamic list report has the same error pop up when running from scheduler.  I'm wondering if there are any open file count limits or something like that. Am running tomcat7

mkrause

Member

Registered: 2018-07-01

Re: 3.71 bug with scheduled SFTP drops

Still having it intermittent. Here is latest capture.  Any ideas what this error captures?  I.e. potential causes?   What tomcat is best to run?  Are there minimum resources I should be allocating to tomcat?   I am getting no other operational errors.

org.hibernate.InstantiationException: Cannot instantiate abstract class or interface:  : net.datenwerke.scheduler.service.scheduler.entities.AbstractAction
    at org.hibernate.tuple.PojoInstantiator.instantiate(PojoInstantiator.java:78)
    at org.hibernate.tuple.PojoInstantiator.instantiate(PojoInstantiator.java:100)
    at org.hibernate.tuple.entity.AbstractEntityTuplizer.instantiate(AbstractEntityTuplizer.java:631)
    at org.hibernate.persister.entity.AbstractEntityPersister.instantiate(AbstractEntityPersister.java:4614)
    at org.hibernate.internal.SessionImpl.instantiate(SessionImpl.java:1412)
    at org.hibernate.internal.SessionImpl.instantiate(SessionImpl.java:1396)
    at org.hibernate.loader.plan.exec.process.internal.EntityReferenceInitializerImpl.hydrateEntityState(EntityReferenceInitializerImpl.java:221)
    at org.hibernate.loader.plan.exec.process.internal.AbstractRowReader.readRow(AbstractRowReader.java:90)
    at org.hibernate.loader.plan.exec.process.internal.ResultSetProcessorImpl.extractResults(ResultSetProcessorImpl.java:112)
    at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:121)
    at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:85)
    at org.hibernate.loader.collection.plan.AbstractLoadPlanBasedCollectionInitializer.initialize(AbstractLoadPlanBasedCollectionInitializer.java:82)
    at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:682)
    at org.hibernate.event.internal.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:75)
    at org.hibernate.internal.SessionImpl.initializeCollection(SessionImpl.java:1933)
    at org.hibernate.collection.internal.AbstractPersistentCollection$4.doWork(AbstractPersistentCollection.java:546)
    at org.hibernate.collection.internal.AbstractPersistentCollection.withTemporarySessionIfNeeded(AbstractPersistentCollection.java:248)
    at org.hibernate.collection.internal.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:542)
    at org.hibernate.collection.internal.AbstractPersistentCollection.read(AbstractPersistentCollection.java:133)
    at org.hibernate.collection.internal.PersistentBag.toArray(PersistentBag.java:283)
    at java.util.ArrayList.<init>(ArrayList.java:178)
    at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.executeActions(SchedulerTask.java:499)
    at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.safeCall(SchedulerTask.java:211)
    at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.call(SchedulerTask.java:103)
    at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.call(SchedulerTask.java:1)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)