Forum Replies Created
-
AuthorPosts
-
I think that SAP expects to get some parameters you don’t supply in your mapping. (Some non-nullable fields or something like that) – I would check in that direction.
In mapiing, you have source and destination schemas. Are you passig messages with data in all fields? Or sometimes some fields come empty?
Hi AK,
did u try setting the value member?
for example: if the nullable variable name is X, try setting:
X.value = TheDateTimeValue;
Rgds,
Mike
August 28, 2010 at 7:21 AM in reply to: Split a XML file into several single XML files and map against DB schema #25776If I were in your shoes, I would have invested more time in implementing a single map (using XSLT) to get this done once regardless the source and destination schema.
hi there, can you elaborate more on the integration interface with DSNACICS? can you use sockets?
August 27, 2010 at 9:26 AM in reply to: Updating Database table based on the filename of the file generated at the send port #25772hi xman,
Actually, i need the part filename as in “Jaguar.xml” from “D:\Ab\Xman\Jaguar.xml”. I said that because if the sql entry is “Jaguar.xml”, the table doesn’t get updated.
Fields with parameters? Do elaborate on that, please.
I just map the elements from the SQL schema to the corresponding elements at SAP end. No other functionality involved. Straight one -> one mapping.
Does your message has all fields with paramteres?
The error says it’s not
. SapErrorMessage=Fill in all required entry fields. AdapterErrorMessage=Error returned by RfcCallReceiveEx while calling RFC:
August 27, 2010 at 8:15 AM in reply to: Updating Database table based on the filename of the file generated at the send port #25768Hi Abhishek,
If you are assigning to the SQL request message, you can do that in a message assignment shape by running XPath queries against your message to assign the whole path from the promoted property FILE.ReceivedFileName. See the following BizTalkGurus blog for more information on how to use XPath in an orchestration:
Daniel.
Hi Greg.
Yes I restartet it and I refreshed the application in BizTalk. So I was wondering. I deleted the orchestration in my project in VS and added a new one from scratch – same error message!
Wolfgang
August 27, 2010 at 1:22 AM in reply to: Updating Database table based on the filename of the file generated at the send port #25764Can’t the filename part be done in the message assignment shape? That is because i tried and it didn’t work and also, the SQL entry needs to be the whole path viz. “D:\A\bab\pdf.pdf”.
How is this to be sorted out?
Known issue – after you delete web reference – close Visual Studio, go to project folder – delete all artefacts and added WebReferences folder too.
August 26, 2010 at 12:08 PM in reply to: Files not getting consumed and getting GetTimeFileName Failed #25761Some process cannot delete those files though. (BizTalk server?) – did you check that there are explicit rights on temp folder?
The issue with GetTempFileName – caused because of unsufficient rights. Did you tyr to run FileMon? (File Monitoring exe frm Microsoft)? – You will see there failures – and will be able to fix alone – without Microsoft help (this also takes looong time till you get down to the problem)
The error message states the exception was thrown on shape Send_1
The orchestration that is suspending must have a Send shape in it. Is it possible you are running an older version of the orchestration? Did you restart your host instances after you redeployed?The assembly which will be called within the orchestration consume further web services and store datas in a database.
But the assembly has no return value.
cheers
Wolfgang
Do you need to have explicitly the number of the child in the destination schema?
if you have in source :
<Child>
<Name>AA</Name>
<Item>
<Detail>AB</Detail>
<Detail>AC</Detail>
</Item>
</Child>Do you need in Destination
<Data>
<Child>
<Name>AA</Name>
<Item>
<Detail>AB</Detail>
</Item>
</Child>
<Child>
<Name>AA</Name>
<Item>
<Detail>AC</Detail>
</Item>
</Child>
</Data>or
<Data>
<Child_1>
<Name>AA</Name>
<Item>
<Detail>AB</Detail>
</Item>
</Child_1>
<Child_2>
<Name>AA</Name>
<Item>
<Detail>AC</Detail>
</Item>
</Child_2>
</Data>And is <Child_3> is necessary (because there is only 2 details)
If this is first destination, you could use the mapper and use the looping functoid linked between the Item in source and the Child in Destination and link Name and Detail from source to dest.
If this is the second destination, you need to define completely the destination xsd and you can use the count functoid and index functoid to fill the correct destination node.
-
AuthorPosts