Item Master getting deleted

nasheer

Dear All

Some strange thing happen to the Item Master table some time. Its getting deleted but no change log entry captured.
I added some code in OnDelete trigger of the table 'Item', but no use.

Any suggestion?

Regards
Nasheer.

csntor

Nasheer
Which version of NAV you have? Suggest create a dummy item, delete it and check change log. If both the entries exist (creation & deletion) in change log then the issue is not with the change log. If not then Change log / user setups need to be checked. Adding code for recording item change is not required as it exists already in base NAV.

nasheer

Thanks for your reply. The problem happened in Version 5.0 SP1.
As you mentioned, I have already tested create item and delete, the change log captures the entries.

But difficult to trace out how all the items were deleted without no information captured in the Change Log.

csntor wrote:

Nasheer
Which version of NAV you have? Suggest create a dummy item, delete it and check change log. If both the entries exist (creation & deletion) in change log then the issue is not with the change log. If not then Change log / user setups need to be checked. Adding code for recording item change is not required as it exists already in base NAV.

Alex_Chow

If the item is deleted through code, then it's not recorded in the change log.

Savatage

It looks like you're saying it happens alot, since you added code to catch it.
Is someone using a report to delete mass items?

FDickschat

If ALL items are deleted it is probably a report where someone forgot to enable the temporary property for a record variable.

The name of the variably will probably be TempItem or ItemTemp. Usually the first thing you do with a temporary record is a deletall.

Try using the Developers Toolkit to find all occurences of a record varaible for T27 with the command deleteall and check whether the property Temporary is set correct.