When a SQL Server Database maintenance plan is implemented that includes the rebuilding of indexes and other job for updating statistics jobs get blocked by the locks created by the Content Migrator Timer Job. And no externalization can be performed or takes long time to externalize content.
1. Check that profiles and jobs are setup correctly, that Endpoints are accessible with the accounts used for Service stp.
2. Do a manual externalization of single file manually. If the operation finish correctly retract manually the file and perform a second externalization of the same file.
3. A error message will show up: On the pop-window for externalization, a top error will indicate this BLOB (or any of its versions) cannot be externalized.
Error: "Detail: Missing suitable target endpoint (hint: try to reconsider StoragePoint profile Endpoint settings".
4. Open the ULS logs and check for these 2 errors:
Error: "unable to insert/update migrate queue item....Execution Time out expired".
Error: The sql.client.command says that "Boolean Async, int32 time out" for the profile where the manual externalization has performed.
5. As the DBA to confirm is its running a rebuild index job, and check to see if the jobs are running. It might be part of a maintenance plan at the SQL server level.
6. If it is running a rebuild index job, ask the DBA to stop the rebuild index job, and also if it has a job that updates statistics job for the Storagepoint Database.
7. Do a manual externalization and it should work back correctly.
© ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center