Admin Error: OPENSEQ failed on Project

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
carlosfelipevfs
Participant
Posts: 2
Joined: Mon Jan 19, 2009 1:37 pm

Admin Error: OPENSEQ failed on Project

Post by carlosfelipevfs »

Hi,

configuration:

Red Hat linux 64
DataStage 8.0
Oracle 10g R2

Erro

DSR_Parseconfig: OPENSEQ of
/opt/IBM/InformationServer/Server/PXEngine/etc/master_config.apt ELSE
clause, STATUS() = 2

Who can help?

Thanks
Felipe
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Status 2 is "file not found". Please check the correct spelling and casing of the file name - file names on UNIX are case-sensitive.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
carlosfelipevfs
Participant
Posts: 2
Joined: Mon Jan 19, 2009 1:37 pm

Post by carlosfelipevfs »

Thanks,
asorrell
Posts: 1707
Joined: Fri Apr 04, 2003 2:00 pm
Location: Colleyville, Texas

Post by asorrell »

I just got this myself and figured out the solution. This message appears when you open the Administrator on a project and your id doesn't have write access to the PXEngine/etc sub-directory.

I opened the Administrator as dsadm, no error message. Opened the project while logged in as my id (which is authorized as an administrator) - error message. Checked and the access write for the PXEngine/etc sub-directory didn't give the "dstage" group write access.

Do a chmod 775 on that directory and the problem goes away.

Code: Select all

$ pwd
/opt/IBM/InformationServer/Server/PXEngine
$ ls -ld etc
drwxr-xr-x  3 dsadm dstage 2048 Oct 22 17:36 etc
$ chmod 775 etc
$ ls -ld etc
drwxrwxr-x  3 dsadm dstage 2048 Oct 22 17:36 etc
Andy Sorrell
Certified DataStage Consultant
IBM Analytics Champion 2009 - 2020
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

That's one of the reasons to install with umask 022.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
philds
Participant
Posts: 8
Joined: Wed Sep 01, 2004 11:09 am

Post by philds »

Actually, umask 022 is what the installation guide or release notes asks for.

I did follow the instructions:
umask 022
./install -is:tempdir /tmp -console

and get the same error msg for the same reason...
...because umask 022 is actually setting the group read only :
>umask 022
>umask -S
u=rwx,g=rx,o=rx

That's probably still better than having to many directories in
"g+w" but they should either fix the dir as a post-install task or change the client to check that the file is there or the dir is writable before trying to open/create it.

As suggested upper in the thread, chmod g+w on the etc dir got rid of the error message.
ritusethi
Participant
Posts: 8
Joined: Thu Dec 04, 2008 11:41 am

Post by ritusethi »

I would like to add that I saw the same error on one of the machines we had configured and changing permissions to the etc directory had nothing to do with the issue .
The issue here was that the path of the parallel files like APT_ORCHHOME was incorrect in the DSParams file and once that was fixed it resolved the issue .

Lesson learnt .. before copying the DSParams file make sure the environments with their paths are the same in source and destination of copy . :roll:

Thanks
Ritu Sethi
Ritu Sethi
Post Reply