The 6 months is just a disclaimer from the manufacturer the same as other products like cookies.
Now I don't know about you guys but I did eat some cookies that were months over date (still closed ofcourse) without problem.
For pro application they just toss the stuff after the shelfdate since if there is a problem with one jar of 500g paste you are talking about $100k or more products that can be scrapped, not an option for a paste jar worth $40.-
For us hobbieists, I use paste that is one and a half year old kept in the fridge which has the same result as my new jar I bought a few weeks back just to be sure.
If you want to add something to get the paste a bit jucier don't add the flux but the solvent, AFAIK plain IPA is the best to use, very little bit is necessary otherwise the paste becomes too juicy and runs.
@TS: do you try at least to imitate the reflow profile, so start with ramping up to 160oC and stay there for almost a minute then rampup to 230oC for 20 seconds and let it cool? Or are you blasting 230oC right away for 40 seconds and stop, I would suspect that this might be an issue. The paste has a wetting phase were the flux becomes active and than starts to evaporate in that process the balls are coming together again.
Another cause could be the pcb it self, do you have made your own pcb or professional pcb with solder mask? The soldermask helps keeping the melting solderpaste at its place.
If nothing helps and you want to continue just use a solderiron and do it pin for pin, works great but takes a lot of time.