Search found 106 matches

by chitravallivenkat
Thu Mar 08, 2007 12:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: unable to create sequential file as debug file
Replies: 9
Views: 3702

Hi,

I am running one instance at a time and i am not using the same filename anywhere in the project..


VC
by chitravallivenkat
Wed Mar 07, 2007 11:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: unable to create sequential file as debug file
Replies: 9
Views: 3702

Hi All, I am able to create a file with forward slash only. I can able to run successfully for 5-6 times. After some time, this error will come. The file was created when i ran the first time. The next time onwards, it will be overwritten. So, there is a chance of locking. I have all type of access ...
by chitravallivenkat
Wed Mar 07, 2007 4:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: unable to create sequential file as debug file
Replies: 9
Views: 3702

unable to create sequential file as debug file

Hi, I am trying to create a debug file to check the data. Actually it is populating into table. I am just populating it to a file in the same way. It is saying unable to create file.... The error message is: H:\\DEV_ZGP0GSAS\\Temp/NyScty_Ins_SctyDescADD.txt: Permission denied I think the file got lo...
by chitravallivenkat
Mon Feb 12, 2007 9:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Status code 127 for the job
Replies: 4
Views: 2197

Status code 127 for the job

Hi,

I got the status code as 127 when i ran the job. Suppose a job returns a status code 127. Where can I see what status 127 means?

Thanks in Advance

VC
by chitravallivenkat
Mon Feb 12, 2007 12:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequential file creation problem
Replies: 7
Views: 3871

narasimha wrote:It could be something with your network. Is H: a mapped network drive?
It is Mapped network. But for other jobs, creation is working fine.
by chitravallivenkat
Sun Feb 11, 2007 8:27 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash file creation problem in the Lookup Job
Replies: 14
Views: 3345

But we can not use the local drives, because our datastage is installed in the server system and also we use citrix connection. :? I've got no idea what 'our datastage is installed in the server system' means, but neither reason seems to me one that means you 'can not' use local drives. You might c...
by chitravallivenkat
Sun Feb 11, 2007 8:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequential file creation problem
Replies: 7
Views: 3871

Sequential file creation problem

In our jobs we are using the sequential files to view the debug the value of the stage variables(50 Stage variables). Previously it was working fine. But now job is continuosly running, not finished. Then we stopped manually and resetted. the error notes that GSAP_NY_SCTY_Insertion11..SortCusip: |GS...
by chitravallivenkat
Sun Feb 11, 2007 8:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash file creation problem in the Lookup Job
Replies: 14
Views: 3345

ray.wurlod wrote:As the others have noted, try at all times to create hashed files on local drives. The main purpose of hashed files is to provide fast, local, lookup capability. ...
But we can not use the local drives, because our datastage is installed in the server system and also we use citrix connection.
by chitravallivenkat
Sun Feb 11, 2007 6:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash file creation problem in the Lookup Job
Replies: 14
Views: 3345

ray.wurlod wrote:Is your H: drive local or remote? You will find (by searching) that using mapped network drives is not supported; you will need to use UNC pathnames.

And even that won't work if ALLOWNFS in uvc ...


Drive H is remote. what is UNC pathnames?
by chitravallivenkat
Sun Feb 11, 2007 4:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash file creation problem in the Lookup Job
Replies: 14
Views: 3345

Now i saw the post. but i could not get any solution for my problem.

Can u give any suggestion to solve that problem? Pls..
by chitravallivenkat
Sun Feb 11, 2007 3:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash file creation problem in the Lookup Job
Replies: 14
Views: 3345

DSguru2B wrote:See if this posthelps. ...
u couldn't get or anything else u need.
by chitravallivenkat
Sat Feb 10, 2007 11:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash file creation problem in the Lookup Job
Replies: 14
Views: 3345

Hash file creation problem in the Lookup Job

In our lookup job, some 20 hash files from SQL Server are created in single job which has only two stages(OLEDB Stage, Hash Stage). we are not using seperate stage for each Hash file. that means from single OLEDB Stage, 20 links have been created to Single Hash Stage. Now the problem is when we are ...
by chitravallivenkat
Fri Feb 02, 2007 4:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Viewing records in error, from log
Replies: 6
Views: 2003

thanks for the answers. But I could not acheive what I wanted. I also went thru the topic you mentioned. ("Creating error report files", posted by JB and answered by Michael Hester). That is exactly what I need. But the solution given does not seem to work for me. My job is as below: msole...
by chitravallivenkat
Thu Feb 01, 2007 9:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Viewing records in error, from log
Replies: 6
Views: 2003

Viewing records in error, from log

Hi,

I have, say 100, records in a flat file to be loaded to a table. After the job is run, I can see warnings in the log. How do I know which records caused this warnings? Can I collect these records in a file? I'm using MSOLEDB database stage (sql server),

thanks,
Venu.
by chitravallivenkat
Wed Dec 20, 2006 5:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: COM Initialization failed
Replies: 5
Views: 2975

Do you have any external (ActiveX) functions defined and being used in this job? Does the job work if you use ODBC rather than OLEDB? ... We don't have any external functions. The job is very simple one.The job has only two stages with 10 links. The records are passing from (SQL Server)OLEDB to Has...