Good Question...

I am dam sure about this ALL SPS/INDEX/VIEW/TRIGG/ and so on are same (Prod/Test)

If i ran Same SP without any changes on Prod giving me Error and On test No Problem.

I change or comment out one Not Null Syntax on Production and its working fine....

To be honest i have no clue what's going on 🙂