Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

ERROR:"Msg 3701, Level 16, State 15, Procedure sp_dropextendedproc, Line 18
Cannot drop the procedure 'xp_jdbc_XXXXX', because it does not exist or you do not have permission."
get generated when executing instjdbc.sql
Problem Description

The following errors get generated when executing the instjdbc.sql script​:

Msg 3701, Level 16, State 15, Procedure sp_dropextendedproc, Line 18
Cannot drop the procedure 'xp_jdbc_open', because it does not exist or you do not have permission.
Msg 3701, Level 16, State 15, Procedure sp_dropextendedproc, Line 18
Cannot drop the procedure 'xp_jdbc_open2', because it does not exist or you do not have permission.
Msg 3701, Level 16, State 15, Procedure sp_dropextendedproc, Line 18
Cannot drop the procedure 'xp_jdbc_close', because it does not exist or you do not have permission.
Msg 3701, Level 16, State 15, Procedure sp_dropextendedproc, Line 18
Cannot drop the procedure 'xp_jdbc_close2', because it does not exist or you do not have permission.
Msg 3701, Level 16, State 15, Procedure sp_dropextendedproc, Line 18
Cannot drop the procedure 'xp_jdbc_start', because it does not exist or you do not have permission.
Msg 3701, Level 16, State 15, Procedure sp_dropextendedproc, Line 18
Cannot drop the procedure 'xp_jdbc_start2', because it does not exist or you do not have permission.
Msg 3701, Level 16, State 15, Procedure sp_dropextendedproc, Line 18
Cannot drop the procedure 'xp_jdbc_end', because it does not exist or you do not have permission.
Msg 3701, Level 16, State 15, Procedure sp_dropextendedproc, Line 18
Cannot drop the procedure 'xp_jdbc_end2', because it does not exist or you do not have permission.
Msg 3701, Level 16, State 15, Procedure sp_dropextendedproc, Line 18
Cannot drop the procedure 'xp_jdbc_prepare', because it does not exist or you do not have permission.
Msg 3701, Level 16, State 15, Procedure sp_dropextendedproc, Line 18
Cannot drop the procedure 'xp_jdbc_prepare2', because it does not exist or you do not have permission.
Msg 3701, Level 16, State 15, Procedure sp_dropextendedproc, Line 18
Cannot drop the procedure 'xp_jdbc_commit', because it does not exist or you do not have permission.
Msg 3701, Level 16, State 15, Procedure sp_dropextendedproc, Line 18
Cannot drop the procedure 'xp_jdbc_commit2', because it does not exist or you do not have permission.
Msg 3701, Level 16, State 15, Procedure sp_dropextendedproc, Line 18
Cannot drop the procedure 'xp_jdbc_rollback', because it does not exist or you do not have permission.
Msg 3701, Level 16, State 15, Procedure sp_dropextendedproc, Line 18
Cannot drop the procedure 'xp_jdbc_rollback2', because it does not exist or you do not have permission.
Msg 3701, Level 16, State 15, Procedure sp_dropextendedproc, Line 18
Cannot drop the procedure 'xp_jdbc_forget', because it does not exist or you do not have permission.
Msg 3701, Level 16, State 15, Procedure sp_dropextendedproc, Line 18
Cannot drop the procedure 'xp_jdbc_forget2', because it does not exist or you do not have permission.
Msg 3701, Level 16, State 15, Procedure sp_dropextendedproc, Line 18
Cannot drop the procedure 'xp_jdbc_recover', because it does not exist or you do not have permission.
Msg 3701, Level 16, State 15, Procedure sp_dropextendedproc, Line 18
Cannot drop the procedure 'xp_jdbc_recover2', because it does not exist or you do not have permission.

Cause

The instjdbc.sql script file first drops existing procedure definitions and then creates the extended stored procedures. Since it is a new SQL Server installation, these extended stored procedures may not exist in the master database.

Solution

​You can safely ignore these errors as long as the following "Extended Stored Procedures" are present in the Master schema in Databases\master\Programmability.

'xp_jdbc_close'

'xp_jdbc_close2'

'xp_jdbc_start'

'xp_jdbc_start2'

'xp_jdbc_end'

'xp_jdbc_end2'

'xp_jdbc_prepare'

'xp_jdbc_prepare2'

'xp_jdbc_commit'

'xp_jdbc_commit2'

'xp_jdbc_rollback'

'xp_jdbc_rollback2'

'xp_jdbc_forget'

'xp_jdbc_forget2'

'xp_jdbc_recover'

'xp_jdbc_recover2'

Last message should be:

creating JDBC XA procedures
instxa.sql completed successfully.
More Information

Starting from Informatica Data Quality 9.5.1 HotFix 1, arbitrary calls to HT transactional are done by using an implementation of JTA (Java Transaction API) and a (XA) datasource, which support distributed transactions.


For more information, see KB 148995 Unable to create contents for the "Human Task" database in Informatica 9.5.1 HotFix1

Applies To
Product: Data Quality
Problem Type:
User Type: Administrator
Project Phase:
Product Version: Data Quality 9.5.1
Database: Microsoft SQL Server 2008
Operating System: Windows
Other Software:

Reference
Attachments
Last Modified Date:7/12/2013 2:17 AMID:150171
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)