4 Replies Latest reply: Jan 14, 2014 10:35 AM by Lee Alderdice RSS

    QEMC Reload Failure on just 3 files

      Hi All,

       

      I am getting a reload failure on just 3 of my files when reloading through a scheduled task.  Reloading through the document is fine.

       

      The log files shows that the document is opened correctly, connection string is accepted, section access is completed and then it just stops ... it seems to hang at trying to get to the first table load a section of the log file is below ... i can't seem to get much more detail from the service event viewer etc.

       

      01/14/14 10:00:03: 0015  star is *

      01/14/14 10:00:03: 0017  Section Access

      01/14/14 10:00:03: 0019  LOAD * INLINE

      01/14/14 10:00:03: 0020  [

      01/14/14 10:00:03: 0021      ACCESS, USERID, PASSWORD, LINKID

      01/14/14 10:00:03: 0022      *****,***, ********, ALLVALUES

      01/14/14 10:00:03: 0023      *****, *****, ****, ALLVALUES

      01/14/14 10:00:03: 0024      ]

      01/14/14 10:00:03:       4 fields found: ACCESS, USERID, PASSWORD, LINKID, 2 lines fetched

      01/14/14 10:00:03: 0026  LOAD 'USER' as ACCESS,

      01/14/14 10:00:03: 0027   upper(U_ID) as USERID,

      01/14/14 10:00:03: 0028   upper(EncryptPassword) as PASSWORD,

      01/14/14 10:00:03: 0029   upper(LINKID) as LINKID

       

      At this point, it just stops.  I have set timeout to what I understand to be the maximum 2400 but there is no issue from within a document if that makes sense.

       

      Would anyone be able to provider a pointer, i can't seem to find a good thread showing a similar issue.

       

      Thanks

       

      Lee