cancel
Showing results for 
Search instead for 
Did you mean: 

Livecache LCA connecting issue

0 Kudos

hi, expert ,

     this issue happened after i initialized the Livecache and restore it back to fix a GATP running issue

     but the bad news is this issue come out and that issue not fixed yet

     The detailed information as below

     Plz help if you can

     thanks so much

'

General Connection Data

   Connection Name....: LCA

   Database Name......: LC2

   Database Server....: localhost

   tp Profiles........: no_longer_used

   DBM User...........: SUPERDBA

   Test Scope

   1. Execute an external operating system command (DBMCLI)

   2. Determine status using TCP/IP connection SAPDB_DBM (DBMRFC command mode)

   3. Determine status using TCP/IP connection SAPDB_DBM_DAEMON (DBMRFC session mode)

   4. Test the SQL connection (Native SQL at CON_NAME)

Application Server:  sapscm_AP1_00                            ( Windows NT )

   1. Connect. test with "dbmcli db_state"                         Successful

   2. Connect. test with command mode "dbmrfc db_state"            Successful

   3. Connect. test with session mode "dbmrfc db_state"            Successful

   4. Connect. test with "native SQL"  ( LCA )                     No connection

      SQL Code: 10709

       Connection failed (RTE:[2] too many database sessions active

      For detailed information, see the developer trace for work process:            4

'

Regards

SL

Accepted Solutions (1)

Accepted Solutions (1)

former_member229109
Active Contributor
0 Kudos

Hello SL,

post output of commands:

dbmcli db_enum

sdbregview -l

x_cons LC2 show active

Did you get LOG FULL issue, then create the complete databackup & set autolog on.

Regards, Natalia Khlopina

0 Kudos

hi,Khlopina ,

actually i m a functional consultant , so your comments is quite difficult for me to understand

i think the first step is to dig out the full log issue , could you help guide me how ? and after that lets see how can turn it back

thanks

rds

sl

former_member229109
Active Contributor
0 Kudos

Hello SL,

-> Just login to liveCache server and run:

    x_cons LC2 show active

   Check the logarea usage using transaction LC10 on the system.

-> Please forward my last reply to your liveCache administrator.

-> Create the SAP message to component "BC-DB-LVC" and get SAP support.

-> Review SAP note - 869267.

Regards, Natalia Khlopina

Former Member
0 Kudos

Hi Shaolong,

Please check the log area usage

check whether auto log is tuned on in LC10 transaction.

LC10 tcode

select LCA as Name of Database Connect

Select properties to find operation state of LC, Last initialization & Last start/stop action is OK (ticked with Green), Automatic log backup.

Check Log area usage:

Select Memory areas-->Log area

Best Regards,

Ganesh

former_member229109
Active Contributor
0 Kudos

Hello Ganesh,

I asked output of the command after login to liveCache server and run: 

    x_cons LC2 show active

Let Shaolong to post the output first.

Regards, NK

0 Kudos

hi, guys,

thanks all for your input

its resolved after i re-create new livecache and configure the connection for LCA/LDA/LEA and sync the data / setup the automatic backup plan for Livecache

not a easy job for me

thanks all

rds

SL

former_member229109
Active Contributor
0 Kudos

Hello SL,

recreation of the liveCache instance should the last selected option.

It's not clear if the analysis of the reported issue was done on your system.

I recommend to create the SAP message and get SAP support at first place.

Regards, Natalia Khlopina

PS:

For SAP liveCache documentation please see the SAP note 767598.

There is online training:

http://maxdb.sap.com/training/

former_member203438
Participant
0 Kudos

HI SL

i am getting the same problem can u plz share me the procedure how did reslolve and how did u recreate the Livecache .

its urgent please share the solution as soon as possible

Thanks

R@J

Answers (0)