Skip to Content
avatar image
Former Member

Data not getting Inserted and/or Deleted in DB. No error in channel.

Hi,

I am using the below structure for both 'Insert' and 'Delete' operation.

<?xml version="1.0" encoding="UTF-8"?>

<ns0:InsertDeleteTable xmlns:ns0="abc:xyz">

<StatementName1>

<TableName Action="INSERT">

<Table>TableName</Table>

<access>

<ID></ID>

<DATE hasQuot="No"></DATE>

<FLAG></FLAG>

</access>

</TableName>

</StatementName1>

<StatementName2>

<Name Action="SQL_DML">

<access>delete statement</access>

</Name>

</StatementName2>

</ns0:InsertDeleteTable>

There's no error in the receiver channel, but the data is not getting and/or deleted fro the table. When I excluded the 'delete' structure, insert was happening properly. I would like to know if it's not possible to do both operations simultaneously from a single mapping.

Thanks,

Vishal

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Sep 24, 2009 at 06:34 AM

    Hi Vishal,

    Set Maximum concurrency to more than 1

    http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

    As per help.sap.com

    +Processing Tab Page

    Maximum Concurrency

    Enter the number of messages to be processed in parallel by the receiver channel. For example, if you enter the value 2, then two messages are processed in parallel. Default value is 1 and this means only one message can be processed at a time by the receiver channel.\+

    Regards

    Suraj

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      The status in receiver commn channel is just 'Message processing started' and not 'Message processing completed successfully'.

  • avatar image
    Former Member
    Sep 24, 2009 at 08:27 AM
    <Name Action="SQL_DML">

    Are you doing any complex validations for the delete action.....i hope you are writing the DELETE query properly in your access tags.....if it is a simple delete action from some columns of the DB table then you can try using the action as DELETE.

    Regards,

    Abhishek.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Yes.. Basically I've to delete records from the table which are 3 months older. Is there any way to subtract 90 days from sysdate if I use 'key' element. When I had used only 'access' I was able to write the query.

      There's a column 'DATE' in the table which holds the date when the record was inserted. If it is 3 months older, it needs to be deleted.

      Edited by: Vishal.P.Kulkarni on Sep 24, 2009 12:07 PM

  • avatar image
    Former Member
    Sep 24, 2009 at 08:54 AM

    Hi vishal,

    Are u using any placeholders in your Delete querry or u r using constants. Generate your strucuture base on the following link

    http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/frameset.htm

    also change the maximum occurency in your channel to 2 or more.

    Regards,

    Rahul

    Add comment
    10|10000 characters needed characters exceeded