TABLE_ALREADY_OPEN error

[SWong]

I wrote a piece of code in the "Dialog is Initialized" event of a form which Fetch the Commodity Code of a shipment for branching purpose. I used F4211.Fetch Single. It works well in development and prototype environment. But after deployed to production, the fetch statement failed to return the commodity code. The error I got is TABLE_ALREADY_OPEN. Does anyone have any idea why it happens?

This is the first time I join the group. Please let me know if there is any additional info I should provide. Thank you.

DB = Oracle 8i
JDE version = 7333
OS = NT 4.0

Stephen Wong
Hong Kong

 

[cemontelongo]

Did you add a new index to the table F4211 and this index is used in your code ? We had this error when we forgot to update production with the object F4211. Sorry because of my english.

 

[SWong]

There is no change on F4211. Besides, the index I am using is the key and there is no more table I/O coding that opens F4211. However, I do find an index which is exactly the same as the key. Does it matter?

Stephen