community-content

Forum Replies Created

Viewing 15 posts - 1,666 through 1,680 (of 9,648 total)
  • Author
    Posts
  • OK, looking at the inputfile.xml from testing the map, for it doesn’t look like it is pulling in the values:

    – <ns0:Sheet1_Record>
      <ns0:id_id>10</ns0:id_id>
      <ns0:id_client_id_client>10</ns0:id_client_id_client>
      <ns0:id_claim_no_id_claim_no>id_claim_no_id_claim_no_0</ns0:id_claim_no_id_claim_no>
      <ns0:id_claimid_id_claimid>id_claimid_id_claimid_0</ns0:id_claimid_id_claimid>
      <ns0:id_brfile_id_brfile>id_brfile_id_brfile_0</ns0:id_brfile_id_brfile>
      <ns0:clmt_name_clmt_name>clmt_name_clmt_name_0</ns0:clmt_name_clmt_name>
      <ns0:clmt_age_clmt_age>10</ns0:clmt_age_clmt_age>
      <ns0:clmt_wage_clmt_wage>10</ns0:clmt_wage_clmt_wage>
      <ns0:clmt_len_clmt_len>10</ns0:clmt_len_clmt_len>
      <ns0:cov_major_cov_major>cov_major_cov_major_0</ns0:cov_major_cov_major>
      <ns0:id_occur_date_id_occur_date>1999-05-31T13:20:00.000-05:00</ns0:id_occur_date_id_occur_date>
      <ns0:pyear_pyear>pyear_pyear_0</ns0:pyear_pyear>
      <ns0:id_close_date_id_close_date>1999-05-31T13:20:00.000-05:00</ns0:id_close_date_id_close_date>
      <ns0:id_reopen_date_id_reopen_date>1999-05-31T13:20:00.000-05:00</ns0:id_reopen_date_id_reopen_date>
      <ns0:id_report_date_id_report_date>1999-05-31T13:20:00.000-05:00</ns0:id_report_date_id_report_date>
      <ns0:status_type_status_type>status_type_status_type_0</ns0:status_type_status_type>
      <ns0:ctl_emp_name_ctl_emp_name>ctl_emp_name_ctl_emp_name_0</ns0:ctl_emp_name_ctl_emp_name>
      <ns0:fin_ind_tot_fin_ind_tot>10</ns0:fin_ind_tot_fin_ind_tot>
      <ns0:fin_ind_pd_fin_ind_pd>10</ns0:fin_ind_pd_fin_ind_pd>
      <ns0:fin_ind_os_fin_ind_os>10</ns0:fin_ind_os_fin_ind_os>
      <ns0:fin_med_tot_fin_med_tot>10</ns0:fin_med_tot_fin_med_tot>
      <ns0:fin_med_pd_fin_med_pd>10</ns0:fin_med_pd_fin_med_pd>
      <ns0:fin_med_os_fin_med_os>10</ns0:fin_med_os_fin_med_os>
      <ns0:fin_exp_tot_fin_exp_tot>10</ns0:fin_exp_tot_fin_exp_tot>
      <ns0:fin_exp_pd_fin_exp_pd>10</ns0:fin_exp_pd_fin_exp_pd>
      <ns0:fin_exp_os_fin_exp_os>10</ns0:fin_exp_os_fin_exp_os>
      <ns0:fin_slv_pd_fin_slv_pd>10</ns0:fin_slv_pd_fin_slv_pd>
      <ns0:fin_sub_pd_fin_sub_pd>10</ns0:fin_sub_pd_fin_sub_pd>
      <ns0:fin_rec_tot_fin_rec_tot>10</ns0:fin_rec_tot_fin_rec_tot>
      <ns0:fin_tot_tot_fin_tot_tot>10</ns0:fin_tot_tot_fin_tot_tot>
      <ns0:fin_tot_pd_fin_tot_pd>10</ns0:fin_tot_pd_fin_tot_pd>
      <ns0:fin_tot_os_fin_tot_os>10</ns0:fin_tot_os_fin_tot_os>
      <ns0:loc_lvl1_loc_lvl1>loc_lvl1_loc_lvl1_0</ns0:loc_lvl1_loc_lvl1>
      <ns0:loc_lvl1_t_loc_lvl1_t>loc_lvl1_t_loc_lvl1_t_0</ns0:loc_lvl1_t_loc_lvl1_t>
      <ns0:id_state_id_state>id_state_id_state_0</ns0:id_state_id_state>
      <ns0:ctl_cause_ctl_cause>ctl_cause_ctl_cause_0</ns0:ctl_cause_ctl_cause>
      <ns0:ctl_cause_t_ctl_cause_t>ctl_cause_t_ctl_cause_t_0</ns0:ctl_cause_t_ctl_cause_t>
      <ns0:ctl_nature_ctl_nature>ctl_nature_ctl_nature_0</ns0:ctl_nature_ctl_nature>
      </ns0:Sheet1_Record>
    Which I don’t understand because when I validate the file schema instance, the resulting XML looks fine.
    Thoughts?

    Grrrr, it’s a Monday…

    right mouse click on the .btm and select TEST Map

    Sorry, not VALIDATE the map, but I get those errors when I TEST the map (right mouse click on the .btm and select Validate Map).

    Hi Daniel,

    Thank you for your response.

    When I validate the mapping (right mouse click on the .btm and select Validate Map) I get the following:

    Output validation error: The ‘http://schemas.microsoft.com/Sql/2008/05/TypedProcedures/dbo:line_of_coverage_type_code_value&#8217; element is invalid – The value ‘cov_major_cov_major_0’ is invalid according to its datatype ‘String’ – The actual length is greater than the MaxLength value. 

    Output validation error: The ‘http://schemas.microsoft.com/Sql/2008/05/TypedProcedures/dbo:claim_nbr&#8217; element is invalid – The value ‘id_claim_no_id_claim_no_0’ is invalid according to its datatype ‘String’ – The actual length is greater than the MaxLength value.

    Output validation error: The ‘http://schemas.microsoft.com/Sql/2008/05/TypedProcedures/dbo:claim_status_code_value&#8217; element is invalid – The value ‘status_type_status_type_0’ is invalid according to its datatype ‘String’ – The actual length is greater than the MaxLength value.

    Output validation error: The ‘http://schemas.microsoft.com/Sql/2008/05/TypedProcedures/dbo:incident_state_code_value&#8217; element is invalid – The value ‘id_state_id_state_0’ is invalid according to its datatype ‘String’ – The actual length is greater than the MaxLength value.

    Why I’m not sure why I would get these errors…

    Scott

    Hi. You will find how to write custom pipeline in Biztalk Hothod magazine

    http://biztalkhotrod.com/Documents/Issue8_Q4_2009.pdf

    page 63

    However, there is many other ways to remove namespace from the message, like with message assignment, and custom dll.

     

    Hi Scott,

     

       A couple of questions for you:

    1) Did you validate and test the map that maps your Spread schema to your Stored Procedure schema, to make sure that the output is what you expect?

    2) The error you are getting is from the Receive Pipeline that is disassembling the message from your spreadsheet into XML format. After you deployed your map (assuming it is in a separate project), did you check to see if your Spread schema is still published in the BizTalk application? Check the Global Cache Assembly (GAC) to make sure that both your map and schema assemblies are still there.

     

       I don’t believe the problem you are facing is specific to FarPoint Spread for BizTalk, and is related to deployment and configuration issues in BizTalk. Let me know how you make out on this one.

     

      Daniel.

    in reply to: WCF Service return null #24160

    Hi Junaid,

    Do you have the WCF Tracing turned on? This issue can be difficult to debug without enabling tracing. You can follow this article on MSDN for enabling tracing http://msdn.microsoft.com/en-us/library/cc185303(BTS.10).aspx. Make sure you dont enable it on production servers and only the development servers 🙂

    Next I would like to suggest to use complex types instead of primitive types like strings, int etc. The issue would probably go away…
    You might find this thread useful on MSDN. The user has the same issue with the string and when he uses the typed messages he gets the response message. I doubt it has something to do with serialization and I dont agree with this reason which he is giving.
    http://social.msdn.microsoft.com/Forums/en/biztalkgeneral/thread/7e9adc00-d1ab-4a71-835f-4879600fcf02

    Enable the tracing and see what you get. The configurations and hosting of the service is fine.

    Thanks
    Abdul Rafay
    http://abdulrafaysbiztalk.wordpress.com
    MVP & MCTS BizTalk Server

    in reply to: Exam 70-241 and 70-235 Difference #24158

    Hi,

    Can you please send me the study material and dumps for 70-241 exam? Please find below my email address:

    [email protected]

    Thanks

    Victor

    in reply to: create a blank .flag file when a file is picked up. #24157

    Thanks buddy. Do you also have Biztalk 70-241 certification dumps? Thanks!!!

    in reply to: 64-bit configs for AppDomainSpec SecondsIdleBeforeShutdown #24155

    I checked my QA system, and neither config file had my AppDomain in it.  Any idea what adds the AppDomain to the config? 

    Neal

    in reply to: create a blank .flag file when a file is picked up. #24154

    I would use this to prepare

    http://www.biztalk247.com/v1/articles/exam70235.aspx

     

     

    in reply to: create a blank .flag file when a file is picked up. #24152

    Hi, I am planning to write Biztalk 70-241 exam. Can you please send me the study material and dumps, in case you have any?

    My email ID is [email protected]

    Thanks

    Victor

    in reply to: Problem with certificate #24150

    any help please ?

    If you are using BT2009 and SQL2008 you should be using the new WCF SQL adapter. The old SQL adapter has been deprecated and will not exist in BizTalk vNext.

    With with this new adapter you can use a table parameter with a stored procedure and the new Merge statement.

    CREATE TYPE YourCSVFileFormat AS TABLE
    (Id INT
    ,Column1VARCHAR(50)
    , Column2 INT
    ,etc,etc );

    CREATE PROCEDURE usp_InsertProductionLocation
        @CSV YourCSVFileFormat READONLY
        AS 
        MERGE DbTable AS target
        USING @CSV AS source
        ON (target.id = source.id)
        WHEN MATCHED THEN
            UPDATE SET Column1= source.Column1, Coumn2 = source.Column2
       WHEN NOT MATCHED THEN 
            INSERT (Column1, Column2)
            VALUES (source.Column1, source.Column2);

    By creating these SQL objects you can use the Add Generated Item feature in VS2008 to generate the table schema in Biztalk. Then simply map your flat file schema to your table schema

    1. To put the filename into the SQL table, you can use a map and the ContextAccessor functoid (http://www.codeplex.com/ContextAccessor). The property you need to map is FILE.ReceivedFileName.

    2. This is a feature of the Merge statement.

    3. Datatype validation you can do by extending the schema. Select a particular field node and in properties window set Derived By to Restriction. Scroll down to the Restriction properties where you can set Min and/or Max length, even a regex pattern. You can use the Xml Validation pipeline component to validate. Remember you lose whitespace in Xml so any checking that involves spaces will not work. 

    4. Data validation is somewhat trickier, what sort of data validation are you expecting. I have used a custom Xslt map with some .NET classes that cache various data items from a database or config file.

    One of the key question is how do you want to handle errors, discard current record and continue or abort and roll back or records?

    in reply to: BizTalk 2009 Configuration Problem #24146

    Are you using a Remote SQL Server?

    -Ivan

Viewing 15 posts - 1,666 through 1,680 (of 9,648 total)