Resolve Error: Server Message RPC layer error nested exception

Use this article to resolve the following error users might receive when navigating to a workflow queue in Synergize Web Explorer if invalid character types were entered for a document field during indexing:

 

1. Log in to Microsoft SQL Server Management Studio.

   

2. Navigate to the database with the same name as the repository for the workflow.

   

3. Query the Main table using the SELECT statement below to identify the problematic entries:

   SELECT <column_name>,
   patindex('%[^ !-~]%' COLLATE Latin1_General_BIN, <column_name>) as [Position],
   substring(<column_name>,patindex('%[^ !-~]%' COLLATE Latin1_General_BIN,<column_name>),1) as [InvalidCharacter],
   ascii(substring(<column_name>,patindex('%[^ !-~]%' COLLATE Latin1_General_BIN,<column_name>),1)) as [ASCIICode]
   from <Database_Name>.[dbo].main
   where patindex('%[^ !-~]%' COLLATE Latin1_General_BIN,<column_name>) > 0 ;

    

   Tip: Problematic entries often occur in the probillnumber column.

    

4. Using the search results, record the problematic entry and form a query similar to below.

   SELECT * FROM [Database_Name].[dbo].[Main] WHERE <column_name> = '<Field Entry>';

    

5. Using the query record and In_DocID value, modify the invalid entries using an Update statement:

   Update [Database_Name].[dbo].[Main] set <Column_Name> = '<Correct Data>' WHERE in_docid = 'synxxxx';

    

6. Run the query from Step 3 and verify no rows are returned. Users will continue to see the error prompt when accessing the workflow until this occurs.