My Oracle Support Banner

Siebel Approval Manager stuck at Home Page upon Login after Fresh Installation (Doc ID 2555420.1)

Last updated on OCTOBER 29, 2019

Applies to:

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

Symptoms

On : 19.2 version, Installation
Siebel Approval Manager seems to get stuck at home page upon login after fresh installation

Customer is on Siebel IP19.2 version and trying to install SAM to explore the features.

ERROR
-----------------------
Some errors in AI log file related to:
org.springframework.messaging.MessagingException: failure occurred while polling for mail; nested exception is javax.mail.AuthenticationFailedException: failed to connect, no password specified?


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Following the bookshelf, they were able to install SAM and login screen does show up.
2. Using default admin user id for login, it should prompt them to change password.
3. However, when trying to login using the admin User ID, it let them through login page to home screen, however the screen just shows the processing graphic and doesn't allow them to navigate further.


After the installation was complete, the following insert statements were seen in SAMSchemadataimp.log:

insert into SIEB2018.SM_FIELD (ROW_ID,
CREATED,
CREATED_BY,
LAST_UPD,
LAST_UPD_BY,
MODIFICATION_NUM,
CONFLICT_ID,
DB_LAST_UPD,
DB_LAST_UPD_SRC,
LIST_ORDER,
DATA_TYPE,
LABEL_NAME,
NAME) values (?, ?, ?, ?, ?, ?, ?, current_date, 'dataimp', ?, ?, ?, ?)

2019-05-09 20:23:23 [tp][ODBC Oracle driver][Oracle]ORA-03101: invalid input data for
2019-05-09 20:23:23
2019-05-09 20:23:23 S1000: [tp][ODBC Oracle driver][Oracle]ORA-03101: invalid input data for
2019-05-09 20:23:23
2019-05-09 20:23:23 Array insert failed. Retry this array row by row ...

2019-05-09 20:23:27 SQL Statement:
insert into SIEB2018.SM_FIELD (ROW_ID,
CREATED,
CREATED_BY,
LAST_UPD,
LAST_UPD_BY,
MODIFICATION_NUM,
CONFLICT_ID,
DB_LAST_UPD,
DB_LAST_UPD_SRC,
LIST_ORDER,
DATA_TYPE,
LABEL_NAME,
NAME) values (?, ?, ?, ?, ?, ?, ?, current_date, 'dataimp', ?, ?, ?, ?)
2019-05-09 20:23:27 [tp][ODBC Oracle driver][Oracle]ORA-03101: invalid input data for
2019-05-09 20:23:27
2019-05-09 20:23:27 S1000: [tp][ODBC Oracle driver][Oracle]ORA-03101: invalid input data for
2019-05-09 20:23:27

2019-05-09 20:23:27 Error inserting row 1 into table SM_FIELD
2019-05-09 20:23:27 Column Name: cbValue: Column Value:
2019-05-09 20:23:27 ROW_ID 24 0CX@32325375
2019-05-09 20:23:27 CREATED 38 2017-01-23 10:28:44
2019-05-09 20:23:27 CREATED_BY 24 XXXXXX
2019-05-09 20:23:27 LAST_UPD 38 2017-01-23 10:28:44
2019-05-09 20:23:27 LAST_UPD_BY 24 XXXXXX
2019-05-09 20:23:27 MODIFICATION_NUM 2 0
2019-05-09 20:23:27 CONFLICT_ID 2 0
2019-05-09 20:23:27 DB_LAST_UPD 38 2017-01-23 10:28:44
2019-05-09 20:23:27 DB_LAST_UPD_SRC 52 Siebel Approval Management
2019-05-09 20:23:27 LIST_ORDER 2 2
2019-05-09 20:23:27 DATA_TYPE -1
2019-05-09 20:23:27 LABEL_NAME 20 Bug Number
2019-05-09 20:23:27 NAME 16 ISSUE_ID
2019-05-09 20:23:27
2019-05-09 20:23:27 SQL statement: insert into SIEB2018.SM_FIELD (ROW_ID,
2019-05-09 20:23:27 CREATED,
2019-05-09 20:23:27 CREATED_BY,
2019-05-09 20:23:27 LAST_UPD,
2019-05-09 20:23:27 LAST_UPD_BY,
2019-05-09 20:23:27 MODIFICATION_NUM,
2019-05-09 20:23:27 CONFLICT_ID,
2019-05-09 20:23:27 DB_LAST_UPD,
2019-05-09 20:23:27 DB_LAST_UPD_SRC,
2019-05-09 20:23:27 LIST_ORDER,
2019-05-09 20:23:27 DATA_TYPE,
2019-05-09 20:23:27 LABEL_NAME,
2019-05-09 20:23:27 NAME) values (?, ?, ?, ?, ?, ?, ?, current_date, 'dataimp', ?, ?, ?, ?)

 

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
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.