Getting Dups record error while building dimension cuboids TSLGENBUHIERARCHY Table has unique set of records of comprising from ID 2 to 13. I have one look up table which has data of Flatten Hierarchy & All are having derived dimension. Can you pls. help in why I am getting the Dups error?
[cid:[email protected]] java.lang.IllegalStateException: The table: TSLGENBUHIERARCHY_SAPRK Dup key found, key=[null], value1=[TOP,TOTAL MARKET,HOUSTON,HOUSTON MARKETS,HOUSTON CENTRAL,HOUSTON MAIN,null,null,null,null,null,JP MORGAN CHASE & CO.,null,null,null,null,null,null,null,null,null,null,JP MORGAN CHASE EX CONSOL ENT.,null,TOTAL GROUPS-EX STAFF & UNDI,CONSUMER & COMMUNITY BANKING,CONSUMER & BUSINESS BANKING,CONSUMER BANKING,CONSUMER BANK W/O CWM,MARKETS, NATIONAL SALES, SAFE ACT,1,2017-11-01 02:50:10.0,null,9999-12-31 00:00:00.0,1238000,0201,6,null,1689017,1683810,1685426,3053087,1672365,1865068,null,null,null,null,null,1689008,null,null,null,null,null,null,null,null,null,null,1687999,null,1687987,1683683,1683201,1689618,1654880,1683216,579999,577143,577920,570223,559604,528466,null,null,null,null,null,579990,null,null,null,null,null,null,null,null,null,null,579980,null,579965,577006,576344,580691], value2=[TOP,TOTAL MARKET,NEW JERSEY REGION,NEW JERSEY MARKETS,NJ PRINCETON,null,null,null,null,null,null,JP MORGAN CHASE & CO.,null,null,null,null,null,null,null,null,null,null,JP MORGAN CHASE EX CONSOL ENT.,null,TOTAL GROUPS-EX STAFF & UNDI,CONSUMER & COMMUNITY BANKING,CONSUMER & BUSINESS BANKING,CONSUMER BANKING,CONSUMER BANK W/O CWM,MARKETS, NATIONAL SALES, SAFE ACT,10,2017-11-01 02:50:10.0,null,9999-12-31 00:00:00.0,1238001,0802,6,null,1689017,1683810,1699104,3053239,1656691,null,null,null,null,null,null,1689008,null,null,null,null,null,null,null,null,null,null,1687999,null,1687987,1683683,1683201,1689618,1654880,1683216,579999,577143,587040,570795,527763,null,null,null,null,null,null,579990,null,null,null,null,null,null,null,null,null,null,579980,null,579965,577006,576344,580691] at org.apache.kylin.dict.lookup.LookupTable.initRow(LookupTable.java:86) at org.apache.kylin.dict.lookup.LookupTable.init(LookupTable.java:69) at org.apache.kylin.dict.lookup.LookupStringTable.init(LookupStringTable.java:79) at org.apache.kylin.dict.lookup.LookupTable.<init>(LookupTable.java:57) at org.apache.kylin.dict.lookup.LookupStringTable.<init>(LookupStringTable.java:65) at org.apache.kylin.cube.CubeManager.getLookupTable(CubeManager.java:686) at org.apache.kylin.cube.cli.DictionaryGeneratorCLI.processSegment(DictionaryGeneratorCLI.java:98) at org.apache.kylin.cube.cli.DictionaryGeneratorCLI.processSegment(DictionaryGeneratorCLI.java:54) at org.apache.kylin.engine.mr.steps.CreateDictionaryJob.run(CreateDictionaryJob.java:66) Regards, Manoj This message is confidential and subject to terms at: http://www.jpmorgan.com/emaildisclaimer including on confidentiality, legal privilege, viruses and monitoring of electronic messages. If you are not the intended recipient, please delete this message and notify the sender immediately. Any unauthorized use is strictly prohibited.
