Adding a Custom KVP to GIM/GI2

Architect & Flows
1

HI

I am looking for the steps for adding a new custom KVP to GIM and GI2 universe. I have added the KVP in ccon_adata_spec file under USER_DATA_CUST_DIM_2.

Also I have added the KVP in ‘IRF_USER_DATA_CUST_2’ and CTL_UD_TO_UDE_MAPPING Tables. But its still not picking the data in GIM DB. Could anyone point out what step i missed to do capture new KVP in GIM.

RKD

2

After you change the adata_spec XML file, you must restart ICON, if you haven’t done this yet, might be the problem.

Do you see the data on g_userdata_history table on ICON DB? If not, check if your ICON has GUD role in addition to GCC and GLS.

If you see the that data there, check if ctl_ude_keys_to_dim_mapping table on GIM DB is also populated correctly (when using low cardinality User Data).

Also, note that the UserData dimensions are hidden by default on GI2 Universe. Follow the steps on this doc to display them on the default universe:
https://docs.genesys.com/Documentation/GI2/latest/UG/UsingAttachedData

3

Thank you. I had already restarted the ICONs and I can see the values for my new KVP in G_USERDATA_HISTORY in ICON DB. But am not seeing the same in GIDB_G_USERDATA_HISTORY_V table :frowning:

Also i have added the new one in CTL_UD_TO_UDE_MAPPING table.

ID UD_KEY_NAME UDE_TABLE_NAME UDE_COLUMN_NAME PROPAGATION_RULE
31 ent_CallerAction IRF_USER_DATA_CUST_2 IUDC2_ENT_CALLERACTION CALL

But I am not able to see the values in in IRF_USER_DATA_CUST_2 table. Its coming as NULL.

RKD

4

Does the DAP which Info Mart uses to connect to ICON DB has the role “gud”? Also, the User Data is case sensitive (must match Lower Case and Upper Case accordingly).

5

Yes it has all three listed as role. ‘gcc,gls,gud’

6

This part is specially strange. I’d recommend to check gim_etl.log file during Job_ExtractICON, specially if there are lines that look like as below:


2017-09-25 14:32:02,624 INFO  ecp-1-102985 25000 Creating slice: <your icon DAP name here>.          G_USERDATA_HISTORY             [2017-09-25 14:21:15,2017-09-25 14:31:25(1506349275,1506349885)], dsKey=43, iconDBID=2354, dssId=453293876
7

Thank you. I saw errors in etl logs and restarted ETL process. Now its picking upthe values.