SQLSever - SQLSTATE = 42000, fNativeError = 2754

[Aquilis]

hi all,

Trying to Invoke a SQL-Server Stored procedure from DataStage. Am encountering below Fatal error.
a. Unfortunately same stored procedure is invoked in different job with same input parameter and is working fine.
b. Also, same job is working fine in other enviroments.
c. Stored procedure is workign fine, if I execute it directly in database.
d. Verified the privielges on stored procedure and everything seems fine.

Missing something. Am not able to figure out what's hapepning around with it.

Code: Select all

Warning: SQLSTATE = 42000, fNativeError = 2754
Fatal Error: Fatal: [IBM(DataDirect OEM)][ODBC SQL Server Driver][SQL Server]Error severity levels greater than 18 can only be specified by members of the sysadmin role, using the WITH LOG option.

[ray.wurlod]

Is the user who is invoking from Datastage a member of sysadmin role?

[Aquilis]

All other jobs are working with same user and more over same procedure being triggered from different jobs with different hardcoded value.

I feel it's related to database, SQL server.

[SURA]

a. Unfortunately same stored procedure is invoked in different job with same input parameter and is working fine.
b. Also, same job is working fine in other enviroments.

I do noticed ( not the same issue) sometimes Datastage behaves bit strange! That too, these kind of issues will come to the jobs ( not all ) which was modified & recompiled !

Datastage may fails to overwrite the behind the screen files properly could be the reason I guess ( Gurus please correct me if my thought is wrong )

1) Fine , you said working fine in other env? The other is Dev/ ?

2) Delete the job where it is not working and import the job from other env where it is working fine!

Let us know the outcome .