Products | Versions |
---|---|
TIBCO Data Virtualization | All supported versions |
In TIBCO Data Virtualization, object creation (creating new folder, view, SQL script, packaged query etc.) may take longer than usual. This happens only when 'Copy privileges from parent folder' checkbox is selected.
Screenshot for reference:
Verify if the total number of Active Directory users and groups in TDV are higher than external group account users which explains that unwanted users have not been deleted from TDV side. Therefore, the create object function in TDV checks the user privilege for every user during object creation resulting in the delay.
To learn more about the create object functions, enable debug logging from Studio > Administration > Configuration > Server > Configuration > Debugging > Debug Output Enabled > Set it to 'true'. Examine the cs_server.log file which might show heavy use of getInheritedUserResourcePrivilege and fetchMemberCids. This would prove, the create object function checks user privileges for every user - approximately several hundreds - which would be the cause for delay.
Here is an example from cs_server log file:
>>> 16 ms to create folder
DEBUG [jetty thread pool-237] 2019-03-25 21:08:45.304 -0700 ContainerImpl - [36392] CREATE name="test" type=1 subType=-10 parent="/users/composite/adminuser"
>>> start
DEBUG [jetty thread pool-237] 2019-03-25 21:08:45.320 -0700 RepositoryImpl - [36392] WRITE 1 dirty objects.
>>> setting privileges
DEBUG [jetty thread pool-236] 2019-03-25 21:08:45.460 -0700 WsapiServlet -
header.SOAPAction: "getResourcePrivileges"
>>> 30 ms hasEffectiveResourcePrivilege
DEBUG [jetty thread pool-236] 2019-03-25 21:08:45.460 -0700 AuthorizationManager - hasEffectiveResourcePrivilege(10100,adminuser,1)
DEBUG [jetty thread pool-236] 2019-03-25 21:08:45.492 -0700 AuthorizationManager - hasEffectiveResourcePrivilege(50102,SCRUBBEDUSER)
>>> 4 secs fetchMemberStates
DEBUG [jetty thread pool-236] 2019-03-25 21:08:45.507 -0700 JdbcRepository - fetchMemberStates(idCidsList={...
DEBUG [jetty thread pool-236] 2019-03-25 21:08:49.633 -0700 JdbcRepository - fetchMemberStates(idCidsList={{1,83350},{2,102081},{2348,83384}}, referenceCid=102204)
>>> 4 secs getInheritedUserResourcePrivilege
DEBUG [jetty thread pool-236] 2019-03-25 21:08:49.664 -0700 AuthorizationManager - getInheritedUserResourcePrivilege(50102,SCRUBBEDUSER)
DEBUG [jetty thread pool-238] 2019-03-25 21:08:53.695 -0700 AuthorizationManager - getInheritedUserResourcePrivilege(12830100,SCRUBBEDUSER)
>>> 2 secs fetchMemberCids
DEBUG [jetty thread pool-237] 2019-03-25 21:08:54.383 -0700 JdbcRepository - fetchMemberCids(domainId=50109, name=SCRUBBEDUSER, subtype=15)
DEBUG [jetty thread pool-237] 2019-03-25 21:08:56.446 -0700 JdbcRepository - fetchMemberCids(domainId=50109, name=SCRUBBEDUSER, subtype=15)
>>> wrapup - 11 secs total
DEBUG [jetty thread pool-238] 2019-03-25 21:08:56.836 -0700 WResourceImpl - Resource Updates (109 ms):
DEBUG [jetty thread pool-238] 2019-03-25 21:08:56.836 -0700 WResourceImpl - Changed:
DEBUG [jetty thread pool-238] 2019-03-25 21:08:56.836 -0700 WResourceImpl - /users/composite/adminuser/test (-1/12830100) true
DEBUG [jetty thread pool-238] 2019-03-25 21:08:56.836 -0700 WResourceImpl - Added:
DEBUG [jetty thread pool-238] 2019-03-25 21:08:56.836 -0700 WResourceImpl - Moved:
DEBUG [jetty thread pool-238] 2019-03-25 21:08:56.836 -0700 WResourceImpl - Deleted:
DEBUG [jetty thread pool-238] 2019-03-25 21:08:56.836 -0700 WResourceImpl - ======================