ReSQL.ru
     
powered by simpleCommunicator - 2.0.59     © 2026 Programmizd 02
Мобильная версия    Контакт    Правила    FAQ    Помощь
Целевая тема:
Создать новую тему:
Автор:
Закрыть
Цитировать
Доб. в избранное | Игнор. тему | Прикреп. тему | Пометить прочит. / непрочит. | Фильтр
Форумы / Отчетные системы [игнор отключен] [закрыт для гостей] / Проблема создания XML через BI Publisher из базы OeBS
1 сообщений из 1, страница 1 из 1
Проблема создания XML через BI Publisher из базы OeBS
    #37003846
GeraCDS
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
GeraCDS
Гость
Используется установленный на отдельной машине BI Publisher 10.1.3.4.1. При выполнении простейшего отчета вида select 123 demo from dual на локальной БД XML генерится без проблем. Если подобного вида отчет выполнить на БД OeBS в XML генерируются пустые теги. Получается вот такой результат:
Код: plaintext
1.
2.
3.
4.
5.
6.
<?xml version="1.0" encoding="UTF-8"?>

<ROWSET>
<ROW>
<> 2 </>
</ROW>
</ROWSET>
лог выполнения
Код: plaintext
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.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
[120810_105255093][][STATEMENT] Setting data definition:New DataSet  2  type:oracle.apps.xdo.servlet.data.bind.SQLBoundValue11
[120810_105255234][][STATEMENT] /Configuration/xdo.cfg not found.
[120810_105255234][][STATEMENT] Logger.init(): *** DEBUG MODE IS ON. ***
[120810_105255234][][STATEMENT] Logger.init(): LogDir=D:\BIP_LOG
[120810_105255453][][STATEMENT] Template parsing started...
[120810_105255453][][STATEMENT] Data Template ......
[120810_105255453][][STATEMENT] oracle.xml.parser.v2.XMLDocument@3acf34
[120810_105255453][][STATEMENT] Inside parameterParser...
[120810_105255453][][STATEMENT] Inside dataQueryParser...
[120810_105255453][][STATEMENT] Template parsing completed...
[120810_105255453][][STATEMENT] include_parameters=false
[120810_105255468][][STATEMENT] Start process Data
[120810_105255468][][STATEMENT] Process Data ...
[120810_105255468][][STATEMENT] Writing Data ...
[120810_105255468][][STATEMENT] Sql Query :  select  2  from dual
[120810_105255468][][EVENT] Data Generation Completed...
[120810_105255468][][EVENT] Total Data Generation Time  0 . 0  seconds
[120810_105255468][][STATEMENT] SQLBoundValue11::callDataEngine ds != null here, release Connection
[120810_105310343][][STATEMENT] Skip migration for cookie (ORA_XDO) is not found
[120810_105310359][][STATEMENT] /Configuration/xdo.cfg not found.
[120810_105310359][][STATEMENT] Logger.init(): *** DEBUG MODE IS ON. ***
[120810_105310375][][STATEMENT] Logger.init(): LogDir=D:\BIP_LOG
[120810_105310593][][STATEMENT] Template parsing started...
[120810_105310593][][STATEMENT] Data Template ......
[120810_105310593][][STATEMENT] oracle.xml.parser.v2.XMLDocument@199ffdd
[120810_105310593][][STATEMENT] Inside parameterParser...
[120810_105310593][][STATEMENT] Inside dataQueryParser...
[120810_105310593][][STATEMENT] Template parsing completed...
[120810_105310593][][STATEMENT] include_parameters=false
[120810_105310593][][STATEMENT] Start process Data
[120810_105310593][][STATEMENT] Process Data ...
[120810_105310593][][STATEMENT] Writing Data ...
[120810_105310593][][STATEMENT] Sql Query :  select  2  from dual
[120810_105310609][][EVENT] Data Generation Completed...
[120810_105310609][][EVENT] Total Data Generation Time  0 . 0  seconds
[120810_105310609][][STATEMENT] SQLBoundValue11::callDataEngine ds != null here, release Connection
[120810_105325359][][STATEMENT] Skip migration for cookie (ORA_XDO) is not found
[120810_105325359][][STATEMENT] /Configuration/xdo.cfg not found.
[120810_105325359][][STATEMENT] Logger.init(): *** DEBUG MODE IS ON. ***
[120810_105325359][][STATEMENT] Logger.init(): LogDir=D:\BIP_LOG
[120810_105325578][][STATEMENT] Template parsing started...
[120810_105325578][][STATEMENT] Data Template ......
[120810_105325578][][STATEMENT] oracle.xml.parser.v2.XMLDocument@167a209
[120810_105325578][][STATEMENT] Inside parameterParser...
[120810_105325578][][STATEMENT] Inside dataQueryParser...
[120810_105325578][][STATEMENT] Template parsing completed...
[120810_105325578][][STATEMENT] include_parameters=false
[120810_105325578][][STATEMENT] Start process Data
[120810_105325578][][STATEMENT] Process Data ...
[120810_105325593][][STATEMENT] Writing Data ...
[120810_105325593][][STATEMENT] Sql Query :  select  2  from dual
[120810_105325593][][EVENT] Data Generation Completed...
[120810_105325593][][EVENT] Total Data Generation Time  0 . 0  seconds
[120810_105325593][][STATEMENT] SQLBoundValue11::callDataEngine ds != null here, release Connection
[120810_105325593][][STATEMENT] Logger.init(): *** DEBUG MODE IS ON. ***
[120810_105325593][][STATEMENT] Logger.init(): LogDir=D:\BIP_LOG
[120810_105325593][oracle.apps.xdo.template.FOProcessor][STATEMENT] FOProcessor constructor is called.
[120810_105325593][oracle.apps.xdo.template.FOProcessor][STATEMENT] FOProcessor has been initialized without default config.
[120810_105325593][oracle.apps.xdo.template.FOProcessor][STATEMENT] FOProcessor.setLocale is called with 'ru-RU'.
[120810_105325593][oracle.apps.xdo.template.FOProcessor][STATEMENT] FOProcessor.setTemplate(InputStream)is called.
[120810_105325593][][STATEMENT] Logger.init(): *** DEBUG MODE IS ON. ***
[120810_105325593][][STATEMENT] Logger.init(): LogDir=D:\BIP_LOG
[120810_105325593][oracle.apps.xdo.template.FOProcessor][STATEMENT]    Log file 'xdo_120810_105325593_fo_data_14.xsl' is created.
[120810_105325609][oracle.apps.xdo.template.FOProcessor][STATEMENT] FOProcessor.setData(InputStream) is called.
[120810_105325609][oracle.apps.xdo.template.FOProcessor][STATEMENT]    Log file 'xdo_120810_105325593_fo_data_15.xml' is created.
[120810_105325609][oracle.apps.xdo.template.FOProcessor][STATEMENT]    Log file 'xdo_120810_105325593_fo_out6.out' is created.
[120810_105325609][oracle.apps.xdo.template.FOProcessor][STATEMENT] FOProcessor.setOutput(OutputStream)is called.
[120810_105325609][oracle.apps.xdo.template.FOProcessor][STATEMENT] FOProcessor.setOutputFormat(byte)is called with ID= 2 .
[120810_105325687][oracle.apps.xdo.template.FOProcessor][STATEMENT] Start Memory: max=508MB, total=34MB, free=12MB
[120810_105325687][oracle.apps.xdo.template.FOProcessor][STATEMENT] FOProcessor.generate() called.
[120810_105325687][oracle.apps.xdo.template.FOProcessor][STATEMENT] createFO(Object, Object) is called.
[120810_105325781][oracle.apps.xdo.common.xml.XSLT10gR1][STATEMENT] Oracle XML Developers Kit  10 . 1 . 0 . 5 . 0  - Production
[120810_105325781][oracle.apps.xdo.common.xml.XSLT10gR1][STATEMENT] Scalable Feature Disabled
[120810_105325781][oracle.apps.xdo.common.xml.XSLT10gR1][UNEXPECTED] <Line  5 , Column  2 >: XML- 20201 : (Fatal Error) Expected name instead of >.
[120810_105325781][oracle.apps.xdo.template.FOProcessor][STATEMENT] clearInputs(Object) is called.
[120810_105325781][oracle.apps.xdo.template.FOProcessor][STATEMENT] clearInputs(Object) done. All inputs are cleared.
[120810_105325781][oracle.apps.xdo.template.FOProcessor][ERROR] End Memory: max=508MB, total=34MB, free=10MB
[120810_105325781][][EXCEPTION] java.lang.reflect.InvocationTargetException
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: 39 )
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java: 25 )
	at java.lang.reflect.Method.invoke(Method.java: 585 )
	at oracle.apps.xdo.common.xml.XSLT10gR1.invokeParse(Unknown Source)
	at oracle.apps.xdo.common.xml.XSLT10gR1.transform(Unknown Source)
	at oracle.apps.xdo.common.xml.XSLTWrapper.transform(Unknown Source)
	at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(Unknown Source)
	at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(Unknown Source)
	at oracle.apps.xdo.template.FOProcessor.createFO(Unknown Source)
	at oracle.apps.xdo.template.FOProcessor.generate(Unknown Source)
	at oracle.apps.xdo.servlet.RTFCoreProcessor.transform(RTFCoreProcessor.java: 91 )
	at oracle.apps.xdo.servlet.CoreProcessor.process(CoreProcessor.java: 302 )
	at oracle.apps.xdo.servlet.CoreProcessor.generateDocument(CoreProcessor.java: 82 )
	at oracle.apps.xdo.servlet.ReportImpl.renderBodyHTTP(ReportImpl.java: 552 )
	at oracle.apps.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java: 255 )
	at oracle.apps.xdo.servlet.XDOServlet.writeReport(XDOServlet.java: 270 )
	at oracle.apps.xdo.servlet.XDOServlet.writeReport(XDOServlet.java: 250 )
	at oracle.apps.xdo.servlet.XDOServlet.doGet(XDOServlet.java: 178 )
	at oracle.apps.xdo.servlet.XDOServlet.doPost(XDOServlet.java: 201 )
	at javax.servlet.http.HttpServlet.service(HttpServlet.java: 763 )
	at javax.servlet.http.HttpServlet.service(HttpServlet.java: 856 )
	at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java: 64 )
	at oracle.apps.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java: 94 )
	at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java: 621 )
	at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java: 368 )
	at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java: 866 )
	at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java: 448 )
	at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java: 216 )
	at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java: 117 )
	at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java: 110 )
	at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java: 260 )
	at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java: 303 )
	at java.lang.Thread.run(Thread.java: 595 )
