Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
karolina_
Creator II
Creator 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?

0 Replies