Hello,
Long story short, our ServiceDesk Plus database (Microsoft SQL Server) is essentially being held hostage, it cannot be migrated in any way whatsoever, all attempts fail. This is troubling since we're stuck on an unsupported (for our version of ServiceDesk Plus) SQL Server version, and EOL is approaching fast.
Currently running ServiceDesk Plus 14.3 Build 14304 with Microsoft SQL 12.00.6449 (2014).
Using EWS (Exchange Web Services) with OAuth.
What we're trying to accomplish is a complete migration to a newly installed Microsoft SQL 2022 server. Attempts at using the
Database Migration Tool always fail with the following (or a similar) error:
[com.zoho.framework.utils.crypto.EnDecryptAESImpl]|[SEVERE]: Decryption failed, Given final block not properly padded. Such issues can arise if a bad key is used during decryption.
Later followed by:
[OauthCredential]|[SEVERE]: Exception occured while migrating table OuathCredential |
java.sql.BatchUpdateException: Cannot insert the value NULL into column 'CLIENTID', table 'dbServiceDesk.dbo.OauthCredential'; column does not allow nulls. INSERT fails.
Any ideas? The backup -> restore methods fail in a similar fashion as well.