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?
