Question

Unable to connect to k2 on port 5252.

  • 23 August 2020
  • 1 reply
  • 83 views

Badge +3

I am running into "Unable to connect to k2.columbia.csc on port 5252. No connection could be made because the target machine actively refused it."

I have checked the K2 Service on the K2 server and it is running, i have even restarted it several times but still nothing.  

I looked in the host server logs and see a bunch of SQL deadlocks.  

 

We are currently on 4.6.9, i know it is out of support but just looking to this thing up and running again.  Is the deadlocks the cause of the unable to connect message?

 

Errors from the log.

 

"407641441","20*personal details removed*:58:11","Error","General","1","GeneralErrorMessage","K2Sql.Log","1 Transaction (Process ID 71) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at SourceCode.Workflow.Runtime.K2Sql.Log(Int32 id, Int32 pid, ArchiveX ar)","","","US-P-K2-APP1:d:Program Files (x86)K2 blackpearlHost ServerBin","407641441","9627a91e38e64566aced61538cf4408e",""
"407641442","20*personal details removed*:58:14","Error","General","1","GeneralErrorMessage","K2Sql.Log","1 Transaction (Process ID 68) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at SourceCode.Workflow.Runtime.K2Sql.Log(Int32 id, Int32 pid, ArchiveX ar)","","","US-P-K2-APP1:d:Program Files (x86)K2 blackpearlHost ServerBin","407641442","9917f73a527445e4bc5da54326976e71",""
"407641443","20*personal details removed*:58:15","Error","General","1","GeneralErrorMessage","K2Sql.Log","1 Transaction (Process ID 67) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at SourceCode.Workflow.Runtime.K2Sql.Log(Int32 id, Int32 pid, ArchiveX ar)","","","US-P-K2-APP1:d:Program Files (x86)K2 blackpearlHost ServerBin","407641443","8d94756b69be4882af52740e00361eb9",""
"407641444","20*personal details removed*:58:16","Error","General","1","GeneralErrorMessage","K2Sql.Log","1 Transaction (Process ID 71) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at SourceCode.Workflow.Runtime.K2Sql.Log(Int32 id, Int32 pid, ArchiveX ar)","","","US-P-K2-APP1:d:Program Files (x86)K2 blackpearlHost ServerBin","407641444","1661355fb9884db984ce271feb79327b",""
"407641445","20*personal details removed*:58:16","Error","General","1","GeneralErrorMessage","K2Sql.Log","1 Transaction (Process ID 68) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at SourceCode.Workflow.Runtime.K2Sql.Log(Int32 id, Int32 pid, ArchiveX ar)","","","US-P-K2-APP1:d:Program Files (x86)K2 blackpearlHost ServerBin","407641445","96387a44b59b4c3781a8926bb1fc57c2",""
"407641446","20*personal details removed*:58:16","Error","General","1","GeneralErrorMessage","K2Sql.Log","1 Transaction (Process ID 67) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at SourceCode.Workflow.Runtime.K2Sql.Log(Int32 id, Int32 pid, ArchiveX ar)","","","US-P-K2-APP1:d:Program Files (x86)K2 blackpearlHost ServerBin","407641446","1a961ff085e2425cb821fee0444787ec",""
"407641447","20*personal details removed*:58:16","Error","General","1","GeneralErrorMessage","K2LogServer.LogProcInst","1 24129 A database error occurred : Transaction (Process ID 67) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at SourceCode.Logging.Logger.ThrowLogMessage(MessageObject LogMessageObj)
at SourceCode.Logging.Logger.ThrowLogMessage(String MessageSource, Int64 MessageID, String[] MessageParameters)
at SourceCode.Workflow.Runtime.K2Sql.Log(Int32 id, Int32 pid, ArchiveX ar)
at SourceCode.Workflow.Runtime.K2LogServer.LogProcInst(Object state)","","","US-P-K2-APP1:d:Program Files (x86)K2 blackpearlHost ServerBin","407641447","9a0e817643824b42bde6893fae22e058",""
"407641448","20*personal details removed*:58:16","Error","General","1","GeneralErrorMessage","K2Sql.Log","1 Transaction (Process ID 71) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at SourceCode.Workflow.Runtime.K2Sql.Log(Int32 id, Int32 pid, ArchiveX ar)","","","US-P-K2-APP1:d:Program Files (x86)K2 blackpearlHost ServerBin","407641448","225adfdee6d14c09ad4bdb0467830af9",""
"407641449","20*personal details removed*:58:16","Error","General","1","GeneralErrorMessage","K2LogServer.LogProcInst","1 24129 A database error occurred : Transaction (Process ID 71) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at SourceCode.Logging.Logger.ThrowLogMessage(MessageObject LogMessageObj)
at SourceCode.Logging.Logger.ThrowLogMessage(String MessageSource, Int64 MessageID, String[] MessageParameters)
at SourceCode.Workflow.Runtime.K2Sql.Log(Int32 id, Int32 pid, ArchiveX ar)
at SourceCode.Workflow.Runtime.K2LogServer.LogProcInst(Object state)","","","US-P-K2-APP1:d:Program Files (x86)K2 blackpearlHost ServerBin","407641449","182ab68b51c243a3b7d7275f33735352",""
"407641450","20*personal details removed*:58:17","Error","General","1","GeneralErrorMessage","K2Sql.Log","1 Transaction (Process ID 68) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at SourceCode.Workflow.Runtime.K2Sql.Log(Int32 id, Int32 pid, ArchiveX ar)","","","US-P-K2-APP1:d:Program Files (x86)K2 blackpearlHost ServerBin","407641450","69d02ce1584542a7b47b28e25fa067c9",""
"407641451","20*personal details removed*:58:17","Error","General","1","GeneralErrorMessage","K2LogServer.LogProcInst","1 24129 A database error occurred : Transaction (Process ID 68) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at SourceCode.Logging.Logger.ThrowLogMessage(MessageObject LogMessageObj)
at SourceCode.Logging.Logger.ThrowLogMessage(String MessageSource, Int64 MessageID, String[] MessageParameters)
at SourceCode.Workflow.Runtime.K2Sql.Log(Int32 id, Int32 pid, ArchiveX ar)
at SourceCode.Workflow.Runtime.K2LogServer.LogProcInst(Object state)","","","US-P-K2-APP1:d:Program Files (x86)K2 blackpearlHost ServerBin","407641451","b2cfeb6dfa174a25911d7dd0ed985cd2",""
"407641452","20*personal details removed*:58:17","Error","General","1","GeneralErrorMessage","K2Sql.Log","1 String or binary data would be truncated.
The statement has been terminated.


1 reply

Badge +6

DannyH,

 

For you K2 version, this issue could be due to lot of records in table  [Server].[DestQueueUser] .

You can see a summary of this table with this query:

 

select distinct [User],[QueueId],COUNT(*) AS "Count"
from [Server].[DestQueueUser]
GROUP BY [User],[QueueId]
HAVING COUNT(*)>1
order by 3 desc

 

 

But in all cases, it's not supported to modify by yourself the K2 database and your K2 version is not supported.
Did you planned to upgrade soon?

 

Best regards,

Olivier Chatagnon

Reply