0 Replies Latest reply: Feb 4, 2014 5:08 AM by Karolina Papaj RSS

    table not found - one occurence

    Karolina Papaj

      Hi All, I hope I do not duplicate question but I could not find similar.
      I have a reload scheduled for quite long time and it just once happen to fail.

       

      Logs:

      Information    2/3/2014 10:00:01 AM: 0004  SecurityUsers:

      2/3/2014 10:00:01.8042510    Information    2/3/2014 10:00:01 AM: 0005  LOAD *

      2/3/2014 10:00:01.8042510    Information    2/3/2014 10:00:01 AM: 0006  INLINE [

      2/3/2014 10:00:01.8042510    Information    2/3/2014 10:00:01 AM: 0007      ACCESS, USERID, PASSWORD, NTNAME, SECURITYUSERID_SYS

      2/3/2014 10:00:01.8042510    Information    2/3/2014 10:00:01 AM: 0008      ADMIN, ADMIN, admin, *, *

      2/3/2014 10:00:01.8042510    Information    2/3/2014 10:00:01 AM: 0009      ADMIN, *, *, .\QlikViewAdmin, *

      2/3/2014 10:00:01.8042510    Information    2/3/2014 10:00:01 AM: 0010  ]

      2/3/2014 10:00:01.8042510    Information    2/3/2014 10:00:01 AM:           5 fields found: ACCESS, USERID, PASSWORD, NTNAME, SECURITYUSERID_SYS, 2 lines fetched

      2/3/2014 10:00:01.8042510    Information    2/3/2014 10:00:01 AM: 0014  CONCATENATE (SecurityUsers)

      2/3/2014 10:00:01.8042510    Information    2/3/2014 10:00:01 AM: 0015  LOAD 'USER' AS ACCESS,

      2/3/2014 10:00:01.8042510    Information    2/3/2014 10:00:01 AM: 0016      '*' AS USERID,

      2/3/2014 10:00:01.8042510    Information    2/3/2014 10:00:01 AM: 0017      '*' AS PASSWORD,

      2/3/2014 10:00:01.8042510    Information    2/3/2014 10:00:01 AM: 0018      UPPER(NTName) AS NTNAME,

      2/3/2014 10:00:01.8042510    Information    2/3/2014 10:00:01 AM: 0019      SecurityUserID_SYS AS SECURITYUSERID_SYS

      2/3/2014 10:00:08.5746944    Information    2/3/2014 10:00:01 AM: 0020  SQL EXEC RSP_QV_GetUsers

      2/3/2014 10:00:08.5746944    Information    2/3/2014 10:00:08 AM:           5 fields found: ACCESS, USERID, PASSWORD, NTNAME,

      2/3/2014 10:00:08.7930958    Information    SECURITYUSERID_SYS, 147 lines fetched

      2/3/2014 10:00:08.7930958    Information    2/3/2014 10:00:08 AM: 0022  STORE SecurityUsers INTO ..\..\QVD\SECURITY_Users.qvd

      2/3/2014 10:00:08.7930958    Information    2/3/2014 10:00:08 AM: 0023  DROP TABLE SecurityUsers

      2/3/2014 10:00:08.7930958    Information    2/3/2014 10:00:08 AM: 0025  SecurityProject:

      2/3/2014 10:00:08.7930958    Information    2/3/2014 10:00:08 AM: 0026  LOAD SecurityUserID_SYS,

      2/3/2014 10:00:08.9022965    Information    2/3/2014 10:00:08 AM: 0027      SecurityTypeKey_SYS,

      2/3/2014 10:00:08.9022965    Information    2/3/2014 10:00:08 AM: 0028      SecurityTypeID_SYS,

      2/3/2014 10:00:08.9022965    Information    2/3/2014 10:00:08 AM: 0029      SecurityProjectID_SYS

      2/3/2014 10:00:09.1206979    Information    2/3/2014 10:00:08 AM: 0030  SQL EXEC RSP_QV_GetProject

      2/3/2014 10:00:09.1206979    Information    2/3/2014 10:00:09 AM: 0032  STORE SecurityProject INTO ..\..\QVD\SECURITY_Project.qvd

      2/3/2014 10:00:09.1206979    Information    2/3/2014 10:00:09 AM:       Error: Table not found


      when load is correct there is:

      2/4/2014 4:00:08 AM: 0030  SQL EXEC RSP_QV_GetProject

      2/4/2014 4:00:09 AM:           4 fields found: SecurityUserID_SYS, SecurityTypeKey_SYS, SecurityTypeID_SYS, SecurityProjectID_SYS, 14,032,445 lines fetched

      2/4/2014 4:05:36 AM: 0032  STORE SecurityUserMergedProjectAccess INTO ..\..\QVD\SECURITY_Project.qvd

      In logs I found just information for "Session stop reason: Session expired after idle time", but it must for user's opened dashboard timeout. Nothing about disconnection with db, but maybe that must be the reason?