Did you observe anything in BDS Console Portal related to this ETL failure?
If not I suspect this is something to with BSA side.
Are you able to run other Jobs from BSA?
ETL is running fine when I am executing it manually. Not getting error in BDSSA console.
It is BSA side error but only for this job I am getting an error. Remaining jobs in BSA are working fine.
what os is the appserver?
if you look in /etc/security/limits.conf or /etc/security/limits.d/*.conf what's there ?
job run/appserver logs when this happens ?
I think Bill is hinting at this:
The same instructions apply to other versions of BSA
I'm sure Bil will comment when he gets online later
Thanks Jim for the reply
yep - i would check the values for open files and processes for the bladmin os user in the noted files. if you need to set them > 8192 you also need to change the ulimit setting in the NSH/br/blappserver and NSH/br/blprocserv files (or just comment them out and let the os value take affect)