cancel
Showing results for 
Search instead for 
Did you mean: 

Insert or Update Item Master is too slow

Former Member
0 Kudos

Dear Expert,

I have a problem in add or update Item Master Data. When I click Add/Update, the process saving is too slow (need more than 5 minutes). This condition appear yesterday. In 2 days ago process add/update item master data normal.

But the others transaction like business process, transaction is normal.

I have did shrink database in SQL, but not help.

Does anybody help my problem? how should I do?

Thank you before help me

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

.

former_member186095
Active Contributor
0 Kudos

Hi pak Hendra,

May I know how much is your livedb size now ? If it is still slow after reindexing, you may consider to do these followings suggestions:

1. Increase your server hdd size

2. Increase your server's processor

3. cut off and do new opening balance

Is the problem happened in branch/outlet ? do you use citrix to access the server from branch ? Of course you can reindex the db to solve this issue but it is not the only one solution. You must also concern about the connection.

Rgds,

JimM@sbo_knowledge_village

Former Member
0 Kudos

Dear Julie and Jimmy,

I have reindexing or Update statistics. but not help.

Pak Jimmy, the others process running smoothly, only on add/update item master.

This condition appear after I have change valuation method ("A" to "S") and update item cost to 0.

Plus update tax group (sales and purchase).

thanks,

Hendra

Former Member
0 Kudos

Dear

When have you changed valuation method ("A" to "S") and update item cost to 0?

Thanks,

Gordon

former_member186095
Active Contributor
0 Kudos

Dear pak Hendra,

How did you update the valuation method ? are you using a query e.g.

" update dbo.oitm set evalsystem = 'S' where oitm.itemcode = 'yyy' " ?

if yes, you should not use query expecially if the item never have used in any transactions. If the item have had, and then you use the query, I am afraid your db is being inconsistent . Let me know.

Rgds,

JimM

Former Member
0 Kudos

Mr. Gordon & Pak Jimmy,

we updated using sql syntax. I think our db is not consistant again.

Do u have solution to solve it?

Former Member
0 Kudos

Hello Hendra,

As is very well documented in this forum, SAP Notes, Custoerm Portal modifications of the SAP Business One Database are NOT permitted via direct manipulation. Your customer DB may now be without support. Please restore the DB to its original state before you made the modifications. Updating price lists is possible via the application, doing it in this manner ensures that all updates are taken rather than the single update you made.

Regards,

Paul

Former Member
0 Kudos

Dear Paul,

Thank you for your advise. I will restore db.

former_member186095
Active Contributor
0 Kudos

Dear pak Hendra,

What Paul said is correct. You must concern about the back log. I mean past transaction. You must discuss with key users. many issue will appears after restoring backup which one of them is the past transactions record again to system.

Rgds,

JimM

private PS.

Sebaiknya Bapak tidak usah terus terang di forum ini mengenai penggunaan syntax SQL untuk ke depannya. Namun demikian, tidak apa2 sudah terjadi. jangan kasitau nama company Bapak.

Former Member
0 Kudos

Is this just for one user, or for all users? Have there been any new customisations added?

Sometimes these issues can be caused by processes left running when clients crash, or don't shut down properly, so a SQL server restart could help, if that is possible

Former Member
0 Kudos

Hi Julie,

the problem appear for all users. I have restart SQL services and the server too. But not help me.

do you have any solution, any syntax sql to solve my problem?

thanks,

Hendra

Former Member
0 Kudos

Hi Hendra,

There are a few things on the SAP Portal related to performance so it would be worth browsing the notes.

You can try reindexing or Update statistics SAP Note 783183