Check Ecid Number

0 views

Skip to first unread message

Sharon Harris

unread,

Aug 3, 2024, 3:42:17 PM8/3/24

to moonsverphoti

In our sandbox environment I am testing AJO journeys using test profiles created by uploading CSV files with user profile attributes. In the schema used for this, there are fields marked as identities for email address, phone number, loyaltyID, and ECID - all with the correct namespaces. All test profiles are also marked as testProfile = true.

During the data ingestion process I mapped the CSV fields to the appropriate schema fields and created a new dataset. When validating the attributes of the profile that I uploaded using Profiles->Browse I see that all identity fields were automatically assigned to an identityMap namespace except ECID. I attempted to delete and recreate the dataset and the same behavior was observed.

Ideally the ECID is automapped as identity when an event (web/app) is ingested into AEP, did you manually map the ECID field from CSV to the identity during the ingestion flow and check if that helps?

We do not have a test website so all of our data is manually mapped. The mapping worked correctly as the ECID namespace attribute is showing on the user's profile, but I was expecting to see an identityMap.ecid.0.id attribute also automatically appearing on the user's profile like for email address, etc.

Oracle Metadata Services
MDS-92001: The upgrade is not supported from Oracle Metadata Services schema version of 11.1.1.6.0
Cause: An unsupported base schema version has being upgraded.
Action: Refer to the Oracle Metadata Services Upgrade Guide for supported versions to upgrade.

Oracle WebCenter Portal: Spaces and Services
UPGCMP-05418: Oracle WebCenter Portal schema WEBCENTER does not contain the required indexes.
Cause: The schema does not contain the indexes which are required to be present before upgrade.
Action: Ensure all required indexes are present before upgrade.

[] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: ,0] Starting schema test: TEST_REQUIRED_TABLES Test that the schema contains all the required tables
[] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: ,0] Run standard query: queryTableNames, Schema tag: WEBCENTER, Schema name: _WEBCENTER, Object: null
[] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: ,0] List of database TABLE objects for user: _WEBCENTER
[] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: ,0] Completed schema test: TEST_REQUIRED_TABLES --> Test that the schema contains all the required tables +++ PASS
[] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: ,0] Starting index test for table WC_AS_CUSTATTR: TEST_REQUIRED_INDEXES --> Test that the table contains all the required indexes
[] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: ,0] Run standard query: queryIndexNames, Schema tag: WEBCENTER, Schema name: _WEBCENTER, Object: WC_AS_CUSTATTR
[] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: ,0] List of database INDEX objects for user: _WEBCENTER
[] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: ,0] EXCEPTION Table is missing a required index: WC_AS_CUSTATTR_FK
[] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: ,0] EXCEPTION Table is missing a required index: WC_AS_CUSTATTR_NI
[] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: ,0] Completed index test for table WC_AS_CUSTATTR: TEST_REQUIRED_INDEXES --> Test that the table contains all the required indexes +++ FAIL
[] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: ,0] INFO Required indexes are not present, schema: WEBCENTER table: WC_AS_CUSTATTR
[] [WEBCENTER] [ERROR] [UPGCMP-05418] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: ,0] Oracle WebCenter Portal schema WEBCENTER does not contain the required indexes.
[] [WEBCENTER] [ERROR] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: ,0] Cause: The schema does not contain the indexes which are required to be present before upgrade.
[] [WEBCENTER] [ERROR] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: ,0] Action: Ensure all required indexes are present before upgrade.
[] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 83] [ecid: ,0] Finished readiness check of Oracle WebCenter Portal: Spaces and Services with status: FAILURE.
[] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 83] [ecid: ,0] Component ID=WEBCENTER, Schema=_WEBCENTER, Schema version=11.1.1.4.0, Status=VALID, Upgraded=false
[] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 83] [ecid: ,0] Finished readiness check of WEBCENTER.WC1 with status: FAILURE.

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

I've been having an issue with our check report returning completely blank, including the Category, Period and Location headers. I've downloaded the 11.1.2.4.1 patch which has a GUI to be able to test a check rule, and the rule that I've built is valid and returns a value in this check rule however, the check report is completely blank. My check intersection report is working well as well as all of our out of the box reports in Report Execution, it's only the check report that is not working. Has anyone experienced this?

[2016-01-20T07:55:49.669-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 26] [userId: ] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.file.script.jython.JythonInterpreterUtil] [SRC_METHOD: ] Error Initializing the PythonInterpreter:null

[2016-01-20T07:55:49.670-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 26] [userId: ] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.gl.common.validation.model.util.CheckProcessManager] [SRC_METHOD: ] Jython Operations Initialization Completed.

[2016-01-20T07:55:49.670-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 26] [userId: ] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.webservices.HFMService] [SRC_METHOD: checkData] ***** Check Initialization - END *****

[2016-01-20T07:55:49.674-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 26] [userId: ] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.webservices.HFMService] [SRC_METHOD: checkData] ******** Check Execution - BEGIN ********

[2016-01-20T07:55:49.782-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 26] [userId: ] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.util.RegistryUtil] [SRC_METHOD: getHfmClusterName] Cluster name:TAIS-HYP-P02

[2016-01-20T07:55:51.073-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 26] [userId: ] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.gl.common.validation.model.util.CheckTargetFactory] [SRC_METHOD: getAppInstance] Connection established to HFM.

[2016-01-20T07:55:51.134-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 26] [userId: ] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.gl.common.validation.model.util.CheckProcessManager] [SRC_METHOD: executeCheckRules] ------------------- Execution for Entity : CZT - BEGIN -------------------

[2016-01-20T07:55:51.140-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 26] [userId: ] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.gl.common.validation.model.util.CheckProcessManager] [SRC_METHOD: executeCheckRules] ------------------- Execution for Entity : CZT - END -------------------

[2016-01-20T07:55:52.911-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 26] [userId: ] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.gl.common.reporting.model.util.ReportManager] [SRC_METHOD: returnValidatedQuery] Query:SELECT CatKey, PeriodKey, rptEntityStatus, rptLocation, rptName, rptDesc, rptMode, rptTitle, rptSubTitle, rptEntName, rptEntCat, rptEntPer, rptRuleSeq, rptRuleTitle, rptRuleDef, rptAcct, rptAcctDesc, rptAcctVal, rptTime, rptRuleStatus, UDVal1, UDVal2, UDText1, UDText2, UDText3 FROM tDataCheck [[

[2016-01-20T07:55:53.866-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 26] [userId: ] [ecid: 00iY5j6NKmAFw00Fzzw0w00002OC0001Wh,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.gl.common.reporting.model.util.ReportManager] [SRC_METHOD: generateReport] Generating report for template:Check Report With Warnings.rtf