Sree query fails
From PTAGISWiki
A user reports that her query runs for about 20 seconds but then always fails.
Tailing schedule.log shows this:
[DEBUG] Dec 12, 2005 10:00:51 AM: Task {Query VirtualQuery} completed
in 102 ms
[TRACE] Dec 12, 2005 10:00:51 AM: Start loading query result:
[TRACE] Dec 12, 2005 10:00:54 AM: File changed on disk:
/global/ds1/pitweb/ptagis-1.0/web/sree/WEB-INF/classes/ldap.tmp, firing
update event.
[TRACE] Dec 12, 2005 10:00:54 AM: DataChangeEvent:
[null,ldap.tmp,1134410441000]
[TRACE] Dec 12, 2005 10:00:54 AM: File changed on disk:
/global/ds1/pitweb/ptagis-1.0/web/sree/WEB-INF/classes/ldap.tmp, firing
update event.
[TRACE] Dec 12, 2005 10:00:54 AM: DataChangeEvent:
[null,ldap.tmp,1134410441000]
[TRACE] Dec 12, 2005 10:00:56 AM: Query data finished loading: 2951
[TRACE] Dec 12, 2005 10:01:00 AM: Task {Generate snesbit/MY04 11W
Recaps at traps_14.11344104512101@local} completed in 0 ms
[ERROR] Dec 12, 2005 10:01:02 AM: Folder does not exist: snesbit
[ERROR] Dec 12, 2005 10:01:02 AM: Failed to save
snesbit/MY04_11W_Recaps_at_traps_14
inetsoft.sree.RepletException: Failed to save
snesbit/MY04_11W_Recaps_at_traps_14 at
inetsoft.sree.RepletEngine.saveInArchive(RepletEngine.java:1021) at
inetsoft.sree.schedule.RepletAction.run(RepletAction.java:650) at
inetsoft.sree.schedule.ScheduleTask.run(ScheduleTask.java:299) at
inetsoft.sree.schedule.Scheduler$TaskExecThread.run(Scheduler.java:1006)
[ERROR] Dec 12, 2005 10:01:02 AM: Failed to save
snesbit/MY04_11W_Recaps_at_traps_14
inetsoft.sree.RepletException: Failed to save
snesbit/MY04_11W_Recaps_at_traps_14 at
inetsoft.sree.RepletEngine.saveInArchive(RepletEngine.java:1021) at
inetsoft.sree.schedule.RepletAction.run(RepletAction.java:650) at
inetsoft.sree.schedule.ScheduleTask.run(ScheduleTask.java:299) at
inetsoft.sree.schedule.Scheduler$TaskExecThread.run(Scheduler.java:1006)
[INFO] Dec 12, 2005 10:01:02 AM: Destroy report: snesbit/MY04 11W
Recaps at traps_14.11344104512101@local total 1
User snesbit appears to have a proper folder according to the SREE enterprise manager (under Repository > Replet Registry > Folders & Replets). However, there is no snesbit folder under Repository > Archive > Folders. === Solution: === I was able to manually create her Archive directory with the SREE enterprise manager, and set permissions to match all the other user's Archive folders. This change enabled her query to run successfully.
All queries always fail. The user has bad sree permissions
A check of the permissions by ldapLookupUser.pl -ku <username> shows this:
[rday@snapper ~]$ ldapLookupPermissions.pl -ku cvh in TEST mode, will make not changes. checking for given user: cvh Found 1 users in LDAP search of ldap. Permissions error for cvh. readusers = : Y3ZoIA== Permissions error for cvh. writeusers = : Y3ZoIA== Permissions error for cvh. deleteusers = : Y3ZoIA== Found 1 users with bad permissions Found 0 users with no SREE folder at all
The cause is a special character that LDAP can't store without special encoding. So the whole entry is encoded. In this case, the special character is a space at the end of the username.
The fix is to rewrite the permissions like so:
[rday@snapper ~]$ ldapLookupPermissions.pl -u cvh checking for given user: cvh Found 1 users in LDAP search of ldap. Permissions error for cvh. readusers = : Y3ZoIA== Permissions error for cvh. writeusers = : Y3ZoIA== Permissions error for cvh. deleteusers = : Y3ZoIA== Found 1 users with bad permissions Found 0 users with no SREE folder at all
Notice the absence of the "k" (kidding) flag. This actually updates the users permission and write them appropriately.
