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.