DSXchange

Hi Ray, Thanks for the help. I am able to fetch the zipcode from the address as it is the last substring in the address column. But when I am mapping the complete address column to a flat file, it is not fetching the full string rather its throwing an error like read_delimited()-invalid quotes, row ...

Hi I have an Address column in the table which is getting split into 3 diffrent fields city, state, zip. Now we need to split the value from Address column and load it to the 3 columns. The value of Address looks like 21785 Filigree Court, Suite 103 Ashburn, Virginia 20147-6214 4431-A Brookfield Cor...

I hope the DS_JOBOBJECTS file got corrupted. One of the reasons can be there was no space left when the job ran into warnings and the file got corrupted. The only thing you need to do is contact the IBM Ascential support desk. they will help u out in resolving the issue. We had the exact problem cou...

ArndW wrote:How are you importing the tables and from what database. Do these tables that cause errors have datatypes that aren't found in the others? ...

We are importing the tables from Import menu:
Import -->TableDefinitions-->ODBC Table Definition

And we are importing from Oracle Database.

Hi

We are unable to import some tables in the DS Manager.
Import is working for most of the tables.

But there is a small set of tables for which we are getting an error like

Runtime Error: 'Overflow'

Can u pls help us.

I found the strange behavior of DS Director. I changed the job name and compiled it. i created a new batch for the new job alone. and it is working fine. It happened with one other job also. I did the same for that job i.e renaming and it is working fine. But I dont understand what's wrong with the ...

I created a new batch with only XYZ job. It s giving the same error. In normal scenario, when we add jobs to a batch, it will generate a line as givien below for all the parameters used in the job. ErrCode = DSSetParam(hJob7, "$PROJDEF", "$PROJDEF") where as it not generating in ...

When I add the job to the Director, The code getting added is as follows: Setup XYZ, run it, wait for it to finish, and test for success hJob8 = DSAttachJob("XYZ", DSJ.ERRFATAL) If NOT(hJob8) Then Call DSLogFatal("Job Attach Failed: XYZ", "JobControl") Abort End ErrCode...

sb_akarmarkar wrote:Hi,

Monitor batch while runing...Check log from director.


Thanks,
Anupam

I compiled the job before running the batch.
But the batch is getting aborted for the same job.
and it is also giving the same error.

Hi, I created batches of 10jobs each in the Director. I am able to run all the batches except one batch. And when I opened the batch log, for one of the jobs i got the following error message. Batch::Setup2_1C..JobControl (fatal error from DSAttachJob): Job control fatal error (-12) (DSOpenJob) Cann...

We refreshed the DS_JOBOBJECTS file from backup taken the last time. After that when we ran the command COUNT DS_JOBOBJECTS we got the following output. 59110 records counted. And the result for UVFIXFILE DS_JOBOBJECTS is as fllows: Beginning trace of DS_JOBOBJECTS TRACE of DS_JOBOBJECTS completed S...

Hi

We are working on DS7.5 for a peoplesoft upgrade project.
Its working fine till yesterday. Today when we try to open any job, it is throwing "Can not open file DS_JOBOBJECTS"

Pls suggest what has to be done.

We are working on peoplesoft upgarde project. One of the peoplesoft consultants told that we have to import all the bundles. we have done it. But still getting the error. When we try to view data from DRS stage, It is saying Error Calling subroutine DSD_Browse or some times DSD_RECORD and some times...

ArndW wrote:The reason I asked is that if you are using your own query it might be causing the issue, whereas it is unlikely that a generated query will cause the error you are having. Which one of the 3 types are you using?

\


We are using generated SQL.

we have 3 Query types in DRS stage.
1. Generated SQL Query
2. User defined SQL Query
3. User defined SQL query file.

Can u pls explain me what can be the reason of DRS behaving this way?