none
DATA SYNC SERVICE FAILS ALWAYS FOR LARGE TABLES?

    Question

  • we are using Data sync agent since last 4 months.we had so many issues and got support for the same but still not been able to consume this service to achieve the desired results.

    we have this table with 1.38Cr. records,it is getting failed with following exceptions each time in order-

    1.)Sync failed with the exception "GetStatus failed with exception:
    SqlException Error Code: -2146232060 - SqlError Number:20, Message: The instance of SQL Server you attempted to connect to does not support encryption. "For more information, provide tracing id ‘7ba9caff-c9d5-44c3-8f85-32e5ba0f9adb’ to customer support. 2.)

    Sync failed with the exception "An unexpected error occurred when applying batch file C:\Users\Deepak\AppData\Local\Temp\DSS_syncjobwqnavkduuk1yfst3y3oece2p\286e6ca2-e7d2-463e-ac27-ab726ab7df20.batch. See the inner exception for more details.
    Inner exception: SqlException Error Code: -2146232060 - SqlError Number:4060, Message: Cannot open database requested by the login. The login failed. SqlError Number:18456, Message: Login failed.
    For more information, provide tracing id ‘c2f106f2-9fc3-407d-b3e9-028fa8adf9c8’ to customer support.

    3.)Sync failed with the exception "An unexpected error occurred when applying batch file C:\Users\Deepak\AppData\Local\Temp\DSS_syncjobdqxumavgprmkyfpdzz03chgr\b51fb90f-bb9f-4cb1-a26c-ed65ebd2b959.batch. See the inner exception for more details.
    Inner exception: SqlException Error Code: -2146232060 - SqlError Number:53, Message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
    "For more information, provide tracing id ‘90671e56-ef50-45b6-9f13-b1383ed85f49’ to customer support.

    4.)Sync failed with the exception "An unexpected error occurred when applying batch file C:\Users\Deepak\AppData\Local\Temp\DSS_syncjobzjluah2m0i4a5u2nqz3qxqyd\b6d2b7e9-04d3-4fa7-a34a-d1c2c8c4d334.batch. See the inner exception for more details.
    Inner exception: Failed to execute the command 'InsertCommand' for table 'WEALTHMAKER_MF.TRANSACTION_ST'; the transaction was rolled back. Ensure that the command syntax is correct.
    Inner exception: SqlException Error Code: -2146232060 - SqlError Number:0, Message: A severe error occurred on the current command.  The results, if any, should be discarded. SqlError Number:0, Message: A severe error occurred on the current command.  The results, if any, should be discarded.
    "For more information, provide tracing id ‘cbb6ac3e-b666-4d84-880f-c2a551933c54’ to customer support.         ANY SOLUTIONS????                                                                                                                                

    Friday, May 25, 2012 7:07 AM