Hi I am hoping someone can help with fixing an issue I believe is with the SQL database for CA
we are currently running CA ITCM 12.8.1 and over the last few days all our software delivery jobs have failed either with timeout for activation has been reached or with DTS Error: dts error
upon investigating I found that in the logs for DTSTOS is it constantly writing to the SQL database the same information just in new rows,
171018-08:29:25.7776488L|016060|000011e4|dtstos |CDb |CDb.cpp |000520|DETAIL | Execute SQL Script command pointer
171018-08:29:25.7776699L|016060|000011e4|dtstos |DbImpl_Ado |DbImpl_Ado.cpp |000610|DETAIL | Execute command pointer
171018-08:29:25.7777447L|016060|000011e4|dtstos |CmdPtreImpl_Ado |CmdPtreImpl_Ado.cpp |001113|DETAIL | ExecuteCommandPointer sql: INSERT INTO dts_torproperties (object_id, row_num, object_data) VALUES(132641,23712779,?)
171018-08:29:25.7777875L|016060|000011e4|dtstos |CmdPtreImpl_Ado |CmdPtreImpl_Ado.cpp |001127|DETAIL | ExecuteCommandPointer sqlwparam: INSERT INTO dts_torproperties (object_id, row_num, object_data) VALUES(132641,23712779,'')
171018-08:29:25.7786717L|016060|000011e4|dtstos |CDb |CDb.cpp |001120|DETAIL | Destroy a Command pointer
171018-08:29:25.7786979L|016060|000011e4|dtstos |DbImpl_Ado |DbImpl_Ado.cpp |002838|DETAIL | Destroy Command Pointer
this appears to cause all software delivery that requires DTS to stall.
I have killed the DTSTOS process and removed all software delivery jobs and restarted the service which has stopped it writing to the database but has caused the database to rollback that transaction which appear it will take hours.
This dts_torproperties table contains about 23 millions rows where as a couple of months ago only contained 200
the only thing that has really changed is we added 600 scalability servers due to the numerous locations of the agents and the speed of the networks.
what i'm asking is if someone can point me in a direction to resolving this issue I am having with DTS, maybe if I can find out what object_id 132641 is.
any help would be much appreciated.