My Oracle Support Banner

Error with sm_load.sh (Doc ID 2805882.1)

Last updated on NOVEMBER 28, 2022

Applies to:

Oracle Financial Services Behavior Detection Platform - Version 8.0 and later
Information in this document applies to any platform.

Symptoms

Version 8.0.2.

It has been failed with below error while loading a scenario with sm_load.sh

Error in load.log

 

2021-09-09 01:50:06,593 [main] DEBUG LOAD - Message 265006: The SQL is: SELECT a.PRMRY_CUST_INTRL_ID, a.ACCT_INTRL_ID, b.ACCT_BAL_SEQ_ID, a.HH_ACCT_GRP_ID FROM ofsaafccmkh.ACCT_BAL_POSN_SMRY b inner join ofsaafccmkh.ACCT a on (b.ACCT_INTRL_ID=a.ACCT_INTRL_ID)
2021-09-09 01:50:06,609 [main] DEBUG LOAD - Message 265061: Note : Grant Successful: DSVIEW116005103
2021-09-09 01:50:06,609 [main] DEBUG LOAD - Message 265061: Note : Creating View: DSVIEW114016597. Attempt: 0
2021-09-09 01:50:06,619 [main] DEBUG LOAD - Message 265197: Failed to create view DSVIEW114016597
2021-09-09 01:50:06,619 [main] DEBUG LOAD - Message 265061: Note : java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis

 

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
References


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