DSXchange

thanks all for your responses. I have got the solution of the issue.

I have added the client systems under DNS server which resolve the hostnames for server, engine, database and client machines.

Sorry to say but I have no other word but to say "Nothing"

Hi Prasson,

No, datastage password is not expired. As team can login datastage server
admin web console with same user id and password.

Hello craig,

to everyone.

Hi, The issue I am facing is not related to job creation, however it is related to datastage administration. I am not able to login datastage designer client, an error comes while login: 'Failed to authenticate the current user against the select Services Tier port out of range: -1'. It was working ...

Thanks you all (kunal,ray and arndw) for replying the topic, I got the issue resolved by applying link sort on input link of Join stage over 'country_code' which is a key field of Join stage. Now the result is as expected.

Hi, I am not able to use the join stage properly and getting wrong result. I have two tables : Table A and Table B Table A has following columns: Country varchar (50), Country_code varchar(10) Table B has : Country_code varchar(10), Car_name varchar(10) Table A records: Country_code Country --------...

resolved:
Please check if any listener port such as orb_listener port is not having 0 value and also not equal to any other websphere cluster node port.
Assign unique port number and restart the server.

Yes you are right I haven't sorted the records and now it is working fine.

Hello, I am stuck with an issue doing vertical pivot by pivot enterprise stage. The issue is that sequence of columns generated from rows are not as expected. For ex: I have the data as: Sale1 100 Sale1 200 Sale1 300 Sale2 400 Sale2 500 Sale2 600 wants to convert as: sale1 100 200 300 sale2 400 500 ...

Hi Rajan, No not at run time. I am facing this error even on clicking on datasource button (under ODBC connector). I am not able to locate any service running on port no. 31531 when I run netstat -an command. I have tried to stop and start nodeagent and engine many times but have not found any succe...

I am trying to add datasource in "ODBC Connector" But following error is coming "Failed to send the request to the handler: The agent id <<hostname:31531>> is not available." I have used netstat -an |grep 3153 and following entries are coming: tcp 0 0 *.31533 *.* LISTEN tcp 0.0 *...

By bundled Webpshere I mean that I have used the websphere which comes along with datastage 8.5 assembly (from passport advantage)

got the solution of the problem by using bundled websphere.

Hi Chulett, Did you have any solution for the above mentioned issue, or you want me to describe further about the issue. I am not able to understand about your reply " Did you?" . I am struggling to solve the issue for last 10 days and not able to figure out the solution for the same. So p...