DSXchange

20000? Yikes. Drop it down to 1 to make sure that's the issue and then raise it in logical increments until performance is acceptable and it no more blow up. ... Thanks Creig....But you know, this error doesnot appear regularly. It occurs, say, 1 or 2 days a week. Is it becoz on those days heap mem...

More details. The error is specific to the OCI stage, what exactly is going on in there? Settings, number / sizes of fields, etc etc etc. ... Inside OCI...the details are: Array size - 20000 Prefetch Memory setting - 0 columns are Varchar (size ranges from 3 - 600), timestam(38), decimal(3,2) . &qu...

It's an operating system process memory issue from the OCI (client) software rather than the database itself. What exactly are you doing in this job? Giant array sizes? CLOB fields? Details, pl ... The job is fetching data from oracle table through OCI and in Transformer stage look up is being done...

Hi, Could anyone give any opinion abot the following error? OCI-04030: out of process memory when trying to allocate 32768 bytes (Alloc statemen,ttcfopr(): alloc pref buffer) Is this something related to database shared pool or Heap memory? Please help. Your reply is appreciated. Thanks in advance.

Sysadmin of the UNIX box says that the scheduler worked fine though the job is not triggered from Datastage. I mean from DS end we couldn't see that the job starts automatically according to schedule. But cronjob log states that the cronjob have been working fine..Do I need to check dsr_sched.sh or ...

The contents of the &PH& subdirectory can be managed by creating an external process that deletes files. You can use cron to schedule a daily run of a command such as "find {path_to_&am ... Thanks mate!! But could please take up littile burden for me? Please post the command only t...

Hi,

Can anybody please give me an overview on &ph& folder in the project directory? How can I manage its size as it is supposed to be growing per job run?

Thanks in advance.

chulett wrote:Not sure. Can you answer the question I asked, please? ...

No i didn't see any such "try" in log...But I cann't get the full view of your post after "Former sup..."...

Do you get any indication in the log that the job even tried to start? Or does it look like absolutely nothing happens when the time comes? For the latter, talk to an SysAdmin. Fo ... I can see your last message partially. By the way, one difference i noticed in "Environment variable settings&...

It couldn't hurt to Unschedule the job and then Add to Schedule again. If there's any doubt about what it did, do a "crontab -l" from the command line as the scheduling user and post it here. ... Creig i have done Unschedule-Add to schedule on that job. Let's see what happens. I will let ...

"overwritten" - Assume a job X in production environment which is scheduled. Meanwhile, business requested some enhancements to job X, which will be developed in DEV environment, tested and then migrated to other environments including production. Migration to production environment can b...

It couldn't hurt to Unschedule the job and then Add to Schedule again. If there's any doubt about what it did, do a "crontab -l" from the command line as the scheduling user and post it here. ... Creig i have done Unschedule-Add to schedule on that job. Let's see what happens. I will let ...

[quoteWe didn't overwrite the scheduled job. We didn't even reschedule it to stop for an opinion. And won't the crontab file be overwritten if we reschedule the job, say in a different time? Yes and No. If you reschedule a job, then cron tab entry is taken care. But if you accidentally overwrite an...

Did you overwrite the existing scheduled job yesterday (during some enhancements migration)? If yes, can you delete the cron entry and reschedule? We didn't overwrite the scheduled job. We didn't even reschedule it to stop for an opinion. And won't the crontab file be overwritten if we reschedule t...

Was this a recurring schedule or a one-time one? The former uses 'cron' while the latter uses 'at'. Can you post the appropriate entry from the scheduler itself, cron or at? Meaning nothing from Direc ... As the job is supposed to run every day at a specific time, it should be using 'cron', I guess...