- SAP Community
- Products and Technology
- Technology
- Technology Q&A
- homogenous system copy
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
homogenous system copy
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
on 09-24-2007 8:09 AM
Hi all
iam doing system copy of livecache as per SAP note i.e restore and intialize instance when i started to install and restore iam getting the error
-24988 sql error and -3008 missing keyword & invalid identifier
so please suggest me
- SAP Managed Tags:
- SAP MaxDB,
- SAP Customer Relationship Management
Accepted Solutions (1)
Accepted Solutions (1)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Date Time TID(hex) Typ MsgID Label Message
-
2007-09-24 10:46:44 0x00000a60 INF 216 DBMSrv DBM Server client connection (established at 2007-09-24 10:46:44): PID 2644 on computer scmtest
2007-09-24 10:46:44 0x00000a60 INF 283 DBMSrv command db_activate
2007-09-24 10:48:08 0x00000a60 INF 226 DBMSrv DBM Server client disconnect: PID 2644 on computer scmtest
2007-09-24 10:48:09 0x000005a0 INF 216 DBMSrv DBM Server client connection (established at 2007-09-24 10:48:08): PID 2772 on computer scmtest
2007-09-24 10:48:09 0x000005a0 INF 283 DBMSrv command load_systab
2007-09-24 10:48:22 0x000005a0 INF 226 DBMSrv DBM Server client disconnect: PID 2772 on computer scmtest
2007-09-24 10:48:24 0x00000ba8 INF 216 DBMSrv DBM Server client connection (established at 2007-09-24 10:48:24): PID 2992 on computer scmtest
2007-09-24 10:48:24 0x00000ba8 INF 283 DBMSrv command user_sap
2007-09-24 10:48:24 0x00000ba8 INF 226 DBMSrv DBM Server client disconnect: PID 2992 on computer scmtest
2007-09-24 11:12:10 0x000000ec INF 216 DBMSrv DBM Server client connection (established at 2007-09-24 11:11:15): PID 1744 on computer scmtest
2007-09-24 11:12:10 0x000000ec INF 283 DBMSrv command user_get
2007-09-24 11:12:10 0x000000ec ERR -24951 DBMSrv ERR_USRREAD: could not read user data
2007-09-24 11:12:23 0x000000ec INF 283 DBMSrv command user_sap
2007-09-24 11:12:26 0x000000ec INF 283 DBMSrv command dban_stop
2007-09-24 11:12:29 0x000000ec ERR -24964 DBMSrv ERR_EXECUTE: error in program execution
0x000000ec ERR -24778 DBMSrv 1,"d:\sapdb\programs\bin\dbanalyzer" -d L03 -u , -stop
0x000000ec ERR -24778 DBMSrv MaxDB Database Analyzer, The Performance Analysis Tool, Version 7.6.00.22
0x000000ec ERR -24778 DBMSrv Copyright 2000-2006 by SAP AG
0x000000ec ERR -24778 DBMSrv
0x000000ec ERR -24778 DBMSrv Used protocol directory: d:\sapdb\data\wrk\L03\analyzer
0x000000ec ERR -24778 DBMSrv
0x000000ec ERR -24778 DBMSrv ERROR 20: Database Analyzer not active in directory "d:\sapdb\data\wrk\L03\analyzer".
0x000000ec ERR -24778 DBMSrv
2007-09-24 11:12:31 0x00000ae4 INF 216 DBMSrv DBM Server client connection (established at 2007-09-24 11:12:31): PID 1512 on computer scmtest
2007-09-24 11:12:31 0x00000ae4 INF 283 DBMSrv command exec_lcinit
2007-09-24 11:12:35 0x000009d0 INF 216 DBMSrv DBM Server client connection (established at 2007-09-24 11:12:35): PID 2248 on computer scmtest
2007-09-24 11:12:35 0x000009d0 INF 283 DBMSrv command db_offline
2007-09-24 11:13:01 0x000009d0 INF 226 DBMSrv DBM Server client disconnect: PID 2248 on computer scmtest
2007-09-24 11:13:02 0x00000ae4 INF 226 DBMSrv DBM Server client disconnect: PID 1512 on computer scmtest
2007-09-24 11:14:01 0x000000ec INF 226 DBMSrv DBM Server client disconnect: PID 1744 on computer scmtest
2007-09-24 11:22:09 0x00000380 INF 216 DBMSrv DBM Server client connection (established at 2007-09-24 11:22:09): PID 1908 on computer scmtest
2007-09-24 11:22:09 0x00000380 INF 283 DBMSrv command db_clear
2007-09-24 11:22:09 0x00000380 INF 226 DBMSrv DBM Server client disconnect: PID 1908 on computer scmtest
2007-09-24 11:22:09 0x00000964 INF 216 DBMSrv DBM Server client connection (established at 2007-09-24 11:22:09): PID 1908 on computer scmtest
2007-09-24 11:22:09 0x00000964 INF 283 DBMSrv command exec_lcinit
2007-09-24 11:22:11 0x00000728 INF 216 DBMSrv DBM Server client connection (established at 2007-09-24 11:22:11): PID 1860 on computer scmtest
2007-09-24 11:22:11 0x00000728 INF 283 DBMSrv command db_admin
2007-09-24 11:22:27 0x00000728 INF 226 DBMSrv DBM Server client disconnect: PID 1860 on computer scmtest
2007-09-24 11:22:28 0x00000b5c INF 216 DBMSrv DBM Server client connection (established at 2007-09-24 11:22:28): PID 2612 on computer scmtest
2007-09-24 11:22:28 0x00000b5c INF 283 DBMSrv command db_online
2007-09-24 11:22:30 0x00000b5c INF 226 DBMSrv DBM Server client disconnect: PID 2612 on computer scmtest
2007-09-24 11:22:30 0x00000ba8 INF 216 DBMSrv DBM Server client connection (established at 2007-09-24 11:22:30): PID 2860 on computer scmtest
2007-09-24 11:22:30 0x00000ba8 INF 283 DBMSrv command load_lcapps
2007-09-24 11:22:41 0x00000ba8 INF 226 DBMSrv DBM Server client disconnect: PID 2860 on computer scmtest
2007-09-24 11:22:42 0x00000c70 INF 216 DBMSrv DBM Server client connection (established at 2007-09-24 11:22:42): PID 3172 on computer scmtest
2007-09-24 11:22:42 0x00000c70 INF 283 DBMSrv command user_sap
2007-09-24 11:22:42 0x00000c70 INF 226 DBMSrv DBM Server client disconnect: PID 3172 on computer scmtest
2007-09-24 11:22:42 0x00000964 INF 226 DBMSrv DBM Server client disconnect: PID 1908 on computer scmtest
2007-09-24 11:22:43 0x00000720 INF 216 DBMSrv DBM Server client connection (established at 2007-09-24 11:22:00): PID 3064 on computer scmtest
2007-09-24 11:22:43 0x00000720 INF 283 DBMSrv command dban_stop
2007-09-24 11:22:43 0x00000720 ERR -24964 DBMSrv ERR_EXECUTE: error in program execution
0x00000720 ERR -24778 DBMSrv 1,"d:\sapdb\programs\bin\dbanalyzer" -d L03 -u , -stop
0x00000720 ERR -24778 DBMSrv MaxDB Database Analyzer, The Performance Analysis Tool, Version 7.6.00.22
0x00000720 ERR -24778 DBMSrv Copyright 2000-2006 by SAP AG
0x00000720 ERR -24778 DBMSrv
0x00000720 ERR -24778 DBMSrv Used protocol directory: d:\sapdb\data\wrk\L03\analyzer
0x00000720 ERR -24778 DBMSrv
0x00000720 ERR -24778 DBMSrv ERROR 20: Database Analyzer not active in directory "d:\sapdb\data\wrk\L03\analyzer".
0x00000720 ERR -24778 DBMSrv
2007-09-24 11:22:46 0x00000720 INF 283 DBMSrv command dban_start
2007-09-24 11:24:33 0x00000de8 INF 216 DBMSrv DBM Server client connection (established at 2007-09-24 11:24:24): PID 3508 on computer scmtest
2007-09-24 11:24:33 0x00000de8 INF 283 DBMSrv command db_offline
2007-09-24 11:25:22 0x00000ea8 INF 216 DBMSrv DBM Server client connection (established at 2007-09-24 11:25:14): PID 3656 on computer scmtest
2007-09-24 11:25:22 0x00000ea8 INF 283 DBMSrv command param_checkall EXTENDED
2007-09-24 11:25:22 0x00000ea8 INF 283 DBMSrv command param_commitsession NOCLOSE
2007-09-24 11:25:22 0x00000ea8 INF 283 DBMSrv command param_checkall EXTENDED
2007-09-24 11:25:22 0x00000ea8 INF 283 DBMSrv command param_commitsession
2007-09-24 11:25:27 0x00000ea8 INF 283 DBMSrv command db_cold -f
2007-09-24 11:25:41 0x00000ea8 INF 283 DBMSrv command util_execute INIT CONFIG
2007-09-24 11:25:41 0x00000ea8 ERR -24988 DBMSrv ERR_SQL: Sql error
2007-09-24 11:25:54 0x00000ea8 ERR -24811 DBMSrv ERR_CONNLOST: connection to client lost (error code 10)
2007-09-24 11:25:54 0x00000ea8 INF 226 DBMSrv DBM Server client disconnect: PID 3656 on computer scmtest
2007-09-24 11:26:32 0x00000de8 INF 226 DBMSrv DBM Server client disconnect: PID 3508 on computer scmtest
2007-09-24 11:27:24 0x00000720 INF 283 DBMSrv command dban_stop
2007-09-24 11:27:24 0x00000720 ERR -24936 DBMSrv ERR_DBNORUN: database is not running
2007-09-24 11:27:28 0x0000031c INF 216 DBMSrv DBM Server client connection (established at 2007-09-24 11:27:28): PID 764 on computer scmtest
2007-09-24 11:27:28 0x0000031c INF 283 DBMSrv command exec_lcinit
2007-09-24 11:27:29 0x00000c18 INF 216 DBMSrv DBM Server client connection (established at 2007-09-24 11:27:29): PID 3120 on computer scmtest
2007-09-24 11:27:29 0x00000c18 INF 283 DBMSrv command db_offline
2007-09-24 11:27:31 0x00000c18 INF 226 DBMSrv DBM Server client disconnect: PID 3120 on computer scmtest
2007-09-24 11:27:31 0x00000c3c INF 216 DBMSrv DBM Server client connection (established at 2007-09-24 11:27:31): PID 3124 on computer scmtest
2007-09-24 11:27:31 0x00000c3c INF 283 DBMSrv command db_admin
2007-09-24 11:27:46 0x00000c3c INF 226 DBMSrv DBM Server client disconnect: PID 3124 on computer scmtest
2007-09-24 11:27:47 0x00000bb4 INF 216 DBMSrv DBM Server client connection (established at 2007-09-24 11:27:47): PID 1196 on computer scmtest
2007-09-24 11:27:47 0x00000bb4 INF 283 DBMSrv command db_offline
2007-09-24 11:27:49 0x00000bb4 INF 226 DBMSrv DBM Server client disconnect: PID 1196 on computer scmtest
2007-09-24 11:27:49 0x0000031c INF 226 DBMSrv DBM Server client disconnect: PID 764 on computer scmtest
2007-09-24 11:28:07 0x00000da0 INF 216 DBMSrv DBM Server client connection (established at 2007-09-24 11:28:07): PID 764 on computer scmtest
2007-09-24 11:28:07 0x00000da0 INF 283 DBMSrv command db_clear
2007-09-24 11:28:07 0x00000da0 INF 226 DBMSrv DBM Server client disconnect: PID 764 on computer scmtest
2007-09-24 11:28:07 0x00000d8c INF 216 DBMSrv DBM Server client connection (established at 2007-09-24 11:28:07): PID 764 on computer scmtest
2007-09-24 11:28:07 0x00000d8c INF 283 DBMSrv command exec_lcinit
2007-09-24 11:28:09 0x00000e70 INF 216 DBMSrv DBM Server client connection (established at 2007-09-24 11:28:09): PID 2964 on computer scmtest
2007-09-24 11:28:09 0x00000e70 INF 283 DBMSrv command db_admin
2007-09-24 11:28:23 0x00000e70 INF 226 DBMSrv DBM Server client disconnect: PID 2964 on computer scmtest
2007-09-24 11:28:23 0x00000f8c INF 216 DBMSrv DBM Server client connection (established at 2007-09-24 11:28:23): PID 560 on computer scmtest
2007-09-24 11:28:23 0x00000f8c INF 283 DBMSrv command db_online
2007-09-24 11:28:24 0x00000f8c INF 226 DBMSrv DBM Server client disconnect: PID 560 on computer scmtest
2007-09-24 11:28:24 0x00000dbc INF 216 DBMSrv DBM Server client connection (established at 2007-09-24 11:28:24): PID 4008 on computer scmtest
2007-09-24 11:28:24 0x00000dbc INF 283 DBMSrv command load_lcapps
2007-09-24 11:28:30 0x00000dbc INF 226 DBMSrv DBM Server client disconnect: PID 4008 on computer scmtest
2007-09-24 11:28:30 0x00000710 INF 216 DBMSrv DBM Server client connection (established at 2007-09-24 11:28:30): PID 912 on computer scmtest
2007-09-24 11:28:30 0x00000710 INF 283 DBMSrv command user_sap
2007-09-24 11:28:30 0x00000710 INF 226 DBMSrv DBM Server client disconnect: PID 912 on computer scmtest
2007-09-24 11:28:30 0x00000d8c INF 226 DBMSrv DBM Server client disconnect: PID 764 on computer scmtest
2007-09-24 11:28:31 0x00000720 INF 283 DBMSrv command dban_stop
2007-09-24 11:28:31 0x00000720 ERR -24964 DBMSrv ERR_EXECUTE: error in program execution
0x00000720 ERR -24778 DBMSrv 1,"d:\sapdb\programs\bin\dbanalyzer" -d L03 -u , -stop
0x00000720 ERR -24778 DBMSrv MaxDB Database Analyzer, The Performance Analysis Tool, Version 7.6.00.22
0x00000720 ERR -24778 DBMSrv Copyright 2000-2006 by SAP AG
0x00000720 ERR -24778 DBMSrv
0x00000720 ERR -24778 DBMSrv Used protocol directory: d:\sapdb\data\wrk\L03\analyzer
0x00000720 ERR -24778 DBMSrv
0x00000720 ERR -24778 DBMSrv ERROR 20: Database Analyzer not active in directory "d:\sapdb\data\wrk\L03\analyzer".
0x00000720 ERR -24778 DBMSrv
2007-09-24 11:28:34 0x00000720 INF 283 DBMSrv command dban_start
2007-09-24 11:34:25 0x00000720 INF 283 DBMSrv command dbm_configset DBADTL
2007-09-24 11:34:26 0x000000b8 INF 216 DBMSrv DBM Server client connection (established at 2007-09-24 11:34:25): PID 3312 on computer scmtest
2007-09-24 11:34:26 0x000000b8 INF 283 DBMSrv command file_getfirst
2007-09-24 11:34:26 0x000000b8 ERR -24994 DBMSrv ERR_RTE: Runtime environment error
0x000000b8 ERR -24778 DBMSrv 1,wrong file or device name
2007-09-24 11:34:26 0x000000b8 INF 226 DBMSrv DBM Server client disconnect: PID 3312 on computer scmtest
2007-09-24 11:35:49 0x00000720 INF 283 DBMSrv command dban_stop
2007-09-24 11:35:50 0x00000244 INF 216 DBMSrv DBM Server client connection (established at 2007-09-24 11:35:50): PID 1184 on computer scmtest
2007-09-24 11:35:50 0x00000244 INF 283 DBMSrv command exec_lcinit
2007-09-24 11:35:53 0x0000012c INF 216 DBMSrv DBM Server client connection (established at 2007-09-24 11:35:52): PID 376 on computer scmtest
2007-09-24 11:35:53 0x0000012c INF 283 DBMSrv command db_offline
2007-09-24 11:35:55 0x0000012c INF 226 DBMSrv DBM Server client disconnect: PID 376 on computer scmtest
2007-09-24 11:35:55 0x00000244 INF 226 DBMSrv DBM Server client disconnect: PID 1184 on computer scmtest
2007-09-24 11:36:40 0x00000720 INF 226 DBMSrv DBM Server client disconnect: PID 3064 on computer scmtest
2007-09-24 11:39:20 0x00000c6c INF 216 DBMSrv DBM Server client connection (established at 2007-09-24 11:39:09): PID 3196 on computer scmtest
2007-09-24 11:39:20 0x00000c6c INF 283 DBMSrv command db_cold -f
2007-09-24 11:39:41 0x00000c6c INF 283 DBMSrv command db_warm -f
2007-09-24 11:42:14 0x00000d48 INF 216 DBMSrv DBM Server client connection (established at 2007-09-24 11:42:02): PID 3380 on computer scmtest
2007-09-24 11:42:14 0x00000d48 INF 283 DBMSrv command db_offline
2007-09-24 11:42:14 0x00000d48 ERR -24996 DBMSrv ERR_PARAM: wrong parameters
2007-09-24 11:42:20 0x00000d84 INF 216 DBMSrv DBM Server client connection (established at 2007-09-24 11:42:18): PID 3380 on computer scmtest
2007-09-24 11:42:20 0x00000d84 INF 283 DBMSrv command db_offline
2007-09-24 11:42:30 0x00000d84 INF 283 DBMSrv command param_checkall EXTENDED
2007-09-24 11:42:30 0x00000d84 INF 283 DBMSrv command param_commitsession NOCLOSE
2007-09-24 11:42:30 0x00000d84 INF 283 DBMSrv command param_checkall EXTENDED
2007-09-24 11:42:30 0x00000d84 INF 283 DBMSrv command param_commitsession
2007-09-24 11:42:38 0x00000d84 INF 283 DBMSrv command db_cold -f
2007-09-24 11:42:57 0x00000d84 INF 283 DBMSrv command util_execute INIT CONFIG
2007-09-24 11:42:57 0x00000d84 ERR -24988 DBMSrv ERR_SQL: Sql error
2007-09-24 11:43:29 0x00000d48 ERR -24811 DBMSrv ERR_CONNLOST: connection to client lost (error code 10)
2007-09-24 11:43:29 0x00000d48 INF 226 DBMSrv DBM Server client disconnect: PID 3380 on computer scmtest
2007-09-24 11:43:29 0x00000d84 ERR -24811 DBMSrv ERR_CONNLOST: connection to client lost (error code 10)
2007-09-24 11:43:29 0x00000d84 INF 226 DBMSrv DBM Server client disconnect: PID 3380 on computer scmtest
2007-09-24 12:27:11 0x00000c6c INF 226 DBMSrv DBM Server client disconnect: PID 3196 on computer scmtest
this is error log iam getting
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hello Rajesh,
-> Please update the thread with additional information:
What is the version of the liveCache do you have?
What is the version of the DBMGUI?
-> Please review the SAP notes::
457425 Homogenous liveCache copy using backup/restore
386714 SQL studio + Database Manager GUI installation
-> For SAP liveCache documentation see the SAP note 767598.
-> From the posted the dbm.prt file & initial reported problem, in your version of the database the DBM command 'db_activate' has to be used instead 'util_execute INIT CONFIG'.
< db_activate ::
http://maxdb.sap.com/currentdoc/91/1a74d35cad11d4aa1500a0c9430730/content.htm
db_activate RECOVER ::
http://maxdb.sap.com/currentdoc/2f/40d93fac0fec06e10000000a1550b0/content.htm >
If you are using DBMGUI tool, please update the DBMGUI as pro SAP note 386714.
If you are using dbmcli tool, please review information at link:
http://maxdb.sap.com/currentdoc/87/dba841c0dae234e10000000a1550b0/content.htm
Thank you and best regards, Natalia Khlopina
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Answers (2)
Answers (2)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
hi
livecache version is 7.6.00
DBM server version is 7.6.00
SAPDB manager verion is 7.4
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Please post the last logs of knldiag containing the error.
--
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Configuring SAP CI/CD pipeline for Deploying ReactJS application in Cloud Foundry in Technology Q&A
- App to automatically configure a new ABAP Developer System in Technology Blogs by Members
- Systemcopy sap QAS longTime in Technology Q&A
- SAP Signavio is the highest ranked Leader in the SPARK Matrix™ Digital Twin of an Organization (DTO) in Technology Blogs by SAP
- ABAP Cloud Developer Trial 2022 Available Now in Technology Blogs by SAP
| User | Count |
|---|---|
| 85 | |
| 10 | |
| 10 | |
| 10 | |
| 7 | |
| 6 | |
| 6 | |
| 5 | |
| 4 | |
| 4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.