Update Item Master Data Failed

[Former Member]

Dear Experts,

We are facing a problem where all users (including super user) cannot update all item master data.  It prompts an error message: "Could Not Commit Transaction: Error - 1 Detected During Transaction (AITM).  Please advise on how should we solve the problem.

Note: We are using SAP B1 9.0 PL:10.

Thanks and Regards,

Lailus Shobah

[Former Member]

Hi,

what field do you want to update ?

regards,

triadi

[Former Member]

Hi Triadi,

Any information in item master data.

Regards,

Lailus

[Former Member]

Hi..

Only specific user can not be able to update item master or all user is not able to update ?

Also check SP_Transaction Notification, may be you have stored procedure for not updating Item Master.

Thanks,

Harshal Makwana

[Former Member]

Hi,

I have problem like this before.

then, like what Harshal Makwana said, I check SP_Transaction Notification and off the query about item master data. then my problem solved.

Regards,

[Former Member]

Hi Triadi,

We didn't have any stored procedure which is updating item master data.

Regards,

Lailus

[agustin_marcoscividanes]

Hi

run this query:

SELECT max(loginstanc) FROM AITM.

The maximum value for this field is 32767, as the note 1846523 explains.

Kind regards

Agustín Marcos Cividanes

[Former Member]

Hi All,

We have solved the problem which is due to user-defined field length issue in both OITM and AITM table.  We re-created the field and re-imported the value to solve the problem.

Thanks everybody for your reply.

Regards,

Lailus

[former_member143715]

Hello ,

try to increase the maximum server memory :

[Former Member]

Hi Mokhtar,

I tried above method but failed.

Regards,

Lailus

[Former Member]

Hello..

Do they allow you to add new item or update item mater ?

Regards,

Harshal

[Former Member]

Hi Harshal,

System allow us to add, but not for update.

Regards,

Lailus

[agustin_marcoscividanes]

Hi

check the note 1582518

Kind regards.

Agustín Marcos Cividanes

[KennedyT21]

HI Lailus..

Check sap note no:1276445

Regards

Kennedy

[Former Member]

Hi Kennedy,

Thanks for your reply.  I tried to open it but the status is not released.  Appreciate if you can copy paste the note.

Thanks and Regards,

Lailus

[KennedyT21]

I think they have removed the note..

This problem often links to specific user and UDF with FMS or SP_Transaction_Notification.  Check what is the issue and log to SAP support if you can not solve it by yourself.

Regards

Kennedy