Search found 3 matches

Go to advanced search

by cebishop
Wed Jul 05, 2006 4:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parrallel Job Validation Error - (non_virtual dataset) ?
Replies: 1
Views: 1376

Parrallel Job Validation Error - (non_virtual dataset) ?

Job extracting from Oracle staging table and loading to another Oracle table, with Look Ups & Transforms. Job compiles OK but on validation fails with the following message: main_program: Data set, file set, or file "LkUpDateSK:DateSK.v": Non-pipe (or non-virtual data set) with .v in i...
by cebishop
Mon Jan 13, 2003 4:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: invalid ROWID
Replies: 6
Views: 2541

The job is a control routine that truncates a table (ds_controls), the table is then recreated and parameter values inserted. This fails with the Oracle error ORA-01410, invalid rowid, using Oracle 9.0.1.4 and datastage 6.0.3. with OCI 9.2. This job still works with Oracle 8.0.5 and datastage 6.0.3....
by cebishop
Fri Jan 10, 2003 9:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: invalid ROWID
Replies: 6
Views: 2541

[quote]
I have an Error-'ORA-01410: invalid ROWID' during running of the compiled job. Can any one suggest why the error occurs??



Did this problem get fixed as I have encountered the same problem after upgrading to Oracle 9.0.1, running on Solaris. Datastage version 6.0.3.

Go to advanced search