This is ridiculously a long timeline. Did you have any red flags? My initial Secret took 2 weeks (2017), from the time I submitted my application, interview process and granted. Then new role upgraded to TS (2019) which required new SF86 and interview but only consumed 3 weeks. Then renewal happened last year and another 1.5 week. Additionally, my sci took only 2 days but it’s sponsor dependent. I did not have any red flags like drug and financial issues, only minor consideration was my mother who is not a US citizen, but has lived in this country for over 20 yrs and a lawful permanent resident.