none
Exchange pst capture tool RRS feed

  • Question

  • Hi All,

    I installed the tool and I am now trying my first .pst imports, I am able to search and find .pst files and create an import list without issue.

    For some reason I am unable to set a destination mailbox, when I click on the option to "Set Mailbox..." I get the following error:

    While trying to retrieve mailboxes, an error occurred in the Central Service. For Details, lookath the Central Service log files in C:\ProgramData\Microsoft\Exchange\PST Capture\Logs.

    The location in the error does not exsist but I did find this in the application logs:

    EVENT ID: 32

    CentralService
    Error occured in get mailbox update check
    System.InvalidCastException: Specified cast is not valid.
       at System.Data.SQLite.SQLiteDataReader.VerifyType(Int32 i, DbType typ)
       at System.Data.SQLite.SQLiteDataReader.GetString(Int32 i)
       at RedGate.PSTImporterForExchange.Engine.Repository.DbMailbox.GetMailboxes(Boolean is365)
       at RedGate.PSTImporterForExchange.Engine.Repository.RepositoryMailbox.GetMailboxes(Boolean is365)
       at RedGate.PSTImporterForExchange.CentralService.PstCentralService.DoADPoll(Object state)

    Any help would be appreciated

    Thanks

    Adam


    Adam

    Wednesday, February 22, 2012 4:33 PM

