locked
The communication object, System.ServiceModel.Channels.ServiceChannel RRS feed

  • Question

  • Hi All.

    Can somebody explain why we get this kind of exception during data syncing from one server to other server. 

    "The communication object, System.ServiceModel.Channels.ServiceChannel, cannot be used for communication because it is in the Faulted state."

    Tuesday, November 20, 2012 3:43 PM

Answers

  • I got the solution to this after working hard for 1 week, its very simple mistake i did while creating scope for the table, In server database i have created scope for a table called " Patient" as "Patient"( First letter of the table is in capital letter) but in client database i created like "pateint" ( First letter of the table is in small letter), so i removed scope in the client data base and re-created the scope as in server database.

    scripts for droping scope for a table :


    delete  from scope_info where scope_config_id = (
    select template_config_id from scope_templates where template_name like 'Pateint')

    delete from scope_parameters Where sync_scope_name =  'Pateint' + 
    cast((select top 1 ownerorganisationuid from Patient order by UID desc) as nvarchar)

    delete from scope_templates where template_name like 'Pateint'

    DROP PROCEDURE [dbo].[Pateint_bulkdelete]
    GO
    DROP PROCEDURE [dbo].[Pateint_bulkinsert]
    GO
    DROP PROCEDURE [dbo].[Pateint_bulkupdate]
    GO
    DROP PROCEDURE [dbo].[Pateint_delete]
    GO
    DROP PROCEDURE [dbo].[Pateint_insert]
    GO
    DROP PROCEDURE [dbo].[Pateint_selectchanges]
    GO
    DROP PROCEDURE [dbo].[Pateint_selectrow]
    GO
    DROP PROCEDURE [dbo].[Pateint_update]
    GO
    DROP PROCEDURE [dbo].[Pateint_updatemetadata]
    GO
    DROP PROCEDURE [dbo].[Pateint_insertmetadata]
    GO
    DROP PROCEDURE [dbo].[Pateint_deletemetadata]
    GO
    DROP TYPE [dbo].[Pateint_BulkType]
    GO

    Wednesday, December 12, 2012 2:56 PM

All replies

  • Can you post the part of the code that this error occurs in. You can also check the following post for help:

    http://stackoverflow.com/questions/2763592/the-communication-object-system-servicemodel-channels-servicechannel-cannot-be

     
    Wednesday, November 21, 2012 7:10 PM
  • I got the solution to this after working hard for 1 week, its very simple mistake i did while creating scope for the table, In server database i have created scope for a table called " Patient" as "Patient"( First letter of the table is in capital letter) but in client database i created like "pateint" ( First letter of the table is in small letter), so i removed scope in the client data base and re-created the scope as in server database.

    scripts for droping scope for a table :


    delete  from scope_info where scope_config_id = (
    select template_config_id from scope_templates where template_name like 'Pateint')

    delete from scope_parameters Where sync_scope_name =  'Pateint' + 
    cast((select top 1 ownerorganisationuid from Patient order by UID desc) as nvarchar)

    delete from scope_templates where template_name like 'Pateint'

    DROP PROCEDURE [dbo].[Pateint_bulkdelete]
    GO
    DROP PROCEDURE [dbo].[Pateint_bulkinsert]
    GO
    DROP PROCEDURE [dbo].[Pateint_bulkupdate]
    GO
    DROP PROCEDURE [dbo].[Pateint_delete]
    GO
    DROP PROCEDURE [dbo].[Pateint_insert]
    GO
    DROP PROCEDURE [dbo].[Pateint_selectchanges]
    GO
    DROP PROCEDURE [dbo].[Pateint_selectrow]
    GO
    DROP PROCEDURE [dbo].[Pateint_update]
    GO
    DROP PROCEDURE [dbo].[Pateint_updatemetadata]
    GO
    DROP PROCEDURE [dbo].[Pateint_insertmetadata]
    GO
    DROP PROCEDURE [dbo].[Pateint_deletemetadata]
    GO
    DROP TYPE [dbo].[Pateint_BulkType]
    GO

    Wednesday, December 12, 2012 2:56 PM