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))
ROUTINES UNABLE TO OPEN
Moderators: chulett, rschirm, roy
ROUTINES UNABLE TO OPEN
ilyas
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:
Try executing, from your UNIX shell:
Code: Select all
$DSHOME/bin/fixtool -file /path/to/your/projectdir/DS_TRANSFORMS
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
It works by replacing with DS_TRANSFORMS hash from oth proj
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
D_DS_TRANSFORMS
I_DS_TRANSFORMS
DS_TRANSFORMS
ilyas
It works by replacing with DS_TRANSFORMS hash from oth proj
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
D_DS_TRANSFORMS
I_DS_TRANSFORMS
DS_TRANSFORMS
ilyas
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.