Problem description:
We have one user that is constantly getting a SOC4 completion code and it appears as the job completed ok.
What is the SOC4 return code and also inbetween the SOC4's this user is also getting some unusual character return codes such as |L |c .The other users are also intermittantly receiving the same SOC4 code but it is not as consistant as this user.
Resolution:
Upon further testing and isolating when the SOC4 occurs during the steps runs, we were able to determine that it occurs when connection to the database occurs. After comparing the two systems that are working without any SOC4's to those that were getting soc4, it turns out that the only difference was the Oracle Client version.The two desktops that were intermittently receiving soc4 had oracle 11.2.0.2 32 bit client and the ones that were not had oracle 11.2.0.4 32 bit. Once we replaced the oracle version on the two desktops reporting SOC4's, the SOC4's stopped.
Additional Keywords:
SOC4 oracle
#MFDS
#EnterpriseDeveloper
