抽取相关报错合集

1.抽取报错Duplicate key

这个报错原因是有两个值想往同一个key值中写入导致的报错，一般在数据准备中会出现，触发场景多数为用户新建计算字段时直接引用原始字段导致的，解决办法为找到新建计算字段，比如它的内容为直接引用原始字段A，改成 str(A),这种，一般就可以解决这种报错问题。

DE Error: (code=525)transId=nWna4tDKr2nZ3nFZxeHCm5, flowId=18541996 <#a90c8f5c> c.n.y.t.m.t.TaskProcessException: Duplicate key EXTERNALPN (attempted merging values 13 and 93)
    at java.util.stream.Collectors.duplicateKeyException(Collectors.java:135)
    at java.util.stream.Collectors.lambda$uniqKeysMapAccumulator$1(Collectors.java:182)
    at java.util.stream.ReduceOps$3ReducingSink.accept(ReduceOps.java:169)
    at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:179)
    at java.util.stream.IntPipeline$1$1.accept(IntPipeline.java:180)
Caused by: <#e8e4132f> java.lang.IllegalStateException: Duplicate key EXTERNALPN (attempted merging values 13 and 93)
    at java.util.stream.Collectors.duplicateKeyException(Collectors.java:135)
    at java.util.stream.Collectors.lambda$uniqKeysMapAccumulator$1(Collectors.java:182)
    at java.util.stream.ReduceOps$3ReducingSink.accept(ReduceOps.java:169)
    at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:179)
    at java.util.stream.IntPipeline$1$1.accept(IntPipeline.java:180)

2.抽取报错Cannot open file /Netease/service/clickhouse/store/

原因 ：输出表里有字段过长或者特殊字符导致的

排查方法：transid去后台查询，看 DE 的input输入，找到字符过长的字段，修改下对应字段名字