projects are broken

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
przytulaguy
Participant
Posts: 14
Joined: Fri Jun 19, 2009 5:39 am
Location: KERMT

projects are broken

Post by przytulaguy »

installed information server datastage 11.5 on redhat linux
started all services : ok
configured users : ok
datastage admin console : all projects have (broken)
tried to create new project - window indicates : creating..copy.... : ok
and status also (broken)
I did not change the hostname since install (as I could read in another entry)
the trace log file does not indicate any errors
LOG CREATED: 21:18:52 17 APR 2018, user=, from=/opt/IBM/InformationServer/Server/DSEngine, version=11.5.0.0, platform=LINUX64
2018-04-17 21:18:52 (,0): Project creation started on server: name=dsproj1, path=/data/ISServer/Projects/dsproj1
2018-04-17 21:18:57 (,0): Adding project to xmeta repository: name=dsproj1, host=ILMT, locale=ENU
2018-04-17 21:19:22 (,0): The following accounts are on the system: number=5, accounts=uvDSdsUVdsproj1
2018-04-17 21:19:22 (,0): Project creation finished OK: name=dsproj1, host=ILMT
2018-04-17 21:34:27 (,0): Project creation started on server: name=ANALYZERPROJECT, path=/opt/IBM/InformationServer/Server/Projects/ANALYZERPROJECT
2018-04-17 21:34:31 (,0): Adding project to xmeta repository: name=ANALYZERPROJECT, host=ILMT, locale=ENU
2018-04-17 21:35:00 (,0): The following accounts are on the system: number=6, accounts=uvDSdsUVdsproj1ANALYZERPROJECT
2018-04-17 21:35:00 (,0): Project creation finished OK: name=ANALYZERPROJECT, host=ILMT
2018-04-17 21:37:12 (,0): Project creation started on server: name=DataClick, path=/opt/IBM/InformationServer/Server/Projects/DataClick
2018-04-17 21:37:17 (,0): Adding project to xmeta repository: name=DataClick, host=ILMT, locale=ENU
2018-04-17 21:37:41 (,0): The following accounts are on the system: number=7, accounts=uvDSdsUVdsproj1ANALYZERPROJECTDataClick
2018-04-17 21:37:41 (,0): Project creation finished OK: name=DataClick, host=ILMT
2018-04-18 12:08:59 (dsadm,admin): Project deletion from xmeta repository started : name=Project1, host=ILMT
2018-04-18 12:09:01 (dsadm,admin): Project deletion from xmeta repository finished: name=Project1, host=ILMT, result=0
2018-04-18 12:09:01 (dsadm,admin): Project deletion from server started : name=Project1
2018-04-18 12:09:01 (dsadm,admin): The following accounts are on the system: number=7, accounts=uvDSdsUVdsproj1ANALYZERPROJECTDataClick
2018-04-18 12:09:01 (dsadm,admin): Project deletion from server finished: name=Project1, ErrorMsg=DSR.ADMIN: Record Project1 in file UV.ACCOUNT - does not exist
2018-04-18 12:09:01 (dsadm,admin): <ERROR> Project delete finished with error: name=Project1, ErrorMsg=DSR.ADMIN: Record Project1 in file UV.ACCOUNT - does not exist
2018-04-18 12:09:01 (dsadm,admin): Project creation started on server: name=Project1, path=/opt/IBM/InformationServer/Server/Projects/Project1
2018-04-18 12:09:08 (dsadm,admin): Adding project to xmeta repository: name=Project1, host=ILMT, locale=ENU
2018-04-18 12:10:08 (dsadm,admin): The following accounts are on the system: number=8, accounts=uvDSdsUVdsproj1ANALYZERPROJECTDataClickProject1
2018-04-18 12:10:08 (dsadm,admin): Project creation finished OK: name=Project1, host=ILMT
~
indicates project : project1 creation=ok
any idea why this occurs and how to correct ?
thanks for all info
best regards, Guy Przytula
Best Regards, Guy Przytula
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

If you do a "ls /data/ISServer/Projects/dsproj1" from a console session, how many files are there in the Directory? (there should be a number of files including one called "VOC").

What is the exact error message if you try to open the Designer to that Server and "proj1"?
przytulaguy
Participant
Posts: 14
Joined: Fri Jun 19, 2009 5:39 am
Location: KERMT

Post by przytulaguy »

thanks for the update
there are 89 files/dir in this directory and
/data/ISServer/Projects/dsproj1/D_VOC

I tried to logon and can ..no error
looking in admin : all the broken have gone away : all are normal
I do not know what happened.. all seems ok
best regards, Guy
Best Regards, Guy Przytula
przytulaguy
Participant
Posts: 14
Joined: Fri Jun 19, 2009 5:39 am
Location: KERMT

Post by przytulaguy »

something very strange
doing again logon and all projects again broken
the message is
the project can not be found in the repository.. (dsproj1)
looking in xmeta db i could find these projects
ANALYZERPROJECT
DataClick
Project1
dsproj1

4 record(s) selected.

[db2repos@ilmt ~]$ db2 "select NAME_XMETA from xmeta.DATASTAGEX_DSPROJECT"
Best Regards, Guy Przytula
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

I asked about the Directory since I've seen Problems when the user had insufficient Access rights to create files and that caused a corrupt Project (with no files) to be created. This isn't the case for your Installation, since it worked once.

Could you Login to the Project using the designer or developer and post the error message?
PaulVL
Premium Member
Premium Member
Posts: 1315
Joined: Fri Dec 17, 2010 4:36 pm

Post by PaulVL »

Make sure your ports between the Client and the Engine are open.

There is a wide range of ports.
przytulaguy
Participant
Posts: 14
Joined: Fri Jun 19, 2009 5:39 am
Location: KERMT

Post by przytulaguy »

I have de-activated the firewall completely
Best Regards, Guy Przytula
przytulaguy
Participant
Posts: 14
Joined: Fri Jun 19, 2009 5:39 am
Location: KERMT

Post by przytulaguy »

and tried again - and again can use project
did not left it yet - creating a job
Best Regards, Guy Przytula
przytulaguy
Participant
Posts: 14
Joined: Fri Jun 19, 2009 5:39 am
Location: KERMT

Post by przytulaguy »

as long as I stay in designer I can create save jobs..
when leaving and connecting again I get
error message:failed to find an entry for the ds designer and project in the repository
the project Project1 can not be found in the repository..
Best Regards, Guy Przytula
PaulVL
Premium Member
Premium Member
Posts: 1315
Joined: Fri Dec 17, 2010 4:36 pm

Post by PaulVL »

Look at your project directory and ensure that you have group RW bits set on all of those files.

is there a mount that went to 100%?

Did your hostname change? (HA failover setup?)
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

I note that you created dsproj1 but, the next day, tried to delete Project1 (a different project name).

It's probably a bug that adding Project1 to XMETA and creation of Project1 are reported to stdout/stderr.

I'd suggest running syncproject on the eight projects that do exist.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
przytulaguy
Participant
Posts: 14
Joined: Fri Jun 19, 2009 5:39 am
Location: KERMT

Post by przytulaguy »

yes the authority is the problem
install was done with root
the project directoy is owned by root and only dsproj1 exists
some other files in other directories are also only allowed to be used by root
most of them are dsadm as it should
did uninstall of engine and trying new install of engine and see if problem corrected
will feedback after new install
best regards, Guy
Best Regards, Guy Przytula
Post Reply