hai friends, I want to send datas from xml file to sql database with sql adapter and updategrams. I configured receive port to use file adapter and send port to use sql adapter. In the receive folder,when I put the file xml ,it vanishes but it does not insert in the sql table.
It gives the following error
The adapter failed to transmit message going to send port \”SQL://KAVITHA/bizTest/\”. It will be retransmitted after the retry interval specified for this Send Port. Details:\”HRESULT=\”0x80040e14\” Description=\”Impossible to find stored procedure’s name\”
The adapter \”SQL\” raised an error message. Details \”HRESULT=\”0x80040e14\” Description=\”Impossible to find stored procedure’s name.\”
My question is Does updategrams use stored procedures? Why it is asking for stored procedures?
I had the same problem a while ago. I think it’s the error message that is confusing, as the updategram does not use stored procedures. Double check that you have the correct shcema, and that you are mapping to it, and sendng the correct message.