I was sucessfully able to install IISv8.1 on Windows, while testing Parallel Tranformer Stage I killed a testing job couple of times.
After rebooting machine I tried to open DataStage client components but started throwing below errors.
I know that killing testing job have corrupted DS repository, I tried to run DS.REINDEX ALL from dssh command line, but couldn't do it.
Guys any idea to resolve this other than re-installing IIS.
Error calling subroutine: *DataStage*DSR.ADMIN (Action=36); check DataStage is set up correctly in project UV
(Subroutine failed to complete successfully (30107))
Error calling subroutine: *DataStage*DSR.ADMIN (Action=38 ); check DataStage is set up correctly in project UV
(Subroutine failed to complete successfully (30107))
Error calling subroutine: *DataStage*DSR.ADMIN (Action=36); check DataStage is set up correctly in project UV
(Subroutine failed to complete successfully (30107))
Error calling subroutine: *DataStage*DSR_PROJECT (Action=1); check DataStage is set up correctly in project ANALYZERPROJECT
(Subroutine failed to complete successfully (30107))
Thanks
SriMitta
Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives.
By William A.Foster
Look carefully at the error messages - the first three are referring to the UV project (the DataStage server engine). So there is a problem of some kind there. Unfortunately there is no single diagnostic tool, but you might like to run queries against the UV.ACCOUNT table, the UV_USERS table and the UV_SCHEMA table just for starters.
In which project did you execute DS.REINDEX? It was not in the UV project because this command does not exist there. And, in any case, you haven't cleaned up the XMETA repository. Remember that there are two repositories now, the local one (on which DS.REINDEX works) and the common one. Search DSXchange for information about freeing resources in the common 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.
I tried to do DS.REINDEX ALL from command line but I could not.
I didn't touch XMETA.
All that I did was closing DataStage Desiner window couple of times forcefully while compiling a Parallel job and tryed to clear status and release locks form Director window.
Any thought where I went wrong!.
Thanks
SriMitta
Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives.
By William A.Foster
These results suggest that the dsadm and Administrator users and the dstage and ANALYZERPROJECT projects are correctly recorded. Therefore the error messages may be misleading.
Go to the web console for Information Server and open the session management page, and see whether there appear to be any defunct sessions there. If there are, release them.
I don't *think* it's a locks issue, because I'd expect the word "lock" to appear in the error message if it were.
What does your official support provider have to say?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.