evertsen
13th January 2003, 18:57
When running this session wide open, it hangs. When it is run for a specific project, it runs very well. This only occurs in one company. It runs well in all other companies (of equal size and on the same server/database). Anyone else come across this?

Ev

Djie-En
14th January 2003, 09:37
Hi,

If i take a look into the tdinv0250m000, there is nothing where you can give an input on the form.
What do you mean by "for a spec. proj."?
What's the last solution, you imported for this session?
I asked this because i want to run it this weekend, since a long time ago.

GN

OmeLuuk
14th January 2003, 14:20
I would say: check your data consitency, this session does do a lot with a lot of data (lot of reading some modifying). If there is a table lock on one of it's tables, it seems to go freezing, but actually starts retrying on locks. Also: the whole session will be one transaction. Take care that your transaction log (if RDBMS is used) is big enough to hold the entire transaction. Check your database spaces. If tbase is used, maybe parameters are to be changed for running this session. If the transaction fails, then the whole transaction is retried (up to setting of MAX_RETRY which is max 10). But if transaction keeps failing on different places, then it may well be that MAX_RETRY will be recounted for every other place where it occurs. (Run with -- -set MAX_RETRY=1).

evertsen
14th January 2003, 16:56
Thanks Omeluuk. I'll give that a try. However, I ran this same session in a test company (which was a copy of our production company (same server, save database) that is experiencing the problem) and it worked well.

Djie-En, I have the latest solution installed (160987) but the project selection was added quite a while ago (SP6 or earlier). It isn't in the form however... you have to go through the Special menu in the session.

Ev

evertsen
24th January 2003, 04:21
Had to do a reorg on tdsls041 and tiitm100 and then it worked fine.

Ev

Paul Eden
3rd February 2003, 23:45
We had a similar problem over Xmas. It seems that when running the rebuild session, it looks at every project (archived or not) As well we found that because the system did not delete customized item data it took excessively long. Ours ran for 6 days before we got a fix from BaaN. I believe that there is a patch available now for the archive issue.

paul