java.sql.SQLException: [FMWGEN][DB2 JDBC Driver][DB2]Error occured with SQLCode -7008 with the following parameters: I_KHAJAC , AVI , 3, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null

Oracle Community | 1374429 | 2 years ago
  1. 0

    ODI-1228: Task Store (Integration) fails on the target IBM_DB2_400 connection AS400_JDAMMS

    Oracle Community | 2 years ago | 1374429
    java.sql.SQLException: [FMWGEN][DB2 JDBC Driver][DB2]Error occured with SQLCode -7008 with the following parameters: I_KHAJAC , AVI , 3, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null
  2. 0

    Unable to read next item after skipping exception using Spring Batch

    Stack Overflow | 2 years ago | user3914257
    org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT TOP 6400 ca.cnsmr_accnt_id,ad.UDEFHost,ad.UDEFSecAddPostCode,d.UDEFCurrLTV,d.UDEFOpeningLTV,ad.UDEFMonthsDown,d.UDEFSecChargePresent,d.UDEFPartLoanReason,d.UDEFIncSelfCertified,ai.UDEFIEXDate,(CASE WHEN cpa.UDEFCurPerEndDt IS NULL THEN cpa.UDEFCurPerStrtDt ELSE cpa.UDEFCurPerEndDt END) ArrearsStatusLastClear,ad.UDEFAccState,t.tag_shrt_nm,cmi.UDEFCMI,d.UDEFRiskNavScore,d.UDEFLettingInProgress,d.UDEFAuthorizedLet,d.UDEFUnauthorizedLet,d.UDEFCreditRepair,d.UDEFIncMult,t.tag_id,ad.ID FROM cnsmr_accnt ca INNER JOIN UDEFTestAccountDetails ad ON ca.cnsmr_accnt_id = ad.cnsmr_accnt_id AND ad.ID = (SELECT MAX(ID) from UDEFTestAccountDetails WHERE cnsmr_accnt_id=ca.cnsmr_accnt_id) INNER JOIN UDEFDecisioning d ON d.cnsmr_accnt_id = ca.cnsmr_accnt_id INNER JOIN UDEFCurPerArrs cpa ON cpa.cnsmr_accnt_id = ca.cnsmr_accnt_id INNER JOIN UDEFCMI cmi ON cmi.cnsmr_accnt_id = ca.cnsmr_accnt_id INNER JOIN cnsmr_accnt_tag cat ON cat.cnsmr_accnt_id = ca.cnsmr_accnt_id AND cat.cnsmr_accnt_sft_delete_flg ='N' INNER JOIN tag t ON t.tag_id = cat.tag_id INNER JOIN UDEFAccountIEX ai ON ai.cnsmr_accnt_id = ca.cnsmr_accnt_id WHERE t.tag_shrt_nm IN ('CLEAR','COLLECT','DEBREC','INPOSS','LIT','PENLIT') ORDER BY cnsmr_accnt_id ASC]; SQL state [null]; error code [0]; null; nested exception is java.sql.SQLException
  3. 0

    JCAPS JDBC  DB2 Driver Error "SQLDIAGGRP was specified and not null"

    Oracle Community | 9 years ago | 807574
    java.sql.SQLException: [SeeBeyond][DB2 JDBC Driver]SQLDIAGGRP was specified and not null.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Issue in DB2 or Java - Handling CLOB data type

    Stack Overflow | 4 years ago | gsonal
    java.sql.SQLException: [BEA][DB2 JDBC Driver]SQLDIAGGRP was specified and not null.
  6. 0

    AV Agent Audit Trail Issue Can Not Start Up.

    Oracle Community | 4 years ago | Royal
    java.sql.SQLException: [Audit Vault][DB2 JDBC Driver][DB2]DISTRIBUTION PROTOCOL ERROR CAUSED DEALLOC: REASON 0x124C"("0103")" (null)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      [FMWGEN][DB2 JDBC Driver][DB2]Error occured with SQLCode -7008 with the following parameters: I_KHAJAC , AVI , 3, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null

      at weblogic.jdbc.db2base.ddb9.b()
    2. weblogic.jdbc.db2base
      ddb8.a
      1. weblogic.jdbc.db2base.ddb9.b(Unknown Source)
      2. weblogic.jdbc.db2base.ddb9.a(Unknown Source)
      3. weblogic.jdbc.db2base.ddb8.b(Unknown Source)
      4. weblogic.jdbc.db2base.ddb8.a(Unknown Source)
      4 frames
    3. weblogic.jdbc.db2
      ddg.h
      1. weblogic.jdbc.db2.drda.ddn.c(Unknown Source)
      2. weblogic.jdbc.db2.drda.ddn.a(Unknown Source)
      3. weblogic.jdbc.db2.drda.ddp.a(Unknown Source)
      4. weblogic.jdbc.db2.drda.ddj.a(Unknown Source)
      5. weblogic.jdbc.db2.drda.ddn.b(Unknown Source)
      6. weblogic.jdbc.db2.ddg.h(Unknown Source)
      6 frames
    4. weblogic.jdbc.db2base
      ddde.execute
      1. weblogic.jdbc.db2base.ddek.e(Unknown Source)
      2. weblogic.jdbc.db2base.ddek.a(Unknown Source)
      3. weblogic.jdbc.db2base.ddde.a(Unknown Source)
      4. weblogic.jdbc.db2base.ddek.v(Unknown Source)
      5. weblogic.jdbc.db2base.ddek.r(Unknown Source)
      6. weblogic.jdbc.db2base.ddde.execute(Unknown Source)
      6 frames
    5. oracle.odi.runtime
      TaskExecutionHandler.handleTask
      1. oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:163)
      2. oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:102)
      3. oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:1)
      4. oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
      4 frames
    6. com.sunopsis.dwg
      SnpSession.treatSession
      1. com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)
      2. com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
      3. com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:558)
      4. com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:464)
      5. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
      5 frames
    7. oracle.odi.runtime
      StartSessRequestProcessor$2.doAction
      1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)
      1 frame
    8. oracle.odi.core
      DwgObjectTemplate.execute
      1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
      1 frame
    9. oracle.odi.runtime
      DefaultAgentTaskExecutor$2.run
      1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)
      2. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)
      3. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)
      4. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
      5. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
      5 frames
    10. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:736)
      1 frame