Гость
Войти | Профиль | Очистить
Целевая тема:
Создать новую тему:
Автор:
Действия ...
Форумы / OLAP и DWH [игнор отключен] [закрыт для гостей] / Ошибка OWB, куда дальше копать / 1 сообщений из 1, страница 1 из 1
30.10.2019, 04:51
    #39882932
Pavel_PV
Pavel_PV
Гость
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Ошибка OWB, куда дальше копать
Всем доброго!
В общем после сбоя базы FLOW у OWB начали виснуть. Ошибку сам owb во внутренних таблицах при этом не видит, но она есть в логе owb.
Сначала изложу свои мысли, нужно мнение как проверить и куда копать дальше. Сейчас прорабатываю вот чего, при стандартном поведении в логе owb пишется так:
Код: sql
1.
2.
3.
2019/10/22-05:16:04-NOVST [3B77FC1A][] Thin driver connection time - 199 millisecond(s)
2019/10/22-05:16:04-NOVST [3B77FC1A][OWB_ADM.UPC_PROD] Initializing execution for auditId= 8190600 parentAuditId= 8188134 topLevelAuditId=8188134 taskName=JDP_FLOW:EXE_LOAD_ISSUES
2019/10/22-05:16:11-NOVST [3B77FC1A][OWB_ADM.UPC_PROD] Attempting to create adapter 'class.RuntimePlatform.0.NativeExecution'


ПРи ошибке так:
Код: sql
1.
2.
3.
 2019/10/22-05:15:20-NOVST [16535394][] Thin driver connection time - 185 millisecond(s)
2019/10/22-05:15:21-NOVST [16535394][OWB_ADM.UPC_PROD] Initializing execution for auditId= 8190595 parentAuditId= 8188581 topLevelAuditId=8188581 taskName=CS_ETL_FLOW:EXE_LOAD_TOKEN_HASH_PAN
2019/10/22-05:15:48-NOVST [16535394][OWB_ADM.UPC_PROD] oracle.wh.runtime.platform.adapter.InfrastructureException: RPE-01003: An infrastructure condition prevented the request from completing.


Т.е. судя по логу или не была корректна выполнена стадия "Initializing execution " или же не был создан адаптер "Attempting to create adapter ". Скорее наверное второе, исходя из того что экспешн такой adapter.InfrastructureException . Вопрос, куда копнуть чтобы получить стабильно ошибку? Где глянуть, какие ресурсы нужны для создания этого самого адаптера. Пакеты все враплены.

Сама ошибка в логах owb:
Код: sql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
 2019/10/22-05:15:48-NOVST [16535394][OWB_ADM.UPC_PROD] oracle.wh.runtime.platform.adapter.InfrastructureException: RPE-01003: An infrastructure condition prevented the request from completing.
 - RPE-01003: An infrastructure condition prevented the request from completing.
 - No more data to read from socket
	at oracle.wh.runtime.platform.service.controller.WarehouseObjectImpl.<init>(WarehouseObjectImpl.java:476)
	at oracle.wh.runtime.platform.service.controller.ExecutionContextImpl.initialize(ExecutionContextImpl.java:1383)
	at oracle.wh.runtime.platform.service.controller.ExecutionController.initialize(ExecutionController.java:32)
	at oracle.wh.runtime.platform.service.controller.ExecutionController.execute(ExecutionController.java:50)
	at oracle.wh.runtime.platform.service.controller.ExecutionController.execute(ExecutionController.java:23)
	at oracle.wh.runtime.platform.service.ExecutionManager.run(ExecutionManager.java:36)
	at java.lang.Thread.run(Thread.java:637)
Caused by: oracle.wh.runtime.platform.adapter.InfrastructureException: RPE-01003: An infrastructure condition prevented the request from completing.
 - No more data to read from socket
	at oracle.wh.runtime.platform.service.controller.StoreImpl.<init>(StoreImpl.java:242)
	at oracle.wh.runtime.platform.service.controller.WarehouseObjectImpl.<init>(WarehouseObjectImpl.java:465)
	... 6 more
Caused by: java.sql.SQLException: No more data to read from socket
	at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1157)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:290)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
	at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:877)
	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1205)
	at sqlj.runtime.ExecutionContext$OracleContext.oracleExecuteQuery(ExecutionContext.java:1605)
	at oracle.wh.runtime.platform.service.controller.StoreImpl.<init>(StoreImpl.java:212)
	... 7 more
oracle.wh.runtime.platform.adapter.InfrastructureException: RPE-01003: An infrastructure condition prevented the request from completing.
 - No more data to read from socket
	at oracle.wh.runtime.platform.service.controller.StoreImpl.<init>(StoreImpl.java:242)
	at oracle.wh.runtime.platform.service.controller.WarehouseObjectImpl.<init>(WarehouseObjectImpl.java:465)
	at oracle.wh.runtime.platform.service.controller.ExecutionContextImpl.initialize(ExecutionContextImpl.java:1383)
	at oracle.wh.runtime.platform.service.controller.ExecutionController.initialize(ExecutionController.java:32)
	at oracle.wh.runtime.platform.service.controller.ExecutionController.execute(ExecutionController.java:50)
	at oracle.wh.runtime.platform.service.controller.ExecutionController.execute(ExecutionController.java:23)
	at oracle.wh.runtime.platform.service.ExecutionManager.run(ExecutionManager.java:36)
	at java.lang.Thread.run(Thread.java:637)
