My Oracle Support Banner

Malformed SQL Statement Can Be Seen In Siebel WfProcBatchMgr Log On RR Environment (Doc ID 2764476.1)

Last updated on MARCH 29, 2021

Applies to:

Siebel CRM - Version 20.11 and later
Information in this document applies to any platform.

Symptoms

On : 20.11 version, Siebel Workflow

Siebel Query Missing Expression error On RR Environment . In DR there is no issue.



The issue can be reproduced at will with the following steps:

1) install Siebel 20.11 in both DR and RR environments

2) do a full migration

3) enable WfProcBatchMgr component in the RR environment

4) restart the Siebel server in RR env

5) go and open WfProcBatchMgr log

6) notice that in this log a malformed SQL exist:

"DBCLog DBCLogError 1 000000025fc82168:0 2020-12-03 12:41:40 OCIStmtExecute:

SELECT

T4.ROW_ID

FROM

(SELECT * FROM SIEBEL.S_LST_OF_VAL WHERE AND WS_INACTIVE_FLG = 'N' )

T1,

(SELECT * FROM SIEBEL.S_LST_OF_VAL WHERE AND WS_INACTIVE_FLG = 'N' )

T2,

SIEBEL.S_TABLE T3,

SIEBEL.S_COLUMN T4

WHERE

T4.CASCADE_CLEAR = T2.VAL AND

T4.TBL_ID = T3.ROW_ID AND

T4.DATA_TYPE = T1.VAL AND

(T1.TYPE = 'COLUMN_DATA_TYPE' AND T2.TYPE = 'CASCADE_MODE') AND

(T3.NAME = :1 AND T4.NAME = :2 AND T4.REPOSITORY_ID = :3)

ORDER BY

T4.NAME

ObjMgrLog Error 1 000000025fc82168:0 2020-12-03 12:41:40 (oracon.cpp (4942))

SBL-DBC-00105: An error has occurred executing a Sql statement.

Please continue or ask your systems administrator to check your application

configuration if the problem persists."

 

Note: the exact problem is here:

"SELECT * FROM SIEBEL.S_LST_OF_VAL WHERE AND"

So there is no expression between "WHERE" word and "AND" word.

 

Attention: same malformed sql issue was reported by the customer in XMLPReportServer log as well.


Note: Customer haven't found any impact to the application to be caused by  this SQL error.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.