ROUTINES UNABLE TO OPEN

[sia_999]

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))

[ArndW]

The REINDEX command only repairs the indices, but your error message indicates that your DS_TRANSFORMS hashed file is corrupt.

Try executing, from your UNIX shell:

Code: Select all

$DSHOME/bin/fixtool -file /path/to/your/projectdir/DS_TRANSFORMS

[ray.wurlod]

Not only do you need to repair DS_TRANSFORMS, but you need to realise that routines are not stored in DS_TRANSFORMS. The hashed file you need to re-index is DS_ROUTINES. Of course, if the corruption in DS_TRANSFORMS was caused by running out of disk space, then you probably need to check all the hashed files in the Repository.

[sia_999]

fixtool does not work, what I did is replace the ds_transforms from another project, including the sub directories then it works fine, thank for the hint provided.

D_DS_TRANSFORMS
I_DS_TRANSFORMS
DS_TRANSFORMS

[sia_999]

fixtool does not work, what I did is replace the ds_transforms from another project, including the sub directories then it works fine, thank for the hint provided.

D_DS_TRANSFORMS
I_DS_TRANSFORMS
DS_TRANSFORMS

[ray.wurlod]

You need to do one more step. The indexes (which are stored in I_DS_TRANSFORMS) are still pointing at the other project. You need to do a DS.REINDEX DS_TRANSFORMS command to get it right.