Hi List,
Owing to an unlikely series of events, all of the ObjectID values in the
Transactions table of our RT3 database have been set to the default
value, 0. Obviously this means that there is now no way to associate
tickets with their content. Does anyone have any ideas about how I can
restore the IDs? I’m 99.99% sure that it can’t be done but I thought
that I’d ask anyway, just on the offchance that there is.
And please don’t mention backups. Grrrr!
Dermot Williams
Senior Network Engineer
Irish Broadband Internet Services Ltd.
Hi List,
Owing to an unlikely series of events, all of the ObjectID values in the
Transactions table of our RT3 database have been set to the default
value, 0. Obviously this means that there is now no way to associate
tickets with their content. Does anyone have any ideas about how I can
restore the IDs? I’m 99.99% sure that it can’t be done but I thought
that I’d ask anyway, just on the offchance that there is.
And please don’t mention backups. Grrrr!
Here is a possilbe solution. Might not work 100%.
The Headers column of the Attachments table should have Subject
(at least some should). If you can match this to the Subject in
the Tickets table, then you can use the TransactionId in the
Attachments table to get the transaction and assign the
ObjectId.
-Todd