topic Re: Deletion of data from Cluster table using SQL scripts in Application Development and Automation Discussions

Deletion of data from Cluster table using SQL scripts

Former Member — Tue, 07 Apr 2015 06:15:02 GMT

Hi All,

We have requirement of panning the Xref and Assignment field values in our development system. We have made a custom program to do that but there is huge data so the program is taking weeks in background itself an still not completed. so we thought of doing a SQL at database level and change the value. So now if that is the case is it enough to delete the values from BSEG(RFBLG) or do we have to delete from any other tables?

Thanks and Regards,

Arun.

Re: Deletion of data from Cluster table using SQL scripts

Former Member — Tue, 07 Apr 2015 13:19:18 GMT

Never update BSEG directly.

Rob

Re: Deletion of data from Cluster table using SQL scripts

RaymondGiuseppi — Tue, 07 Apr 2015 13:42:18 GMT

If it actually concerns only the development system or a sandbox system, okay, you have also to change data in the secondary indexes tables (BSIS, BSAS, BSIK, etc.) as well as in CO tables (COBK, COEP, etc.) - perform some where used on data element to find permanent transparent tables. (There are also some temporary work tables as for payment, etc.)

But as BSEG is actually part of RFBLG pool/cluster, a native SQL statement won't be effective, except if you convert BSEG (temporary) to a transparent database table, execute the updates, then convert it back to cluster. (And that will also take some times, as it seems your DEV database is huge?)

Did you also try to parallelize the update in multiple background jobs? (e.g. one per year or per company)

Regards,

Raymond

Re: Deletion of data from Cluster table using SQL scripts

Former Member — Tue, 07 Apr 2015 13:58:08 GMT

I wouldn't do this in a development system. I once made a single change to a text field of BSEG in a system that I knew would be refreshed that evening. The accounting system was broken - I think I got an error when trying to display any document.

Rob