Forum Replies Created
-
AuthorPosts
-
Hi Ram,
From the article you mentioned in your post, to answer your question “How we can create the User environment varible like DBLIB.EMPLOYEEUTIL?”, it depends on the OS of your workstation where you installed and are using that sample application:
1) If it’s Windows XP, right-click on My Computer icon on the desktop, choose Properties option to open the System Properties window, then select the Advanced tab, then click on the Environment Variables button at the bottom to open the Environment Variables window, then click on the New button for the User variables section, and follow the instructions in that article to create the user environment variable.
2) If it’s Windows Server 2003, click on Start -> Administrative Tools -> Computer Management to open the Computer Management window, then right-click on the Computer Management folder and select Properties option to open the Computer Management Properties window, select the Advanced tab and click the Settings button in the Environment variables section to bring up the Environment variables window, then click on the New button for the User variables section, and follow the instructions in that article to create the user environment variable.
Hope this helps,
Daniel.
Hi,
Are you looking for something like what the following blog explains?
http://seroter.wordpress.com/2007/01/02/orchestration-handling-of-suspended-messages/
Daniel.
July 6, 2010 at 7:45 AM in reply to: Call Assembly in an Orchestration and use return code to delete dataset in Msgbox #25146Hi wal,
Read this BizTalkGurus blog on the use (or misuse) of atomic scope in an orchestration:
It all depends on how your .NET assembly is constructed and whether or not it requires state (and therefore serialization).
Daniel.
Hi,
Before that I was getting the following error –
Due to an Oracle Client limitation, the adapter failed to open a connection. This is because either (a) ambient transaction is present and the TNS alias is longer than 39 characters, or (b) ambient transaction is present and a non-TNS based URI was used. To resolve this, use a TNS alias to connect to Oracle and make sure it is not more than 39 characters.
And when I resolved the upper issue by putting the TNS alias name I am getting something which I am not able to understand. Please see the error below –
The adapter failed to transmit message going to send port “WcfSendPort_OracleDBBinding_PAYHUB_ADMIN_Table_PH_RESPONSE_MESSAGES_Custom” with URL “oracledb://abretail”. It will be retransmitted after the retry interval specified for this Send Port. Details:”Microsoft.ServiceModel.Channels.Common.TargetSystemException: ORA-06550: line 2, column 231:
PL/SQL: ORA-00917: missing comma
ORA-06550: line 2, column 1:
PL/SQL: SQL Statement ignored —> Oracle.DataAccess.Client.OracleException ORA-06550: line 2, column 231:
PL/SQL: ORA-00917: missing comma
ORA-06550: line 2, column 1:
PL/SQL: SQL Statement ignored at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()
at Microsoft.Adapters.OracleCommon.OracleCommonUtils.ExecuteNonQuery(OracleCommand command, OracleCommonExecutionHelper executionHelper)
— End of inner exception stack trace —
Please give me thoughts on this regard.
Thanks
Amit Sahu
What a strange error. I can confirm that this method worked for me as well.
We are experiencing this issue using the adapter pack with BizTalk 2009 on a Windows Server 2008 environment. The registry key specified in the article HKEY_LOCAL_MACHINE\Software\Microsoft\BizTalkAdapters\ does not even exist.
We can “work around” the issue by adding the domain BizTalk service account to the local administrators group, however this isn’t obviously a security best practice solution.
Maps are only executed when the MessageType of the message matches the input schema of your map. If you use a pass-thru pipeline then the MessageType is not promoted and the map will not be executed.
If you specify the XmlReceive pipeline on your receive location this will promote the MessageType property and then your map should be executed.
Hi Greg,
I am not using any XML disassembler in the receive pipeline even i am not using any pipeline file. Just created 2 schemas and one map for mapping. Then depoyed the solution. In the send port i am calling the map. Is this the right procedure i m following. or do i need to do some other thing?
Regards,
Where are you using the map, in the receive port or send port?
Are you using the XmlDisassembler in the receive pipeline?OK – time for eating crow. I restarted the box and now it works. i guess something was cached. But what? I had started and stopped BizTalk several times and also stopped and started the host instance. Refreshed and restarted several times. So, it may be somewhere else in the OS that this was cached?
So – it works – if for no other reason than by accident. Well, at least I know I can still VB code 🙂
Hi Daniel,
How interesting that you and Yonathan are friends?
Anyway, I actually followed that article and made it work last month for my first BizTalk project. I uninstalled and installed jsdtc again but I don’t know why it’s not working anymore.
Both projects are just testing projects for learning purpose only. I am actually a c# web application developer. Our company has just introduced BizTalk and everybody got 5-day training. Since I like the way of thinking when developing BizTalk projects, like an architect, I am trying to learn more. I am kind of stuck now. I may simply stop here.
I don’t know if I’ll ever be assigned to work on real BizTalk projects. If that day comes, I’ll definitely post more questions here again.
Thank you and Yonathan again. It has been a pleasure to communicate with you both.
Lynn
Weird how the webpage messes up the formatting of the code 🙁
Hi,
Thanks for the reply.
I’ve managed to get it working now.
For starters I was using the incorrect adapter, had to use WSHttp instead of basicHttp.
Then I wasn’t correctly using the artifacts generated by the WCF Adapter wizard.
Regards
Tony
Hi Lynn,
I found the following MSDN link that deals with troubleshooting problems with MSDTC. Run your servers through this checklist and see if you come across any conflicting settings in server configuration:
http://msdn.microsoft.com/en-us/library/aa561924(BTS.20).aspx
I hope this helps,
Daniel.
-
AuthorPosts