1 2 Previous Next 21 Replies Latest reply on Sep 2, 2013 6:25 AM by Aditya K

    Error in using SQLLDR LKM

    Aditya K

      I am trying to load fixed length flat file into Oracle table in ODI by using LKM File to Oracle (SQLLDR).

      But getting below error in Call sqlldr step,

       

      org.apache.bsf.BSFException: exception from Jython:

      Traceback (most recent call last):

        File "<string>", line 22, in <module>

      Load Error: See C:\Aditya\ODI\SQL_Loader/TARIFF_SERVICE.log for details

       

          at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)

          at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)

          at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)

          at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2472)

          at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:47)

          at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:1)

          at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)

          at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)

          at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)

          at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:558)

          at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:464)

          at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)

          at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)

          at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

          at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)

          at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)

          at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)

          at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)

          at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)

          at java.lang.Thread.run(Thread.java:662)

      Caused by: Traceback (most recent call last):

        File "<string>", line 22, in <module>

      Load Error: See C:\Aditya\ODI\SQL_Loader/TARIFF_SERVICE.log for details

       

          at org.python.core.PyException.fillInStackTrace(PyException.java:70)

          at java.lang.Throwable.<init>(Throwable.java:181)

          at java.lang.Exception.<init>(Exception.java:29)

          at java.lang.RuntimeException.<init>(RuntimeException.java:32)

          at org.python.core.PyException.<init>(PyException.java:46)

          at org.python.core.PyException.doRaise(PyException.java:219)

          at org.python.core.Py.makeException(Py.java:1166)

          at org.python.core.Py.makeException(Py.java:1170)

          at org.python.pycode._pyx13.f$0(<string>:59)

          at org.python.pycode._pyx13.call_function(<string>)

          at org.python.core.PyTableCode.call(PyTableCode.java:165)

          at org.python.core.PyCode.call(PyCode.java:18)

          at org.python.core.Py.runCode(Py.java:1204)

          at org.python.core.Py.exec(Py.java:1248)

          at org.python.util.PythonInterpreter.exec(PythonInterpreter.java:172)

          at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:144)

          ... 19 more

       

       

      TARIFF_SERVICE.log is not getting created.

       

      Code generated is,

       

      import java.lang.String

      import java.lang.Runtime as Runtime

      from jarray import array

      import java.io.File

      import os

      import re

       

       

      ctlfile = r"""C:\Aditya\ODI\SQL_Loader/TARIFF_SERVICE.ctl"""

      logfile = r"""C:\Aditya\ODI\SQL_Loader/TARIFF_SERVICE.log"""

      outfile = r"""C:\Aditya\ODI\SQL_Loader/TARIFF_SERVICE.out"""

      oracle_sid=''

      if len('XE')>0: oracle_sid = '@'+'XE'

       

       

      loadcmd = r"""sqlldr 'HR/<@=snpRef.getInfo("DEST_PASS") @>%s' control='%s' log='%s' > "%s" """ % (oracle_sid,ctlfile, logfile, outfile)

       

       

      rc = os.system(loadcmd)

       

      if rc <> 0 and rc <> 2:

          raise "Load Error", "See %s for details" % logfile

       

      # Init Vars

      nbIns = 0

      nbRej = 0

      nbNull = 0

      strprt = ""

      maxAllowedError = r"""0"""

      c = 0

      flag = 0

       

      # Open log file

      f = open(logfile, "r")

      try:

          lines = f.readlines()

          for line in lines:

              if line.rstrip().upper().endswith(r"""HR.TC$_0SAS_TARIFF_SERVICEREPLACE:""".upper()):

                  flag = 1

                  c = 0

              if flag == 1:

                  if c > 0 and c <= 4:

                      if c == 1 :

                          nbIns = int(re.findall("\d+", line)[0])

                      elif c == 2:

                          nbRej = int(re.findall("\d+", line)[0])

                      elif c == 4:

                          nbNull = int(re.findall("\d+", line)[0])

                          break

              c+=1

          strprt = "\n\tIns:\t%s\n\tReject:\t%s\n\tNullField:\t%s" % (nbIns, nbRej, nbNull)

      finally:

          f.close()

       

       

      # if some rows has been rejected due to invalide data, check KM option LOA_ERRORS

      if rc == 2:

          if nbRej > int(maxAllowedError):

              raise strprt

              break

       

      Can anyone suggest how to resolve this issue?

       

      Thanks,

      Aditya

        • 1. Re: Error in using SQLLDR LKM
          user5912565

          What does log file (C:\Aditya\ODI\SQL_Loader/TARIFF_SERVICE.log) say?

           

          Can you see the SQLLDR files (ctl, log, out)? Can you run the SQLLDR outside of ODI using those generated files?

          • 2. Re: Error in using SQLLDR LKM
            Aditya K

            .log file is not getting created.

            neither .out file is getting created.

             

            I am using Oracle XE database..so client is not installed on my PC.

            Can this be the reason for above issue?

             

            Thanks

            Aditya

            • 3. Re: Error in using SQLLDR LKM
              Sutirtha Roy

              Hi Aditya,

               

              Verify the following

              • The Oracle Client and the SQL*Loader utility is installed on the machine running the Oracle Data Integrator Agent.
              • The server names defined in the Topology is matching the Oracle TNS name used to access the Oracle instances.
              • If you are using DIRECT mode then Oracle Data integrator Agent must  run on the target Oracle server machine. The source file must also be on that machine.

              Thanks,

              Sutirtha

              1 person found this helpful
              • 4. Re: Error in using SQLLDR LKM
                Aditya K

                Hi Sutirtha,

                 

                I have installed Oracle11g database and Client on my pc.

                 

                Also set the oracle_home path as
                SET ORACLE_HOME=C:\app\aditya.karmalkar\product\11.2.0\dbhome_1

                 

                Also defined the SID in instance/dblink(Data server) as ORCL.

                I am executing interface by using Local Agent.

                 

                Still I am facing the same issue,

                .log file is not getting generated and ODI is giving above error.

                 

                I am able to load the same file by using SQL Loader (from cmd).

                 

                Can you please help here?

                 

                Thanks

                Aditya

                • 5. Re: Error in using SQLLDR LKM
                  umit

                  Hi,

                   

                  Can you pls check your file data server and physical server under topology? And test it with the same agent when you are execute your interface or package.

                   

                  What does it say? Is it successful or not?

                   

                  Thx

                  • 6. Re: Error in using SQLLDR LKM
                    Aditya K

                    Hi,

                     

                    Both Oracle and file topology connections are giving successful connection.

                     

                    Thanks

                    Aditya

                    • 7. Re: Error in using SQLLDR LKM
                      DecaXD

                      Try to put a everyone - full control permission on C:\Aditya\ODI\SQL_Loader

                      • 8. Re: Error in using SQLLDR LKM
                        Aditya K

                        Tried with everyone - full permission, but still getting the same error.

                        .ctl file is getting created at C:\Aditya\ODI\SQL_Loader

                        So there should not be any access issue.

                         

                        Thanks

                        Aditya

                        • 9. Re: Error in using SQLLDR LKM
                          DecaXD

                          Hi, try execute sql loader outside ODI. Does it work?

                          • 10. Re: Error in using SQLLDR LKM
                            Aditya K

                            Yes...It's working outside.

                             

                            Thanks

                            Aditya

                            • 11. Re: Error in using SQLLDR LKM
                              DecaXD

                              Please post here the command from Operator of "generate CTL file" ( i don't remember if is the exact name).

                               

                              you are not able to execute both with local agent and "real" agent, isn't it?

                              • 12. Re: Error in using SQLLDR LKM
                                Aditya K

                                Hi,

                                 

                                Generate CTL file code is,

                                 

                                SnpsOutFile "-File=C:\Aditya\ODI\SQL_Loader/TARIFF_SERVICE.ctl" "-CHARSET_ENCODING=ISO8859-1"

                                OPTIONS (

                                    SKIP=0,

                                    ERRORS=<default>:10,

                                    DIRECT=FALSE

                                    )

                                LOAD DATA

                                INFILE "C:\Aditya\ODI\SQL_Loader/TARIFF_SERVICE.dat" "STR x'0D0A'"

                                BADFILE "C:\Aditya\ODI\SQL_Loader/TARIFF_SERVICE.bad"

                                DISCARDFILE "C:\Aditya\ODI\SQL_Loader/TARIFF_SERVICE.dsc"

                                DISCARDMAX <default>:10

                                INTO TABLE SCOTT.TC$_0SAS_TARIFF_SERVICEREPLACE

                                 

                                FIELDS TERMINATED BY X'5E7C'

                                 

                                TRAILING NULLCOLS

                                (

                                    TARIFF_SERVICE_KEY    ,

                                    TARIFF_CODE    ,

                                    SERVICE_CODE    ,

                                    STATUS    ,

                                    CHANGED_BY    ,

                                    CHANGEDLO    DECIMAL EXTERNAL,

                                    CHANGEDHI    DECIMAL EXTERNAL,

                                    CREATED_BY    ,

                                    CREATEDLO    DECIMAL EXTERNAL,

                                    CREATEDHI    DECIMAL EXTERNAL

                                )

                                 

                                This step is getting executed successfully.

                                 

                                I am getting error in next Call sqlldr step.

                                Its code is,

                                 

                                import java.lang.String

                                import java.lang.Runtime as Runtime

                                from jarray import array

                                import java.io.File

                                import os

                                import re

                                 

                                 

                                ctlfile = r"""C:\Aditya\ODI\SQL_Loader/TARIFF_SERVICE.ctl"""

                                logfile = r"""C:\Aditya\ODI\SQL_Loader/TARIFF_SERVICE.log"""

                                outfile = r"""C:\Aditya\ODI\SQL_Loader/TARIFF_SERVICE.out"""

                                oracle_sid=''

                                if len('ORCL')>0: oracle_sid = '@'+'ORCL'

                                 

                                 

                                loadcmd = r"""sqlldr 'SCOTT/<@=snpRef.getInfo("DEST_PASS") @>%s' control='%s' log='%s' > "%s" """ % (oracle_sid,ctlfile, logfile, outfile)

                                 

                                 

                                rc = os.system(loadcmd)

                                 

                                if rc <> 0 and rc <> 2:

                                    raise "Load Error", "See %s for details" % logfile

                                 

                                # Init Vars

                                nbIns = 0

                                nbRej = 0

                                nbNull = 0

                                strprt = ""

                                maxAllowedError = r"""<default>:10"""

                                c = 0

                                flag = 0

                                 

                                # Open log file

                                f = open(logfile, "r")

                                try:

                                    lines = f.readlines()

                                    for line in lines:

                                        if line.rstrip().upper().endswith(r"""SCOTT.TC$_0SAS_TARIFF_SERVICEREPLACE:""".upper()):

                                            flag = 1

                                            c = 0

                                        if flag == 1:

                                            if c > 0 and c <= 4:

                                                if c == 1 :

                                                    nbIns = int(re.findall("\d+", line)[0])

                                                elif c == 2:

                                                    nbRej = int(re.findall("\d+", line)[0])

                                                elif c == 4:

                                                    nbNull = int(re.findall("\d+", line)[0])

                                                    break

                                        c+=1

                                    strprt = "\n\tIns:\t%s\n\tReject:\t%s\n\tNullField:\t%s" % (nbIns, nbRej, nbNull)

                                finally:

                                    f.close()

                                 

                                 

                                # if some rows has been rejected due to invalide data, check KM option LOA_ERRORS

                                if rc == 2:

                                    if nbRej > int(maxAllowedError):

                                        raise strprt

                                        break

                                 

                                I tried to execute it with Local agent only as I have installed everything on my PC.

                                I am able to load the same file by using External Table LKM.

                                 

                                Thanks

                                Aditya

                                • 13. Re: Error in using SQLLDR LKM
                                  DecaXD

                                  Hi,

                                   

                                   

                                  sorry for the late response.

                                   

                                  I'm seeing this

                                   

                                   

                                    TARIFF_SERVICE_KEY    ,

                                      TARIFF_CODE    ,

                                      SERVICE_CODE    ,

                                      STATUS    ,

                                      CHANGED_BY    ,

                                      CHANGEDLO    DECIMAL EXTERNAL,

                                      CHANGEDHI    DECIMAL EXTERNAL,

                                      CREATED_BY    ,

                                      CREATEDLO    DECIMAL EXTERNAL,

                                      CREATEDHI    DECIMAL EXTERNAL

                                   

                                  Could you check your datastore? I havent't a ctl file here but if i remember well you're missing some datatype...

                                  • 14. Re: Error in using SQLLDR LKM
                                    fa0b58cf-4de9-4770-bcf9-20880b9c9c1f

                                    Hi

                                     

                                    i am facing same issue did any body find any solution for it

                                     

                                    Hi 1005380,

                                    Thanks for quick respond.

                                     

                                    Source(position based file so i cant change the phsical length)

                                     

                                    name,type,physical length,logical length,-,-,recordCount

                                     

                                    pading

                                    String

                                    1

                                    1

                                    50

                                    null

                                    2

                                    journal_name

                                    String

                                    2

                                    50

                                    50

                                    null

                                    journal_line_number

                                    String

                                    52

                                    6

                                    50

                                    null

                                    segment1

                                    String

                                    58

                                    6

                                    50

                                    null

                                    segment2

                                    String

                                    64

                                    8

                                    50

                                    null

                                    segment3

                                    String

                                    72

                                    5

                                    50

                                    null

                                    segment4

                                    String

                                    77

                                    3

                                    50

                                    null

                                    segment5

                                    String

                                    80

                                    1

                                    50

                                    null

                                    segment6

                                    String

                                    81

                                    4

                                    50

                                    null

                                    segment7

                                    String

                                    85

                                    3

                                    50

                                    null

                                    segment8

                                    String

                                    88

                                    5

                                    50

                                    null

                                    line_desc

                                    String

                                    93

                                    240

                                    50

                                    null

                                    debit_amount

                                    String

                                    333

                                    15

                                    50

                                    null

                                    credit_amount

                                    String

                                    348

                                    15

                                    50

                                    null

                                     

                                     

                                    Target(DB)

                                    order,name,type,logicalLength,scale,Source mapping fields

                                    55

                                    ENTERED_DR

                                    NUMBER

                                    0

                                    -127

                                    Debit_amt(sorce)

                                    56

                                    ENTERED_CR

                                    NUMBER

                                    0

                                    -127

                                    credit_amt(source)

                                    60

                                    REFERENCE1

                                    VARCHAR2

                                    100

                                    0

                                    journalname(source)

                                    142

                                    CUSTOM_ATTRIBUTE1

                                    VARCHAR2

                                    150

                                    0

                                    segment1(s)

                                    143

                                    CUSTOM_ATTRIBUTE2

                                    VARCHAR2

                                    150

                                    0

                                    segment2(s)

                                    144

                                    CUSTOM_ATTRIBUTE3

                                    VARCHAR2

                                    150

                                    0

                                    segment3(s)

                                    145

                                    CUSTOM_ATTRIBUTE4

                                    VARCHAR2

                                    150

                                    0

                                    segment4(s)

                                    146

                                    CUSTOM_ATTRIBUTE5

                                    VARCHAR2

                                    150

                                    0

                                    segment5(s)

                                    147

                                    CUSTOM_ATTRIBUTE6

                                    VARCHAR2

                                    150

                                    0

                                    segment6(s)

                                    148

                                    CUSTOM_ATTRIBUTE7

                                    VARCHAR2

                                    150

                                    0

                                    segment7(s)

                                    149

                                    CUSTOM_ATTRIBUTE8

                                    VARCHAR2

                                    150

                                    0

                                    segment8(s)

                                     

                                    i am omitting padding and line_desc from source for mapping.

                                    Note : 1)even i am mapping single column eg: journal_name and reference1 for more than 1000 records i am getting the Error(Number format exception).for 999 records it is picking up and it is not throwing any error.

                                    2)for 999 records i mapped all the fields its working fine,if pass more than 999 records it throwing error.

                                     

                                    knowledge Modules:

                                    LKM File to SQL and IKM SQL Control Append

                                     

                                    Execution Steps:

                                    loading Drop work table ,Create work table and error at Load data

                                     

                                    Error code:

                                    Source Code:

                                    select

                                    journal_name

                                    C3_JOURNAL_NAME,

                                    segment1

                                    C4_SEGMENT1,

                                    segment2

                                    C5_SEGMENT2,

                                    segment3

                                    C6_SEGMENT3,

                                    segment4

                                    C7_SEGMENT4,

                                    segment5

                                    C8_SEGMENT5,

                                    segment6

                                    C9_SEGMENT6,

                                    segment7

                                    C10_SEGMENT7,

                                    segment8

                                    C11_SEGMENT8,

                                    debit_amount

                                    C1_DEBIT_AMOUNT,

                                    credit_amount

                                    C2_CREDIT_AMOUNT

                                    from

                                    TABLE

                                    /*$$SNPS_START_KEYSNP$CRDWG_TABLESNP$CRTABLE_NAME=ADA_ENTRY_STG_LINESSNP$CRLOAD_FILE=/C:/DavidNithin/GL_Abstraction/adaoasisla.dat.07012013_13h23.txtSNP$CRFILE_FORMAT=FSNP$CRFILE_SEP_FIELD=0x0009SNP$CRFILE_SEP_LINE=0ASNP$CRFILE_FIRST_ROW=0SNP$CRFILE_ENC_FIELD=SNP$CRFILE_DEC_SEP=SNP$CRSNP$CRDWG_COLSNP$CRCOL_NAME=padingSNP$CRTYPE_NAME=STRINGSNP$CRLINE_OFFSET=1SNP$CRLENGTH=1SNP$CRPRECISION=50SNP$CRREC_CODE_LIST=2SNP$CRSNP$CRDWG_COLSNP$CRCOL_NAME=journal_nameSNP$CRTYPE_NAME=STRINGSNP$CRLINE_OFFSET=2SNP$CRLENGTH=50SNP$CRPRECISION=50SNP$CRSNP$CRDWG_COLSNP$CRCOL_NAME=journal_line_numberSNP$CRTYPE_NAME=STRINGSNP$CRLINE_OFFSET=52SNP$CRLENGTH=6SNP$CRPRECISION=50SNP$CRSNP$CRDWG_COLSNP$CRCOL_NAME=segment1SNP$CRTYPE_NAME=STRINGSNP$CRLINE_OFFSET=58SNP$CRLENGTH=6SNP$CRPRECISION=50SNP$CRSNP$CRDWG_COLSNP$CRCOL_NAME=segment2SNP$CRTYPE_NAME=STRINGSNP$CRLINE_OFFSET=64SNP$CRLENGTH=8SNP$CRPRECISION=50SNP$CRSNP$CRDWG_COLSNP$CRCOL_NAME=segment3SNP$CRTYPE_NAME=STRINGSNP$CRLINE_OFFSET=72SNP$CRLENGTH=5SNP$CRPRECISION=50SNP$CRSNP$CRDWG_COLSNP$CRCOL_NAME=segment4SNP$CRTYPE_NAME=STRINGSNP$CRLINE_OFFSET=77SNP$CRLENGTH=3SNP$CRPRECISION=50SNP$CRSNP$CRDWG_COLSNP$CRCOL_NAME=segment5SNP$CRTYPE_NAME=STRINGSNP$CRLINE_OFFSET=80SNP$CRLENGTH=1SNP$CRPRECISION=50SNP$CRSNP$CRDWG_COLSNP$CRCOL_NAME=segment6SNP$CRTYPE_NAME=STRINGSNP$CRLINE_OFFSET=81SNP$CRLENGTH=4SNP$CRPRECISION=50SNP$CRSNP$CRDWG_COLSNP$CRCOL_NAME=segment7SNP$CRTYPE_NAME=STRINGSNP$CRLINE_OFFSET=85SNP$CRLENGTH=3SNP$CRPRECISION=50SNP$CRSNP$CRDWG_COLSNP$CRCOL_NAME=segment8SNP$CRTYPE_NAME=STRINGSNP$CRLINE_OFFSET=88SNP$CRLENGTH=5SNP$CRPRECISION=50SNP$CRSNP$CRDWG_COLSNP$CRCOL_NAME=line_descSNP$CRTYPE_NAME=STRINGSNP$CRLINE_OFFSET=93SNP$CRLENGTH=240SNP$CRPRECISION=50SNP$CRSNP$CRDWG_COLSNP$CRCOL_NAME=debit_amountSNP$CRTYPE_NAME=STRINGSNP$CRLINE_OFFSET=333SNP$CRLENGTH=15SNP$CRPRECISION=50SNP$CRSNP$CRDWG_COLSNP$CRCOL_NAME=credit_amountSNP$CRTYPE_NAME=STRINGSNP$CRLINE_OFFSET=348SNP$CRLENGTH=15SNP$CRPRECISION=50SNP$CR$$SNPS_END_KEY*/

                                     

                                     

                                    Target Code:

                                    insert into ODI.C$_0MNA_ENTERY_STG_LINES_ADA

                                    (

                                      C3_JOURNAL_NAME,

                                      C4_SEGMENT1,

                                      C5_SEGMENT2,

                                      C6_SEGMENT3,

                                    C7_SEGMENT4,

                                    C8_SEGMENT5,

                                    C9_SEGMENT6,

                                    C10_SEGMENT7,

                                    C11_SEGMENT8,

                                    C1_DEBIT_AMOUNT,

                                    C2_CREDIT_AMOUNT

                                    )

                                    values

                                    (

                                    :C3_JOURNAL_NAME,

                                    :C4_SEGMENT1,

                                    :C5_SEGMENT2,

                                    :C6_SEGMENT3,

                                    :C7_SEGMENT4,

                                    :C8_SEGMENT5,

                                    :C9_SEGMENT6,

                                    :C10_SEGMENT7,

                                    :C11_SEGMENT8,

                                    :C1_DEBIT_AMOUNT,

                                    :C2_CREDIT_AMOUNT

                                    )

                                     

                                     

                                    Error message:

                                     

                                    1. java.lang.NumberFormatException: For input string: "1,000"

                                      at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)

                                      at java.lang.Integer.parseInt(Integer.java:458)

                                      at java.lang.Integer.valueOf(Integer.java:554)

                                      at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatBadRowsFileCollect(SnpSessTaskSql.java:2583)

                                      at oracle.odi.runtime.agent.execution.sql.concurrent.FastJDBCRecordSet.call(FastJDBCRecordSet.java:148)

                                      at oracle.odi.runtime.agent.execution.sql.concurrent.FastJDBCRecordSet.call(FastJDBCRecordSet.java:1)

                                      at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)

                                      at java.util.concurrent.FutureTask.run(FutureTask.java:138)

                                      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

                                      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

                                      at java.lang.Thread.run(Thread.java:662)

                                     

                                    Thanks

                                    David

                                    1 2 Previous Next