ReSQL.ru
     
powered by simpleCommunicator - 2.0.59     © 2025 Programmizd 02
Мобильная версия    Контакт    Правила    FAQ    Помощь
Целевая тема:
Создать новую тему:
Автор:
Закрыть
Цитировать
Доб. в избранное | Игнор. тему | Прикреп. тему | Пометить прочит. / непрочит. | Фильтр
Форумы / OLAP и DWH [игнор отключен] [закрыт для гостей] / Ошибка OWB, куда дальше копать
1 сообщений из 1, страница 1 из 1
Ошибка OWB, куда дальше копать
    #39882932
Pavel_PV
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Pavel_PV
Гость
Всем доброго!
В общем после сбоя базы 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
30.10.2019, 04:51
| Ответить | Цитировать | Написать  
1 сообщений из 1, страница 1 из 1
Форумы / OLAP и DWH [игнор отключен] [закрыт для гостей] / Ошибка OWB, куда дальше копать
Найденые пользователи ...
Разблокировать пользователей ...
Читали тему (0):
Читали форум (0):
Пользователи онлайн (0):
Польз. соглашение
NoSQL.ru       Новости, Чат       Фотоальбом: Участники, Встречи
Закрыть
start [/forum/topic.php?desktop=1&fid=49&tid=1857479]:
 0ms
get settings:
 9ms
get forum list:
 12ms
check forum access:
 4ms
check topic access:
 4ms
track hit:
 48ms
get topic data:
 11ms
get forum data:
 2ms
get page messages:
 27ms
get tp. blocked users:
 2ms
others: 15ms
total:  134ms
созд. / загр.: 134ms
x
x
Закрыть


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