[community-content]

Hi,

 

   Is your issue related to what is detailed in the following BizTalkGurus blog?

http://www.biztalkgurus.com/blogs/biztalksyn/archive/2010/03/17/host-integration-server-smart-multihoming-causing-delays-to-connect-to-a-his-server.aspx

 

   Just a guess, but I could be way off-base.

 

   Best.

 

[community-content]

I’m not sure what you mean.  Every attempt I have made has, so far, been unable to validate the flat file instance.

 

[community-content]

Hi,

 

   Do you have a sample data for your XML and Flat file? It’s difficult to figure out what you need without seeing the data first.

[community-content]

Hi Abhishek,

 

   You can also convert the field(s) to an integer datatype in a map that transforms your CSV schema to your BAPI schema. Is that not what you want?

 

   If you don’t want to use a map, if your field(s) are not Distinguished Fields, then you would have to use XPath expressions and System.Convert.ToInt32 function in a Message Assignment shape to do the conversion.

 

   Hope this helps,

 

   Daniel.

 

[community-content]

First you have to install your new database server an leave it as it is. No installation of other databases are required so far.

Unconfigure on the BizTalk server SSO, Groups an whatever you need.

Just configure BizTalk new – also the parts you have unconfigured before.

The first thing you have to configure is the SSO and you will see on the database server, that there will be a new table automatically installed.

If this isn’t working properly, please check the log.

And one more thing. Check that DTC is enabled that means on the database side is Network DTC Access enabled with Allow Inbound and Allow Outbound and no Authentification Required. So it works for me.

I hope this helps.

Wolfgang

[community-content]

Hello Daniel,

I am building the schema from the csv file. But, i need to map it to a BAPI schema from SAP end and the corresponding currency fields in the BAPI schema will be ‘int’ datatyped. So, i’ve come to know that ‘int’ datatype on the field i mentioned isn’t possible and i’ll have to use it as a ‘string’.

If so, before mapping, can i convert the field into int through a message assignment shape(one of my friends suggested this just now)?

or

is there any other method to achieve this?

[community-content]

Thank you so much, Ewa.

I’ve done what you’d suggested, and now the sample Invoice.xml document does successfully validate against new Proxy schema.

However, I am still unable to generate an instance file from this new proxy schema in both BizTalk and XMLSpy. In XMLSpy I open the schema, then select DTD/Schema -> Generate Sample XML File. And here is what I get:

<?xml version=”1.0″ encoding=”UTF-8″?>
<!–Sample XML file generated by XMLSpy v2010 rel. 3 sp1 (http://www.altova.com)–>
<ns5:message xmlns:ns5=”urn:ean.ucc:2″>
 <entityIdentification>
  <uniqueCreatorIdentification>a</uniqueCreatorIdentification>
  <contentOwner>
   <gln>0000000000000</gln>
  </contentOwner>
 </entityIdentification>
 <probably_invalid_for_strict_wildcard/>
</ns5:message>

And the error is: “No element name could be determined for strict wildcard {##any}.”

my email is: mylodka at gmail dot com

Kind regards

 

 

 

 

 

 

 

 

 

 

[community-content]

I am having a similar difficultis – you don’t have a sample that generates a positional flat file for a complex do you? I’ve been beating my head for two days now.

[community-content]

Hi,

    I have done all the following successfully(thank you all for your inputs)

1. installed SSO on new SQL server

2. Un-configured and Re-Configured the sso, groups, EDI/AS2 etc

3. Restored the databases to the new server.

4. Connected the group in BizTalk Administration

I can now see the Msgbox and Mgmt DB showing my new server name.

Only thing which I am unable to follow is when I go back in BizTalk Configuration , I still see the ENTSSO configured on the old/current server and not pointing to the new SQL server.

Is it something wrong?

Secondly , can I safely uninstall SQL server and ENTSSO from my current machine.

Your advise is very imp to me.

Please advise

 

Thank you all again. I will detail all the steps that I did after this task is completed successfuly

-Sangeetha

[community-content]

Hi,

Did you decide to reconfigure your BizTalk on remote SQL?

If so – did you configure MSDTC on both servers? (BizTalk + SQL)?

Your user under which run service – is it Active Direcory defined? Because it must – groups and users need to be defined in domain.

The user under which will run BizTalk service – need for configuration to have sufficient rights on master – while configuring BizTalk, it creates DataBases and jobs, and different objects like this.

In my case – sysadmins define the service account as administrator on SQL, and after if they want to set lower rights – they do so.

Your error seems like unsufficient rights on SQL.

Good Luck,

Yonathan.

[community-content]

Hi Abhishek:

 

   Are you creating a schema in BizTalk based on the CSV file? If so, then try setting the datatype to xs:string for the fields that will hold the currency values (e.g.   $9,000 ,  ($9000) ) and see if that works.

 

   Daniel.

 

[community-content]

Dunawayc,

se tag identifier for each record to create child nodes for a particular record.

– Jyothsna

 

[community-content]

Hi Jeremie.

Thanks a lot for your help …

But as you said, I think for my application the better way is to build a new receive location without copying it. But it is good to know another way.

Thanks

Wolfgang

[community-content]

Hi,

 

You can duplicate the receive location with the following Step :

• Export Bindings
• Copy and Past the xml corresponding to the receive location
• change the Name of the receivelocation
• Import Bindings

If you do like this, BizTalk must set an error because you use the same URI in two receive location. So you can add after you URI :?InboundId=MyParameterN

Example :

rloc1, uri : mssql://xxx.xx.xx.xxx/MyDatabase?InboundId=Rloc1
rloc2, uri : mssql://xxx.xx.xx.xxx/MyDatabase?InboundId=Rloc2

If you need to poll data in a receive location, I think it’s a good solution.

Hope this answer help you!

 

Regards

 

[community-content]

Ok, I build a new WCF SQL adapter and a new receive location and in the new sqlbindings I inserted another parameter.

But I’m still interessted if someone knows if I can duplicate a receive location and change just the properties.

Thanks

Wolfgang   

[Author]

Posts