Hi,
I recently upgraded the Symantec Workflow Solution from version 8.5.4230 to the latest version 8.5.5700.
I use database queues in my solution.
Every time I try to run the workflow process, I get the following error. It seems as if someone did not close the comment in a stored procedure or in some other SQL component. Please help.
Message :
process timeouts and escalations
System.Data.SqlClient.SqlException (0x80131904): Missing end comment mark '*/'.
Server stack trace:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at LogicBase.Core.Messaging.SqlExchange.CreateTables(String[] createDDL)
at LogicBase.Core.Messaging.SqlExchange..ctor(SqlExchangeConfiguration config, String name)
at LogicBase.Core.Messaging.SqlExchangeConfiguration.Create(String name)
at LogicBase.Core.Messaging.MessageExchangeFactory.CreateLocalTarget(String name, Boolean allowInternal)
at LogicBase.Core.Messaging.MessageExchangeFactory.TargetCache.GetOrCreateTarget(String name, Boolean allowInternal)
at LogicBase.Core.Messaging.MessageExchangeFactory.GetExchangeTarget(String name, Boolean allowInternal)
at LogicBase.Core.Messaging.AliasConfiguration.Create(String name)
at LogicBase.Core.Messaging.MessageExchangeFactory.CreateLocalTarget(String name, Boolean allowInternal)
at LogicBase.Core.Messaging.MessageExchangeFactory.TargetCache.GetOrCreateTarget(String name, Boolean allowInternal)
at LogicBase.Core.Messaging.MessageExchangeFactory.GetExchangeTarget(String name, Boolean allowInternal)
at LogicBase.Core.Messaging.MessageExchangeFactory.GetExchange(String name, Boolean allowInternal)
at LogicBase.Core.Messaging.Remoting.MessagingServer.GetList(String session, String exchangeName, ExchangeAttributeQuery[] attributes, MessageQueryType queryType)
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at LogicBase.Core.Messaging.Remoting.MessagingServer.GetList(String session, String exchangeName, ExchangeAttributeQuery[] attributes, MessageQueryType queryType)
at LogicBase.Core.Messaging.RemoteServerImpl.<>c__DisplayClass30.<GetList>b__2f()
at LogicBase.Framework.Utilities.RemotingHelper.<>c__DisplayClass1`1.<CallWithRetry>b__0()
at LogicBase.Framework.Utilities.RemotingHelper.CallWithRetry(Action func)
at LogicBase.Framework.Utilities.RemotingHelper.CallWithRetry[T](Func`1 func)
at LogicBase.Core.Models.Workflow.WorkflowServices.ProcessTimeoutsAndEscalationsCore()
ClientConnectionId:c866e2f1-03ea-492a-ac38-bcd79b570c41
Error Number:113,State:1,Class:15