My Oracle Support Banner

When Attempting to Login to Siebel After a Couple Of Hours Proxy Error HTTP 400 Is Returned (Doc ID 2766129.1)

Last updated on APRIL 05, 2021

Applies to:

Siebel Public Sector Sales - Version 20.12 and later
Information in this document applies to any platform.

Symptoms

When attempting to UAT URL that behind a proxy server it gives proxy error in the first attempts to login to the application early in the morning or after a couple of hours of idle time.

In the localhost_access_log.YYYY-MM-DD.txt log file found under AI/applicationcontainer/logs directory there are HTTP 400 errors around the time the login attempt is made, see below:

<IP_ADDRESS> - - [24/Feb/2021:07:43:07 -0500] "-" 400 -
<IP_ADDRESS> - - [24/Feb/2021:07:43:08 -0500] "-" 400 -
<IP_ADDRESS> - - [24/Feb/2021:07:43:34 -0500] "-" 400 -
...

The initial login failure could be associated with the following query that was apparently taking long time to fetch rows:

...
DBCLog DBCLogDetail 4 0000007a603b0456:0 2021-02-28 12:33:17 Siebel Workload Tagging :: Unable to set tagging information into MODULE attribute
DBCLog DBCLogError 1 0000007a603b0456:0 2021-02-28 12:48:45 OCIStmtExecute: SELECT
  T1.CONFLICT_ID,
  T1.LAST_UPD,
  T1.CREATED,
  T1.LAST_UPD_BY,
  T1.CREATED_BY,
  T1.MODIFICATION_NUM,
  T1.ROW_ID,
  T1.COMPILED_OBJ_DEFN,
  :1
  FROM
  SIEBEL.S_RR_STREAMS T1
  WHERE
  (T1.NAME = :2 AND T1.LANG_CD = :3 AND T1.REPOSITORY_ID = :4 AND T1.WS_ID = :5 AND T1.VERSION_NUM <= :6)
  ORDER BY
  T1.REPOSITORY_ID DESC, T1.NAME DESC, T1.WS_ID DESC, T1.VERSION_NUM DESC

ObjMgrLog Error 1 0000007a603b0456:0 2021-02-28 12:48:45 (oracon.cpp (4890)) SBL-DAT-00523: L'enregistrement sélectionné a été modifié par un autre utilisateur depuis son extraction. Veuillez continuer.
ObjMgrLog Error 1 0000007a603b0456:0 2021-02-28 12:48:45 (oracon.cpp (4919)) SBL-DBC-00105: Une erreur s'est produite lors de l'exécution d'une instruction SQL.

Veuillez continuer ou demander à l'administrateur système de vérifier la configuration de l'application si le problème persiste.
SQLParseAndExecute Execute 5 0000007a603b0456:0 2021-02-28 12:48:45

ORA-03113: end-of-file on communication channel
Process ID: 2452
Session ID: 398 Serial number: 46823

ObjMgrSqlCursorLog Execute 5 0000007a603b0456:0 2021-02-28 12:48:45 End: ExecuteStmt for Sql Cursor at 69d9edd0
ObjMgrSqlLog Detail 4 0000007a603b0456:0 2021-02-28 12:48:45
***** SQL Statement Failed Execute Time for SQL Cursor with ID 69D9EDD0: 928.203 seconds *****
...
ObjMgrSqlLog Detail 4 0000007a603b0456:0 2021-02-28 12:48:45 Bind variable 1: PSCcObjMgr_fra,<siebel_server_name>,10485777,SADMIN,0000007a603b0456:0,,Runtime Repository Stream,

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Try to login to the UAT URL after a couple of hours of idle time
2. Generic Proxy error is received

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


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