Caused by: org.xml.sax.SAXParseException: <Line  5 , Column  2 >: XML- 20201 : (Fatal Error) Expected name instead of >.
	at oracle.xdo.parser.v2.XMLError.flushErrorHandler(XMLError.java: 441 )
	at oracle.xdo.parser.v2.XMLError.flushErrors1(XMLError.java: 303 )
	at oracle.xdo.parser.v2.XMLReader.scanNameChars(XMLReader.java: 1061 )
	at oracle.xdo.parser.v2.XMLReader.scanQName(XMLReader.java: 1833 )
	at oracle.xdo.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java: 1240 )
	at oracle.xdo.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java: 338 )
	at oracle.xdo.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java: 285 )
	at oracle.xdo.parser.v2.XMLParser.parse(XMLParser.java: 289 )
	...  34  more

[120810_105325781][][EXCEPTION] java.lang.reflect.InvocationTargetException
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: 39 )
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java: 25 )
	at java.lang.reflect.Method.invoke(Method.java: 585 )
	at oracle.apps.xdo.common.xml.XSLT10gR1.invokeParse(Unknown Source)
	at oracle.apps.xdo.common.xml.XSLT10gR1.transform(Unknown Source)
	at oracle.apps.xdo.common.xml.XSLTWrapper.transform(Unknown Source)
	at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(Unknown Source)
	at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(Unknown Source)
	at oracle.apps.xdo.template.FOProcessor.createFO(Unknown Source)
	at oracle.apps.xdo.template.FOProcessor.generate(Unknown Source)
	at oracle.apps.xdo.servlet.RTFCoreProcessor.transform(RTFCoreProcessor.java: 91 )
	at oracle.apps.xdo.servlet.CoreProcessor.process(CoreProcessor.java: 302 )
	at oracle.apps.xdo.servlet.CoreProcessor.generateDocument(CoreProcessor.java: 82 )
	at oracle.apps.xdo.servlet.ReportImpl.renderBodyHTTP(ReportImpl.java: 552 )
	at oracle.apps.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java: 255 )
	at oracle.apps.xdo.servlet.XDOServlet.writeReport(XDOServlet.java: 270 )
	at oracle.apps.xdo.servlet.XDOServlet.writeReport(XDOServlet.java: 250 )
	at oracle.apps.xdo.servlet.XDOServlet.doGet(XDOServlet.java: 178 )
	at oracle.apps.xdo.servlet.XDOServlet.doPost(XDOServlet.java: 201 )
	at javax.servlet.http.HttpServlet.service(HttpServlet.java: 763 )
	at javax.servlet.http.HttpServlet.service(HttpServlet.java: 856 )
	at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java: 64 )
	at oracle.apps.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java: 94 )
	at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java: 621 )
	at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java: 368 )
	at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java: 866 )
	at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java: 448 )
	at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java: 216 )
	at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java: 117 )
	at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java: 110 )
	at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java: 260 )
	at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java: 303 )
	at java.lang.Thread.run(Thread.java: 595 )
