Too much data make my sap b1 hang......

[Former Member]

is it the sap b1 is not suitable for those company which having too much data? now our company data is more than 50,000 it make my sap b1 application hang when i press 'tab' to show all details....

[Former Member · Accepted solution]

Dear ad,

is 50,000 data of item master data

server: Intel (R) Xeon (TM) CPU 3.20GHz, 4 GHz Ram

clients: Pentium (R) 4 CPU 2.40Ghz, 512MB RAM

thanks

from

grace

[AdKerremans · Accepted solution]

Hi Grace,

Hardware should be enough, is the behavior on server the same as on the client?

If you use the query analyzer and do a "select * from oitm" how long does it take on server and on the client?

Ad

[Former Member · Accepted solution]

Dear Ad,

Thank you for your reply.

At server, when i press "tab" in sales documents and monitor the memory usage at server, it increase until 2GB of RAM and hang.

At Clients, it totally hang and came out a message "virtual memory low".

"select * from oitm" take around 1 - 2 minutes at clients.

[AdKerremans · Accepted solution]

Hi Grace,

I have never seen this behaviour, just pressing tab should not increase the memory usage to 2Gb, have you tried to load the database on another machine and tested this?

what version are you using?

Select from oitm time doesn't look strange to me.

Regards

Ad

[Former Member · Accepted solution]

Dear ad,

just now i try to use "select * from oitm" it on the client side again, it took 1 to 2 min to show the table contain how many data but when i try to click the "ok" there....then it become hang and show a message "not enough momery"

grace

[Former Member · Accepted solution]

Dear ad,

we r using SAP Business One 2004A(6.70.193)

grace

[AdKerremans · Accepted solution]

Hi Grace,

You version is good, I don't know what causes this, maybe someone else know more.

Ad

[Former Member · Accepted solution]

Hi ad,

Anyway thank you very much.

[Former Member · Accepted solution]

Hi Grace,

did you change the choosefromlist settings ?

Did you select grouping ?

Look into table CHFL.

There you can find the settings.

If there's no other way, delete the settings for the object

and try again.

Hope it helps !

Regards,

Holger

[Former Member · Accepted solution]

Dear Holger,

thanks, now it is work....

but i dont understand why the setting will effect the application become 'hang'?

the other question is why when i run "select * from oitm" it will also make my system hang?

from

grace

Message was edited by: grace ng

[Former Member · Accepted solution]

Hi,

Looks like the problem wasn´t the selecction, but the "painting" of the data or the matrix loading performance.

I don´t think the query is hanging your system. It usually looks like it is hanged, but after a while the result is shown.

Regards,

Ibai Peñ

[Former Member · Accepted solution]

hi lbai,

it is hang for few min, and after that the sap b1 will straight away disapper .....

from

grace

[Former Member · Accepted solution]

Try reporting it to SAP. I don´t think we can help you more.

Sorry,

Ibai Peñ

[Former Member · Accepted solution]

Hi,

this happens quite often

Regards,

Holger

Message was edited by: Holger Reppert

[Former Member · Accepted solution]

Hello,

I Quote the post before

did you change the choosefromlist settings ?

Did you select grouping ?

Look into table CHFL.

Where can I find the choosefrom list setting?

What's mean by select grouping, you mean choose the itemgroup in searching ?

I see about thirty rows in CHFL, do I need to delete it?

Thanks

[AdKerremans]

Hi Grace,

Your are talking about data being more than 50,000. 50,000 of what.

We have clients with about 200,000 different item and databases of 6 Gb of more and no performance problems.

What are the hardware spec?

Regards

Ad