How to INSERT/ADD new records in already Archived area (NLS Table of ADSO)?

[former_member598944]

Dear Experts,

I have a requirement like I need to insert a new record into my NLS Table of an ADSO, the record occurs in between of already archived area.

I have tried below approach to Add a new record in NLS Table but didn't work.

1. INSERT/MODIFY Statement using ABAP Program.

2. From HANA Perspective, SQL INSERT Statement failed with Error “operation is not permitted: remote source is restricted to read-only queries”.

Both the case failing because of NLS Table Setting “Display/Maintenance not allowed.”

3. Data Archival Process failed, when I tried to run the DAP manually to INSERT a new record occurs between archived area, gives error "Selected area already completely archived".

Note:

• I am not allowed to change the setting of NLS table.
• I am not allowed to unlock the previous archived request.

Can you please provide me any alternate solution for this?

Thanks in Advance.

[john_hawk]

What is the basis for your NLS? Is it time characteristic? What kind of ADSO is it?

What is the Key for the ADSO?

[former_member598944]

Hi John,

Thank you for your reply. To answer your questions:

What is the basis for your NLS?

NLS table is created on Sybase IQ and here we have already archived the last 5 Years of data now wanted to insert a new record which comes in the range of archived area.

Is it time characteristic?

In the Property of DAP, it is selected as "Time Slice Archiving".

What kind of ADSO is it?

The ADSO is of Type "Data warehouse layer" having Change log Table.

What is the Key for the ADSO?

Few fields are captured as a Key Fields like order number, item, fiscal year and uniquely generated random number.

Please let me know if you need any further details.

[shasan]

Just wondering if you got a delta record in the ADSO which belongs to archived region, how come you never got a request lock error for the same.