MailClient throws ORA-00932 when using OAuth2.0

ID:    D27861
Published:    23 August 2022
Updated:    30 November 2022

Defect Id


Originally Reported Against

SBM 11.8

Resolved In

SBM 12.1


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