Гость
Войти | Профиль | Очистить
Целевая тема:
Создать новую тему:
Автор:
Действия ...
Форумы / Отчетные системы [игнор отключен] [закрыт для гостей] / Проблема создания XML через BI Publisher из базы OeBS / 1 сообщений из 1, страница 1 из 1
09.12.2010, 11:10
    #37003846
GeraCDS
GeraCDS
Гость
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Проблема создания XML через BI Publisher из базы OeBS
Используется установленный на отдельной машине 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
| Ответить | Цитировать | Написать  
Форумы / Отчетные системы [игнор отключен] [закрыт для гостей] / Проблема создания XML через BI Publisher из базы OeBS / 1 сообщений из 1, страница 1 из 1
Найденые пользователи ...
Разблокировать пользователей ...
Читали тему (0):
Читали форум (0):
Пользователи онлайн (0):
x
x
Закрыть


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