SQL job failing only on particular instances

SQL job failing only on particular instances

We have an application ,where the session data of the application is
stored in a table, from that table we have a SQL job which places the
above data in one more table segregating it more meaningfully.
When we created the job ,the job passed in DEV environment and TEST ,but
when we implemented the job in production and stage, the job is failing
with below error.
Conversion failed when converting date and/or time from character string
We tried restoring the DB to some other instance other than where the
application DB resides and the SQL job is completing successfully. The Job
is failing only in the instance where application DB resides.
Steps what we tried: We tried comparing the SQL configuration of the
instances where the job completed successfully to the instance where it is
failing, no differences we tried executing the stored proc manually
writing some print statements to see if it really a code issue, this
didn't helped us since the job is not failing for a particular session
GUID and the same step is passing in DEV environment.
We are not able to figure out why this is happening only on instances
where application DB resides.