Caused by: org.xml.sax.SAXParseException: <Line  5 , Column  2 >: XML- 20201 : (Fatal Error) Expected name instead of >.
	at oracle.xdo.parser.v2.XMLError.flushErrorHandler(XMLError.java: 441 )
	at oracle.xdo.parser.v2.XMLError.flushErrors1(XMLError.java: 303 )
	at oracle.xdo.parser.v2.XMLReader.scanNameChars(XMLReader.java: 1061 )
	at oracle.xdo.parser.v2.XMLReader.scanQName(XMLReader.java: 1833 )
	at oracle.xdo.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java: 1240 )
	at oracle.xdo.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java: 338 )
	at oracle.xdo.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java: 285 )
	at oracle.xdo.parser.v2.XMLParser.parse(XMLParser.java: 289 )
	...  34  more
Помогите разобраться в чем дело. Раньше никогда такого не было.
...
Рейтинг: 0 / 0
09.12.2010, 11:10
| Ответить | Цитировать | Написать  
1 сообщений из 1, страница 1 из 1
Форумы / Отчетные системы [игнор отключен] [закрыт для гостей] / Проблема создания XML через BI Publisher из базы OeBS
Найденые пользователи ...
Разблокировать пользователей ...
Читали тему (0):
Читали форум (0):
Пользователи онлайн (0):
x
x
Закрыть


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