com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -418, SQLSTATE: 42610, SQLERRMC: null

XWiki.org JIRA | Bindul Bhowmik | 8 years ago
  1. 0

    How to make JDBC SQLExceptions for DB2 more descriptive?

    Stack Overflow | 7 years ago | Juha Syrjälä
    com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -302, SQLSTATE: 22001, SQLERRMC: null
  2. 0

    DB2 trigger timing out

    Stack Overflow | 3 years ago | nfvindaloo
    com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -101, SQLSTATE: 54001, SQLERRMC: null
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    A GSPS is stored to the pacs. The statement that triggers the error is: INSERT INTO INSTANCE (created_time, updated_time, sop_iuid, sop_cuid, inst_no, content_datetime, sr_complete, sr_verified, inst_attrs, ext_retr_aet, retrieve_aets, availability, inst_status, all_attrs, commitment, srcode_fk, series_fk, media_fk) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?,?, ?, ?, ?, ?, ?, ?, ?, ?) I believe the problem is because the value in column 9 (inst_attrs) is too big (larger than 64K) as defined for inst_attr. By dumping the dicom object and checking what tags are extracted at instance level I saw (8,1115) which is about ~100K. The strange thing is that the same store operation works against dcm4jboss-2.2.1 configured also to extract (8,1115). Plese find attached: - the stored gsps - dcm4{jboss,chee}-attribute-filter.xml -------------------- server.log ------------------------- 2006-10-10 23:27:56,928 INFO ID_QR_SCU->STORE_SCP (TCPServer-2) [org.dcm4chex.archive.ejb.entity.SeriesBean] Created Series[pk=5381, uid=1.3.6.1.4.1.16978.2.40455242477.4533261.23132.990, study->ejb/Study:111] 2006-10-10 23:27:57,301 INFO -> (Timer-1) [org.dcm4chex.wado.mbean.cache.WADOCacheImpl] getFreeDiskSpace from :/opt/tiani/dcm4chee-standalone-db2-2.10.4.1/server/default/wadocache free:453655920642006-10-10 23:27:57,388 ERROR ID_QR_SCU->STORE_SCP (TCPServer-2) [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCDB2IdentityValLocalCreateCommand.Instance] Could not create entity com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -302, SQLSTATE: 22001, SQLERRMC: null at com.ibm.db2.jcc.b.sf.d(sf.java:1396) -------------------------------------------------------------- -------------------- Explanation on SQL -302 ----------------------------- SQL0302N The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use. Explanation: The value of an input host variable was found to be too large for its use in the SELECT, VALUES, or prepared statement. One of the following occurred: .... and more ....

    JIRA | 1 decade ago | Alexander Karaivanov
    com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -302, SQLSTATE: 22001, SQLERRMC: null
  5. 0

    I am getting sql error while retrive the data from server

    Coderanch | 3 years ago | sachin pate
    com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -516, SQLSTATE: 26501, SQLERRMC: 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. com.ibm.db2.jcc.b.SqlException

      DB2 SQL error: SQLCODE: -418, SQLSTATE: 42610, SQLERRMC: null

      at com.ibm.db2.jcc.b.hh.c()
    2. com.ibm.db2
      hh.c
      1. com.ibm.db2.jcc.b.hh.c(hh.java:1662)
      1 frame