All replies

  • hi,

    Which account do you use to do this action?

    The account should have correct permission to do it.

    You can see this link:http://technet.microsoft.com/en-us/library/hh781035.aspx

    I have done a test for you,and i can do successful.

    hope can help you

    thanks,


    CastinLu

    TechNet Community Support

    Thursday, February 23, 2012 8:11 AM
  •  

    Thanks Castinlu.

    I have double checked and all the permissions required have been set, it's still not working.

    The event error I mentioned in the opening post is happening 6 to 9 times every second! :(

    Any further suggestions?

    Does anyone know if you can enable extended logging for this tool, the logs folder mentioned in the error does not even exist?


    Adam

    Thursday, February 23, 2012 5:30 PM
  • HI,

    If can,can you reinstall the pst capture.

    Please follow this link to install:http://technet.microsoft.com/en-us/library/hh781036.aspx

    Make sure that meet all requierments.

    See if the issue is still occured.

    thanks,


    CastinLu

    TechNet Community Support


    • Edited by Castinlu Friday, February 24, 2012 2:13 AM
    Friday, February 24, 2012 2:11 AM
  • Hi,

    I have already tried a re-install but it's still not working :(

    I guess the next step is to try another machine.

    Thanks

    Adam


    Adam

    Friday, February 24, 2012 1:12 PM
  • hi,

    How about your issue now?

    Have you fix it by install the tool on another machine?

    Any update?

    thanks,


    CastinLu

    TechNet Community Support

    Monday, February 27, 2012 1:16 AM
  • Hi,

    I have now tried a second machine and it still does not work?? :(

    Same problem so I guess it has something to do with Exchange or AD config's but I have no idea where to start.

    Thanks


    Adam


    Adam

    Monday, February 27, 2012 2:03 PM
  • The ProgramData folder exists but is hidden.  Have you set Explorer to view hidden folders and files?  There is quite extensive logging available under there.

    Jason

    Monday, February 27, 2012 3:25 PM
  • Thanks Jason....Can't believe I didn't check that! :(

    I have looked into the log file and it would seem that tool is trying to use the wrong DC, I am currently running this tool in a child domain.

    For some reason the tool is trying to use the root domain DC's, is there a way to change this behavour?

    Thanks

    Adam


    Adam

    Monday, February 27, 2012 3:57 PM
  • Do you have any global catalog servers in the child domain?

    Tuesday, February 28, 2012 1:01 PM
  • Hi Jason,

    Yes all the DC's in the child domain are GC's, even the one that is located in the same site as the Exchange servers and capture tool.

    Thanks


    Adam


    Adam

    Tuesday, February 28, 2012 3:48 PM
  • Any update on this issue I am having the exact same problem.
    Thursday, June 14, 2012 12:35 AM
  • Hi Ted,

    The problem I have is that the capture tool is attempting to use a DC in the root domain I raised a support call with Microsoft to see if I can specify a child DC for the tool to use.

    The answer was no but they did supplied the following workaround, the goals in my project have changed somewhat I had no reason to pursue the use of the tool so I am not sure if it works. You might like to try their suggestion:

    The PST Capture tool generates a list of Domain Controllers, and generally uses the first one in the list.

    What you can try is to use a work around with the HOSTS file on your PST Capture server.

    If you put the HOST name for the Domain Controllers you don’t wish the PST Capture Tool to use (root DC's), and use an invalid IP Address, the tool will mark them as unavailable and therefore choose the next server in the list

    This may enable you to use the tool.

    Let us know if this works?

    Thanks

    Adam


    Adam

    Thursday, June 14, 2012 10:23 AM
  • ajsmithy,t

    I tried your suggestion and I was able to get it to use a DC on the same subnet instead of one 4000 miles away.

    But the issue remains, I am unable to get a list of destination mailboxes.

    getting this error

    09:12:10.453|Error  |CentralService      |4  |Error occured in get mailbox update check
    System.InvalidCastException: Specified cast is not valid.
       at System.Data.SQLite.SQLiteDataReader.VerifyType(Int32 i, DbType typ)
       at System.Data.SQLite.SQLiteDataReader.GetString(Int32 i)
       at RedGate.PSTImporterForExchange.Engine.Repository.DbMailbox.GetMailboxes(Boolean is365)
       at RedGate.PSTImporterForExchange.Engine.Repository.RepositoryMailbox.GetMailboxes(Boolean is365)
       at RedGate.PSTImporterForExchange.CentralService.PstCentralService.DoADPoll(Object state)

    This looks good.

    9:07:02.601|Verbose|Active Directory    |4  |Creating Exchange hierarchy provider
    09:07:02.616|Verbose|AdoDb               |4  |SELECT cn FROM 'LDAP://lou-domaincontroler2.mydomain.local/CN=Schema,CN=Configuration,DC=mydomain,DC=local' WHERE lDAPDisplayName='msExchMDBAvailabilityGroupLink'
    09:07:02.632|Verbose|AdoDb               |4  |SELECT distinguishedName, networkAddress, serialNumber, msExchMDBAvailabilityGroupLink, msExchServerSite, msExchCurrentServerRoles FROM 'LDAP://mydomain.local/CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=mydomain,DC=local' WHERE objectClass='msExchExchangeServer' AND serverRole=0
    09:07:02.789|Verbose|AdoDb               |9  |SELECT nCName, nETBIOSName FROM 'LDAP://lou-domaincontroler2.mydomain.local/CN=Partitions,CN=Configuration,DC=mydomain,DC=local' WHERE systemFlags=3
    09:07:02.789|Verbose|AdoDb               |9  |SELECT distinguishedName, mail, msExchMailboxGuid, msExchArchiveGuid, legacyExchangeDN, sAMAccountName, homeMDB, name, msExchResourceCapacity, msExchResourceDisplay, msExchResourceMetaData, msExchResourceSearchProperties  FROM 'LDAP://lou-domaincontroler2.mydomain.local/DC=mydomain,DC=local' WHERE msExchHideFromAddressLists<>TRUE AND objectClass='Person'
    09:07:02.805|Debug  |DBComputer          |10 |SetStatus - Agent of BOSMIAJT02 sent state  NotStarted
    09:07:02.884|Verbose|AdoDb               |4  |SELECT distinguishedName, name FROM 'LDAP://mydomain.local/CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=mydomain,DC=local' WHERE objectClass='msExchMDBAvailabilityGroup'
    09:07:03.025|Trace  |AD                  |4  |AsyncUpdatedObject update forced
    09:07:03.025|Verbose|Active Directory    |4  |Creating managed Exchange server hostnames
    09:07:03.041|Verbose|Active Directory    |4  |Creating AD hierarchy provider
    09:07:03.041|Verbose|Active Directory    |4  |Finished creating Active Directory Service
    09:07:03.056|Verbose|AD                  |4  |GetExchangeServerHostnames() returns:
        GENDAG01

    09:07:03.056|Verbose|ExchangeHierarchy   |4  |GetDatabases for Exchange: GENDAG01
    09:07:03.198|Trace  |Listener            |5  |Accepted incoming connection from 192.168.241.196:64826
    09:07:03.276|Verbose|AdoDb               |3  |SELECT distinguishedName FROM 'LDAP://lou-domaincontroler2.mydomain.local/CN=Configuration,DC=mydomain,DC=local' WHERE objectClass='msExchOrganizationContainer'
    09:07:03.323|Verbose|AdoDb               |3  |SELECT cn, distinguishedName FROM 'LDAP://lou-domaincontroler2.mydomain.local/CN=Databases,CN=Exchange Administrative Group (FYDIBOHF23SPDLT),CN=Administrative Groups,CN=mydomain,CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=mydomain,DC=local' WHERE objectClass='msExchPrivateMDB' AND msExchMasterServerOrAvailabilityGroup='CN=GENDAG01,CN=Database Availability Groups,CN=Exchange Administrative Group \28FYDIBOHF23SPDLT\29,CN=Administrative Groups,CN=mydomain,CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=mydomain,DC=local'
    09:07:03.386|Trace  |Listener            |5  |Accepted incoming connection from 172.24.1.77:4926
    09:07:03.402|Verbose|AdoDb               |3  |SELECT msExchHostServerLink FROM 'LDAP://lou-domaincontroler2.mydomain.local/CN=OnlineArchive,CN=Databases,CN=Exchange Administrative Group (FYDIBOHF23SPDLT),CN=Administrative Groups,CN=mydomain,CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=mydomain,DC=local' WHERE objectClass='msExchMDBCopy'
    09:07:03.418|Verbose|AdoDb               |3  |SELECT msExchHostServerLink FROM 'LDAP://lou-domaincontroler2.mydomain.local/CN=High,CN=Databases,CN=Exchange Administrative Group (FYDIBOHF23SPDLT),CN=Administrative Groups,CN=mydomain,CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=mydomain,DC=local' WHERE objectClass='msExchMDBCopy'
    09:07:03.418|Verbose|AdoDb               |3  |SELECT msExchHostServerLink FROM 'LDAP://lou-domaincontroler2.mydomain.local/CN=Mid,CN=Databases,CN=Exchange Administrative Group (FYDIBOHF23SPDLT),CN=Administrative Groups,CN=mydomain,CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=mydomain,DC=local' WHERE objectClass='msExchMDBCopy'
    09:07:03.433|Verbose|AdoDb               |3  |SELECT msExchHostServerLink FROM 'LDAP://lou-domaincontroler2.mydomain.local/CN=STD,CN=Databases,CN=Exchange Administrative Group (FYDIBOHF23SPDLT),CN=Administrative Groups,CN=mydomain,CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=mydomain,DC=local' WHERE objectClass='msExchMDBCopy'
    09:07:03.433|Verbose|AdoDb               |3  |SELECT msExchHostServerLink FROM 'LDAP://lou-domaincontroler2.mydomain.local/CN=Infra,CN=Databases,CN=Exchange Administrative Group (FYDIBOHF23SPDLT),CN=Administrative Groups,CN=mydomain,CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=mydomain,DC=local' WHERE objectClass='msExchMDBCopy'

    • Edited by Ted Laun Thursday, June 14, 2012 1:21 PM
    Thursday, June 14, 2012 1:13 PM
  • I should mention this was working fine about a month ago.
    Thursday, June 14, 2012 1:29 PM
  • I just did a complete uninstall reinstall including removing the files in ProgramData and Program Files.
    Thursday, June 14, 2012 3:04 PM
  • And? Did that end up resolving your issue?

    Phluxed

    Tuesday, July 3, 2012 12:37 PM
  • Still not working.
    Friday, July 6, 2012 6:12 PM
  • Did you ever find the fix?

    I'm running into the exact same issue - the tool worked great for 4+ months and recently it stopped working.  The only change I could think of are security patches on the domain controllers.
    Would hate to use PS script as this tool was a real time saver especially for large quantity of PSTs.

    Thursday, July 19, 2012 8:11 PM
  • I've come up with a workaround.  It's not ideal but I think still beats resorting to PS scripts.

    Download this tool - "SQLite Database Browser" from SorceForge http://sourceforge.net/projects/sqlitedbrowser/ 

    Stop the central service (aka. Microsoft Exchange PST Capture Service) to prevent database from updating dynamically from agents.

    Then use SQLite browser to open c:\programdata\microsoft\exchange\pst capture\data .  The table that you can modify to populate the target mailbox/SMTP address is "pst_import_files" .

    Save changes and then in PST Capture close and re-load the import list and the target mailbox is now populated!  If you're in a large environment like ours this may actually be faster than the browse and select method (e.g. when it was working) as that takes time to come up - browse - select.

    Will

    Tuesday, July 31, 2012 9:25 PM
  • One more thing - the "import status" value should be changed from a 0 to 1
    Tuesday, July 31, 2012 9:37 PM
    • The issue for me was when I click on "set mailbox" , the PST Capture tool craps out and does not allow me to select from a listing of mailboxes the way it used to. We already have a listing of users and their SMTP addresses from csvde export from a domain controller.

      To get around it:

      1. download SQLite Database browser

      2. stop Microsoft Exchange PST Capture service

      3. Open the database file in c:\programdata\microsoft\exchange\PST Capture\data with SQLite Database browser

      4. Add the file to the import list as you would previously.

      5. to set mailbox, use SQLite Database browser, go to Browse Data, then "pst_import_list" table to lookup the list "ID" for the import list in question.

      6. go to "pst_import_files" table then scroll to the import list ID (typically at bottom if a new list), then you'll see entries without target mailbox -- those would be the files you've just added to the list.

      7. Change "import status" to 1 , change "target mailbox" to the SMTP address of the mailbox. Make sure there are no spaces or returns after the SMTP address.

      8. Save database

      9. within few seconds, you'll see PST Capture update its GUI reflecting the target mailbox.

      10. Once all done and ready to import, make sure you start the PST Capture service in services applet.

      Hope this work for you.

      Will

    • Proposed as answer by AndrewWilsonSI Thursday, October 10, 2013 3:03 PM
    Friday, August 3, 2012 8:46 PM
  • Check AD Sites and Services for a list of your DC's in your site.

    Use LDP tool to connect and bind to each DC. This will prove connectivity.

    I believe the PST Capture service will connect to the DC's in alphabetical order.

    Restart the PST Capture service and watch Resource Monitor > Network Tab > Processes with Network Actvity and watch it PSTCapture thread try to connect to all your DC's. You should see what DC's are reachable and which are not.


    * Blackberry Certified Support Specialist * Blackberry Certified Server Administrator * Blackberry Certified Server Support Specialist * Comptia A+ * Comptia Linux + * Comptia Network + * MCITP - Enterprise Support Technician * MCITP - Enterprise Desktop Administrator 7 * MCITP - Server Administrator * MCITP - Enterprise Messaging Administrator * MCTS - 70-620 - TS: Configuring Microsoft Windows Vista Client * MCTS - 70-622 - PRO: Supporting and Troubleshooting Applications on a Windows Vista Client for Enterprise Support Technicians * MCTS - 70-685 - Windows 7 Enterprise Desktop Support Technician * MCTS - 70-686 - Windows 7 Enterprise Desktop Administration * MCTS - 70-432 - Microsoft SQL Server 2008, Implementation and Maintenance * MCTS - 70-640 - Windows Server 2008 Active Directory Configuration * MCTS - 70-642 - Windows Server 2008 Network Infrastructure Configuration * MCTS - 70-643 - Windows Server 2008 Applications Infrastructure Configuration * MCTS - 70-646 - Windows Server 2008

    Friday, September 21, 2012 3:30 PM
  • PERFECT! I have been banging my head against a wall with this for ages. The Central Capture service has connectivity so rarely and so briefly for me that it has been almost impossible to get the process started. This bypasses the need for that service. Here are some tags for Googlers:

    Fix for No mailboxes found for Exchange Online

    Fix for The central service is retrieving the mailbox data

    Thursday, October 10, 2013 3:08 PM