Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to solve the problem that the ERP system in BASIS cannot log in". In the daily operation, I believe that many people have doubts about how to solve the problem that the ERP system in BASIS cannot log in. The editor has consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful for you to answer the doubt that "how to solve the problem that the ERP system in BASIS cannot log in". Next, please follow the editor to study!

1. SAP GUI end-user login prompt: "rabax during sapgui logon"; check / usr/sap/DEV/DVEBMGS00/work/dev_disp log:

* WARNING = > DpHdlDeadWp: wp_adm slot for W22 has no pid [dpxxwp.c 1362] still cannot locate the cause of the problem.

Check the words that dev_rfc.trc found logsegment full.

2. Check the database log: / sybase/DEV/ASE-16_0/install/DEV.log prompts a lot: Can't allocate space for object 'syslogs' in database' DEV' because 'logsegment' segment is full

3. Temporary solution: log in to sapsa Sybase isql: > dump transaction DEV with no_log > go

4. Adjust the logsegment size of DEV database:

a. Expand the capacity of database equipment and add 15360MB

Disk resize name= "DEV_log_001", size= "15360M"

> go

b. Adjust the database server to single-user mode

> use master

> go

> sp_dboption master, "single user", true

> go

> use DEV

> use go

> checkpoint

> go

c. Execute sp_extendsegment

> alter database DEV on DEV_log_001=15360

> go

> sp_extendsegment logsegment DEV DEV_log_001

> go

d. To view the current log_size, you can use the following SQL statement; https://benohead.com/sybase-size-of-data-and-log-segments-for-all-databases/

Select db_name (d.dbid) as db_name,ceiling (sum (case when u.segmap! = 4 then u.size/1048576.*@@maxpagesize end)) as data_size,ceiling (sum (case when u.segmap! = 4 then size-curunreservedpgs (u.dbid, u.lstart, u.unreservedpgs) end) / 1048576.*@@maxpagesize) as data_used,ceiling U.unreservedpgs) end) / sum (case when u.segmap! = 4 then u.size end)) as data_used_pct,ceiling (sum (case when u.segmap = 4 then u.size/1048576.*@@maxpagesize end)) as log_size,ceiling (sum (case when u.segmap = 4 then u.size/1048576.*@@maxpagesize end)-lct_admin ("logsegment_freepages", d.dbid) / 1048576.*@@maxpagesize) as log_used Ceiling (100,1.0 * lct_admin ("logsegment_freepages", d.dbid) / sum (case when u.segmap in (4,7) then u.size end)) as log_used_pct from master..sysdatabases d, master..sysusages uwhere u.dbid = d.dbid and d.status! = 256group by d.dbidorder by db_name (d.dbid) so far The study on "how to solve the problem that the ERP system can not log in in BASIS" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.