on 11-30-2010 8:02 AM
Hi All,
when I'm trying to start liveCache I'm getting an error: "Cannot open SQL connection to liveCache LCA".
Operational state is online.
Kernel - 7.7.07
Next steps are successful:
"LC10 -> liveCache monitoring -> Tools -> dbmcli ::
a) sql_execute select * from users"
From Alert monitor I see an error: "Instance ONLINE, but no SQL access possible". If i try connection test, thenI see:
"
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: 4025
For detailed information, see the developer trace for work process: 2
"
How to see this developer trace I do not know...
Thanks!
In SM50 I found that "*** ERROR => different codepage: application=UNICODE, LVC=ASCII"
But during liveCache installation I cheched "Unicode SAP system". How can I check in MAXDB it's codepage version?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
"
I've downloaded and installed MaxDB from http://www.sdn.sap.com/irj/scn/maxdb-downloads. Is it incorrect? "
no it is not correct for 2 reasons:
1)
as SAP customer you should be downloading the software from SAP service marketplace , not from SDN
2)
when you want to install liveCache, use liveCache package, not MaxDB package, the one you used was MaxDB package
SDBUNINST should be part of liveCache installation (/sapdb/programs/bin)
Regards
Ivan
Edited by: Ivan Levrinc on Nov 30, 2010 3:58 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks.
I've did how you recomend: I've started installation from "51036865_13 BS 7 SR1 liveCache 7.7.04 Windows Server on x64 64bit".
During installation I have an error. In Log file I see:
===========
Execute Command : C:\sapdb\programs\pgm\dbmcli.exe -n kleva -d LCI -u CONTROL,******** db_start
Execute Session Command : exit
> Subprocess stops at 20101128003947
OK
-
> Subprocess starts at 20101128003947
Execute Command : C:\sapdb\programs\pgm\dbmcli.exe -n kleva -d LCI -u CONTROL,******** db_state
Execute Session Command : exit
> Subprocess stops at 20101128003948
> Subprocess call failed
ERR
-24961,ERR_STATE: The operational state of the database instance could not be determined
-24994,ERR_RTE: Runtime environment error
20067,Getting Kernel state failed: 2
=====================================================
The investiogation on this isue showd that:
1) I'm restarting server. when server is up, LCI db service is stoped.
2) I run db_state and see OFFLINE
3) I run db_start and see ONLINE, OK
4) I run again db_state and see
-24961,ERR_STATE: The operational state of the database instance could not be determined
-24994,ERR_RTE: Runtime environment error
5) most of the commands afterward returns same result.
Mark, I have this tool installed.
In those logs I found that:
Thread 0x1A8 Task 35 2010-11-30 23:30:20 Pager 20018: First DataCacheSegment:31
Thread 0x1A8 Task 1 2010-11-30 23:30:21 SrvTasks 31: Permanently reserved 13 servertasks for 'Backup / Restore'.
Thread 0x1A8 Task 1 2010-11-30 23:30:21 SrvTasks 31: Permanently reserved 2 servertasks for 'Backup / Restore'.
Thread 0x1A8 Task 1 2010-11-30 23:30:21 SrvTasks 31: Permanently reserved 1 servertasks for 'Savepoint'.
Thread 0x1A8 Task 1 2010-11-30 23:30:21 RTETask 18: Kernel initialization done
DESCRIPTION:
The initialization of the Kernel components has finished. All special tasks are started now.
Thread 0x1A5 Task - 2010-11-30 23:30:21 RunTime 3: State changed from STARTING to ADMIN
Thread 0x1A5 Task - 2010-11-30 23:30:21 STATE 19601: SERVERDB is ready
============================================ begin of write cycle ==================
Thread 0x1AA Task 71 2010-11-30 23:30:22 CONNECT 19633: Connect req. (LCI, T71, connection obj. 0x000007FFFFE30BF0, Node:'kleva', PID: 6676)
Thread 0x1AA Task 71 2010-11-30 23:30:22 ERR RTEIO 12: attach of volume DATA_VOLUME_0001 failed during open,VOLUME_NO=1,_FILE=RTEIO_VolumeInfo-k.cpp,_LINE=1776
DESCRIPTION:
An error accurred when trying to add the volume DATA_VOLUME_0001 with the logical number 1 to the configuration and physically attach it.
ACTION:
Contact your system administrator. Show him the error message which points to an operating system configuration error and then contact the database support if your system administrator can not fix the error.
2010-11-30 23:30:22 ERR RTEIO 1: The opening of path 'C:\sapdb\LCI\sapdata\DISKD0001' failed,DESCRIPTION=CreateFile(READWRITE,OPEN_EXISTING),ERRORTEXT=The system cannot find the file specified.
,RETURNCODE=2,_FILE=RTEIO_VolumeInfo-k.cpp,_LINE=2385
DESCRIPTION:
An attempt to open the path 'C:\sapdb\LCI\sapdata\DISKD0001' failed. The operating system returned the error code 2 and the error text 'The system cannot find the file specified.
'. The complete command line reads 'CreateFile(READWRITE,OPEN_EXISTING)'.
Thread 0x1AA Task 71 2010-11-30 23:30:22 ERR Admin 3: Database state: OFFLINE,_FILE=Kernel_Administration.cpp,_LINE=692
2010-11-30 23:30:22 KernelComm 6: Internal errorcode, Error code 9050 "disk_not_accessible"
2010-11-30 23:30:22 ERR Admin 20017: RestartFilesystem failed with 'I/O error',_FILE=Kernel_Administration.cpp,_LINE=410
Thread 0x1AA Task 71 2010-11-30 23:30:22 CONNECT 19651: Connection released (LCI, T71, connection obj. 000007FFFFE30BF0)
Thread 0x1AA Task 71 2010-11-30 23:30:22 RTEKernel 112: Offline KILL requested
Thread 0x1AA Task 71 2010-11-30 23:30:22 RunTime 3: State changed from ADMIN to SHUTDOWNKILL
Thread 0x1A0 Task - 2010-11-30 23:30:22 ERR Messages 7: Begin of dump of registered messages,_FILE=Msg_List.cpp,_LINE=3527
Thread 0x1A0 Task - 2010-11-30 23:30:19 RTEHSS 13951: No hot standby node configured -> No HotStandby configuration
Thread 0x1A0 Task - 2010-11-30 23:30:22 ERR RTEIO 1: The opening of path 'C:\sapdb\LCI\sapdata\DISKD0001' failed,DESCRIPTION=CreateFile(READWRITE,OPEN_EXISTING),ERRORTEXT=The system cannot find the file specified.
,RETURNCODE=2,_FILE=RTEIO_VolumeInfo-k.cpp,_LINE=2385
DESCRIPTION:
An attempt to open the path 'C:\sapdb\LCI\sapdata\DISKD0001' failed. The operating system returned the error code 2 and the error text 'The system cannot find the file specified.
'. The complete command line reads 'CreateFile(READWRITE,OPEN_EXISTING)'.
Thread 0x1A0 Task - 2010-11-30 23:30:22 ERR RTEIO 1: The opening of path 'C:\sapdb\LCI\sapdata\DISKD0001' failed,DESCRIPTION=CreateFile(READWRITE,OPEN_EXISTING),ERRORTEXT=The system cannot find the file specified.
,RETURNCODE=2,_FILE=RTEIO_VolumeInfo-k.cpp,_LINE=2385
DESCRIPTION:
An attempt to open the path 'C:\sapdb\LCI\sapdata\DISKD0001' failed. The operating system returned the error code 2 and the error text 'The system cannot find the file specified.
'. The complete command line reads 'CreateFile(READWRITE,OPEN_EXISTING)'.
Thread 0x1A0 Task - 2010-11-30 23:30:22 KernelComm 6: Internal errorcode, Error code 9050 "disk_not_accessible"
Thread 0x1A0 Task -Thread 0x1A0 Task - 2010-11-30 23:30:22 ERR Admin 3: Database state: OFFLINE,_FILE=Kernel_Administration.cpp,_LINE=692
2010-11-30 23:30:22 KernelComm 6: Internal errorcode, Error code 9050 "disk_not_accessible"
2010-11-30 23:30:22 ERR Admin 20017: RestartFilesystem failed with 'I/O error',_FILE=Kernel_Administration.cpp,_LINE=410
Thread 0x1A0 Task -Thread 0x1A0 Task - 2010-11-30 23:30:22 ERR Messages 8: End of the message list registry dump,_FILE=Msg_List.cpp,_LINE=3555
Thread 0x1A0 Task - 2010-11-30 23:30:22 RTEKernel 61: rtedump written to file 'rtedump'
Thread 0x1A6 Task 3 2010-11-30 23:30:22 Trace 20000: Start flush kernel trace
Thread 0x1A0 Task - 2010-11-30 23:30:22 RTEKernel 111: Tracewriter resumed
Thread 0x1A0 Task - 2010-11-30 23:30:22 RTEKernel 94: Waiting for tracewriter to finish work
Thread 0x1A0 Task - 2010-11-30 23:30:22 RTEKernel 116: Tracewriter termination timeout: 1200 seconds
Thread 0x1A6 Task 3 2010-11-30 23:30:22 Trace 20001: Stop flush kernel trace
Thread 0x1A6 Task 3 2010-11-30 23:30:22 Trace 20002: Start flush kernel dump
Thread 0x1A6 Task 3 2010-11-30 23:30:22 Trace 20003: Stop flush kernel dump
Thread 0x1A6 Task 3 2010-11-30 23:30:22 RTEKernel 110: Releasing tracewriter
Thread 0x1A0 Task - 2010-11-30 23:30:22 TASKING 19822: Thread 6712 joining
Thread 0x1A0 Task - 2010-11-30 23:30:22 TASKING 19822: Thread 6868 joining
Thread 0x1A0 Task - 2010-11-30 23:30:22 RTEThread 13: The thread Requestor_LCI is finished
Thread 0x1A0 Task - 2010-11-30 23:30:22 RTEThread 13: The thread LegacyRequestor is finished
Thread 0x1A0 Task - 2010-11-30 23:30:22 TASKING 19822: Thread 6836 joining
Thread 0x1AC Task - 2010-11-30 23:30:22 RTE 20214: CONSOLE thread stopped
Thread 0x1A0 Task - 2010-11-30 23:30:22 TASKING 19822: Thread 6716 joining
Thread 0x1A0 Task - 2010-11-30 23:30:22 TASKING 19822: Thread 6860 joining
Thread 0x1A0 Task - 2010-11-30 23:30:22 TASKING 19822: Thread 6708 joining
Thread 0x1A0 Task - 2010-11-30 23:30:22 TASKING 19822: Thread 6864 joining
Thread 0x1A0 Task - 2010-11-30 23:30:22 RTEKernel 58: Backup of diagnostic files will be forced at next restart
Thread 0x1A0 Task - 2010-11-30 23:30:22 RTEKernel 118: SERVERDB LCI has stopped
2010-11-30 23:30:22 RTEKernel 14: Kernel version: Kernel 7.7.04 Build 029-123-196-543
Thread 0x1A0 Task - 2010-11-30 23:30:22 RunTime 3: State changed from SHUTDOWNKILL to STOPPED
Thread 0x1A0 Task - 2010-11-30 23:30:22 TENANT 20005: Tenant database LCI has stopped
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
Looks like I'm not authorized to created folders/files in 'C:\sapdb\LCI\sapdata\'? But I can...
Mark,
I've checked the note. Unfortunatley it doesn't help. I did what it suggest, but the error remains!
I think that I have another reason for this issue because:
1) I dhould have db_addvolume and db_deletevolume in dbm.prt, but I do not have them!
2) The error message is a little bit different. In the note is "data volume configuration corrupted:", but I do not have this.
============================================ begin of write cycle ==================
Thread 0x938 Task 71 2010-12-01 23:09:09 CONNECT 19633: Connect req. (LCI, T71, connection obj. 0x000007FFFFE30BD0, Node:'kleva', PID: 3828)
Thread 0x938 Task 71 2010-12-01 23:09:10 ERR RTEIO 12: attach of volume DATA_VOLUME_0001 failed during open,VOLUME_NO=1,_FILE=RTEIO_VolumeInfo-k.cpp,_LINE=1776
DESCRIPTION:
An error accurred when trying to add the volume DATA_VOLUME_0001 with the logical number 1 to the configuration and physically attach it.
ACTION:
Contact your system administrator. Show him the error message which points to an operating system configuration error and then contact the database support if your system administrator can not fix the error.
2010-12-01 23:09:10 ERR RTEIO 1: The opening of path 'c:\sapdb\LCI\sapdata\DISKD0001' failed,DESCRIPTION=CreateFile(READWRITE,OPEN_EXISTING),ERRORTEXT=Access is denied.
,RETURNCODE=5,_FILE=RTEIO_VolumeInfo-k.cpp,_LINE=2385
DESCRIPTION:
An attempt to open the path 'c:\sapdb\LCI\sapdata\DISKD0001' failed. The operating system returned the error code 5 and the error text 'Access is denied.
'. The complete command line reads 'CreateFile(READWRITE,OPEN_EXISTING)'.
Thread 0x938 Task 71 2010-12-01 23:09:10 ERR Admin 3: Database state: OFFLINE,_FILE=Kernel_Administration.cpp,_LINE=692
2010-12-01 23:09:10 KernelComm 6: Internal errorcode, Error code 9050 "disk_not_accessible"
2010-12-01 23:09:10 ERR Admin 20017: RestartFilesystem failed with 'I/O error',_FILE=Kernel_Administration.cpp,_LINE=410
Thread 0x938 Task 71 2010-12-01 23:09:10 CONNECT 19651: Connection released (LCI, T71, connection obj. 000007FFFFE30BD0)
Thread 0x938 Task 71 2010-12-01 23:09:10 RTEKernel 112: Offline KILL requested
Thread 0x938 Task 71 2010-12-01 23:09:10 RunTime 3: State changed from ADMIN to SHUTDOWNKILL
Thread 0xE7C Task - 2010-12-01 23:09:10 ERR Messages 7: Begin of dump of registered messages,_FILE=Msg_List.cpp,_LINE=3527
Thread 0xE7C Task - 2010-12-01 23:09:08 RTEHSS 13951: No hot standby node configured -> No HotStandby configuration
Thread 0xE7C Task - 2010-12-01 23:09:10 ERR RTEIO 1: The opening of path 'c:\sapdb\LCI\sapdata\DISKD0001' failed,DESCRIPTION=CreateFile(READWRITE,OPEN_EXISTING),ERRORTEXT=Access is denied.
,RETURNCODE=5,_FILE=RTEIO_VolumeInfo-k.cpp,_LINE=2385
I've put all permissions allowing any actions (starting from c:\sbpdb).
The thing that I con not understand is that the error is: "An attempt to open the path 'C:\sapdb\LC2\sapdata\DISKD0001' failed."
But I do not have DISKD0001 folder in 'C:\sapdb\LC2\sapdata\ at all! May be that is the case? What shold be in there? When this folder should be created.
Looks like your database has not been created completely...
Perhaps you could drop your database first, and then re-create it: http://help.sap.com/saphelp_nw70ehp1/helpdata/en/6f/d53842134bad04e10000000a1550b0/frameset.htm
Kind regards,
Mark
Mark,
I've tried to do that. Drop db is not an issue:-)
I've started to create DB like SAP liveCache script is doing this according to XCMDOUT.LOG:
C:\sapdb\programs\pgm\dbmcli.exe -R C:\sapdb\LC2\db db_create LC2 CONTROL,********
C:\sapdb\programs\pgm\dbmcli.exe -n kleva -d LC2 -u CONTROL,******** param_directput CACHE_SIZE 68224
C:\sapdb\programs\pgm\dbmcli.exe -n kleva -d LC2 -u CONTROL,******** param_directput OMS_HEAP_LIMIT 545792
C:\sapdb\programs\pgm\dbmcli.exe -n kleva -d LC2 -u CONTROL,******** param_directput INSTANCE_TYPE LVC
C:\sapdb\programs\pgm\dbmcli.exe -n kleva -d LC2 -u CONTROL,******** param_directput LOG_MIRRORED NO
C:\sapdb\programs\pgm\dbmcli.exe -n kleva -d LC2 -u CONTROL,******** param_directput MAXUSERTASKS 34
C:\sapdb\programs\pgm\dbmcli.exe -n kleva -d LC2 -u CONTROL,******** param_directput MAXCPU 1
C:\sapdb\programs\pgm\dbmcli.exe -n kleva -d LC2 -u CONTROL,******** param_directput LOG_IO_QUEUE 2000
C:\sapdb\programs\pgm\dbmcli.exe -n kleva -d LC2 -u CONTROL,******** param_directput MAXLOCKS 300000
C:\sapdb\programs\pgm\dbmcli.exe -n kleva -d LC2 -u CONTROL,******** param_directput CAT_CACHE_SUPPLY 10000
C:\sapdb\programs\pgm\dbmcli.exe -n kleva -d LC2 -u CONTROL,******** param_directput JOIN_MAXTAB_LEVEL4 64
C:\sapdb\programs\pgm\dbmcli.exe -n kleva -d LC2 -u CONTROL,******** param_directput _UNICODE YES
C:\sapdb\programs\pgm\dbmcli.exe -n kleva -d LC2 -u CONTROL,******** param_directput DEFAULT_CODE ASCII
C:\sapdb\programs\pgm\dbmcli.exe -n kleva -d LC2 -u CONTROL,******** param_directput PACKETSIZE 131072
C:\sapdb\programs\pgm\dbmcli.exe -n kleva -d LC2 -u CONTROL,******** param_directput MCOD NO
C:\sapdb\programs\pgm\dbmcli.exe -n kleva -d LC2 -u CONTROL,******** param_directput MAXGARBAGECOLL 10
C:\sapdb\programs\pgm\dbmcli.exe -n kleva -d LC2 -u CONTROL,******** param_directput CLUSTERED_LOBS YES
C:\sapdb\programs\pgm\dbmcli.exe -n kleva -d LC2 -u CONTROL,******** param_directput LOG_QUEUE_COUNT 1
Execute Command : C:\sapdb\programs\pgm\dbmcli.exe -n kleva -d LC2 -u CONTROL,********
Execute Session Command : param_startsession
Execute Session Command : param_checkall
Execute Session Command : param_commitsession
Execute Session Command : exit
C:\sapdb\programs\pgm\dbmcli.exe -n kleva -d LC2 -u CONTROL,******** param_addvolume 1 DATA C:\sapdb\LC2\sapdata\DISKD0001 F 76800
C:\sapdb\programs\pgm\dbmcli.exe -n kleva -d LC2 -u CONTROL,******** param_addvolume 1 LOG C:\sapdb\LC2\saplog\DISKL001 F 76800
Execute Command : C:\sapdb\programs\pgm\dbmcli.exe -n kleva -d LC2 -u CONTROL,********
Execute Session Command : param_startsession
Execute Session Command : param_checkall
Execute Session Command : param_commitsession
Execute Session Command : exit
C:\sapdb\programs\pgm\dbmcli.exe -n kleva -d LC2 -u CONTROL,******** db_start
C:\sapdb\programs\pgm\dbmcli.exe -n kleva -d LC2 -u CONTROL,******** db_state
and now it fails again. ove?
What I do not understand is that why in the log there is no db_addvolume command? I've tried to execute this (it returns errors), but is doesn't help.
On wich step C:\sapdb\LC2\sapdata\DISKD0001 should be created from log ab
Hi,
Check this link for the documentation on users and groups:
http://help.sap.com/saphelp_nw70ehp1/helpdata/en/02/fccab622cd414488fc926278851263/frameset.htm
Kind regards,
Mark
I've solved last error with autorization.
So I successfully recreated DB.
Now very strande thing happens (that's why my installation fails):
If i run
C:\sapdb\programs\pgm\dbmcli.exe -n kleva -d LC2 -u CONTROL,******** db_start
C:\sapdb\programs\pgm\dbmcli.exe -n kleva -d LC2 -u CONTROL,******** db_state
then I have runtime error (and standard installator gets it).
But if I run
C:\sapdb\programs\pgm\dbmcli.exe -n localhost -d LC2 -u CONTROL,******** db_start
C:\sapdb\programs\pgm\dbmcli.exe -n localhost-d LC2 -u CONTROL,******** db_state
then it is ok!
Why that can be?
Mark,
the resolving is ok: ping kleva shows ip 10.0.0.1. ping localhost shows 127.0.0.1
I have installed MS loopback adapter with assigned 10.0.0.1 address.
If I connect to 10.0.0.1 as a host name in dbmcli then evverything is ok. If I connect to kleva (which is assigned to 10.0.0.1 in hosts file and ping confirms it) then dbmcli returns runtime error for db_state.
SAP insatllation tries to access through hostname kleva.
I'm totaly confused.
28530 (POS(0) Incompatible Version: LiveCache: 777016, LC-Apps: 774029"
-> something went really wrong here
"
That's why I've installed liveCache 7.7.7016 and proceed with liceCache Server installation which was successfull."
-> what is the name of the .SAR file you have used for this installation ?
->, I would usggest following
1) drop liveCache instance and use SDBUNINST utility to uninstall everything from liveCache server
2) use SAP installation DVD with "liveCache server" and install liveCache again
3) if you decide to upgrade liveCache (apply patch) than make sure you are uing correct liveCache package
name of .SAR file usually starts with LCA*.SAR
Regards
Ivan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I've downloaded and installed MaxDB from http://www.sdn.sap.com/irj/scn/maxdb-downloads. Is it incorrect?
I do not have any SAR file in my distributive. I have disr number "51036865_13 BS 7 SR1 liveCache 7.7.04 Windows Server on x64 64bit"
And there is only SDBINST, and no SDBUNINST.
Thanks! It helps.
I've changed it to UNICODE, but now I'm facing another error in SM50: "C *** ERROR => execute() of C_0010, #rec=0, rc=1, rcSQL=-28530 (POS(0) Incompatible Version: LiveCache: 777016, LC-Apps: 774029"
It is because I've installed SCM with 7.7.4029 liveCache version. During liveCache server installation there were errors (MAXDB behaves very strange, after db_start it returns ok, but if I execute db_state afterwards, then runtime error occurs). That's why I've installed liveCache 7.7.7016 and proceed with liceCache Server installation which was successfull.
How can I install client part 7.7.7016 to avoid this error?
In MAXDB installed components I see that SAP Utilities are 7.7.04.29. Looks like this should be updated?
Edited by: kleva82 on Nov 30, 2010 3:28 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.