Error saving map. Stored procedure returned non-zero result. Check if source and target schemas are present.

Advertisement
I am using VS 2012 and BizTalk 2013 and attempting to deploy an application to BizTalk when I get these errors:
Error 47
at Microsoft.BizTalk.Deployment.Assembly.BtsMap.Save()
   at Microsoft.BizTalk.Deployment.Assembly.BtsArtifactCollection.Save()
   at Microsoft.BizTalk.Deployment.Assembly.BtsAssembly.Save(String applicationName)
   at Microsoft.BizTalk.Deployment.BizTalkAssembly.PrivateDeploy(String server, String database, String assemblyPathname, String applicationName)
   at Microsoft.BizTalk.Deployment.BizTalkAssembly.Deploy(Boolean redeploy, String server, String database, String assemblyPathname, String group, String applicationName, ApplicationLog log)
0 0
Error 49
Failed to add resource(s). Change requests failed for some resources. BizTalkAssemblyResourceManager failed to complete end type change request. Failed to deploy map "XXX.BTS2013.XXX.Maps.map_XXXX_R01_InsLabProc".
Error saving map. Stored procedure returned non-zero result. Check if source and target schemas are present. Error saving map. Stored procedure returned non-zero result. Check if source and target schemas are present.
0 0
Error 46
Failed to deploy map "XXX.BTS2013.XXX.Maps.map_XXXX_R01_InsLabProc".
Error saving map. Stored procedure returned non-zero result. Check if source and target schemas are present.
0 0
I also tried to Import a MSI file from our test environment to see if that would work...got the same errors.  After spending hours (not kidding) looking for an answer, all I could find is that a hotfix would work.  So, I got the hotfix from Microsoft
Support and applied it then rebooted.  Still getting the same errors.  I'm absolutely at a stand still.  Interesting that I got this application to deploy yesterday and then the next time I deployed it I started getting these errors.  I'm
ready to pull my hair out!
Is there an answer for this out there somewhere?  Any help would be appreciated.
Thanks,
Dave
Advertisement

Replay

Hi Dave,
Which hotfix have you applied? I don't think a hotfix of this issue is available for BizTalk 2013 yet. You should create a
support ticket with Microsoft to get a solution.
If this answers your question please mark as answer. If this post is helpful, please vote as helpful by clicking the upward arrow mark next to my reply.

Error in calling Stored procedure returns REFCURSOR

Hi, I've written a oracle stored procedure returning REFCURSOR. say,extractorderdespatchconfirmsp('','','','','','H1','ACG','','','','',:rc). Following statement throwing error. CallableStatement cs = con.PrepareCall("{extractorderdespatchconfirmsp('

ERROR-Logging of Stored Procedure (Stop / Going on after error + logging)

Hi @all, I am using a Stored Procedure which is very simple: =>The stored procedure is selecting many tousands of records from table1 + table2. => Some values (records) will be summarized (aggregated/group by). =>After this selection and summariz

Error when stored procedure returns cursor in pro c

Hi I was trying to make work the stuff explained at [m-2537153] It executes a stored procedure from pro c that returns a cursor. But when i compllie at pro c I get following error. My procedure name is TEST. If i change the output parameter to a int

Got error when creating stored procedure

Hi, I am a rookie in Oracle. I created a stored procedure: create or replace procedure my_first_sp as begin select cid from actions where rownum<3; end; And I got an error : "**** compilation error" After I "show error" I got the de

Stored procedure returning multiple records without using SYS_REFCURSOR

Hello, I am new to oracle stored procedures, have done stored procs in SQL server in past. I am trying to write single stored proc which will return multiple records. I have the stored proc as below and that is compiled without any errors. We don't w

Error executing a stored procedure from SSIS using the MERGE statement between databases

Good morning, I'm trying to execute from SSIS a stored procedure that compares the content of two tables on different databases in the same server and updates one of them. To perform this action, I've created a stored procedure in the destination dat

Calling stored procedure returning result set

Hi all, i know this issue is discussed quite often. I did not find an answer in the forums, not in the manual and even not in the examples for stored procedure. So i try it here once more :) Description: GET_SKS: The GET_SKS procedure is used to gene

Stored Procedure Returning Multiple Rows

Hello. Where can I find sample code from a class that calls a stored procedure that returns multiple rows? I have a servlet that calls the DB directly from the servlet & loops through the result set. I want to put that code into a stored procedure, b

How to stop SQL Server Agent Job if Stored Procedure returns value 0

I have SQL Server 2012 SSIS. I have 2 SSIS packages. I have created SQL Server Agent Job for running packages. I have created steps. If first step have run succesfully next step is run. I have need to add new logic. I have validation stored procedure

Error calling Java Stored Procedure

hi I am calling java stored procedure from jdbc. i am getting wierd exceptions: CallableStatement cstmt = conn.prepareCall("begin SEND_MAIL(?,?,?);end;"); cstmt.setString(1,"[email protected]"); cstmt.setString(2,"Mail from Stored

Stored Procedure returning just one row

Hi! I've a problem with a MSSQL Stored Procedure. This procedure works perfectlly if I execute it directly on MSSQL Query Analyzer. But the problem is in Java, when I call it, the resultset has just one row, and it must have 59, so I don't know what

Java- Stored Procedure with Call by Result

Hi Oracle-Community, I am looking for some example Code how to use a Java-Stored Procedure with Out-Parameters. Don't get me wrong. I dont want to call a Procedure with Out Parameters from Java (there are a lot of examples for this out there) . I jus

Non zero values in the extraction of the planning area

In our DP implementation we have been trying to extract 2 key figures  from the planning area, one of the key figures might have zero values, when we set the indicator for the non zero values then it only eliminates the records for which both the key

Retriving data through stored procedure returning Table of object type

I am trying to retrieve the data returned as a table(secret_tab_type) of object type(secret_type). Now we can get the secret_tab_type table through rset = (ResultSet) cstmt.getObject(1); but how to map the SQL object type to Java object type ?? FUNCT

Error when calling Stored Procedure from backing bean

I am using Jdeveloper 11.1.1.6 and am trying to utilize the following URL to execute a SP from a backing bean: http://ramannanda.blogspot.com/2011/11/optimized-update-insert-adf.html The reason I am looking at this is currently I have coded my backin

When I am on facebook I continually get a syntax error message which keeps coming back. I have checked my settings and enabled java script but doesnt help.

I can access my facebook account with no trouble, but once facebook is loaded I repeatedly get an error message; syntax error. The words 'Java Script application' are in the bar across the top of the message. It comes up many times and completely dis

Disconnected rowset CachedRowSet from a select inside stored procedure?

Hello everyone I am using CachedRowSet returning it from a parameterised select statement and it works fine. If I put the same select statement into a simple read-only stored procedure then I get this exception: "A result set was generated for update

Calling a stored procedure with default parameters

Dear all, I am trying to call a stored procedure that has not all the parameters compulsory, and indeed, there are some I am not interested in. Therefore, I would like to call the stored procedure initializing only some of the parameters but if I mis

Stored Procedure for Zero Price in GRPO

Hi all,    Can anybody let me know the required stored procedure for restricting zero price in the GRPO transaction . Thanks in advance , AdityaUse this in your SBO_SP_TransactionNotification IF @transaction_type = 'A' AND @object_type = '20' BEGIN I