DSXchange

First The stage does not let me give parameters and even when I use the full path 2 command are not executed in asingle stage

I am trying to run two commands as chmod 774 #$ScriptPath#/#FileName#.KSH; #$ScriptPath#/#FileName#.KSH My questions are 1) Can I run 2 commands in a single Execute Command stage? 2) How do I use parameters in Parallel Sequence? As of now I am using 2 stages and "fullpath/filename" in the ...

kduke wrote:Have you checked your permissions to see if they have changed?

Kduke, i have checked and permissions haven't changed at all.

If EditServ.impl.JobDefnImpl@79427df4 is your job name then that is your problem. Eliminate the special characters. Kduke, EditServ.impl.JobDefnImpl@79427df4 is not my job name. My job name is TestUserActivity. Thanks Ok i searched the forum and as an initial step i rebuilt the indexes. Now i can s...

If EditServ.impl.JobDefnImpl@79427df4 is your job name then that is your problem. Eliminate the special characters. Kduke, EditServ.impl.JobDefnImpl@79427df4 is not my job name. My job name is TestUserActivity. Thanks Ok i searched the forum and as an initial step i rebuilt the indexes. Now i can s...

kduke wrote:If EditServ.impl.JobDefnImpl@79427df4 is your job name then that is your problem. Eliminate the special characters.

Kduke, EditServ.impl.JobDefnImpl@79427df4 is not my job name. My job name is TestUserActivity.

Thanks

Hi All,

I am trying to save a job with stages and i get the following error.

Unable to Save EditServ.impl.JobDefnImpl@79427df4

Has it got something to do with the indexes in the repository? Please let me know.

Thank You!!

Thanks DSguru

A hashed file in the job had the wrong metadata.... correcting that solved the issue, I dont see the connection between the two but looks like everything good now !

I have a job which extracts data from a OCI stage and then does a few lookups and writes the data to Three OCI stages. The job just hangs when I run it , the log stops at "Write caching disabled". I think something is wrong with target OCI stages . I hooked up 3 sequential files in the pla...

Ray,

I meant that the source Orcale table has the dates in that format. When I use the TOCHAR function in the SQl to extract the date I get the dates as 14245 , 13939, 13880 ...etc.

I created a job to extract the dates to a text file and thats what I get in the text file after the TOCHAR function.

If its date and your source is OCI, dont you get your dates in internal format? Heck no.[/quote] Hmm ... tht sounds like trouble for me ... All the jobs i am working with get dates from OCI in Internal Format, let me explain My source data from the OCI stage is the datatype "DATE" ex : 31...

Yes, The date is in internal format ( i was saying i did a oconv to a text file and made sure that the conversion to internal format is ok) But my problem is when I write the internal date to a DATE field in a OCI stage it gives me the error posted above. It should convert Internal date to Oracle fo...

Yes the Source is OCI and the datatype is "DATE"

@ DSGuru The input data looks good, it is like 30-Nov-2004 31-Dec-1998 31-Mar-2004 30-Nov-2004 @Chulett I myself dont like the job design but I am comparing dates in my job and doing a (internal date - 1) in the job to get the previous day date, And I am "SUPPOSED" to stick to this job des...

I am trying to insert DataStage numeric internal date value into a OCI stage "DATE" field. The transform I am using to convert the original date into internal format is like ICONV("1950-03-02", "D-YMD[4,2,2]"). It seems to work for many of my jobs but I am having a prob...