mgakhar
16th November 2006, 23:09
Hi,
I've created a new table in our system in say VRC "ABCD" which has a parent VRC "WXYZ". Package Combination B40CABCD has all ABCD VRC's and Package Combination B40CWXYZ has all WXYZ VRC's. The Baan company that is currently attached to my user has a Package Combination B40CWXYZ.
And my user is also attached to the same Package Combination B40CWXYZ.

Now when I run my maintain session which has this new table as the main table it runs just fine without any issues. However, for another user who is attached to the same company but Package Combination B40CABCD, gets this error while saving any changes -
Fatal error: Error 1236 (bdb_errno 1236) on <new table number> in db_insert(51)
Fatal error: Cannot continue in <new session> in DLL: ottstpstandard()
Error: A not terminated transaction is aborted.

Also note that if I change the package combination for this user to B40CWXYZ the session works just fine. Im thinking this has something to do with the runtime data dictionary for this Package Combination. However, I've converted to runtime dd for both Pk combinations.

Really appreciate some insight into what is causing this problem.

Thanks,
MG.

mark_h
17th November 2006, 00:17
That sounds backwards from what we do. Example in our test patch company everyone(including developers) comes into tpt which is derived from prd. When I make a change I do it in tpt and everyone sees the change. In this case it looks like you would be developing in our prd which would not be seen in tpt. To test this can you log into the ABCD VRC and try to force it to create run time data dictionary on the table. I agree with you it looks like abcd's RTDD does not know about the table.

mgakhar
17th November 2006, 00:45
Hi Mark,
Thanks for you input ... actually I was developing the components in the correct VRC but I had done rtdd for both VRC's. And for whatever reason, the ABCD VRC had the dd messed up.

So deleted everything and recreated the table and converted to rtdd and now it works fine ...

Thanks,
MG.