DSXchange

Hey Gagan,

Please just try this...

IF (Len((NullToValue(AddressLineOne, ''))) > 0

Use an empty string ('') rather than spaces - and no TRIM is needed here,
Source field AddressLineOne is Varchar - I assume.

Cheers!
Ash

Gagan, You are writing to a Varchar field so there cannot be any spaces unless you write it - please have a look at what you are doing in this condition IF (Len(Trim(NullToValue(AddressLineOne, ''))) > 0 Why you are assigning spaces to null value and then trying to TRIM it, doesn't make any sense. C...

Why you are using TRIM function on a Varchar field - do you think it's needed?


Ash

Hey Bala,

I saw this post and just replied - didn't realise that it's duplicate and has been answered already.

Cheers!
Ash

If it is giving warning for this problem - you can set the job to Abort after warnings, this will make it abort. Try providing Null Field value and see what output it is giving.

Set the Preserve Partitioning Flag to Clear, that weill solve the problem.

Cheers!
Ash

Try specifying the Config File Parameter before your DS run command.

Hi

Do you have any other stage between transformer and lookup?
Change the field names to something different and then try running it.

Hi

You can't run every version of PX on Windows 2000. Only Version 7.5x2 is compatible with windows platform with Visual Studio.net.

Regards
Ashwin

Hi

Can you please tell us about your Job design?

It may be because of combining of parallelSortMergeOperator.


Regards
Ashwin

Hi Broken pipe may be because of incorrect metadata. Esnure that you are using the right metadata and you are not creating bigger data than waht your fields are. Check properly the metdata of datasets what you have defined and what you are reading here. Sigbus errors is mostly if you try reading an ...

Hi

Check the Write access to the particular project.
Also check if its a protected project.

Regards
Ashwin

Hi

Can you please elaborate more on your job design and error, it will be easy for us to help you.

Regards
Ashwin

Hi

In addition to what all Craig suggested you can simply convert the date from one format to other, if that is what you intend to do by removing '/' from date.



Regards
Ashwin

Hi Keerthi

This has been often discussed on this forum, try searching for it. I am sure you will get all the details about it.

Regards
Ashwin