BizTalk - Convert.ToString() function cause Business Rule failure
Asked By Robert Song
02-Sep-11 10:59 PM
There is a strang issue at one of my BizTalk server: In ACTIONS area, when I use Convert.ToString(decimal) function, the rule failed to fire. The only happended on certain Machine. Other BizTalk machines had no this issue. So weird.
Hmm, ToString() is culture aware
This is a wild guess but you may want to confirm that the current thread's culture is what you expect. Depending on what you are running this code, you may need to double check the culture settings for the system this code runs on.
ToString() on certain objects behaves differently with different culture settings. I don't know enough about your code to offer a definitive solution to your specific problem.
Robert Song replied to Robbe Morris
I compared the culture info (Control panel, Region, date time and number format) between machines. looks they are same.
Compared the mscorlib.dll version across different machines. There are slight sub version difference. 2.0.50727.4200 Vs 2.0.50727.4214. I don't believe it will cause the problem.
Did another test: moved the Convert.ToString(deciaml d) from BRE to Customized .net c# component. It works for all the machines!! ??
Interesting
Good job on nailing down the issue.
Robert Song replied to Robbe Morris
in the right direction to be able to correct the settings programmatically? Thanks, Steve - - My BizTalk blog: http: / / stevestechnotes.blogspot.com / SharePoint Development Discussions SharePoint (1) BizTalk (1) [SNIP] The solution to this was to create the subsites using the Publishing interface using the following piece of code. Changing the locale of the site helps display the date and number formats with their respective decimal and group separators. http: / / www.mindfiresolutions.com / Changing-SharePoint-site-locale-programmatically-834.php Hi using the following piece of code. Changing the locale of the site helps display the date and number formats with their respective decimal and group separators. The example below shows changing an existing SharePoint site into Italian locale
namespace 'http: / / schemas.wpc-edi.com / X12 / ISOMORPH / HIPAA / 4010A1 / TS837Q1'. thanks for any suggestions BizTalk Discussions LineItemChargeAmount (1) ProfessionalService (1) LindaBztk (1) Windiff (1) Linda (1) Stu (1) Correctorder (1 your case is " 5.43"). Maybe you should consider to trim it, or remove the decimal point. 543 could be treated as 5.43 as long as your trading partner understands lindaB. . .@> the ld l]source - Hi Linda, the properties of TS837Q1_2400_SV102_ _LineItemChargeAmount show that the base date type is xs:decimal and the EDI Datatype is Real. the 5.43 is a fee that is from your idea of trimming was close. I'm not sure if you can trim a decimal, but what i did was right justified the source node. that did it. thank you
I need help please. I am creating a staff scheduling. the format is like this date date date date date date name client A client A client C client C client D client D name client create a summary per client which showing the staff participated in each client and the date we perform work on the client. I am thinking to use Vlookup function. To do table which copy the name column between each column which make the table like this date name date name date name client A name client A name client C name client
am trying to sumif different days of the week. Table is setup as below: A. Date Date Date Date Date . . . . . . B. Data Data Data Data Data . . . . . . I know that = weekday(Date, 1) will give me a 1 through 7 of the date Sunday through Saturday. Somehow, I feel like = sumif(A:A, weekday(A:A) = 1, sum can not use whole column pior to XL-2007 If you are using the 1900 date system, and DOW = 7, you will also add any values in B2:B40 where A2