Work order update termination error

[Former Member]

Hi Experts,

Currently we have issue while creating work order.

After input all required field for creating work order (T-Code IW31/IW34), work order number saved with number 4000020. But when performing change or display respective work order. there's message shown " Express document "Update was terminated" received from author" and routed to business workplace inbox an notified as SAPSQL_ARRAY_INSERT_DUPREC for the error info.

We have checked from table AUFK and no work order 4000020 available. Also, check the number range and seems no problem there.

Any idea?

Please help

Rgds,

[Former Member]

Hi Kishore,

Thank you for your quick response,

I have checked the number range configuration. I have adjusted the interval number range (at configuration)with last number range used in table AUFK.Let's say into 4000225.

While new create WO transaction (IW34/IW31) work order generated with 4000226. But, at the configuration side suddenly last interval number range jumped ito 4000286.

And, while display WO (using T-Code IW33), WO 4000225, 4000226, 4000286, and other WO doesn't exist. and align also while performing IW39.

Mean while, on table AFIH WO number saved up to 4006152.

Any idea on what should I do? Please help.

Thank you

Rgds,

[Former Member]

Hi

I hope your first problem is solved

Coming to your next problem.

The number range object used in this is AUFTRAG, check out the same in SNRO transaction.

Click on display & check the No. of numbers in buffer.

This number determines how many numbers are reserved in the application server buffer for the intervals.

The number interval buffer is in the Shared Memory of the application server. Each buffer is used to store the external number intervals and a certain number (subinterval) of the internal number intervals. If the numbers of an internal number interval are used up, numbers are taken from the database via the number range server. The status of the number interval in the database is increased by the number of numbers fetched to the buffer.

When buffering number intervals, gaps may result in number assignment.

I also donot have much idea why system some times takes more than the buffer values.

Thanks & Regards

Kishore

[Former Member]

Hi all,

Here's the current situation,

I have created Work Order (WO) with T-Code IW31 and generated with WO number 4000020.

on number range intervals the current WO number is 4001039. And table AFIH shows WO number generated up to 4006244. Is there something incorrect occurs thru the number range configuration or improper setting for WO scheduling by IP30 (Deadline monitoring-batch input)?

Any idea?Please help.

Thank you

Rgds,

[Former Member]

Hi

There is alot of inconsistency in the numbers you have provided.

I suggest you check the Table Numbers using the correct order type.

Check the number ranges assigned to the order types in customizing.

In the table always check the number based on the order type.

Then check the number range assigned to the order type in customizing check if both are same.

The number ranges should be the same in the Cutomizing as well as in the Tables.

Adjust in the Number range object accordingly.

Thanks & Regards

Kishore

[Former Member]

Hi,

Problem for Update Termination Error occurs due to- User exists or Unicode Conversion.

Check with Tech Consultant

[Former Member]

Hi

"For your update terminate problem please proceed accordingly

goto SM13, there you can see the updates terminated & their logs.

Click on one of the Updates terminated with transaction.

Double click on the line , you will see alist of Function modules, click on the function module in red, here click on the log to see more details on the reason for update termination.

in the dump anlysis you can see the reason for dump.

Act as per the dump anlaysis. usuall reasons for the dump is any new changes to the program or number range error ."

Please check ther number range of the Work Order in the number range Object & in the table for work orders AFIH

Thanks & Regards

Kishore