I need to decrypt the source files before processing into database using datastage. For this I have batch script which will decrypt the files and make them ready to process.
I am calling script via Command Execute Activity in Datastage, which giving error "No Secret Key". Same Command is being executed successfully when i run it manually on Server at Command Prompt using the same User ID as Datastage Execution.
For testing purpose i have created separate Sequence with the below command and executed:
It is possible that your job actually executes under some other user account (you could add some sort of whoami command to verify) and/or likely that the run time execution environment has different settings that your command line session. Start doing some comparisons there.
Choose a job you love, and you will never have to work a day in your life. - Confucius
Does the command line version work when your current working directory is the project directory (as would it would be in a command execute activity)?
Echo your env settings before doing that GBG call. Compare that with your shell settings when running manually. Maybe $PATH or some other odd setting is messing with you.
Is HOME environment variable the same for both runs?
dsrpc was running by using local system account, i have changed to specific user id which have full access and i have configured gpg keys for that user.
It worked fine when i manually run a datastage Jobs. But it throws same error when i schedule datastage Job. i have configured same user in administrator schedule tab.
Do i need to configure any other place for schedule?