table not found - one occurence

karolina_ — Tue, 04 Feb 2014 10:08:42 GMT

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?

topic table not found - one occurence in QlikView

table not found - one occurence