Scenario: Sharepoint 2013 the entire environment is in English. The Chinese language pack is installed. When I created an English-language site, and then created a workflow with SharePoint design, the whole process works.
Problem: When I create a Chinese site and then create a workflow with SharePoint design, the overall process does not run and the following error is reported:
requestorid:84bfca0a-cef5-b2d6-0000-000000000000. Details:an unhandled exception occurred during the execution of the workflow instance. Exception Details:System.ApplicationException:HTTP {"error": {"code": "-2146232060, Microsoft.SharePoint.SPException "," message ": {" lang ":" ZH-CN "," Value ":" Exception from Hresult:0x80131904 "}}}
To view the log, you will find the following information:
W3wp.exe (0x0d18) 0x1e04 SharePoint Foundation Database 880i high System.Data.SqlClient.SqlException (0x80131904): Expression type int is not valid for the COLLATE clause.
Unknown SQL Exception 447 occurred. Additional error information from SQL Server is included below. Expression type int is not valid for the COLLATE clause.
ConnectionString: ' Data source=win-rqdf9p2cnn9;initial catalog=wss_content;integrated security=true; Enlist=false; Pooling=true; Min Pool size=0; Max Pool size=100; Connect timeout=15 ' partition:401174ad-bb2b-4f75-ba1d-e79c68ae7a63 connectionstate:closed connectiontimeout:15
SqlError: ' expression type int is not valid for the COLLATE clause. ' Source: '. Net SqlClient Data Provider ' number:447 state:0 class:16 Procedure: ' linenumber:1 Server: ' win-rqdf9p 2cnn9 '
Proxy Response returned error: ' The remote server returned a fault: (500) Internal server error. '
Blog: http://bbs.csdn.net/topics/390936396 and my mistakes are basically the same. He mentions the problem of database rule ordering. But there is no mention of how it is solved?
And I doubt if the problem is resolved by modifying the database rules. So if I later I created an English site, this time the workflow is not also related issues?
Or is there any other solution? The great gods we want to see offer some solutions.
Sharepoint Workflow (Chinese and English)