Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
karolina_
Contributor II

table not found - one occurence

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?