DSXchange

Hi All, I have the BW Load pack documentation saying that : change the following environment variables in DS admin. ASC_BWLOAD_IPAK_TIMEOUT for chaning the default timeout period from 120 to 180. But I do not find any such variables in Administrator. Should I create a custom variable and include the...

Hi Ray and all, Finally running around the bush will not help...I have realised..Just lack of Documentation and experience will make you do this... The issue is resolved. Solution: When I transported the DS job which uses QS plugin, the Host system within QS plugin was still pointing to the same old...

Hi Ray, Just now I tried running the QS job from a DS job as Before Job subroutine instead of using a DS job with QS plugin. It runs in 1 min tme. Also, my server is on Windows server and I cannot using Unix commands. I also checked the server performance...its is optimum as desired since no other a...

Hi Ray, I run the QS job independently thru QS designer and it executes within few seconds for 34000 recs. So I assume that the QS is not giving problems. Ascential Support replies: "Then it has to be the server differences with the id's being used. When certain id's are used on the particular ...

Hi Ray,
Do you want the server config information for the 2 servers(Q and P)?Actually I have one more QS job attached as a After Job Subroutine with Exec Dos. This is a match job and it executes within seconds for the same number of records. What do you forsee?

Regards,
SM

Hi All, I have a DS Server job with Oracle as source and BW Load pack as target. The same job runs without any warnings and loads data inot BW InfoObject succefuly uin D and Q environment. My D and Q runs on the same server but my P runs on a dfferent machine. This warning occurs only when loading d...

Hi All, I have a job which uses BW load pack as target. Source is Oracle. The same job runs fine without any warning or error in Dev and Quality Environment. But in Production it gives me an error and job aborts. ERROR: Timeout waiting for BW to indicate InfoPackage ready for load Also I get warning...

Hi,
The Production server runs only DS and QS. In dev and Quality Environment we tested the same number of records. It went thru in 2min.
The input link of the Plugin takes 4rows per sec for 34000 rows. Why?
Is it DS problem or QS? There are no traces on P server.
Please advice.

Thanks,
SM

Hi all, I have a job which uses QS PLugin for DS to run a QS job within DS. Its a Undup Job with 1 input file and 2 output files. It has 6 passes within the job. Strangely it never took that much time in our Quality and Dev environment but in Production it is taking 2hrs for Deduplicating 34000 reco...

Hi All, Can anyone tell me whether Ascential has a tool which would translate any script(Japenese,Thai,Chinese,Arabic,French,Spanish etc.) to English character set. I have a requirement that files would come in from different countries around the world and we need to build a warehouse in English. Pl...

Hi all,
Can anyone provide me with the best practices used in Version Control tool of DataStage Server..?
I have some 60 odd jobs to be transported to Quality environment. Please suggest whetehr should I use Version Control tool ?

Thanks,
SM

Hi Roy, I have 2 BW connections created in the DataStage Administrator for SAP BW...These 2 connection point to the same BW system App Server... Is it because of this I am falling short of Named Pipes.?? Any experiences?Should I delete one since I am no more using it but it still may be occupying th...

Hi, I am currently facing a problem using the BW load pack...I have a job with source as OCI 9 and Target as BW Load pack4.1 I am trying to load data from oracle into BW ODS using Push mechanism...Somtimes it goes smoothly but then sometime the Job gets hanged with the Director logs stating as "...

Hi Ray,
How do i ensure that pipe files are cleaned up after the laod is completed..? Why this error occurs only when loading into BW system using Load pack?

Thanks,
Sm

Hi All, I have a strange issue coming up while running my jobs with BW system as the target using BW load pack....Sometime it runs smoothly but sometime it gives me the following error. "Error creating named pipe : (231) All pipe instances are busy." This error comes after 2 or 3 times the...