Today I had installed fresh updates for Windows Server 2003R2 x64 and TZ-fix for JRE. And later, when I had tried to import requestors from AD I had found that list of OU's is empty. It contains only "Users" OU.
Yesterday I had no problems with AD import process.
SD 8.0.0 build 8022.
I pressed to "import OU structure again"
Here is the log of today's OU scan:
[15:45:08:059]|[03-16-2012]|[com.adventnet.sqlone.search.dbcrawler.ejb.internal.DatabaseCrawler]|[INFO]|[24]|: Connection obtained for crawling the database <AppIndexingInfo CRID="171" APPLICATIONID="1" APPLICATIONNAME="ServiceDesk" APPDSNAME="default" MAXWORDSIZE="200" INDEXINGDELIMITERS=",:@-. (){}" ENABLEPARTIALSEARCH="true" ENABLEDYNAMICINDEXING="true" ENABLEINCREMENTALINDEXING="false" POPULATE_FK_REL="false" STATUS="0" />|
[15:45:11:996]|[03-16-2012]|[SYSOUT]|[INFO]|[23]|: user trying to view or import|
[15:45:12:105]|[03-16-2012]|[com.adventnet.sqlone.search.dbcrawler.ejb.internal.DatabaseCrawler]|[INFO]|[23]|: Connection obtained for crawling the database <AppIndexingInfo CRID="171" APPLICATIONID="1" APPLICATIONNAME="ServiceDesk" APPDSNAME="default" MAXWORDSIZE="200" INDEXINGDELIMITERS=",:@-. (){}" ENABLEPARTIALSEARCH="true" ENABLEDYNAMICINDEXING="true" ENABLEINCREMENTALINDEXING="false" POPULATE_FK_REL="false" STATUS="0" />|
[15:45:12:105]|[03-16-2012]|[com.adventnet.sqlone.search.dbcrawler.ejb.internal.DatabaseCrawler]|[INFO]|[23]|: Connection obtained for crawling the database <AppIndexingInfo CRID="171" APPLICATIONID="1" APPLICATIONNAME="ServiceDesk" APPDSNAME="default" MAXWORDSIZE="200" INDEXINGDELIMITERS=",:@-. (){}" ENABLEPARTIALSEARCH="true" ENABLEDYNAMICINDEXING="true" ENABLEINCREMENTALINDEXING="false" POPULATE_FK_REL="false" STATUS="0" />|
[15:45:12:215]|[03-16-2012]|[com.adventnet.servicedesk.setup.util.SDADMappingUtil]|[INFO]|[23]|: Successfully created the mapping props for domain id : 301|
[15:45:12:215]|[03-16-2012]|[com.adventnet.servicedesk.setup.action.ImportADUserAction]|[INFO]|[23]|: New mapping inserted to db|
[15:45:12:215]|[03-16-2012]|[SYSOUT]|[INFO]|[23]|: OU importing...|
[15:45:12:215]|[03-16-2012]|[SYSOUT]|[INFO]|[23]|: serverName : TLSDC|
[15:45:12:215]|[03-16-2012]|[SYSOUT]|[INFO]|[23]|: domainName : TLS|
[15:45:12:215]|[03-16-2012]|[com.adventnet.servicedesk.setup.action.ImportADUserAction]|[INFO]|[23]|: Domain to be saved : TLS|
[15:45:12:215]|[03-16-2012]|[com.adventnet.servicedesk.setup.action.ImportADUserAction]|[INFO]|[23]|: Domain data to be updated : <WritableDataObject>
<Tables>
[DomainInfo, DomainLoginInfo, PasswordInfo, SDActiveDirectoryInfo] </Tables>
SelectQuery Object:
Select columnNames=[DomainInfo.DOMAINID, DomainInfo.COMMENTS, DomainInfo.DOMAINNAME, DomainInfo.DISCOVERYSTATUS, DomainInfo.ISPUBLIC, SDActiveDirectoryInfo.AD_ID, SDActiveDirectoryInfo.DOMAIN_ID, SDActiveDirectoryInfo.SERVER_NAME, DomainLoginInfo.DOMAINID, DomainLoginInfo.DOMAINLOGINNAME, DomainLoginInfo.PASSWORDID, PasswordInfo.PASSWORDID, PasswordInfo.DOMAINPASSWORD]
Criteria=(DomainInfo.DOMAINNAME LIKE 'TLS')
Number of Objects=0
Starting row=1
Order by columnNames=[]
Table List=[DomainInfo AS DomainInfo, SDActiveDirectoryInfo AS SDActiveDirectoryInfo, DomainLoginInfo AS DomainLoginInfo, PasswordInfo AS PasswordInfo]
Joins= Join := DomainInfo AS DomainInfo LEFT JOIN SDActiveDirectoryInfo AS SDActiveDirectoryInfo ON DomainInfo.DOMAINID=SDActiveDirectoryInfo.DOMAIN_ID , Join := DomainInfo AS DomainInfo LEFT JOIN DomainLoginInfo AS DomainLoginInfo ON DomainInfo.DOMAINID=DomainLoginInfo.DOMAINID , Join := DomainLoginInfo AS DomainLoginInfo LEFT JOIN PasswordInfo AS PasswordInfo ON DomainLoginInfo.PASSWORDID=PasswordInfo.PASSWORDID
SetLock= false
<JoinsInDO>
Join := DomainInfo AS DomainInfo LEFT JOIN SDActiveDirectoryInfo AS SDActiveDirectoryInfo ON DomainInfo.DOMAINID=SDActiveDirectoryInfo.DOMAIN_ID
Join := DomainInfo AS DomainInfo LEFT JOIN DomainLoginInfo AS DomainLoginInfo ON DomainInfo.DOMAINID=DomainLoginInfo.DOMAINID
Join := DomainLoginInfo AS DomainLoginInfo LEFT JOIN PasswordInfo AS PasswordInfo ON DomainLoginInfo.PASSWORDID=PasswordInfo.PASSWORDID
</JoinsInDO>
<Operations>
</Operations>
<Rows>
<DomainInfo DOMAINID="301" DOMAINNAME="TLS" CANONICALNAME="null" DISCOVERYSTATUS="UNDISCOVERED" COMMENTS="null" LASTDISCOVEREDTIME="null" ISPUBLIC="true" />
<DomainLoginInfo DOMAINID="301" DOMAINLOGINNAME="alekseev" PASSWORDID="1" />
<PasswordInfo PASSWORDID="1" DOMAINPASSWORD="fvKK7QcL0917K65C" ALGORITHM="null" />
<SDActiveDirectoryInfo AD_ID="1" DOMAIN_ID="301" SERVER_NAME="TLSDC" USER_NAME="null" USER_PASSWORD="null" />
</Rows>
</WritableDataObject>
|
[15:45:12:215]|[03-16-2012]|[com.adventnet.sqlone.search.dbcrawler.ejb.internal.DatabaseCrawler]|[INFO]|[23]|: Connection obtained for crawling the database <AppIndexingInfo CRID="171" APPLICATIONID="1" APPLICATIONNAME="ServiceDesk" APPDSNAME="default" MAXWORDSIZE="200" INDEXINGDELIMITERS=",:@-. (){}" ENABLEPARTIALSEARCH="true" ENABLEDYNAMICINDEXING="true" ENABLEINCREMENTALINDEXING="false" POPULATE_FK_REL="false" STATUS="0" />|
[15:45:12:215]|[03-16-2012]|[com.adventnet.sqlone.search.dbcrawler.ejb.internal.DatabaseCrawler]|[INFO]|[23]|: Connection obtained for crawling the database <AppIndexingInfo CRID="171" APPLICATIONID="1" APPLICATIONNAME="ServiceDesk" APPDSNAME="default" MAXWORDSIZE="200" INDEXINGDELIMITERS=",:@-. (){}" ENABLEPARTIALSEARCH="true" ENABLEDYNAMICINDEXING="true" ENABLEINCREMENTALINDEXING="false" POPULATE_FK_REL="false" STATUS="0" />|
[15:45:12:215]|[03-16-2012]|[com.adventnet.servicedesk.security.Encoder]|[INFO]|[23]|: Deconvertor called.|
[15:45:12:590]|[03-16-2012]|[com.adventnet.servicedesk.servlet.AJaxServlet]|[INFO]|[23]|: AJaxServlet's doPost called ... |
[15:45:12:590]|[03-16-2012]|[com.adventnet.servicedesk.servlet.AJaxServlet]|[INFO]|[23]|: AjaxServlet - post reload - loggeduserid is 606|
[15:45:12:590]|[03-16-2012]|[com.adventnet.servicedesk.security.Encoder]|[INFO]|[23]|: Deconvertor called.|
[15:45:12:590]|[03-16-2012]|[com.adventnet.servicedesk.asset.OUHandler]|[INFO]|[23]|: Before start the transaction to import the ous.|
[15:45:12:590]|[03-16-2012]|[com.adventnet.servicedesk.asset.OUHandler]|[INFO]|[23]|: It is not first import, going to show the ous which was already exist in DB.|
[15:45:12:590]|[03-16-2012]|[com.adventnet.servicedesk.asset.OUHandler]|[INFO]|[23]|: Total time taken for constructOUList is 0 sec and 0 ms.|
[15:45:12:590]|[03-16-2012]|[com.adventnet.servicedesk.asset.OUHandler]|[INFO]|[23]|: After commit the transaction.|
[15:45:12:590]|[03-16-2012]|[com.adventnet.servicedesk.asset.OUHandler]|[INFO]|[23]|: @@@ total time in processOUInfo(..) : 0 seconds.|
I think that problem might be in this log's message: "[15:45:12:590]|[03-16-2012]|[com.adventnet.servicedesk.asset.OUHandler]|[INFO]|[23]|: It is not first import, going to show the ous which was already exist in DB.|