День добрый. Требуется помощь по решению проблемы, периодически возникающей при выгрузки данных из R3 в BW.
При возникновении проблемы формируется дамп :
Code:
Runtime Error DBIF_DSQL2_SQL_ERROR
Exception CX_SY_NATIVE_SQL_ERROR
Occurred on 11.02.2009 at 04:04:37
SQL error 3114 occurred when executing EXEC SQL.
What happened?
The error occurred in the current database connection "R/3*".
Error analysis
An exception occurred. This exception is dealt with in more detail below
. The exception, which is assigned to the class 'CX_SY_NATIVE_SQL_ERROR', was
neither
caught nor passed along using a RAISING clause, in the procedure
"SID_RECORD_UPDATE" "(FORM)"
.
Since the caller of the procedure could not have expected this exception
to occur, the running program was terminated.
The reason for the exception is:
How to correct the error
The exception must either be prevented, caught within the procedure
"SID_RECORD_UPDATE"
"(FORM)", or declared in the procedure's RAISING clause.
To prevent the exception, note the following:
Database error text........: "ORA-03114: not connected to ORACLE"
Triggering SQL statement...: "UPDATE "/BI0/SREQUID" SET "DATAFL" = ? , "INCFL"
= ? WHERE "REQUID" = ? "
Internal call code.........: "[DBDS/NEW DSQL]"
Please check the entries in the system log (Transaction SM21).
You may able to find an interim solution to the problem
in the SAP note system. If you have access to the note system yourself,
use the following search criteria:
------------------------------------------------------------------------
"DBIF_DSQL2_SQL_ERROR" CX_SY_NATIVE_SQL_ERRORC
"GP4DF48GB7N4FFLTLDLUGHMH8EA " or "GP4DF48GB7N4FFLTLDLUGHMH8EA "
"SID_RECORD_UPDATE"
В системном журнале BW слудующее
Code:
04:04:36 DIA 03 500 ALEREMOTE BY2 Database error 3114 at EXE
04:04:36 DIA 03 500 ALEREMOTE BY0 > ORA-03114: not connected to ORACLE
04:04:36 DIA 03 500 ALEREMOTE R68 Perform rollback
04:04:36 DIA 03 500 ALEREMOTE BYM SQL error 3114 . Work processes in reconnect status
04:04:36 DIA 03 500 ALEREMOTE BYY Work process has left reconnect status
04:04:37 DIA 03 500 ALEREMOTE AB0 Run-time error "DBIF_DSQL2_SQL_ERROR" occurred
04:04:38 DIA 03 500 ALEREMOTE AB1 > Short dump "090211 040437 ornbw ALEREMOTE " generated
07:00:00 DIA 01 000 SAPSYS EEA OPERATION MODES: Switch to operation mode DAY triggered
Кусочек алерта с продуктивной системы - никаких ошибок во время дампа:
Code:
Wed Feb 11 03:50:32 2009
/* BRCONNECT */ ALTER TABLESPACE "PSAPUSER1I" COALESCE
Completed: /* BRCONNECT */ ALTER TABLESPACE "PSAPUSER1I" COALESCE
Wed Feb 11 03:50:32 2009
/* BRCONNECT */ ALTER TABLESPACE "SYSTEM" COALESCE
Completed: /* BRCONNECT */ ALTER TABLESPACE "SYSTEM" COALESCE
Wed Feb 11 03:50:46 2009
Incremental checkpoint up to RBA [0x3650.9a6e.0], current log tail at RBA [0x3650.9b60.0]
Wed Feb 11 04:03:17 2009
Beginning log switch checkpoint up to RBA [0x3651.2.10], SCN: 938009152
Thread 1 advanced to log sequence 13905
Current log# 13 seq# 13905 mem# 0: /oracle/ORN/origlogA/log_g13m1.dbf
Current log# 13 seq# 13905 mem# 1: /oracle/ORN/mirrlogA/log_g13m2.dbf
Wed Feb 11 04:08:21 2009
Completed checkpoint up to RBA [0x3651.2.10], SCN: 938009152
Wed Feb 11 04:12:29 2009
Beginning log switch checkpoint up to RBA [0x3652.2.10], SCN: 938014202
Thread 1 advanced to log sequence 13906
Current log# 15 seq# 13906 mem# 0: /oracle/ORN/origlogA/log_g15m1.dbf
Current log# 15 seq# 13906 mem# 1: /oracle/ORN/mirrlogB/log_g15m2.dbf
Wed Feb 11 04:17:33 2009
Completed checkpoint up to RBA [0x3652.2.10], SCN: 938014202
Wed Feb 11 04:20:54 2009
Incremental checkpoint up to RBA [0x3652.24d0.0], current log tail at RBA [0x3652.5eb1.0]
Wed Feb 11 04:31:22 2009
Beginning log switch checkpoint up to RBA [0x3653.2.10], SCN: 938020635
Thread 1 advanced to log sequence 13907
Current log# 11 seq# 13907 mem# 0: /oracle/ORN/origlogA/log_g11m1.dbf
Current log# 11 seq# 13907 mem# 1: /oracle/ORN/mirrlogA/log_g11m2.dbf
Wed Feb 11 04:36:25 2009
Completed checkpoint up to RBA [0x3653.2.10], SCN: 938020635
Wed Feb 11 04:38:22 2009
Beginning log switch checkpoint up to RBA [0x3654.2.10], SCN: 938025532
Thread 1 advanced to log sequence 13908
Current log# 12 seq# 13908 mem# 0: /oracle/ORN/origlogB/log_g12m1.dbf
Current log# 12 seq# 13908 mem# 1: /oracle/ORN/mirrlogB/log_g12m2.dbf
Wed Feb 11 04:43:04 2009
Beginning log switch checkpoint up to RBA [0x3655.2.10], SCN: 938031075
Thread 1 advanced to log sequence 13909
Current log# 14 seq# 13909 mem# 0: /oracle/ORN/origlogB/log_g14m1.dbf
Current log# 14 seq# 13909 mem# 1: /oracle/ORN/mirrlogB/log_g14m2.dbf
Wed Feb 11 04:43:25 2009
а в BW тем более ничего криминального :
Code:
Wed Feb 11 03:52:34 2009
Completed checkpoint up to RBA [0x3810.2.10], SCN: 0x0000.7861d667
Wed Feb 11 04:01:01 2009
Beginning log switch checkpoint up to RBA [0x3811.2.10], SCN: 0x0000.786462da
Thread 1 advanced to log sequence 14353
Current log# 4 seq# 14353 mem# 0: /oracle/OBW/origlogB/log_g14m1.dbf
Current log# 4 seq# 14353 mem# 1: /oracle/OBW/mirrlogB/log_g14m2.dbf
Wed Feb 11 04:01:01 2009
ARC0: Evaluating archive log 3 thread 1 sequence 14352
ARC0: Beginning to archive log 3 thread 1 sequence 14352
Creating archive destination LOG_ARCHIVE_DEST_1: '/oracle/OBW/oraarch/OBWarch1_14352.dbf'
ARC0: Completed archiving log 3 thread 1 sequence 14352
Wed Feb 11 04:05:18 2009
Completed checkpoint up to RBA [0x3811.2.10], SCN: 0x0000.786462da
Wed Feb 11 04:06:45 2009
Beginning log switch checkpoint up to RBA [0x3812.2.10], SCN: 0x0000.78648832
Thread 1 advanced to log sequence 14354
Current log# 1 seq# 14354 mem# 0: /oracle/OBW/origlogA/log_g11m1.dbf
Current log# 1 seq# 14354 mem# 1: /oracle/OBW/mirrlogA/log_g11m2.dbf
Wed Feb 11 04:06:45 2009
ARC1: Evaluating archive log 4 thread 1 sequence 14353
ARC1: Beginning to archive log 4 thread 1 sequence 14353
Creating archive destination LOG_ARCHIVE_DEST_1: '/oracle/OBW/oraarch/OBWarch1_14353.dbf'
ARC1: Completed archiving log 4 thread 1 sequence 14353
Wed Feb 11 04:09:00 2009
Beginning log switch checkpoint up to RBA [0x3813.2.10], SCN: 0x0000.78648fda
Wed Feb 11 04:09:00 2009
Thread 1 advanced to log sequence 14355
Current log# 2 seq# 14355 mem# 0: /oracle/OBW/origlogB/log_g12m1.dbf
Wed Feb 11 04:09:00 2009
ARC0: Evaluating archive log 1 thread 1 sequence 14354
Current log# 2 seq# 14355 mem# 1: /oracle/OBW/mirrlogB/log_g12m2.dbf
Wed Feb 11 04:09:00 2009
ARC0: Beginning to archive log 1 thread 1 sequence 14354
Creating archive destination LOG_ARCHIVE_DEST_1: '/oracle/OBW/oraarch/OBWarch1_14354.dbf'
Wed Feb 11 04:09:00 2009
Completed checkpoint up to RBA [0x3812.2.10], SCN: 0x0000.78648832
Wed Feb 11 04:09:02 2009
ARC0: Completed archiving log 1 thread 1 sequence 14354
Wed Feb 11 04:09:34 2009
Completed checkpoint up to RBA [0x3813.2.10], SCN: 0x0000.78648fda
Wed Feb 11 04:09:34 2009
в логе процесса есть кое-что
Code:
C Tue Feb 10 23:50:42 2009
C Starting user session (con_hdl=0,svchp=8000000102699c68,srvhp=8000000104226eb8,usrhp=800000010371bbe0)
C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1034
[dboci.c 3807]
C Detaching from DB Server (con_hdl=0,svchp=8000000102699c68,srvhp=8000000104226eb8)
C *** ERROR => CONNECT failed with sql error '1034'
[dbsloci.c 9650]
C
C Tue Feb 10 23:50:47 2009
C Logon as OPS$-user to get SAPOBW's password
C Connecting as /@OBW on connection 0 ...
C Attaching to DB Server OBW (con_hdl=0,svchp=8000000102699c68,svrhp=8000000104226eb8)
C
C Tue Feb 10 23:50:48 2009
C Starting user session (con_hdl=0,svchp=8000000102699c68,srvhp=8000000104226eb8,usrhp=800000010371bbe0)
C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1034
[dboci.c 3807]
C Detaching from DB Server (con_hdl=0,svchp=8000000102699c68,srvhp=8000000104226eb8)
C *** ERROR => CONNECT failed with sql error '1034'
[dbsloci.c 9650]
C Try to connect with default password
C Connecting as SAPOBW/<pwd>@OBW on connection 0 ...
C Attaching to DB Server OBW (con_hdl=0,svchp=8000000102699c68,svrhp=8000000104226eb8)
C Starting user session (con_hdl=0,svchp=8000000102699c68,srvhp=8000000104226eb8,usrhp=800000010371bbe0)
C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1034
[dboci.c 3807]
C Detaching from DB Server (con_hdl=0,svchp=8000000102699c68,srvhp=8000000104226eb8)
C *** ERROR => CONNECT failed with sql error '1034'
[dbsloci.c 9650]
C
C Tue Feb 10 23:50:53 2009
C Logon as OPS$-user to get SAPOBW's password
C Connecting as /@OBW on connection 0 ...
C Attaching to DB Server OBW (con_hdl=0,svchp=8000000102699c68,svrhp=8000000104226eb8)
C
C Tue Feb 10 23:50:54 2009
C Starting user session (con_hdl=0,svchp=8000000102699c68,srvhp=8000000104226eb8,usrhp=800000010371bbe0)
C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1034
[dboci.c 3807]
C Detaching from DB Server (con_hdl=0,svchp=8000000102699c68,srvhp=8000000104226eb8)
C *** ERROR => CONNECT failed with sql error '1034'
[dbsloci.c 9650]
C Try to connect with default password
C Connecting as SAPOBW/<pwd>@OBW on connection 0 ...
C Attaching to DB Server OBW (con_hdl=0,svchp=8000000102699c68,svrhp=8000000104226eb8)
R3 oracle 10.2.0.2, hp-ux 11.31
BW oracle 9.2.0.4, hp-ux 11.11
скриптик utlrp.sql запускал