Symantec Workflow Solution - Missing end comment mark '*/'.

[Sebastian Famulski]

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

[Reto.Wintsch]

Hello, 

I had the same thing. 
You need to update your installation with the Workflow pointfix. This issue is solved in the pointfix. 

You find the pointfix here:
https://knowledge.broadcom.com/external/article/198337/cumulative-post-itms-85-ru4-point-fixes.html

Kind regards

------------------------------
Reto Wintsch
FYRE Consulting AG (Switzerland)
https://fyre-consulting.ch/
------------------------------

[Sebastian Famulski]

Thanks for your help and answer.

It's good to know that there are still companies that use the solution :)
Do you know when version 8.6 may be released?

Best regards,
Sebastian Famulski.​

------------------------------
Symantec Worfklow Developer (Poland)
------------------------------

[Reto.Wintsch]

Hi Sebastian, 

your welcome. 

To my last knowledge 8.6 was target for somewhere in the december timeframe. 

Best regards
Reto

------------------------------
Reto Wintsch
FYRE Consulting AG
https://fyre-consulting.ch/
------------------------------