If you are unable to create a new account, please email support@bspsoftware.com

 

Cognos Data Manager Job Execution Issue

Started by Aayush11, 29 Oct 2013 06:01:05 AM

Previous topic - Next topic

Aayush11

I am executing a DS job which fails at the procedure node with the error:
[DBNETLIB] Server does not exists or access denied.
[DBNETLIB] ConnectionOpen Connect(()).

Actually the Procedure node is executing a stored procedure which is on the other server (database server) and the stored procedure is working fine in the database server.Following is the logic in the procedure node:
IF(NOT EXEC_SP('procedure_name'))
THEN EXIT(-1);
Also EXEC_SP is a function which is defined and holds expressions for two variable database (lookup from the target connection),server(lookup from the target connection) and a $cmd variable which I think establishes connection to the server (Database server) and the database.
But when I test this function it displays the output value but it also shows the same cmd error
[DBNETLIB] Server does not exists or access denied.
[DBNETLIB] ConnectionOpen Connect(()).

Please help me with this issue as I got stuck at this point and cannot perform the job successfully.Any help would be greatly appreciated.Thanks.

MFGF

Hi,

I don't think you can use a procedure node to call a stored procedure in a database directly You would perhaps use a SQL() function or a SQL Node? When you refer to EXEC_SP as being a function, do you mean it's an external UDF, compiled into a dll? If so, my money is on the coding of this being flawed somewhere.

MF.
Meep!