community-content

Forum Replies Created

Viewing 15 posts - 2,866 through 2,880 (of 9,648 total)
  • Author
    Posts
  • in reply to: XSD Schema will not validate #22280

    Hi again,

    I don’t know if it’s a better way (for your solution) – but there’s other way: you create stored procedure , and after that you add generated Items -> generate SQL – generate schema. After you generate it – there will be added schema  and an empty orchestration which you can delete. After you generate the schema – go to your stored procedure and delete the row “for xml auto, xmldata” – otherwise you will receive the exact error you get in your case.

    Didn’t work much with queries, but maybe the row with “for xmlauto, xmlschema” – that is what makes error (not familiar with syntax for queries).

    in reply to: XSD Schema will not validate #22279

    I created the schema using a query.  The only purpose for the query was to create the schema.  Is there a better way?

    in reply to: Mapping data lookups #22278

    Thanks for the comment.

    This is not really what I was after.  I have looked into the cross referencing functionality and while it meets the need of data value mapping, it does not have a interface that would meet the following requirements…

    – Manage the data held easily so that a power user can easily upload edit and remove data.

    – Secure management of the data using some kind of permissions so that certain power users had permission to view certain data types

    – Easily map from several fields to a single value.  This implements one to one mapping.  I know this can be done using some sort of delimiter between fields like ###, but again it makes data management of these values a more difficult job.

     I have found this which I think is the same thing as you sent me

    http://www.softpedia.com/progDownload/Cross-Reference-Data-Manager-Download-121732.html

    But it is far from perfect and has no security model, hey ho, may look at enhancing this tool further should my client allow it 🙂  

    in reply to: XSD Schema will not validate #22276

    Hello,

    You created the schema (you call it XSD file) – using stored procedrure or using query?

    After you create the schema – you need to eliminate the<< xmlauto, xmldata>> line from your SQL query.

    in reply to: Mapping data lookups #22274
    in reply to: Pending \"Terminate\" in HAT? #22270

    When I terminate active orchestration instances from HAT, the instances stay active with Terminate as the pending job. How can I force them to terminate immediately?

    You can stop and unenlist the orchestration. Then you can terminate the orchestration in HAT.

    http://msdn.microsoft.com/en-us/library/bb418739.aspx

    Hello,

    The answer is in a body of your question: it seems that you have no SQL server availiable. Try to test connection string by creating on your desktop “1.udl” file, there select  In providers “Microsoft OleDb for SQL”, then go to connection TAB and define your specs. If you can’t connect to SQL and get time Out, or any other error – check the issue with your SQL server. Might be that SQL service is stopped or something like that.

    Hi.. Plz send the error details which you are getting inside event viewer..

    suggest, restart host instance once.

    Hi again,

    – There’s nothing to be frustrated about, it’s just a code 🙂

    Check to be sure that there’s no another application takes your file from your file – it really happens. You just work on something and then forget it and then you just don’t get what happens and the file dissapears.

    Try to build the same thing from scratch – define new folders on different machine (if you have such an option).

    About your last question – it must be pass tru on both sides, else the file which is ZIP (correct?) won’t pass – there’s no schema defined and no dissassembling part.

    Something else – stop your send port – to ensure that your receive location takes the file and not something else. After you check it – enable send port again and look what happens.

    Good luck

     

     

     

     

    1. less than 5 kb

    2. Yep

    3. Yep

    4. First time to create a BizTalk app without using VS

    5. Yes, I’ve developed numerous complex BizTalk applications on this virtual machine for over 2 years now, which is why I can’t look at myself in the mirror no more (as this application is the simplest thing I’ve ever had to built (and yet I can’t get it to work))   [:(]

    I’m going to give it another try tomorrow, there must be something that I’m missing.

     

    Did you use pass through for both ports?

    in reply to: Running "phantom" service instances – Isolated Adapter #22264

    Hello,

    Do you work with SOAP adapter in a case? If so – you need to restart IIS you work with or to stop it (don’t remember,  but remember such thing – undeletable service instances), than stop host instance, and then try to delete your phantoms.

    Anyway – they can be deleted after 30 minutes I think – it depends on definition in IIS for session or something like that.

    Hmm, Ive just deleted it – it’s so simple – dont think you need it 🙂

    1. Another question – what is the size of file you try to transfere?

    2. It just dissapears from your folder and that’s it?

    3. Did you try to create it from the beginnig again?

    4. Is it first time you make such solution or there was something alike and it worked?

    5. Do you have another solutions (even more complex) which are working?

     

    1. filename is irrelevant because my send port has a filter (bts.receiveportname == X) and my receive port is called X

    2. yes, its an active subscription (verified by looking at all my subscriptions in admin console)

    3. no

    4. I enabled tracking on the receive and send port but there is nothing to be found in HAT/event viewer. Host instance is started.

    5. No permission issues.

     

    Thanks for testing it for me. Perhaps you could mail me an MSI of your solution? Can’t believe a project this simple is causing so much frustration.

     

     

    in reply to: Response problem with Oracle-adapter #22261

    Hello,

    You’ve wrote: “We can see in the HAT that the Query- or Insert-message have been send by BizTalk to Oracle”

    1. The insert/update succeeds?

    2. Your aplications just stays in dehydrated mode?

    The server updates you’ve wrote about – can they be some security updates? Did you check, that MSDTC configuration on both sides  is the same as it was before? Anything interesting in event vewier?

    Hi,

    1. Did you check that you write the name of file correctly?

    2. Did you check that the filter exists?

    3. Is there any other subscriber to your filter? Maybe you created something and forgot about it?

    4. You don’t have ANY indication exept dissapearing file that something happened? – Event viewer? HAT? Suspended? Is your host instance started?

    5. Check that you have enough permissions on your directories.

    – If BTS installed correctly, and you have no system errors – your solution should work – I’ve made a test for such one right now.

     

     

     

Viewing 15 posts - 2,866 through 2,880 (of 9,648 total)