Defects
MailClient throws ORA-00932 when using OAuth2.0
| ID: | D27861 | |
| Published: | 23 August 2022 | |
| Updated: | 23 May 2023 |
Defect Id
DEF347063
Originally Reported Against
SBM 11.8
Resolved In
SBM 12.1
SBM 12.1 Hotfix
SBM 12.1 Hotfix
SBM 12.1 Hotfix
SBM 12.1 Hotfix
Description
In SBM 11.8 and 12.0, SBM MailClient will throw the error, "ORA-00932: inconsistent datatypes: expected - got CLOB", when it tries to access a POP3 or IMAP mailbox using OAuth2 authentication.
Review the NS.LOG located in SBM\COMMON\TOMCAT\SERVER\DEFAULT\LOGS. Look for a stack trace like below. This is caused by an invalid SQL query.
ERROR 16-08-2022 23:53:30 [MailClient] -- Unable to obtain authentication details for Mailbox=14.
ERROR 16-08-2022 23:53:30 [MailClient] -- Error while processing mailbox sbm.dev@yourCo.com with namespace Optional[0]:
org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute statement; SQL [n/a]; nested exception is
... 32 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got CLOB Resolution
We have identified the defect and resolved it in SBM 12.1. If you are running SBM 11.8, you may also apply hotfix 10.
