We encountered some strange things just yesterday.
last firday 10/5 the item code FHFGL2 can be transacted normally.
but yesterday 10/8 the item code was mysteriously change, see following changes that occur per package module combination
tiitm### = @00000000000145
psrou### = @00000000000145
psfrm### = @00000000000145
tdinv### = FHFGL2
tdpur### = FHFGL2
tdsls### = FHFGL2
with the changes in the tables we can not do any transaction for the said item.

Is it possible to recreate yesterdays data all over again if you were to restore the day-before-yesterdays(7/10) backup? This considering you do take daily baan table dumps.

If not i think you would have to call in Infor Support on this.

sk

We do have backups, but we do it as per database and not per table. is it possible to extract specific tables from the database dump. We can not restore the whole database coz theirs only one affected company, and restoring the whole database would affect a lot.

What are the possible causes why we have this problem? as we can recall last friday 10/5 we have network problems for this company. but the problem is we dont have an audit trail for us to know if there where processes that was affected by the network problem.

Thanks for your time.

Hi there,

is only this one item concerned?
If yes, I would do the following:
a)create seq. dump of table with field seperator for all tables of this company
b)substitute "@00000000000145" with "FHFGL2" in all files (!! make sure you don't have the token sequence "@00000000000145" at other places, where you don't want to substitute it !!)
c)create tables from sequential dump

hth

Norbert

P.S.: Contact Infor anyway, it should be interesting to find out how this could happen

there are several items that have this problem. based on Baan Infor suggestion we will reconfigure tiitm and then run rebuild inventory.

also, this problem was cause when there were financial processing and out network was unstable that causes intermetent connection.

thanks for the suggestions

I wouldnt just bank on my database backup alone. For the long run it would be best if you start using Baan Backup as well where you have the provision to backup per company/company tables. Its interesting to note what unstable network connections or problems can create in Baan.
sk

Hi Norbert,
How are you out there? Just a small doubt on what you said...
b)substitute "@00000000000145" with "FHFGL2" in all files
Wont this corrupt the hash keys?

sk

This was resolve by changing the field tiitm001.reli which equates with tiitm001.item for table ITEMS. Afterwards tiitm100.item was replaced with the baan generated tiitm001.item for containerized item

According to infor there was probably an update being made for containerized item when something got wrong in our network connection. Baan processing suddenly halted even if the table relationship being made hasn't finish yet.