DSXchange

Hi All , Our source is Oracle Database and destination also , each table have primary key , and at the time of data loading we mark that filed as key . As suggest by Mr. ray and Denzilsyb , we need to redesige our job , and create Hash file for each table and first lookup source file with this has f...

Hi Mahesh ,

If you calling job from job sequencer and if any child job is in not comlie , finished , rest stage then you root job sequencer will abort . to avoid this type of error you may use option in Execution Action as " Reset If Require the run "


Thanks

Arun

We have developed Billing Delta Application , which extract incremental data based on last_modified_date from source system and load the same in DSS server , In data loading job we have choosen option " Update Existing Rows or Insert New Row" . and following two sql statement generated in ...

Hi , We have also faced this problem while loading customer data , our source is comm seperated file customer file , some time we got comm "," character in address filed , this increase of no of column and job aborted at the time of loading . If you have also this problem , open file and f...

Dear Mr. Ray We have checked server log , when this error occur that time a lot of application was running , we have change schedule time , lets see tomorrow . We have SUN server with 24 CPU M/c 48 GB RAM , the value in uvconfig for T30FILE is "T30FILE 1000" , so should we increase ? . Tha...

We have multistance job , which data extract from seven serevr and load data into DSS server , at the time of data extraction we create Hash File for each server and at the time of data loading we are using this Hash File . for each server we are creating hass file like Hash_file_11 Hash_file_12 Has...

Thanks ,

We have clean project status , Index rebuild , now we are able to take
job category wise export backup .

Thanks again

Arun Verma

Hi Ray/Chulett

Thanks for reply , yes i got info from other people that we need to rebuild indexes , now we are going to implement , if agin this problem will not solve , i will give some trouble to you .


Arun

Hi Ray ,

I am taking export backup from DataStage Manager . not from DS.TOOLS.


arun

I am unable to take category wise export backup from my development server , I can take backup job individually . but if i choose category wise then getting following error . Error calling subroutine *DataStage*DSR_SELECT (Action=7); check DataStage is set up correctly in project ric_dss_dev (Subrou...

Dear Ray, Thanks for your valuable information. Can you please elloborate the suggestion provided as where to code this statement in the job. I am not clear that where do i incorporate this statement? We have implemented multi instance job after you left. We are getting maximum of this erorr only in...

Hi Ray ,

Is it related to controler problem ?

Thanks & Regards

arun

We have checked in confing file that T30FILES values is 1000 , should we increase more .

Yest it is true that this time a lot of process run , let it me search file and test ,
then i will reply

Thanks

Arun

HI ray.wurlod ,

Thanks for giving solution , I was worried that some problem in our ETL server or Job .


Thanks again

Arun Verma