DSXchange

Hi All,

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

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.

Thanks Ray for the response,

As per your advise I quried these tables couldn't interpret results, any help!.

• >SELECT * FROM UV.ACCOUNT;
  Account... UID GID Owner name...... NT pathname............. Permissions
  
  uv 0 0 C:\IBM\InformationServer
  \Server\DSEngine
  DS 0 0 C:\IBM\InformationServer
  \Server\DSEngine
  ds 0 0 C:\IBM\InformationServer
  \Server\DSEngine
  UV 0 0 C:\IBM\InformationServer
  \Server\DSEngine
  dstage 0 0 DataStage\8.1\ma C:\IBM\InformationServer
  rkardev\30977 \Server\Projects\dstage
  ANALYZERPR 0 0 DataStage\8.1\maC:\IBM\InformationServer
  OJECT rkardev\23604 \Server\Projects\ANALYZE
  RPROJECT
  
  6 records listed.

• >SELECT * FROM UV_USERS;
  
  User Name.......... NT AUTHORITY\system
  
  DBauth Privilege... YES
  Resource Privilege. YES
  Author............. Administrator
  Own-Table Schema.. Owned Tables......
  
  Perm-Table Schema. Permitted Tables..
  
  
  User Name.......... MARKARDEV\Administrator
  
  DBauth Privilege... NO
  Resource Privilege. YES
  Author............. Administrator
  Own-Table Schema.. Owned Tables......
  ANALYZERPROJECT EXAMPLE1
  Perm-Table Schema. Permitted Tables..
  
  
  User Name.......... Administrator
  DBauth Privilege... YES
  Resource Privilege. YES
  Author............. Administrator
  Own-Table Schema.. Owned Tables......
  CATALOG UV_TABLES
  CATALOG UV_COLUMNS
  CATALOG UV_SCHEMA
  CATALOG UV_VIEWS
  CATALOG UV_ASSOC
  CATALOG UV_USERS
  Perm-Table Schema. Permitted Tables..
  
  
  User Name.......... MARKARDEV\dsadm
  DBauth Privilege... YES
  Resource Privilege. YES
  Author............. MARKARDEV\dsadm
  Own-Table Schema.. Owned Tables......
  
  Perm-Table Schema. Permitted Tables..

• >SELECT * FROM UV_SCHEMA;
  
  Schema. CATALOG
  Owner.. 0
  Path... C:\IBM\InformationServer\Server\DSEngine/sql/catalog
  
  Schema. dstage
  Owner.. 0
  Path... C:\IBM\InformationServer\Server\Projects\dstage
  
  Schema. ANALYZERPROJECT
  Owner.. 0
  Path... C:\IBM\InformationServer\Server\Projects\ANALYZERPROJECT
  
  
  3 records listed.

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

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?