DSXchange

We have the same jobs with DRS stage running fine in DS7.1 in production and also we are able to view data there.

Now we are migrating the jobs from 7.1 to 7.5.
And in 7.5, there's no problem in running the jobs.

I replaced DRS stage with ODBC and I am able to view data.
But why is it so?

Hi, We are working on DS7.5. The jobs run fine. But when we try to view data from the DRS stage, it throws the error Error calling Subroutine: DSD.Browse (Action=3); Check Datastage is set up correctly in project 'DEVELOPMENT' If we press Ok one more pop window will come saying 'Datasource is empty'...

I check the data in the hash file and the date column looks like
'YYYY-MM-DD HH24:MI:SS'

But when we try to compare it with the date column of a table using LastModifiedDateTime, its now working.

So I am trying to convert it to date before comparing.
But that is also not working

Hi, We are using DS7.5 for Peoplesoft upgarde project. I am passing the MaxDateTime value to a shared container StoreMaxLastUpdDttm , in trun it is getting stored in a hash file. The datatype of the MaxDateTime is Timestamp(19). Now I am trying t retrieve the date using '#LastModifiedDateTime#' (del...

Pls find the query below: 1 select count(*) from <table> where to_char(dttm_sec)>to_char('2005-03-30 14:26:51'); and another query is as follows: 2 select count(*) from PS_LEDGER where dttm_stamp_sec> '30-Mar-05'; the first query returns 1309100 rows and the second query returns 1032525 rows. The on...

Hi I have a problem with the date stored in Shared container. I have already posted in this forum sometime back; as i did not get the required outcome, i am posting again. We are working on Peoplesoft 8.9upgrade project. The lastupdateddate will be stored in the shared container. If we open and see ...

the proejct in Production is running on DS7.1v where as we are doing the upgarde in 7.5. So, there's no IPC stage defined in the customised maps. Anywhere else I can change the Timeout option if we dont have IPC stage?[b/] Please find the description of the job below Source-->Aggregator-->Transforme...

Hi, We are using DS7.5. We are working on Peoplesoft upgrade project. If we have more than 500000 records, the job is getting aborted without showing any error. or sometimes the error looks like as given below Call to output link returned numeric error code:-100 Please help me. If we limit the numbe...

u need to restart the server and then try logging in to Client.

If the jobs are incremental in nature, u have to check whether new records are getting populated with current timestamp and the number of records coming from the lookups. If existing rows have to be updated, pls check the created date for the row and updated date once the increment is done. And also...

i am using @in rownum system variable in the transformer to load data in chunks
and it works fine
thanks alot!!

we are doing peoplesoft upgrade project. i dont have information of how often the dba does commit?

any other info needed?

I wanted to test whether incremental job is working fine ie whether the new rows are getting inserted and existing rows are getting populated. I created a temporay source table which is exact replica of original source I have done because the original table has millions of records. now i inserted so...

Sometime back OS patch has been installed and immediately after that we were getting an error like "Failed to load control 'ImageList' from MSCOMCTL.OCX.

We are getting the same error now.
Or some times the error which i mentioned in the previous message.

We have problems in accessing Ascential Datastage7.5 from Citrix machine I have DS7.5 installed on my Desktop too. It is working fine. Only when we access DS through Citrix, it is showing 'Run Time Error '35610''. then i need to end the DS component and then start again. It s really painful. Pls sug...