Discussion:
InventSumDateTable and InventSumDateTrans
(too old to reply)
sid1996
2008-01-14 21:09:02 UTC
Permalink
Hello

Could someone confirm, or disconfim, my theory that the tables
InventSumDateTable and InventSumDateTrans are only used for temporary data.

For example, the report Physical inventory by inventory dimension creates
records in these tables, however, it's deleted after it's finished. If the
report is aborted for some reason, the records created will not be deleted,
and I therefore presume that all the records in these tables could be deleted
in order to get rid rid of a lot of temporary data.

The question is whether these tables also contain information that is not of
the temporary kind? Is it safe to delete all records from these tables, or do
they contain data which cannot be deleted without losing vital information?

Thanks in advance,
Tobias Nyström
WM_DH
2008-02-01 12:42:00 UTC
Permalink
Hello Tobias,

I totally aggree with you that the tables are used like temporary table
although their not. If you look at the cross-reference you will notice that
it is only the class InventSumDateEngine that is using the tables and that
the report deletes the data when it is finished (in the fetch method).
//Dan
Post by sid1996
Hello
Could someone confirm, or disconfim, my theory that the tables
InventSumDateTable and InventSumDateTrans are only used for temporary data.
For example, the report Physical inventory by inventory dimension creates
records in these tables, however, it's deleted after it's finished. If the
report is aborted for some reason, the records created will not be deleted,
and I therefore presume that all the records in these tables could be deleted
in order to get rid rid of a lot of temporary data.
The question is whether these tables also contain information that is not of
the temporary kind? Is it safe to delete all records from these tables, or do
they contain data which cannot be deleted without losing vital information?
Thanks in advance,
Tobias Nyström
Mike Frank
2009-03-05 10:01:08 UTC
Permalink
You absolutely should delete old data in the InventSumDateTrans table, more
so because the InventSumDateEngine class always inserts data for all items
and all dimensions into InventSumDateTrans not considering the ranges
specified on the report calling this class. Filtering is done only when
reading the data from InventSumDateTrans.

On a system with mass data, this is a mess. They never tested this on a
system with real data. Probably only on their playground systems.

The InventSumDateTable is not used at all and should not contain any data.

Mike
Post by WM_DH
Hello Tobias,
I totally aggree with you that the tables are used like temporary table
although their not. If you look at the cross-reference you will notice that
it is only the class InventSumDateEngine that is using the tables and that
the report deletes the data when it is finished (in the fetch method).
//Dan
Post by sid1996
Hello
Could someone confirm, or disconfim, my theory that the tables
InventSumDateTable and InventSumDateTrans are only used for temporary data.
For example, the report Physical inventory by inventory dimension creates
records in these tables, however, it's deleted after it's finished. If the
report is aborted for some reason, the records created will not be deleted,
and I therefore presume that all the records in these tables could be deleted
in order to get rid rid of a lot of temporary data.
The question is whether these tables also contain information that is not of
the temporary kind? Is it safe to delete all records from these tables, or do
they contain data which cannot be deleted without losing vital information?
Thanks in advance,
Tobias Nyström
Anh Mai
2011-08-26 10:08:59 UTC
Permalink
Hello Dan,

as your comment, you mean that all data from InventSumDateTrans Table can be delete without any effect.
This mean I can delete all this data then run the InventDimPhys report -> will have no nay problem?
Am I right?

Thanks!
Anh Mai
Post by sid1996
Hello
Could someone confirm, or disconfim, my theory that the tables
InventSumDateTable and InventSumDateTrans are only used for temporary data.
For example, the report Physical inventory by inventory dimension creates
records in these tables, however, it's deleted after it's finished. If the
report is aborted for some reason, the records created will not be deleted,
and I therefore presume that all the records in these tables could be deleted
in order to get rid rid of a lot of temporary data.
The question is whether these tables also contain information that is not of
the temporary kind? Is it safe to delete all records from these tables, or do
they contain data which cannot be deleted without losing vital information?
Thanks in advance,
Tobias Nyström
Post by WM_DH
Hello Tobias,
I totally aggree with you that the tables are used like temporary table
although their not. If you look at the cross-reference you will notice that
it is only the class InventSumDateEngine that is using the tables and that
the report deletes the data when it is finished (in the fetch method).
//Dan
Post by Mike Frank
You absolutely should delete old data in the InventSumDateTrans table, more
so because the InventSumDateEngine class always inserts data for all items
and all dimensions into InventSumDateTrans not considering the ranges
specified on the report calling this class. Filtering is done only when
reading the data from InventSumDateTrans.
On a system with mass data, this is a mess. They never tested this on a
system with real data. Probably only on their playground systems.
The InventSumDateTable is not used at all and should not contain any data.
Mike
Loading...