My Oracle Support Banner

Not Able To Open Mapping Tab In DIH Connector (Doc ID 2595785.1)

Last updated on OCTOBER 30, 2019

Applies to:

Oracle Financial Services Data Integration Hub - Version 8.0.6 and later
Information in this document applies to any platform.

Symptoms

On : 8.0.6 version, Metadata Issues_OFSS

When we open the connectors mapping screen they are not able to open the mapping tab in some of DIH connectors. Those connectors are made in 8.0.4 and migrated to 8.0.5 then to 8.0.6.

the following error occurs in the SMSService.log file.

ERROR
-----------------------
[29-08-19 12:53:32,318 GMT PM] [DEBUG] [WEB] [SMS] [NA] [FILTERSERVLET] This pattern does not allow '((>)|(>)|(\\x3e))' for the input string '3743~~ [CSA_STG_PARTY_MASTER].[FIC_MIS_DATE]=TO_DATE( #STG_LOAD_BBL.MISDATE, \'YYYYMMDD\')@@3700~~[GL_EXCHANGE_RATE].[REPORTING_DATE] = TO_DATE( #STG_LOAD_BBL.MISDATE, \'YYYYMMDD\') AND [GL_EXCHANGE_RATE].[SET_OF_BOOK]=\'BBGL_THB_BOOK\' @@3691~~@@3689~~@@3687~~@@3686~~@@3685~~@@3684~~@@3681~~@@3663~~@@3659~~@@3658~~@@3657~~@@3652~~ [MIS_CUSTOMER_AGING].[AS_OF_DATE] = TO_DATE( #STG_LOAD_BBL.MISDATE, \'YYYYMMDD\')@@3651~~ [MIS_RM_JOINT_ACCT].[AS_OF_DATE] = TO_DATE( #STG_LOAD_BBL.MISDATE, \'YYYYMMDD\')@@3649~~@@3648~~ [NLP_CUST_ACCUM].[AS_OF_DATE] = TO_DATE( #STG_LOAD_BBL.MISDATE, \'YYYYMMDD\')@@3610~~[PRE_STG_CUST_RELATIONSH].[FIC_MIS_DATE] = TO_DATE( #STG_LOAD_BBL.MISDATE, \'YYYYMMDD\') AND [PRE_STG_CUST_RELATIONSH].[F_PRIM_SEC_INDICATOR]=\'P\'@@3587~~ [PRE_STG_GUARANTEES].[FIC_MIS_DATE] = TO_DATE( #STG_LOAD_BBL.MISDATE, \'YYYYMMDD\')@@3571~~[PRE_STG_LOAN_CONTRACTS_TXNS].[N_FEE_TRANS_AMT] <> 0 AND [PRE_STG_LOAN_CONTRACTS_TXNS].[V_TRANS_CODE] NOT IN (\'7011\',\'8010\', \'9011\', \'9010\',\'7075\',\'8075\',\'9075\',\'7056\',\'8056\',\'9056\',\'7076\',\'8076\',\'9076\') AND [PRE_STG_LOAN_CONTRACTS_TXNS].[V_ACCOUNT_NUMBER] IN (713511,713521,713535,713545) AND [PRE_STG_LOAN_CONTRACTS_TXNS].[FIC_MIS_DATE] = TO_DATE( #STG_LOAD_BBL.MISDATE,\'YYYYMMDD\')@@3538~~[PRE_STG_TF_FEE_TRANS].[AS_OF_DATE] = TO_DATE( #STG_LOAD_BBL.MISDATE, \'YYYYMMDD\') AND [PRE_STG_TF_FEE_TRANS].[FEE_AMOUNT_LC] <> 0 AND [PRE_STG_TF_FEE_TRANS].[GL_ACCOUNT_ID_FEE] IN (713511,713521,713535,713545) @@3902~~ [RAR_CLAS_QUALITY_TYPE_CD].[AS_OF_DATE] = TO_DATE( #STG_LOAD_BBL.MISDATE, \'YYYYMMDD\')@@3903~~ [RAR_CLAS_QUALITY_TYPE_CD2].[AS_OF_DATE] = TO_DATE( #STG_LOAD_BBL.MISDATE, \'YYYYMMDD\')@@3935~~ [RAR_CLAS_QUALITY_TYPE_CD3].[AS_OF_DATE] = TO_DATE( #STG_LOAD_BBL.MISDATE, \'YYYYMMDD\')'



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open the data mapping in screen DIH.
2. Select the connector
3. Open the Data Mapping screen,

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot open the mapping screen.

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.