MailClient throws ORA-00932 when using OAuth2.0

ID:    D27861
Published:    23 August 2022
Updated:    23 May 2023

Defect Id


Originally Reported Against

SBM 11.8

Resolved In

SBM 12.1
SBM 12.1 Hotfix
SBM 12.1 Hotfix


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 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  


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. 

Find Answers

Type a question or describe what you are looking for below

My Recent Searches

Welcome kb sso

Additional Assistance

  • Submit a Case Online
  • FAQs