Failed To open the Project ( Status code = 81016 )

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
BIuser
Premium Member
Premium Member
Posts: 238
Joined: Thu Feb 02, 2006 4:03 am
Location: South Africa

Failed To open the Project ( Status code = 81016 )

Post by BIuser »

Hi All,

We are running Jobs on 8.5

We recently moved our code to New Test box and the project name is Test_GE.

We dont have any issues while opening the project Or Runinng the Jobs in the project from Director

But while running the jobs from the Command prompt we are getting the following error message

ERROR: Failed to open project

Status code = 81016


Belwo are the steps we followed
1) cd `cat /.dshome`
2) . ./dsenv
3) /IIS/InformationServer/Server/DSEngine/bin/./dsjob -run -jobstatus Dev_GE STTUS_CONTROL

After failing the above steps we tried to list the Projects uisng the command

/IIS/InformationServer/Server/DSEngine/bin/./dsjob -lprojects

Result is same

In addition to the above We tried to check if dsrpcd is running uisng command

ps -ef | grep dsrpcd | grep -v grep

below is the result for it

root 7995438 1 0 Feb 07 - 0:00 /IIS/InformationServer/Server/DSEngine/bin/ab1dsrpcd


Please advise why we are not able to find the project while running through Command Prompt
-------------------------
https://www.ssa.co.za
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Supply all of the proper credentials - user, password, domain at a minimum.
-craig

"You can never have too many knives" -- Logan Nine Fingers
BIuser
Premium Member
Premium Member
Posts: 238
Joined: Thu Feb 02, 2006 4:03 am
Location: South Africa

Post by BIuser »

Hi Chullet,

With the same command we are able to run on the dev boxes .

With User names and passwords , below is the error message

/IIS/InformationServer/Server/DSEngine/bin/./dsjob -server setlap1 -user dsadm -password icek8tul -run -jobstatus DEV_GE STTUS_CONTROL

ERROR: Failed to open project


Status code = -1010 DSJE_DOMAINLOGTOFAILED


I am not able to list the projects as well using teh belwo command

/IIS/InformationServer/Server/DSEngine/bin/./dsjob -lprojects

OutPut is :

Status code = 81016

Please advise ,
-------------------------
https://www.ssa.co.za
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

You left out the domain.
-craig

"You can never have too many knives" -- Logan Nine Fingers
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

I'll assume that's not your real password...

FYI: You don't need an extra ./ in your full path to dsjob. A ./ prefix is most useful when executing a command from the command line where the command is in your current working directory but the current working directory is not in your PATH.

For both the -domain and -server options, it will be good for you to specify appropriate port numbers after those values. For example ... -server servername:portnumber.
Choose a job you love, and you will never have to work a day in your life. - Confucius
BIuser
Premium Member
Premium Member
Posts: 238
Joined: Thu Feb 02, 2006 4:03 am
Location: South Africa

Post by BIuser »

Hi ,

Thnaks for you rsuggestion

I tried to run the below command


/IIS/InformationServer/Server/DSEngine/bin/dsjob -domain detldb1N:9080 -user c35430133 -password c35430133 -server detlap1N -lprojects


Below is the output

Status code = 81016


Same command is getting executed in the dev box with out any issues

I have checked the RPC and is running

Please advise


Regards
BI User
-------------------------
https://www.ssa.co.za
BIuser
Premium Member
Premium Member
Posts: 238
Joined: Thu Feb 02, 2006 4:03 am
Location: South Africa

Post by BIuser »

Hi All,

I ran the command grep dsrpc /etc/services , and below is the output


ad1dsrpc 31538/tcp # RPCdaemon DSEngine@/IIS/InformationServer/Server/DSEngine
ab1dsrpc 31548/tcp # RPCdaemon DSEngine@/IIS/InformationServer/Server/DSEngine



is it correct to have two entries for dsrpc ?

On the other server which is working fine i have only one entry for dsrpc for with port number 31538

Please advise if this is the problem


Regards
-------------------------
https://www.ssa.co.za
kandyshandy
Participant
Posts: 597
Joined: Fri Apr 29, 2005 6:19 am
Location: Singapore

Post by kandyshandy »

:shock: Is it possible to have 2 port numbers for the same engine?
Kandy
_________________
Try and Try again…You will succeed atlast!!
BIuser
Premium Member
Premium Member
Posts: 238
Joined: Thu Feb 02, 2006 4:03 am
Location: South Africa

Post by BIuser »

Hi All,

I got this problem sresolved by appending Port number to the Servername


/IIS/InformationServer/Server/DSEngine/bin/dsjob -domain detldb1N:9080 -user c35430133 -password c35430133 -server detlap1n:31548 -lprojects

Thanks for your support


Regards
-------------------------
https://www.ssa.co.za
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

kandyshandy wrote:Is it possible to have 2 port numbers for the same engine?
Not that I know of, but it's entirely possible to have 2 engines on the same server, each with a separate port number.
Choose a job you love, and you will never have to work a day in your life. - Confucius
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

BIuser wrote:I got this problem sresolved by appending Port number to the Servername
Glad you got it working! If you do have multiple instances running side by side on the same server, then you just have to be extra careful when you specify port numbers for the -domain and -server options.
Choose a job you love, and you will never have to work a day in your life. - Confucius
Post Reply