DSXchange

Hi,

Is there any way to achieve this scenario in PX 8.5 or above -- "Edit/Import any existing table definition and those changes automatically reflect on reference jobs column definition" ?

The project default is always set, even if the setting is "not enabled". If it's changed, the changes only affect jobs created/imported after the change has been wrought. Thank you very much for patiently answering all my questions Ray!!! I have another one, what is the purging project de...

What if a given job is imported before the project default is set?

Ray,
No one did in 7.5 server as well since I created a new job without any manual intervention.

Also, I don't find the \\PURGE.SETTINGS in log hashed file and it purges the entries as per the project default. Then how do I confirm if the purge is enable for that particular job?

Ray, In my case no one is overriding the default setting. Just curious to know how it got into RT_LOG in 7.5 and not on 8.1? If I stick to your observations then how can I verify that a given job is enforced for project level purging? So, that I can scan through all the jobs with corresponding purge...

I am still not clear Ray. This was a new job created by me without any manual intervention on RT files. These commands were executed on UNIX box immediately after creating this simple job "Test".

There looks be difference in 7.5 and 8.1 //PURGE.SETTINGS record in RT_LOG files.

Hi, We have enable the auto purge at the project level on our 8.1 FP1 DS server. I am unable to find the PURGE.SETTINGS control record in our RT_LOGnnn files to reflect the project level purge setting. Inerestingly log entries are cleared as per the project level auto purge settings. The question I ...

Hello Everyone, Just to be more precise about my requirement. I have basic routines to run the in the transformer of a paralle job thus using BASIC transformer is must and also note that writing parallel routine is not in our scope at this moment. While invoking routine for every row I need to gener...

Hi, When I use a BASIC transoformer in a parallel job, by default it runs in parallel on all the nodes as per the configuration file but it doesn't have partitionnum and numpartitions sytem varibales to generate a surrogate key. It only has @INROWNUM which is not sufficient when the job is running i...

Curious to learn the results of your deliberation. Probably the first place to look would be the APT_CONDUCTOR_NODE environment variable definition. DSParams investigation revealed that PXGridGUIEnabled is set to true which generates the nodepool("conductor") text when compiling on grid-e...

Hi Ray,
I think the issue is with the DSParams file which got corrupted for some reason. Jobs are running fine when I replaced corrupted DSParams with the working copy from a different project on the same server. I have to investigate corrupted DSParams to figure out the root cause though.

Ray, I also created a new parallel job row generator->basic transformer->peek which throws similar error. But when I use Node Map Constraint property to "node1" job runs fine. Your expert advice is very much appreciated!!! Node Map Constraint is not set: OSH script # OSH / orchestrate scri...

Examine the score. Which operator is op1? Does it specify any node pool or disk pool constraint? Hi Ray, Interestingly score shows node pool constraint which is not set in job design though. Not sure how it gets added compile time. When I manually removed the nodepool("conductor") from Os...

Hi, In our development server I get the below error for one of the jobs which was running fine all these days without any issues. main_program: Fatal Error: The set of available nodes for op1 (parallel DSInput in Copy_of_Pre_CleaneData_Trf). is empty. This set is influenced by calls to addNodeConstr...

This won't work if we have value lilke -00000.00100.

akbar2002 wrote:Yes, made a typo. Sorry about that
SV1 : DecimalToString(column_name) --> DataType = VarChar
SV2 : Field(SV1,'.',1) --> DataType = Integer
SV3 : Right(SV1,2) --> DataType = VarChar

Derivation : SV2:'.':SV3 --> DataType = VarChar