Tersus: Re: Failed to generate sequence number

Re: Failed to generate sequence numberDate: Feb 17, 2014hi David,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;Cheers
CliffSee Also:

To use the full functionality of this web site, JavaScript needs to be turned on.

For best results, use the Firefox browser..

Loading ...