Like to express my gratitude and thanks again for the above response.
The problem previously mentioned was somehow overcome previously by renaming the sequence numbers used. However, that did not last very long and the problem recurred again last week.
Have been trying to solve it quickly as the system in now heavily in use in Production environment. Struggled with it for two days :(Thankfully, the suggestion below resolved the issue. I think this time and hopefully, the problem is fixed completely.
3. Consider replacing sequence numbers with auto-generated fields maintained by the database itself - see http://www.tersus.com/#Id=6589.
Some extra info for others' reference, as seen below, i converted the fields id and fileid to be maintained by the database itself - converting the fields to auto increment instead of incremented by the sequence numbers.
alter table documentrecord modify column id double auto_increment;alter table filesdb modify column fileid double auto_increment;
For best results, use the Firefox browser..