$PROJDEF in an encrypted variable replaced by a wrong value

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
Palermo
Participant
Posts: 24
Joined: Fri Dec 12, 2014 2:05 pm
Location: Belarus
Contact:

$PROJDEF in an encrypted variable replaced by a wrong value

Post by Palermo »

Hi Everyone,

So, I have a problem when I reschedule my jobs which contain encrypted variables and have $PROJDEF as default, $PROJDEF is replaced by a wrong value. For example, $TEST=test in Administrator and this variable was added to a job and value was set $PROJDEF instead of *****. When I scheduled the job, it finished successfully but when I rescheduled the job, it failed. I found out that 'test' was replaced by '㔷◘'. Why this happens? When I unschedule the job and schedule again, it finishes successfully.
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

This may be worth looking into...

We ran into an incredibly frustrating intermittent problem on version 11.3.1.2 after rescheduling jobs they would sometimes abort and our database accounts would sometimes get locked. Restarting the job manually would always work fine.

The only suggestions I found by searching the forums was to try rescheduling it again. We checked with Support and found a solution to download and apply a Director patch on the clients, which resolved the problems!

JR53246 Fixed problem with rescheduling and encrypted job parameters
Choose a job you love, and you will never have to work a day in your life. - Confucius
Palermo
Participant
Posts: 24
Joined: Fri Dec 12, 2014 2:05 pm
Location: Belarus
Contact:

Post by Palermo »

Thank you very much. I think it will help me solve the problem. As I understand correctly, I should update my Director client. Now I have 11.3.1.2 version. Server version is 11.3. Which of versions should be used in my case or install fix pack? In the description of JR53246 mentioned 11.5.1.
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

You're welcome. I do not see that patch as a download on IBM Fix Central web site. In our case, we had to open a PMR with IBM Support and they provided the patch to us through the PMR (it's not an upgrade or a fix pack, but rather just a small patch). It should be based on your Director client version. They will probably ask for your Version.xml file from your client and possibly from your server as well.
Choose a job you love, and you will never have to work a day in your life. - Confucius
Palermo
Participant
Posts: 24
Joined: Fri Dec 12, 2014 2:05 pm
Location: Belarus
Contact:

Post by Palermo »

I installed the patch and the issue was fixed. Thank you.
Post Reply