Defects

MailClient throws ORA-00932 when using OAuth2.0



ID:    D27861
Published:    23 August 2022
 

Defect Id

DEF347063

Originally Reported Against

SBM 11.8

Assigned To

SBM 12.1

Status

In Progress

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. 

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