Usage of BASIC transformer in IIS 8.0.1

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
parag.s.27
Participant
Posts: 221
Joined: Fri Feb 17, 2006 3:38 am
Location: India
Contact:

Usage of BASIC transformer in IIS 8.0.1

Post by parag.s.27 »

We are getting a warning/fatal while executing a job that has BASIC transformer used in parallel IIS job. The error is: -

Code: Select all

BASIC_Transformer_117,0: dspipe_init(332276): open(/tmp/ade.HGI_DW_DMI_PRD.EDW_Trans_QuotePolicyHeader_Policy_07.#0.BASIC_Transformer_117.Lnk_Xfm_Lkp-Output) - No such file or directory
can some one please suggest what is the reason and how it can be resolved?
Thanks & Regards
Parag Saundattikar
Certified for Infosphere DataStage v8.0
MVL
Premium Member
Premium Member
Posts: 33
Joined: Wed Apr 30, 2008 5:43 am

Re: Usage of BASIC transformer in IIS 8.0.1

Post by MVL »

MVL
Premium Member
Premium Member
Posts: 33
Joined: Wed Apr 30, 2008 5:43 am

Re: Usage of BASIC transformer in IIS 8.0.1

Post by MVL »

parag.s.27
Participant
Posts: 221
Joined: Fri Feb 17, 2006 3:38 am
Location: India
Contact:

Re: Usage of BASIC transformer in IIS 8.0.1

Post by parag.s.27 »

This was the error due to the following warning: -

Code: Select all

Unable to Read Temp_EDW_Trans_QuotePolicyHeader_Policy_07#02 from OMD.XML.DIR
Now the job is not getting this earlier fatal error but it is throwing the above warning. Is there any method to avoid this warning. We've tried and suppressed the warning but still it is coming and everytime it comes, the number appearing after "#" in Temp_EDW_Trans_QuotePolicyHeader_Policy_07#02 from OMD.XML.DIR increments by 1. For e.g. here the number after "#" is 02. If I again run the job then same warning comes and the number this time is 03 and so on.

Can someone tell why this warning is appearing. Is it something to do with improper installation of IIS server on system. Because the same IIS job is running on devlopment and test environments with suppressed warning. But on production server, the warning is constantly appearing even though it is suppressed.
Thanks & Regards
Parag Saundattikar
Certified for Infosphere DataStage v8.0
srimitta
Premium Member
Premium Member
Posts: 187
Joined: Sun Apr 04, 2004 7:50 pm

Post by srimitta »

Replace with Parallel Tranformer Stage, you will be fine or try to find that file in tmp directory and delete it.
Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives.
By William A.Foster
parag.s.27
Participant
Posts: 221
Joined: Fri Feb 17, 2006 3:38 am
Location: India
Contact:

Post by parag.s.27 »

srimitta wrote:Replace with Parallel Tranformer Stage, you will be fine or try to find that file in tmp directory and delete it.
Actually we have to do a complex date transformation where we have to increase the time by 1 second if the date has timestamp value as 23:59:59. Now this will increase a day after adding 1 second because the timestamp will be 00:00:00. Hence we also have to check for leap year and all such things while increasing the time value. Now we've trying with parallel routine but there is some issue with server and hence the routines are not compiling. IBM consultant is looking into it. Hence to achieve this date transformation we did use BASI transformer in parallel 8.0.1 jobs to use ICONV and OCONV functionalities.

So still the same warning is appearing.
Thanks & Regards
Parag Saundattikar
Certified for Infosphere DataStage v8.0
parag.s.27
Participant
Posts: 221
Joined: Fri Feb 17, 2006 3:38 am
Location: India
Contact:

Post by parag.s.27 »

srimitta wrote:Replace with Parallel Tranformer Stage, you will be fine or try to find that file in tmp directory and delete it.
Actually we have to do a complex date transformation where we have to increase the time by 1 second if the date has timestamp value as 23:59:59. Now this will increase a day after adding 1 second because the timestamp will be 00:00:00. Hence we also have to check for leap year and all such things while increasing the time value. Now we've trying with parallel routine but there is some issue with server and hence the routines are not compiling. IBM consultant is looking into it. Hence to achieve this date transformation we did use BASI transformer in parallel 8.0.1 jobs to use ICONV and OCONV functionalities.

So still the same warning is appearing.
Thanks & Regards
Parag Saundattikar
Certified for Infosphere DataStage v8.0
Post Reply