Page 1 of 1

projects are broken

Posted: Wed Apr 18, 2018 4:31 am
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

Posted: Wed Apr 18, 2018 5:02 am
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"?

Posted: Wed Apr 18, 2018 6:27 am
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

Posted: Wed Apr 18, 2018 6:32 am
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"

Posted: Wed Apr 18, 2018 8:55 am
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?

Posted: Wed Apr 18, 2018 11:31 am
by PaulVL
Make sure your ports between the Client and the Engine are open.

There is a wide range of ports.

Posted: Wed Apr 18, 2018 12:15 pm
by przytulaguy
I have de-activated the firewall completely

Posted: Wed Apr 18, 2018 12:25 pm
by przytulaguy
and tried again - and again can use project
did not left it yet - creating a job

Posted: Wed Apr 18, 2018 12:45 pm
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..

Posted: Wed Apr 18, 2018 12:58 pm
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?)

Posted: Wed Apr 18, 2018 9:49 pm
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.

Posted: Fri Apr 20, 2018 3:22 am
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