0 Replies Latest reply on Apr 1, 2020 1:14 PM by 3243016

    EDQ - DB connection issue

    3243016

      Hello,

       

      Getting the below errors when running the EDQ > Siebel Contact Deduplication Batch Job.

      WARNING: 31-Mar-2020 21:46:02: Matching:Record cluster "Full Name Meta"."FLM^3^ALNMR" larger than 500 records (group size 1,861) - skipping

      WARNING: 31-Mar-2020 21:58:50: Matching:Record cluster "Phone last N"."PLN^1^989236" larger than 500 records (group size 806) - skipping

      WARNING: 31-Mar-2020 22:06:05: [EDQ-05369] A problem occurred reading relationships from the database: A database error has occurred : Result set already closed. (Code: 200,302)

      SEVERE: 31-Mar-2020 22:06:05: [EDQ-06916] [process Match - Individual [278]/job:Siebel Batch Contact Match (343):[22696]] : [dnm:matchadvanced.3] batch 0 terminated by exception: com.datanomic.director.runtime.AbortedProcessException: A database error has occurred : Result set already closed. (Code: 200,302) (Code: 209,885)

      SEVERE: 31-Mar-2020 22:06:07: [EDQ-06913] [process Match - Individual [278]/job:Siebel Batch Contact Match (343):[22696]] : [subprocess 4] batch 0 terminated by exception: Record read interrupted (Code: 201,109)

      SEVERE: 31-Mar-2020 22:06:07: [EDQ-06916] [process Match - Individual [278]/job:Siebel Batch Contact Match (343):[22696]] : [rde:streammerge.4] batch 0 terminated by exception: com.datanomic.director.runtime.AbortedProcessException: java.lang.InterruptedException (Code: 209,003)

      SEVERE: 31-Mar-2020 22:06:07: [EDQ-06913] [process Match - Individual [278]/job:Siebel Batch Contact Match (343):[22696]] : [subprocess 3] batch 0 terminated by exception: Process was cancelled (Code: 201,100)

      SEVERE: 31-Mar-2020 22:06:09: [EDQ-06919] [process Match - Individual [278]/job:Siebel Batch Contact Match (343):[22696]] : runtime process terminated uncleanly: A database error has occurred : Result set already closed. (Code: 200,302) (Code: 209,885)

      SEVERE: 31-Mar-2020 22:06:09: [EDQ-06913] [process Match Results - Prepare [282]/job:Siebel Batch Contact Match (343):[22697]] : [subprocess 3] batch 0 terminated by exception: Record read interrupted (Code: 201,109)

      SEVERE: 31-Mar-2020 22:06:09: [EDQ-06913] [process Match Results - Prepare [282]/job:Siebel Batch Contact Match (343):[22697]] : [subprocess 2] batch 0 terminated by exception: Record read interrupted (Code: 201,109)

      SEVERE: 31-Mar-2020 22:06:09: [EDQ-06916] [process Match Results - Prepare [282]/job:Siebel Batch Contact Match (343):[22697]] : [rde:streammerge.27] batch 0 terminated by exception: com.datanomic.director.runtime.AbortedProcessException: java.lang.InterruptedException (Code: 209,003)

      SEVERE: 31-Mar-2020 22:06:09: [EDQ-06916] [process Match Results - Prepare [282]/job:Siebel Batch Contact Match (343):[22697]] : [dnm:groupandmerge.21] batch 0 terminated by exception: com.datanomic.director.runtime.AbortedProcessException: Interrupt during table insert (Code: 200,024) (Code: 209,861)

      SEVERE: 31-Mar-2020 22:06:09: [EDQ-06913] [process Match Results - Output [281]/job:Siebel Batch Contact Match (343):[22698]] : [subprocess 1] batch 0 terminated by exception: Message read interrupted (Code: 201,103)

      SEVERE: 31-Mar-2020 22:06:09: [EDQ-06919] [process Match Results - Output [281]/job:Siebel Batch Contact Match (343):[22698]] : runtime process terminated uncleanly: Message read interrupted (Code: 201,103)

      SEVERE: 31-Mar-2020 22:06:10: [EDQ-06919] [process Match Results - Prepare [282]/job:Siebel Batch Contact Match (343):[22697]] : runtime process terminated uncleanly: Record read interrupted (Code: 201,109)

       

      The Job is failing and the Contacts are not matching.

       

      Please help to understand the issue, and please suggest a solution to address this issue.

       

      Thanks, Sam P N