DSXchange

While loading the data in to oracle using oracle enterprise stage having properties disable constraints true and index rebuild, running Giving the following warning. LA_BMS_9999999_104: When checking operator: There are no indexes on table `BMS_9999999_104', and an index option was included; the ind...

As I mentioned,despite of use of Trim or its derivative,its still padding while loading into database. ArndW I'm not at a system where I can check, but I seem to remember that Oracle VarChar() and VarChar2() act a bit differently when it comes to padding. Can you try to export a VarChar() column as ...

Hello All, I have found that using APT_ORACLE_PRESERVE_BLANK = True option also Pads blank spaces behing the passed string. i.e. eventhough i pass only 5 or 6 or 7 characters to a field defined as Varchar2(12) in database it is actually stored as 12 instead of 5 or 6 or 7 characters padding blank sp...

We are encountering this problem with more jobs resulting in abort which are writing zero records,

Any insight in the matter shall be welcomed

Hi All, This job is only aborting incase when there is 0 records to be writen in EH_EXCEPTION_INSTANCE (oracle enterprise edition) with following errors other wise running fine. Wondering had it been permission issue (based upon search on this forum) then why running successfuly when it has few reco...

Hi, Woke up today morning with jobs in abort state which happened to run perfectly till yesterday. ##E IIS-DSEE-TDOR-00172 11:16:23(001) <BMS_9999999_104> Access to sys.dba_extents is required but not available; please see your database administrator for select privileges. Wondering what could have ...

it can be done thro' transfer but given modify stage is lighter was using this

Problem is persiting despit of Disabling operator combination generated this while viewing the data, ##I IIS-DSEE-TFCN-00001 16:23:36(000) <main_program> IBM WebSphere DataStage Enterprise Edition 8.0.1.4458 Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved ##I IIS-DSEE-TOSH-00002 1...

Ray,

As suggested,tried to view data with less number records even with 1 since total records in the table is just 21 .

But still it is of no avail...

One of our jobs aborted in production while direct loading the data from one oracle table(source) to another Oracle table(target) with no transformtion,this job used to run succefully till previous run. When we tried to veiw data in Source it thro' following info ##I IIS-DSEE-TFCN-00001 11:23:34(000...

Hi Ray, As per your suggestion, made stage's combinability to "Don't combine" re-ran the job and captured the error as below, SG_EXCEPTION_INSTANCE: Error occurred during initializeFromArgs(). main_program: Incorrect -dboptions option list; failed on Expected "," or "}"...

Ray,

How can we disable operator combination to reproduce the error.

thanks

Hi, While using Surrogate Key Generator which in turn invoking oracle data base sequence in job aborting with error APT_CombinedOperatorController,2: Caught exception from runLocally(): APT_ParseError: Expected "," or "}", got: ".", line 1. APT_CombinedOperatorControlle...

As a temporary work around disabled APT_NO_JOBMON from administrator, but still looking for resolution

Cheers

Hi All, All of sudden we came across this warning in production(nightly batch run) " main_program: Failed to initialize job monitoring. Monitor information will not be generated." because of which our daily extraction is incomplete. And search did not fetch any meaningful result for Window...