Page 1 of 1

Datastage serives down and port issue 8881

Posted: Sat Jul 25, 2015 7:28 am
by mandyli
Hi

we are in process of install Datastage 9.1 and doing configuration on new host with AIX 7.1 . we have installed and created some projects also. In sudden our datastage services are down and projects deleted from the /opt/IBM/Projects folder. when we try to restart the services we got following error"
The system cannot create a SOAP connector to connect to host aaa.bbb at port 8881 " and also I am seeing following error from "DSAuditTrace" file.
//-------------
015-07-20 17:10:50 (,0): The following accounts are on the system: number=6, accounts=uv?DS?ds?UV?dstage1?DataClick
2015-07-20 17:10:50 (,0): Project creation finished OK: name=DataClick, host=aaa.bbb

2015-07-21 18:05:26 (dsadm,admin): Project deletion from xmeta repository finished: name=SAMPLE_PROJECT, host=aaa.bbb, result=0
2015-07-21 18:05:26 (dsadm,admin):"

//------------------------------------------------

Is this any issue with file system or something happened with corruption on XMETA ?

Thanks for your help.

Thanks
Man

Posted: Sat Jul 25, 2015 3:26 pm
by ray.wurlod
It appears that someone has been deleting projects.

Posted: Sat Jul 25, 2015 4:20 pm
by mandyli
Thanks Ray,

I hope I am seeing project list from XMETA and also I am seeing from Datastage Admin ,but when I select the projects I am getting error this project not present in UV.

HOSTNAME_XMETA INSTANCETAG_XMETA NAME_XMETA
----------------- ------------------- --------------------------
aaa.bbbb Test_ds_ptst
aaa.bbbb SAMPLE_PROJECT
aaa.bbbb DW_uat

I hope I have to clean from XMETA also. Is this correct ?

any idea about port issue 8881?


Thanks
Man

Posted: Sun Jul 26, 2015 7:38 am
by PaulVL
Could the mount for the projects have been dis-mounted? That would cause the mount path to revert back to a root entry and thus appear empty.

Posted: Mon Jul 27, 2015 5:51 am
by mandyli
Thanks for your reply.

Is there any idea about port 8881 issue ?


Thanks
Man

Posted: Mon Jul 27, 2015 6:53 am
by chulett
Have you tried searching? Found several references to that message including this one. Could be the same person that is deleting projects.

Posted: Tue Jul 28, 2015 10:23 am
by mandyli
Thanks Lot.

But we never installed or uninstalled any software . I can't able to ping and listen 8881 port on same Datastage server itself.

working in another server :

$ telnet a006 8881
Trying...
Connected to a006
Escape character is '^]'.
Connection closed.

Issue server :

$ telnet a008 8881
Trying...
telnet: connect: A remote host refused an attempted connect operation.

Thanks
Man

Posted: Tue Jul 28, 2015 10:36 am
by chulett
Time to involve support.

Posted: Fri Jul 31, 2015 3:10 pm
by mandyli
Hi

I have fixed this issue. there is some issue with XMETA id and password setup.

I followed following steps :

1) I have tested Xmeta user log into Xmeta db outside of Information Server then run the AppServerAdmin.sh script

from /opt/IBM/InformationServer/ASBServer/bin/ path.

./AppServerAdmin.sh -db -user xmeta -password xxxxxxx

After resolving XMETA password issue, run below step to verify if it returns "Info Connection to the database OK " status.
./AppServerAdmin.sh -w -time 1

and works fine.

2) Missing projects I restored using "./SyncProject.sh" project.

1). Log to DataStage server as root.
2). Go to opt/IBM/InformationServer/ASBNode/bin/
./SyncProject.sh -ISHost <Host name of the services tier:Port> -ISUser <User ID> -ISPassword <Password> -project <Project name> -report /tmp/myprojrep.txt


Thanks
Man