My XIB integration is like this:
Receive Activity->Coded MBC(this mbc open the input EDI message, parse it, and open a database connection and put the data into database).
But if i input several input files for the receive activity, around 10% of the time, the MBC process those files in parallel, and most of the cases of the 10%, the MBC will fail cause of DATABASE connection error.
part of the mbc:
Database OPEN “user/password@SID” DBID $DBID,
…..
….
DATABASE EXECUTE “COMMIT”
According to the Trace view log, the MBC tries to open the DATABASE almost the same time, and
if print the $DBID, it will show two different values, most of the time, the first one is 0, and the next one is a positive integer.
But for the latter one, when EXECUTE “COMMIT”, the MBC will through exectpion:
DATABASE not open.
Also I check the input file, there is no error of the file, cause if i input these files one by one, there will be no error. It only SOMETIMES happens when the MBC processing several input file.(not always happen).
http://forums.axway.com/index.php?act=attach&type=post&id=10
Please Help, this is stange and important for me.
Thank you everyone.
Jim
