Sequence issue
Hello Alexander,
You should submit a ticket at Adobe Campaign support team, because such error with database insertions errors are always tricky...
I got a similar bug for an another AC object insert/update in a specific AC build past year, with a value overflow; AC product team resolved it by providing an hotfix and they reacted promptly; it is why I recommend you to submit a ticket.
In the meanwhile, waiting for the hotfix, I have raised the size of the column in DB and of course set the same raised value in the schema (extended schema for this workaround of course).
But perhaps I am wrong and your issue is not the same case at all, so sorry in advance if I mislead you and Adobe support with this hypothesis.
To my mind, I guess the error you are facing with is linked to the size of the sMessage parameter in some cases.
sMessage is defined as 512 varchar length in DB (same in @message in Adobe Campaign XML schema xtk:kobLog).
And if the AC source code doesn't manage correctly strings length over than 512 char, it generates an overflow/not truncated so the position 94 means that the values parameter are incorrect.
One thing you can do for pointing out for which the sMessage parameter length below; but it the variable parameter in the insert exceeds the size of sMessage length max 512, the SQL exception is raised so you can't see the right occurrence generating the error. But it can helps sometimes to see what kind of messages are close to the max value.
Regarding the xtkNewId sequences management (automatic cycle/ set to 1000 or set to negative numbers depending on the sequence), I recommend you to create a monitoring workflow as is:
It helps greatly to be alerted by reaching thresholds, and also to analyze excessive consumption in some cases and be warned. In my example, it is xtkNewId sequence of xtkNewId, but you can put xtkJobLogId or xtkWorkflowLogId if you want to monitor them.
Regards
Jean-Serge
.png){kind=avatar}
