Page 1 of 1
Usage of BASIC transformer in IIS 8.0.1
Posted: Thu Nov 20, 2008 5:46 am
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?
Re: Usage of BASIC transformer in IIS 8.0.1
Posted: Thu Nov 20, 2008 6:05 am
by MVL
Re: Usage of BASIC transformer in IIS 8.0.1
Posted: Thu Nov 20, 2008 6:06 am
by MVL
Re: Usage of BASIC transformer in IIS 8.0.1
Posted: Thu Nov 20, 2008 8:09 am
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.
Posted: Thu Nov 20, 2008 8:50 am
by srimitta
Replace with Parallel Tranformer Stage, you will be fine or try to find that file in tmp directory and delete it.
Posted: Fri Nov 21, 2008 12:00 am
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.
Posted: Fri Nov 21, 2008 12:02 am
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.