com.ibm.commerce.foundation.dataimport.exception.DataImportSystemException: CWFDIH0002: An SQL exception was caught. The following error occurred: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601,SQLERRMC=);tryattr.attr_id in (;<value_expr_body>, DRIVER=4.14.103.

ibm.com | 9 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    IBM Solr Preprocessing fails after upgrading to WebSphere Commerce Feature Pack 6 - United States

    ibm.com | 9 months ago
    com.ibm.commerce.foundation.dataimport.exception.DataImportSystemException: CWFDIH0002: An SQL exception was caught. The following error occurred: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601,SQLERRMC=);tryattr.attr_id in (;<value_expr_body>, DRIVER=4.14.103.
  2. 0

    Yashod's Blog

    blogspot.com | 9 months ago
    com.ibm.commerce.foundation.dataimport.exception.DataImportSystemException: CWFDIH0001: Data Import encountered a generic error. The error is CWFDIH0002: An SQL exception was caught. The following error occurred: [jcc][1091][10404][4.19.49] Invalid data conversion: Parameter instance 5711501;5711502 is invalid for the requested conversion. ERRORCODE=-4461, SQLSTATE=42815..
  3. 0

    IBM Pre-process job fails with SQLCODE=-104, SQLSTATE=42601, - United States

    ibm.com | 9 months ago
    com.ibm.commerce.foundation.dataimport.exception.DataImportSystemException: CWFDIH0002: An SQL exception was caught. The following error occurred: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=language_id;D CD.LANGUAGE_ID = ?;CONCAT, DRIVER=4.16.53.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Tip of the Day « Beyond Technology -

    beyondtech.ca | 1 year ago
    com.ibm.commerce.foundation.dataimport.exception.DataImportSystemException: CWFDIH0002: An SQL exception was caught. The following error occurred: ORA-00001: unique constraint (WCADMIN.SYS_C0064248) violated .
  6. 0

    Solr – PreProcess Config fails with the following exception – ORA-00001: unique constraint (.SYS_C0064248) violated « Beyond Technology –

    beyondtech.ca | 9 months ago
    com.ibm.commerce.foundation.dataimport.exception.DataImportSystemException: CWFDIH0002: An SQL exception was caught. The following error occurred: ORA-00001: unique constraint (WCADMIN.SYS_C0064248) violated .

    Root Cause Analysis

    1. com.ibm.commerce.foundation.dataimport.exception.DataImportSystemException

      CWFDIH0002: An SQL exception was caught. The following error occurred: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601,SQLERRMC=);tryattr.attr_id in (;<value_expr_body>, DRIVER=4.14.103.

      at com.ibm.commerce.foundation.dataimport.preprocess.DataImportPreProcessorMain.processDataConfig()
    2. com.ibm.commerce
      DataImportPreProcessorMain.main
      1. com.ibm.commerce.foundation.dataimport.preprocess.DataImportPreProcessorMain.processDataConfig(DataImportPreProcessorMain.java:907)
      2. com.ibm.commerce.foundation.dataimport.preprocess.DataImportPreProcessorMain.execute(DataImportPreProcessorMain.java:759)
      3. com.ibm.commerce.foundation.dataimport.preprocess.DataImportPreProcessorMain.main(DataImportPreProcessorMain.java:286)
      3 frames
    3. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
      4. java.lang.reflect.Method.invoke(Method.java:611)
      4 frames
    4. com.ibm.ws
      WSLauncher.main
      1. com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:267)
      1 frame