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

Last updated on OCTOBER 28, 2022

Applies to:

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

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