Error saving map. Stored procedure returned non-zero result. Check if source and target schemas are present.
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
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.
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
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
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
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
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
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
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
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
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
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
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
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
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
I am using Jdeveloper 220.127.116.11 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
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
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
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
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