DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
Developer9



Group memberships:
Premium Members, Heartland Usergroup

Joined: 14 Apr 2011
Posts: 187

Points: 2663

Post Posted: Tue Mar 12, 2019 3:33 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Windows
Additional info: Parameter sets
Hi,

I am using parameter set "Ps_count" to populate text file "param.txt" with count . I did compile the job before running. Please suggest me the steps to troubleshoot the issue with parameter set.

Quote:
***Ps_count Parameters tab**
count (parameter name)
Value tab
param.txt | "why blank value here " -->(count)

***job design***
DB extract sql (count) ----> sequential file stage (param.txt)

**Job run options**
Ps_count parameters --param.txt (selected from drop down)


Quote:
**Warning message**
Value for parameter 'Ps_count.count' could not be read,using default value instead .

Quote:
**When I click OK, job ran with default value (blank).I can see that count value is getting updated in the file (param.txt) but I do not see its updating in parameter set meaning I can't see the actual value in values tab..

Code:
****Expected result ****
Every time value updated in value file (param.txt) it should gets updated in parameter set


Quote:
***Troubleshooting steps performed ****

Manually changed the value in value file (param.txt) but its not updating the value in parameter set (values tab) .

I already searched forums and spent enough time to debug but couldn't figure out the actual cause .


Thank you for the input.
Mike



Group memberships:
Premium Members

Joined: 03 Mar 2002
Posts: 1021
Location: Tampa, FL
Points: 6600

Post Posted: Fri Mar 15, 2019 1:39 pm Reply with quote    Back to top    

I think you are a bit confused on how parameter sets and their values files are stored on the engine server.

Your job design may be updating a file called param.txt, but I'll wager it is not the parameter set values file that you are updating.

On the server go to your project folder. In it you should see a folder called ParameterSets. Inside the ParameterSets folder you will see a folder for each parameter set that is defined in the project. Inside the folder for a parameter set, you will see a simple text file for each values file defined in the parameter set. View the content of the values file so that you know what you need to provide. Each parameter will be on a separate line with name=value.

In your job design, what path have you specified in the sequential file stage?

Try this fully-qualified path inside your sequential file stage:

Code:
./ParameterSets/Ps_count/param.txt


A job's current working directory is the project folder by default. The dot in the path represents the current working directory.

I don't work on windows, so I don't know if the engine will recognize the forward slashes in the path. Switch them to backslashes if the Windows engine doesn't like them.

Mike
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54537
Location: Sydney, Australia
Points: 295725

Post Posted: Sun Mar 17, 2019 3:17 pm Reply with quote    Back to top    

When you look at the Parameter Set in the Designer client, what is the actual name of the values file?

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours