Output connection is not getting deleted due to ingest status entries

[Shubham mittal <sh...@newgen.co.in.INVALID>]

Hi Team,

We have implemented a custom DBInterfaceSQLServer implementation similar to other databases supported by apache manifold. 

We normally configure two scheduling jobs. 

Everything works fine. except that entries from ingest status table are not getting deleted when I am trying to delete the second job or sometimes for both the jobs. 

Also docbins table entries are not getting deleted. 

Due to this I am unable to delete the output connection.

Request you to please guide what is the issue specific to the DBInterface implementation in regards to this. As per my understanding ,it should be independent of the database being used and should work fine.

Thanks & Regards,
Shubham Mittal
Senior Software Design Engineer
Newgen Software Technologies Ltd.
Ext 1032. Phone :+918527105599
Disclaimer :- This e-mail and any attachment may contain confidential, proprietary or legally privileged information. If you are not the original intended recipient and have erroneously received this message, you are prohibited from using, copying, altering or disclosing the content of this message. Please delete it immediately and notify the sender. Newgen Software Technologies Ltd (NSTL)  accepts no responsibilities for loss or damage arising from the use of the information transmitted by this email including damages from virus and further acknowledges that no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of NSTL.

Re: Output connection is not getting deleted due to ingest status entries

[Karl Wright <da...@gmail.com>]

If you try the same thing running against HSQLDB, does the table get
cleaned up?

If so, you must figure out why your database implementation is not working
properly.  Databases differ considerably on their characteristics.  Perhaps
you are ignoring certain kinds of errors and that is leading
inconsistencies in what is present in the tables.

Karl


On Wed, Jun 24, 2020 at 6:36 AM Shubham mittal
<sh...@newgen.co.in.invalid> wrote:

> Hi Team,
>
> We have implemented a custom DBInterfaceSQLServer implementation similar
> to other databases supported by apache manifold.
>
> We normally configure two scheduling jobs.
>
> Everything works fine. except that entries from ingest status table are
> not getting deleted when I am trying to delete the second job or sometimes
> for both the jobs.
>
> Also docbins table entries are not getting deleted.
>
> Due to this I am unable to delete the output connection.
>
> Request you to please guide what is the issue specific to the DBInterface
> implementation in regards to this. As per my understanding ,it should be
> independent of the database being used and should work fine.
>
> Thanks & Regards,
> Shubham Mittal
> Senior Software Design Engineer
> Newgen Software Technologies Ltd.
> Ext 1032. Phone :+918527105599
> Disclaimer :- This e-mail and any attachment may contain confidential,
> proprietary or legally privileged information. If you are not the original
> intended recipient and have erroneously received this message, you are
> prohibited from using, copying, altering or disclosing the content of this
> message. Please delete it immediately and notify the sender. Newgen
> Software Technologies Ltd (NSTL)  accepts no responsibilities for loss or
> damage arising from the use of the information transmitted by this email
> including damages from virus and further acknowledges that no binding
> nature of the message shall be implied or assumed unless the sender does so
> expressly with due authority of NSTL.
>
>
>