Caused by: java.sql.SQLException: No more data to read from socket
	at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1157)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:290)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
	at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:877)
	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1205)
	at sqlj.runtime.ExecutionContext$OracleContext.oracleExecuteQuery(ExecutionContext.java:1605)
	at oracle.wh.runtime.platform.service.controller.StoreImpl.<init>(StoreImpl.java:212)
	... 7 more
java.sql.SQLException: No more data to read from socket
	at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1157)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:290)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
	at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:877)
	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1205)
	at sqlj.runtime.ExecutionContext$OracleContext.oracleExecuteQuery(ExecutionContext.java:1605)
	at oracle.wh.runtime.platform.service.controller.StoreImpl.<init>(StoreImpl.java:212)
	at oracle.wh.runtime.platform.service.controller.WarehouseObjectImpl.<init>(WarehouseObjectImpl.java:465)
	at oracle.wh.runtime.platform.service.controller.ExecutionContextImpl.initialize(ExecutionContextImpl.java:1383)
	at oracle.wh.runtime.platform.service.controller.ExecutionController.initialize(ExecutionController.java:32)
	at oracle.wh.runtime.platform.service.controller.ExecutionController.execute(ExecutionController.java:50)
	at oracle.wh.runtime.platform.service.controller.ExecutionController.execute(ExecutionController.java:23)
	at oracle.wh.runtime.platform.service.ExecutionManager.run(ExecutionManager.java:36)
	at java.lang.Thread.run(Thread.java:637)
2019/10/22-05:15:48-NOVST [16535394][OWB_ADM.UPC_PROD] Thread terminating due to fatal exception of type oracle.wh.runtime.platform.adapter.InfrastructureException
2019/10/22-05:15:48-NOVST [16535394][OWB_ADM.UPC_PROD] oracle.wh.runtime.platform.adapter.InfrastructureException: RPE-01003: An infrastructure condition prevented the request from completing.
 - No more data to read from socket
	at oracle.wh.runtime.platform.service.controller.PlatformDb.disconnect(PlatformDb.java:141)
	at oracle.wh.runtime.platform.service.ExecutionManager.run(ExecutionManager.java:40)
	at java.lang.Thread.run(Thread.java:637)
Caused by: java.sql.SQLException: No more data to read from socket
	at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1157)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:290)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
	at oracle.jdbc.driver.T4C7Ocommoncall.doOCOMMIT(T4C7Ocommoncall.java:75)
	at oracle.jdbc.driver.T4CConnection.doCommit(T4CConnection.java:610)
	at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3885)
	at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3891)
	at oracle.wh.runtime.platform.service.controller.PlatformDb.disconnect(PlatformDb.java:135)
	... 2 more
java.sql.SQLException: No more data to read from socket
	at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1157)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:290)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
	at oracle.jdbc.driver.T4C7Ocommoncall.doOCOMMIT(T4C7Ocommoncall.java:75)
	at oracle.jdbc.driver.T4CConnection.doCommit(T4CConnection.java:610)
	at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3885)
	at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3891)
	at oracle.wh.runtime.platform.service.controller.PlatformDb.disconnect(PlatformDb.java:135)
	at oracle.wh.runtime.platform.service.ExecutionManager.run(ExecutionManager.java:40)
	at java.lang.Thread.run(Thread.java:637)


и в алерт логе:
Код: sql
1.
 ORA-07445: exception encountered: core dump [eoa_scan_mark_eobject()+372] [SIGSEGV] [ADDR:0xFFFFFFFF71BFC080] [PC:0x1128181F4] [Address not mapped to object] []


В трэйсах ничего почти нет, оракл молчит.
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
Форумы / OLAP и DWH [игнор отключен] [закрыт для гостей] / Ошибка OWB, куда дальше копать / 1 сообщений из 1, страница 1 из 1
Найденые пользователи ...
Разблокировать пользователей ...
Читали тему (0):
Читали форум (0):
Пользователи онлайн (0):
Польз. соглашение
созд. / загр.: 175ms
Закрыть
start [/forum/topic.php?fid=49&mobile=1&tid=1857479]:
 0ms
get settings:
 8ms
get forum list:
 13ms
check forum access:
 3ms
check topic access:
 3ms
track hit:
 95ms
get topic data:
 10ms
get forum data:
 2ms
get page messages:
 26ms
get tp. blocked users:
 1ms
others: 14ms
total:  175ms
x
x
Закрыть


Просмотр
0 / 0
Close
Debug Console [Select Text]