ROUTINES UNABLE TO OPEN
Posted: Mon Oct 29, 2007 8:03 am
I am not able to open the routines, in designer below is the message,
Error calling subroutine: DataStage DSR_Select (Action=10); check DataStage is set up correctly in project <<xyz>> (Subroutine failed to complete successfully (30107))
I have rebuild the using DS.REINDEX DS_TRANSFORMS ALL then it gave this error.
>DS.REINDEX DS_TRANSFORMS ALL
Locking 'DS_TRANSFORMS' file for exclusive use.
Starting SSELECT for file 'DS_TRANSFORMS index CATEGORY'.
Compiling "@INDEX.CATEGORY".
@Ak.0 ; @1 : ( char ( 251 ) ) : @Ak.ID
Read operation failure. Internal file corruption detected. File must be repair.
SELECT did not complete as expected. Please verify!
File 'DS_TRANSFORMS' Unlocked.
Alternate Key Index Summary for file DS_TRANSFORMS
File........... DS_TRANSFORMS
Indices........ 1 (0 A-type, 0 C-type, 1 D-type, 0 I-type, 0 SQL, 0 S-type)
Index Updates.. Enabled, No updates pending
Index name Type Build Nulls In DICT S/M Just Unique Field num/I-type
CATEGORY D Required Yes Yes S L N 3
NLS Collation Locale... US-ENGLISH
then I delete the Index using this command
DELETE.INDEX DS_TRANSFORMS ALL
then I run for rebuilding indexes
DS.REINDEX ALL
Still I have same issue now I am getting this error.
Error calling subroutine: DataStage DSR_SELECT (Action=10); check DataStage is set up correctly in project (Subroutine failed to complete successfully (30107))
Error calling subroutine: DataStage DSR_Select (Action=10); check DataStage is set up correctly in project <<xyz>> (Subroutine failed to complete successfully (30107))
I have rebuild the using DS.REINDEX DS_TRANSFORMS ALL then it gave this error.
>DS.REINDEX DS_TRANSFORMS ALL
Locking 'DS_TRANSFORMS' file for exclusive use.
Starting SSELECT for file 'DS_TRANSFORMS index CATEGORY'.
Compiling "@INDEX.CATEGORY".
@Ak.0 ; @1 : ( char ( 251 ) ) : @Ak.ID
Read operation failure. Internal file corruption detected. File must be repair.
SELECT did not complete as expected. Please verify!
File 'DS_TRANSFORMS' Unlocked.
Alternate Key Index Summary for file DS_TRANSFORMS
File........... DS_TRANSFORMS
Indices........ 1 (0 A-type, 0 C-type, 1 D-type, 0 I-type, 0 SQL, 0 S-type)
Index Updates.. Enabled, No updates pending
Index name Type Build Nulls In DICT S/M Just Unique Field num/I-type
CATEGORY D Required Yes Yes S L N 3
NLS Collation Locale... US-ENGLISH
then I delete the Index using this command
DELETE.INDEX DS_TRANSFORMS ALL
then I run for rebuilding indexes
DS.REINDEX ALL
Still I have same issue now I am getting this error.
Error calling subroutine: DataStage DSR_SELECT (Action=10); check DataStage is set up correctly in project (Subroutine failed to complete successfully (30107))