Categories
- All Categories
- 4 Oracle Analytics Sharing Center
- 12 Oracle Analytics Lounge
- 189 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.4K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 65 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE 11 : Configure MySQL JDBC datasource
Summary
OBIEE 11 : Configure MySQL JDBC datasource
Content
Hello,
In BI Publisher ( OBIEE 11.1.1.7 ) , we need to configure Datasource JDBC MySQL:
We configure it in Administration tab :
Driver Type : com.mysql.jdbc.Driver
Connection String : jdbc:mysql://[host]:[port]/[database]
I test a connection, it’s established successfully. But when a create a new data set (SQL Query) in Data Model
Select *
From table1
It failed with error message : Failed to load SQL. With Mysql Client, it’s work fine. Maybe we need to add a library
I need your help to fix this please ;-)
Regards
Djam
Answers
-
Might be due to multiple schemas in the database and bip unable to choose among one , add schema name infront of table as
select from schema_name.table1
Thanks
0 -
can you post the bipublisher.log ? OR after you run data model then click on view engine log , Thanks
log contain detailed information to debug , Thanks
0 -
Thanks for your update.
We have the same error when I add schema name infront of table :-(
Djam
0 -
[100217_102905645][][STATEMENT] ReportRepository - get data model: /RPT-TMP/Mysql_connection.xdm
[100217_102905648][][STATEMENT] CatalogServiceUtil - input path: /RPT-TMP/Mysql_connection.xdm
[100217_102905650][oracle.xdo.servlet.resources.catalog.ResourceCatalogServiceImpl][STATEMENT] Loading: Basic
[100217_102905652][][STATEMENT] CatalogServiceUtil.getValidation: [Resoure type: ReportItem, Readable: true, traversable: true]
[100217_102905653][oracle.xdo.servlet.resources.catalog.ResourceCatalogServiceImpl][STATEMENT] Loading: SkipReadOnly
[100217_102905656][oracle.xdo.servlet.ReportImpl][ERROR] Switch to default layout because requested layout is null:
[100217_102905657][oracle.xdo.servlet.ReportImpl][ERROR] Default layout is null.
[100217_102905659][][STATEMENT] Requested document locale: en_US
[100217_102905661][][STATEMENT] Mobile request: html-use-data-uri=false
[100217_102905663][][STATEMENT] From CoreProcessor Properties setting to = {xslt.CURRENT_SERVER_SCHEME='http', html-image-dir=/servers/bipublisher/bip11/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/bipublisher_11.1.1/to5gma/war/xdo/tmp/, fo-external-link-target=_blank, xslt._XDOTIMEZONE='Europe/Paris', html-css-dir=/servers/bipublisher/bip11/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/bipublisher_11.1.1/to5gma/war/xdo/tmp/, system-temp-dir=/servers/bipublisher/BIP11_TMP/xdo/tmp/, xslt.XDO_USER_ROLES='XMLP_TEMPLATE_DESIGNER,ccms,XMLP_ADMIN,ATLC-RPT,XMLP_ANALYZER_ONLINE,Support_UMGI,XMLP_SCHEDULER,OPS_report,XMLP_DEVELOPER,XMLP_ANALYZER_EXCEL,ATLC_readOnly_role', xslt.CURRENT_SERVER_PORT='80', xslt.CURRENT_SERVER_URL='http://bipublisher.mnt.digiplug.com:80/xmlpserver/', fo-external-link-base-url=http://bipublisher.mnt.digiplug.com:80/xmlpserver/RPT-TMP/, xslt.XDO_USER_NAME='administrator', xslt.CURRENT_SERVER_CONTEXT_PATH='xmlpserver', xslt._XDOCHARTTYPE='image/png', xslt._XDOOUTPUTFORMAT='text/html', html-use-data-uri=false, html-css-base-uri=http://bipublisher.mnt.digiplug.com:80/xmlpserver/xdo/tmp, xslt._FURL='http://bipublisher.mnt.digiplug.com:80/xmlpserver/RPT-TMP/', xslt._xt='', xslt._xdo_user='administrator', html-image-base-uri=http://bipublisher.mnt.digiplug.com:80/xmlpserver/xdo/tmp/, xslt.CURRENT_SERVER_NAME='bipublisher.mnt.digiplug.com', xslt._xf='xml', html-image-acl-id=7721be3945e2b7bd6ba1cc3a10f7e042bd9a4d0491c49b842c92f73ac8ab4080}
[100217_102905706][][STATEMENT] temp file is created: /servers/bipublisher/BIP11_TMP/xdo/tmp/xmlp8231080622070963666tmp
[100217_102905708][][STATEMENT] MonitoringEvent started: class oracle.xdo.servlet.monitor.ReportDataProcessEvent:threadName=[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)',format=xml,totalMemory=271974400,reportName=/RPT-TMP/Mysql_connection.xdm,templateName=,userLocale=en_US,freeMemory=57936280
[100217_102905709][oracle.xdo.servlet.RTFCoreProcessor][EVENT] start-getdata: DataModel=/RPT-TMP/Mysql_connection.xdm, OutFormat=xml, Locale=en_US
[100217_102905712][][STATEMENT] ReportRepository - get data model: /RPT-TMP/Mysql_connection.xdm
[100217_102905714][][STATEMENT] CatalogServiceUtil - input path: /RPT-TMP/Mysql_connection.xdm
[100217_102905716][oracle.xdo.servlet.resources.catalog.ResourceCatalogServiceImpl][STATEMENT] Loading: Basic
[100217_102905718][][STATEMENT] CatalogServiceUtil.getValidation: [Resoure type: ReportItem, Readable: true, traversable: true]
[100217_102905719][oracle.xdo.servlet.resources.catalog.ResourceCatalogServiceImpl][STATEMENT] Loading: SkipReadOnly
[100217_102905722][][EVENT] Storing DMSC Session thread :Thread[[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads] : for id:NxtECswkid1506932945721
[100217_102905785][oracle.xdo.servlet.ReportModelContextImpl][EVENT] ReportModelContextImpl- Invoking dataengine dataprocessor..
[100217_102905789][][EVENT] Initializing DateFormatter for thread id:Thread[[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads]:MapSize:5
[100217_102905791][][STATEMENT] server_temp_dir=/servers/bipublisher/BIP11_TMP/xdo/tmp/
[100217_102905794][][EVENT] Storing Session thread :Thread[[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads] : for id:UIPz2SsoZg1506932945792
[100217_102905796][][EVENT] SessionId for Parsing:UIPz2SsoZg1506932945792
[100217_102905797][][STATEMENT] DataModel parsing started...
[100217_102905800][][STATEMENT] Oracle XML Parser version : Oracle XML Developers Kit 11.1.1.3.0 - Production
[100217_102905802][][STATEMENT] Data Model ......
[100217_102905804][][STATEMENT] Inside properties Parser...
[100217_102905806][][STATEMENT] include_parameters=true
[100217_102905808][][STATEMENT] include_null_Element=false
[100217_102905810][][STATEMENT] include_rowsettag=false
[100217_102905812][][STATEMENT] xml_tag_case=upper
[100217_102905814][][STATEMENT] Inside dataQueryParser...
[100217_102905816][][STATEMENT] rowtagchange=false
[100217_102905819][][STATEMENT] Inside dataStructureParser...
[100217_102905822][][STATEMENT] Group ...report
[100217_102905826][][STATEMENT] Group ...G_1
[100217_102905828][][STATEMENT] Inside triggerParser...
[100217_102905829][][STATEMENT] Inside parameterParser...
[100217_102905831][][STATEMENT] DataModel parsing completed....
[100217_102905833][][STATEMENT] Setting Data Model ...
[100217_102905835][][STATEMENT] datamodel_path=/RPT-TMP/Mysql_connection.xdm
[100217_102905837][][STATEMENT] module=/RPT-TMP/Mysql_connection.xdm
[100217_102905839][][STATEMENT] processing_mode=0
[100217_102905841][][STATEMENT] absPath/~administrator/user~.profile, is report item type: false, is layout template type: false, matches report item reg expr: false, matches style template reg expr: false
[100217_102905843][oracle.xdo.servlet.ReportModelContextImpl][STATEMENT] Setting timeZoneId:Europe/Paris
[100217_102905845][][STATEMENT] Setting Parameters ...
[100217_102905846][][EVENT] DataProcessor.processData():Begin
[100217_102905848][][EVENT] DataProcessor.processData():Invoke super.processData
[100217_102905850][][STATEMENT] DEConnection:initConnectionContext:Begin
[100217_102905853][][EVENT] DEConnection:initConnectionContext:Type:SQL
[100217_102905855][][STATEMENT] DEConnection:handleJDBCConnection:Begin
[100217_102905856][][STATEMENT] DEConnection:getJDBCConnection:Begin
[100217_102905858][][STATEMENT] DEConnection:getJDBCConnection:PRIMARY_DATASOURCE
[100217_102905873][][STATEMENT] DEConnection:getJDBCConnection:End
[100217_102905875][][STATEMENT] DEConnection:handleJDBCConnection:connection found
[100217_102905876][][STATEMENT] DEConnection:handleJDBCConnection:setting connection to the context
[100217_102905878][][STATEMENT] DEConnection:handleJDBCConnection:End
[100217_102905881][][STATEMENT] Setting Data sets Connections...
[100217_102905883][][EVENT] SessionId for process:UIPz2SsoZg1506932945792
[100217_102905884][][STATEMENT] Executing data triggers...
[100217_102905886][][STATEMENT] Executing data triggers...
[100217_102905888][][STATEMENT] Start process Data Structure ..
[100217_102905894][][STATEMENT] XDO_USER_NAME
[100217_102905896][][STATEMENT] XDO_USER_ROLES
[100217_102905898][][STATEMENT] XDO_USER_UI_LOCALE
[100217_102905900][][STATEMENT] XDO_USER_UI_ORACLE_LANG
[100217_102905902][][STATEMENT] XDO_USER_REPORT_LOCALE
[100217_102905904][][STATEMENT] XDO_USER_REPORT_ORACLE_LANG
[100217_102905905][][STATEMENT] XDO_DASHBOARD_EXPR
[100217_102905907][][STATEMENT] FUSION_SECURITY_ENABLED
[100217_102905909][][STATEMENT] FUSION_ESS_APPLSESSION_ID
[100217_102905911][][EVENT] User Preference time zone selected:sun.util.calendar.ZoneInfo[id="Europe/Paris",offset=3600000,dstSavings=3600000,useDaylight=true,transitions=184,lastRule=java.util.SimpleTimeZone[id=Europe/Paris,offset=3600000,dstSavings=3600000,useDaylight=true,startYear=0,startMode=2,startMonth=2,startDay=-1,startDayOfWeek=1,startTime=3600000,startTimeMode=2,endMode=2,endMonth=9,endDay=-1,endDayOfWeek=1,endTime=3600000,endTimeMode=2]]
[100217_102905916][][EVENT] Java Converted Date with no timezone set:2017-10-02 10:29:05.013+020010
[100217_102905918][][EVENT] JVM Java.Util.Timezone:Central European Time:3600000:true
[100217_102905920][][EVENT] Java Converted Date with default java timezone set:2017-10-02 10:29:05.013+020010
[100217_102905922][][EVENT] FND Cononical Date Format:2017-10-02T10:29:05.915+02:00
[100217_102905923][][STATEMENT] Writing Data ...
[100217_102905926][][EVENT] Number of queries :1
[100217_102905928][][STATEMENT] Returning Final Query from QueryParser:
select "deployment_project"."NAME" as "NAME",
"deployment_project"."DESCRIPTION" as "DESCRIPTION"
from "bambootomcat"."deployment_project" "deployment_project"
[100217_102905930][][EVENT] DB Fetch Size: 100
[100217_102905933][][EVENT] SQL Query Timeout: 0
[100217_102905935][][STATEMENT] Sql Query :dd: select "deployment_project"."NAME" as "NAME",
"deployment_project"."DESCRIPTION" as "DESCRIPTION"
from "bambootomcat"."deployment_project" "deployment_project"
[100217_102905938][][EVENT] Removing StringList sessionId:UIPz2SsoZg1506932945792
[100217_102905940][][EXCEPTION] XMLGEN:Exception while processing...:_RPT_TMP_Mysql_connection_xdm
[100217_102905942][][EXCEPTION] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '."NAME" as "NAME",
"deployment_project"."DESCRIPTION" as "DESCRIPTION"
from' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281)
at oracle.xdo.dataengine.XMLPGEN.processQuery(XMLPGEN.java:1896)
at oracle.xdo.dataengine.XMLPGEN.processSQLDataSource(XMLPGEN.java:522)
at oracle.xdo.dataengine.XMLPGEN.writeData(XMLPGEN.java:437)
at oracle.xdo.dataengine.XMLPGEN.writeGroupStructure(XMLPGEN.java:338)
at oracle.xdo.dataengine.XMLPGEN.writeXMLDataStructure(XMLPGEN.java:271)
at oracle.xdo.dataengine.XMLPGEN.processDataSet(XMLPGEN.java:1787)
at oracle.xdo.dataengine.XMLPGEN.processMergedDataSet(XMLPGEN.java:1490)
at oracle.xdo.dataengine.DataProcessor.processData(DataProcessor.java:376)
at oracle.xdo.servlet.dataengine.DataProcessorImpl.processData(DataProcessorImpl.java:318)
at oracle.xdo.servlet.dataengine.DataProcessorImpl.render(DataProcessorImpl.java:672)
at oracle.xdo.servlet.ReportModelContextImpl.getReportXMLData(ReportModelContextImpl.java:329)
at oracle.xdo.servlet.CoreProcessor.process(CoreProcessor.java:407)
at oracle.xdo.servlet.CoreProcessor.generateDocument(CoreProcessor.java:101)
at oracle.xdo.servlet.ReportImpl.renderBodyHTTP(ReportImpl.java:1154)
at oracle.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java:663)
at oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:492)
at oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:462)
at oracle.xdo.servlet.XDOServlet.doGet(XDOServlet.java:280)
at oracle.xdo.servlet.XDOServlet.doPost(XDOServlet.java:313)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.xdo.servlet.metadata.track.MostRecentFilter.doFilter(MostRecentFilter.java:64)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:143)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.xdo.servlet.init.InitCheckingFilter.doFilter(InitCheckingFilter.java:63)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1499)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:263)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
[100217_102905945][][EVENT] Removing StringList sessionId:UIPz2SsoZg1506932945792
[100217_102905947][][EVENT] Printing Session Details....
[100217_102905948][][EVENT] Session Details:0:
[100217_102905950][][EVENT] Removing DPsessionId:UIPz2SsoZg1506932945792
[100217_102905952][][EVENT] Removed Session thread :Thread[[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads] : for id:UIPz2SsoZg1506932945792
[100217_102905955][][EVENT] DataProcessor.processData():Finally clsoing all connections..
[100217_102905959][][EVENT] DEConnection::closeConnections: close connection for [bamboo]
[100217_102905961][][EVENT] Removing DMSC Session thread :Thread[[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads] : for id:NxtECswkid1506932945721
[100217_102905970][][STATEMENT] MonitoringEvent errored: class oracle.xdo.servlet.monitor.ReportRequestEvent:scheduled=false,report_runtime_property={},HTML_SESSION_ID=-lrcMpQY4Sy3xR7Je2F-Lc-0Mf7Tqda03iHRS7XgzQkg0DgKV9tV!-44563551!1506932855832,timezone=Europe/Paris,_xuil=en_US,weblogic.servlet.network_channel.port=8080,oracle.dms.context.http.WebRequestContextProcessed=true,_svg=false,userName=administrator,locale=en_US,format=xml,reportName=/RPT-TMP/Mysql_connection.xdm,templateName=,_xservreq=weblogic.servlet.internal.RequestEventsFilter$EventsRequestWrapper@7ed64715
[100217_102905972][oracle.xdo.servlet.XDOServlet][EXCEPTION] oracle.xdo.XDOException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '."NAME" as "NAME",
"deployment_project"."DESCRIPTION" as "DESCRIPTION"
from' at line 1
at oracle.xdo.dataengine.XMLPGEN.processMergedDataSet(XMLPGEN.java:1647)
at oracle.xdo.dataengine.DataProcessor.processData(DataProcessor.java:376)
at oracle.xdo.servlet.dataengine.DataProcessorImpl.processData(DataProcessorImpl.java:318)
at oracle.xdo.servlet.dataengine.DataProcessorImpl.render(DataProcessorImpl.java:672)
at oracle.xdo.servlet.ReportModelContextImpl.getReportXMLData(ReportModelContextImpl.java:329)
at oracle.xdo.servlet.CoreProcessor.process(CoreProcessor.java:407)
at oracle.xdo.servlet.CoreProcessor.generateDocument(CoreProcessor.java:101)
at oracle.xdo.servlet.ReportImpl.renderBodyHTTP(ReportImpl.java:1154)
at oracle.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java:663)
at oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:492)
at oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:462)
at oracle.xdo.servlet.XDOServlet.doGet(XDOServlet.java:280)
at oracle.xdo.servlet.XDOServlet.doPost(XDOServlet.java:313)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.xdo.servlet.metadata.track.MostRecentFilter.doFilter(MostRecentFilter.java:64)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:143)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.xdo.servlet.init.InitCheckingFilter.doFilter(InitCheckingFilter.java:63)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1499)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:263)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '."NAME" as "NAME",
"deployment_project"."DESCRIPTION" as "DESCRIPTION"
from' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281)
at oracle.xdo.dataengine.XMLPGEN.processQuery(XMLPGEN.java:1896)
at oracle.xdo.dataengine.XMLPGEN.processSQLDataSource(XMLPGEN.java:522)
at oracle.xdo.dataengine.XMLPGEN.writeData(XMLPGEN.java:437)
at oracle.xdo.dataengine.XMLPGEN.writeGroupStructure(XMLPGEN.java:338)
at oracle.xdo.dataengine.XMLPGEN.writeXMLDataStructure(XMLPGEN.java:271)
at oracle.xdo.dataengine.XMLPGEN.processDataSet(XMLPGEN.java:1787)
at oracle.xdo.dataengine.XMLPGEN.processMergedDataSet(XMLPGEN.java:1490)
... 54 more
[100217_102905976][oracle.xdo.servlet.XDOServlet][EXCEPTION] javax.servlet.ServletException: oracle.xdo.XDOException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '."NAME" as "NAME",
"deployment_project"."DESCRIPTION" as "DESCRIPTION"
from' at line 1
at oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:472)
at oracle.xdo.servlet.XDOServlet.doGet(XDOServlet.java:280)
at oracle.xdo.servlet.XDOServlet.doPost(XDOServlet.java:313)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.xdo.servlet.metadata.track.MostRecentFilter.doFilter(MostRecentFilter.java:64)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:143)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.xdo.servlet.init.InitCheckingFilter.doFilter(InitCheckingFilter.java:63)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1499)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:263)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused by: oracle.xdo.XDOException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '."NAME" as "NAME",
"deployment_project"."DESCRIPTION" as "DESCRIPTION"
from' at line 1
at oracle.xdo.servlet.ReportException.fillInStackTrace(ReportException.java:124)
at oracle.xdo.servlet.data.DataException.fillInStackTrace(DataException.java:127)
at java.lang.Throwable.<init>(Throwable.java:181)
at java.lang.Exception.<init>(Exception.java:29)
at oracle.xdo.servlet.ReportException.<init>(ReportException.java:40)
at oracle.xdo.servlet.data.DataException.<init>(DataException.java:44)
at oracle.xdo.servlet.ReportModelContextImpl.getReportXMLData(ReportModelContextImpl.java:367)
at oracle.xdo.servlet.CoreProcessor.process(CoreProcessor.java:407)
at oracle.xdo.servlet.CoreProcessor.generateDocument(CoreProcessor.java:101)
at oracle.xdo.servlet.ReportImpl.renderBodyHTTP(ReportImpl.java:1154)
at oracle.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java:663)
at oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:492)
at oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:462)
... 44 more
From the Highlighted Text it shows connection to database was found successfully and problem is with your sql query , change the query syntax as per database. Thanks
0 -
Please find attached xdo.log BI Publisher core engine debug log file
[100217_102905645][][STATEMENT] ReportRepository - get data model: /RPT-TMP/Mysql_connection.xdm
[100217_102905648][][STATEMENT] CatalogServiceUtil - input path: /RPT-TMP/Mysql_connection.xdm
[100217_102905650][oracle.xdo.servlet.resources.catalog.ResourceCatalogServiceImpl][STATEMENT] Loading: Basic
[100217_102905652][][STATEMENT] CatalogServiceUtil.getValidation: [Resoure type: ReportItem, Readable: true, traversable: true]
[100217_102905653][oracle.xdo.servlet.resources.catalog.ResourceCatalogServiceImpl][STATEMENT] Loading: SkipReadOnly
[100217_102905656][oracle.xdo.servlet.ReportImpl][ERROR] Switch to default layout because requested layout is null:
[100217_102905657][oracle.xdo.servlet.ReportImpl][ERROR] Default layout is null.
[100217_102905659][][STATEMENT] Requested document locale: en_US
[100217_102905661][][STATEMENT] Mobile request: html-use-data-uri=false
[100217_102905663][][STATEMENT] From CoreProcessor Properties setting to = {xslt.CURRENT_SERVER_SCHEME='http', html-image-dir=/servers/bipublisher/bip11/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/bipublisher_11.1.1/to5gma/war/xdo/tmp/, fo-external-link-target=_blank, xslt._XDOTIMEZONE='Europe/Paris', html-css-dir=/servers/bipublisher/bip11/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/bipublisher_11.1.1/to5gma/war/xdo/tmp/, system-temp-dir=/servers/bipublisher/BIP11_TMP/xdo/tmp/, xslt.XDO_USER_ROLES='XMLP_TEMPLATE_DESIGNER,ccms,XMLP_ADMIN,ATLC-RPT,XMLP_ANALYZER_ONLINE,Support_UMGI,XMLP_SCHEDULER,OPS_report,XMLP_DEVELOPER,XMLP_ANALYZER_EXCEL,ATLC_readOnly_role', xslt.CURRENT_SERVER_PORT='80', xslt.CURRENT_SERVER_URL='http://bipublisher.mnt.digiplug.com:80/xmlpserver/', fo-external-link-base-url=http://bipublisher.mnt.digiplug.com:80/xmlpserver/RPT-TMP/, xslt.XDO_USER_NAME='administrator', xslt.CURRENT_SERVER_CONTEXT_PATH='xmlpserver', xslt._XDOCHARTTYPE='image/png', xslt._XDOOUTPUTFORMAT='text/html', html-use-data-uri=false, html-css-base-uri=http://bipublisher.mnt.digiplug.com:80/xmlpserver/xdo/tmp, xslt._FURL='http://bipublisher.mnt.digiplug.com:80/xmlpserver/RPT-TMP/', xslt._xt='', xslt._xdo_user='administrator', html-image-base-uri=http://bipublisher.mnt.digiplug.com:80/xmlpserver/xdo/tmp/, xslt.CURRENT_SERVER_NAME='bipublisher.mnt.digiplug.com', xslt._xf='xml', html-image-acl-id=7721be3945e2b7bd6ba1cc3a10f7e042bd9a4d0491c49b842c92f73ac8ab4080}
[100217_102905706][][STATEMENT] temp file is created: /servers/bipublisher/BIP11_TMP/xdo/tmp/xmlp8231080622070963666tmp
[100217_102905708][][STATEMENT] MonitoringEvent started: class oracle.xdo.servlet.monitor.ReportDataProcessEvent:threadName=[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)',format=xml,totalMemory=271974400,reportName=/RPT-TMP/Mysql_connection.xdm,templateName=,userLocale=en_US,freeMemory=57936280
[100217_102905709][oracle.xdo.servlet.RTFCoreProcessor][EVENT] start-getdata: DataModel=/RPT-TMP/Mysql_connection.xdm, OutFormat=xml, Locale=en_US
[100217_102905712][][STATEMENT] ReportRepository - get data model: /RPT-TMP/Mysql_connection.xdm
[100217_102905714][][STATEMENT] CatalogServiceUtil - input path: /RPT-TMP/Mysql_connection.xdm
[100217_102905716][oracle.xdo.servlet.resources.catalog.ResourceCatalogServiceImpl][STATEMENT] Loading: Basic
[100217_102905718][][STATEMENT] CatalogServiceUtil.getValidation: [Resoure type: ReportItem, Readable: true, traversable: true]
[100217_102905719][oracle.xdo.servlet.resources.catalog.ResourceCatalogServiceImpl][STATEMENT] Loading: SkipReadOnly
[100217_102905722][][EVENT] Storing DMSC Session thread :Thread[[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads] : for id:NxtECswkid1506932945721
[100217_102905785][oracle.xdo.servlet.ReportModelContextImpl][EVENT] ReportModelContextImpl- Invoking dataengine dataprocessor..
[100217_102905789][][EVENT] Initializing DateFormatter for thread id:Thread[[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads]:MapSize:5
[100217_102905791][][STATEMENT] server_temp_dir=/servers/bipublisher/BIP11_TMP/xdo/tmp/
[100217_102905794][][EVENT] Storing Session thread :Thread[[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads] : for id:UIPz2SsoZg1506932945792
[100217_102905796][][EVENT] SessionId for Parsing:UIPz2SsoZg1506932945792
[100217_102905797][][STATEMENT] DataModel parsing started...
[100217_102905800][][STATEMENT] Oracle XML Parser version : Oracle XML Developers Kit 11.1.1.3.0 - Production
[100217_102905802][][STATEMENT] Data Model ......
[100217_102905804][][STATEMENT] Inside properties Parser...
[100217_102905806][][STATEMENT] include_parameters=true
[100217_102905808][][STATEMENT] include_null_Element=false
[100217_102905810][][STATEMENT] include_rowsettag=false
[100217_102905812][][STATEMENT] xml_tag_case=upper
[100217_102905814][][STATEMENT] Inside dataQueryParser...
[100217_102905816][][STATEMENT] rowtagchange=false
[100217_102905819][][STATEMENT] Inside dataStructureParser...
[100217_102905822][][STATEMENT] Group ...report
[100217_102905826][][STATEMENT] Group ...G_1
[100217_102905828][][STATEMENT] Inside triggerParser...
[100217_102905829][][STATEMENT] Inside parameterParser...
[100217_102905831][][STATEMENT] DataModel parsing completed....
[100217_102905833][][STATEMENT] Setting Data Model ...
[100217_102905835][][STATEMENT] datamodel_path=/RPT-TMP/Mysql_connection.xdm
[100217_102905837][][STATEMENT] module=/RPT-TMP/Mysql_connection.xdm
[100217_102905839][][STATEMENT] processing_mode=0
[100217_102905841][][STATEMENT] absPath/~administrator/user~.profile, is report item type: false, is layout template type: false, matches report item reg expr: false, matches style template reg expr: false
[100217_102905843][oracle.xdo.servlet.ReportModelContextImpl][STATEMENT] Setting timeZoneId:Europe/Paris
[100217_102905845][][STATEMENT] Setting Parameters ...
[100217_102905846][][EVENT] DataProcessor.processData():Begin
[100217_102905848][][EVENT] DataProcessor.processData():Invoke super.processData
[100217_102905850][][STATEMENT] DEConnection:initConnectionContext:Begin
[100217_102905853][][EVENT] DEConnection:initConnectionContext:Type:SQL
[100217_102905855][][STATEMENT] DEConnection:handleJDBCConnection:Begin
[100217_102905856][][STATEMENT] DEConnection:getJDBCConnection:Begin
[100217_102905858][][STATEMENT] DEConnection:getJDBCConnection:PRIMARY_DATASOURCE
[100217_102905873][][STATEMENT] DEConnection:getJDBCConnection:End
[100217_102905875][][STATEMENT] DEConnection:handleJDBCConnection:connection found
[100217_102905876][][STATEMENT] DEConnection:handleJDBCConnection:setting connection to the context
[100217_102905878][][STATEMENT] DEConnection:handleJDBCConnection:End
[100217_102905881][][STATEMENT] Setting Data sets Connections...
[100217_102905883][][EVENT] SessionId for process:UIPz2SsoZg1506932945792
[100217_102905884][][STATEMENT] Executing data triggers...
[100217_102905886][][STATEMENT] Executing data triggers...
[100217_102905888][][STATEMENT] Start process Data Structure ..
[100217_102905894][][STATEMENT] XDO_USER_NAME
[100217_102905896][][STATEMENT] XDO_USER_ROLES
[100217_102905898][][STATEMENT] XDO_USER_UI_LOCALE
[100217_102905900][][STATEMENT] XDO_USER_UI_ORACLE_LANG
[100217_102905902][][STATEMENT] XDO_USER_REPORT_LOCALE
[100217_102905904][][STATEMENT] XDO_USER_REPORT_ORACLE_LANG
[100217_102905905][][STATEMENT] XDO_DASHBOARD_EXPR
[100217_102905907][][STATEMENT] FUSION_SECURITY_ENABLED
[100217_102905909][][STATEMENT] FUSION_ESS_APPLSESSION_ID
[100217_102905911][][EVENT] User Preference time zone selected:sun.util.calendar.ZoneInfo[id="Europe/Paris",offset=3600000,dstSavings=3600000,useDaylight=true,transitions=184,lastRule=java.util.SimpleTimeZone[id=Europe/Paris,offset=3600000,dstSavings=3600000,useDaylight=true,startYear=0,startMode=2,startMonth=2,startDay=-1,startDayOfWeek=1,startTime=3600000,startTimeMode=2,endMode=2,endMonth=9,endDay=-1,endDayOfWeek=1,endTime=3600000,endTimeMode=2]]
[100217_102905916][][EVENT] Java Converted Date with no timezone set:2017-10-02 10:29:05.013+020010
[100217_102905918][][EVENT] JVM Java.Util.Timezone:Central European Time:3600000:true
[100217_102905920][][EVENT] Java Converted Date with default java timezone set:2017-10-02 10:29:05.013+020010
[100217_102905922][][EVENT] FND Cononical Date Format:2017-10-02T10:29:05.915+02:00
[100217_102905923][][STATEMENT] Writing Data ...
[100217_102905926][][EVENT] Number of queries :1
[100217_102905928][][STATEMENT] Returning Final Query from QueryParser:
select "deployment_project"."NAME" as "NAME",
"deployment_project"."DESCRIPTION" as "DESCRIPTION"
from "bambootomcat"."deployment_project" "deployment_project"
[100217_102905930][][EVENT] DB Fetch Size: 100
[100217_102905933][][EVENT] SQL Query Timeout: 0
[100217_102905935][][STATEMENT] Sql Query :dd: select "deployment_project"."NAME" as "NAME",
"deployment_project"."DESCRIPTION" as "DESCRIPTION"
from "bambootomcat"."deployment_project" "deployment_project"
[100217_102905938][][EVENT] Removing StringList sessionId:UIPz2SsoZg1506932945792
[100217_102905940][][EXCEPTION] XMLGEN:Exception while processing...:_RPT_TMP_Mysql_connection_xdm
[100217_102905942][][EXCEPTION] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '."NAME" as "NAME",
"deployment_project"."DESCRIPTION" as "DESCRIPTION"
from' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281)
at oracle.xdo.dataengine.XMLPGEN.processQuery(XMLPGEN.java:1896)
at oracle.xdo.dataengine.XMLPGEN.processSQLDataSource(XMLPGEN.java:522)
at oracle.xdo.dataengine.XMLPGEN.writeData(XMLPGEN.java:437)
at oracle.xdo.dataengine.XMLPGEN.writeGroupStructure(XMLPGEN.java:338)
at oracle.xdo.dataengine.XMLPGEN.writeXMLDataStructure(XMLPGEN.java:271)
at oracle.xdo.dataengine.XMLPGEN.processDataSet(XMLPGEN.java:1787)
at oracle.xdo.dataengine.XMLPGEN.processMergedDataSet(XMLPGEN.java:1490)
at oracle.xdo.dataengine.DataProcessor.processData(DataProcessor.java:376)
at oracle.xdo.servlet.dataengine.DataProcessorImpl.processData(DataProcessorImpl.java:318)
at oracle.xdo.servlet.dataengine.DataProcessorImpl.render(DataProcessorImpl.java:672)
at oracle.xdo.servlet.ReportModelContextImpl.getReportXMLData(ReportModelContextImpl.java:329)
at oracle.xdo.servlet.CoreProcessor.process(CoreProcessor.java:407)
at oracle.xdo.servlet.CoreProcessor.generateDocument(CoreProcessor.java:101)
at oracle.xdo.servlet.ReportImpl.renderBodyHTTP(ReportImpl.java:1154)
at oracle.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java:663)
at oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:492)
at oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:462)
at oracle.xdo.servlet.XDOServlet.doGet(XDOServlet.java:280)
at oracle.xdo.servlet.XDOServlet.doPost(XDOServlet.java:313)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.xdo.servlet.metadata.track.MostRecentFilter.doFilter(MostRecentFilter.java:64)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:143)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.xdo.servlet.init.InitCheckingFilter.doFilter(InitCheckingFilter.java:63)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1499)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:263)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
[100217_102905945][][EVENT] Removing StringList sessionId:UIPz2SsoZg1506932945792
[100217_102905947][][EVENT] Printing Session Details....
[100217_102905948][][EVENT] Session Details:0:
[100217_102905950][][EVENT] Removing DPsessionId:UIPz2SsoZg1506932945792
[100217_102905952][][EVENT] Removed Session thread :Thread[[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads] : for id:UIPz2SsoZg1506932945792
[100217_102905955][][EVENT] DataProcessor.processData():Finally clsoing all connections..
[100217_102905959][][EVENT] DEConnection::closeConnections: close connection for [bamboo]
[100217_102905961][][EVENT] Removing DMSC Session thread :Thread[[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads] : for id:NxtECswkid1506932945721
[100217_102905970][][STATEMENT] MonitoringEvent errored: class oracle.xdo.servlet.monitor.ReportRequestEvent:scheduled=false,report_runtime_property={},HTML_SESSION_ID=-lrcMpQY4Sy3xR7Je2F-Lc-0Mf7Tqda03iHRS7XgzQkg0DgKV9tV!-44563551!1506932855832,timezone=Europe/Paris,_xuil=en_US,weblogic.servlet.network_channel.port=8080,oracle.dms.context.http.WebRequestContextProcessed=true,_svg=false,userName=administrator,locale=en_US,format=xml,reportName=/RPT-TMP/Mysql_connection.xdm,templateName=,_xservreq=weblogic.servlet.internal.RequestEventsFilter$EventsRequestWrapper@7ed64715
[100217_102905972][oracle.xdo.servlet.XDOServlet][EXCEPTION] oracle.xdo.XDOException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '."NAME" as "NAME",
"deployment_project"."DESCRIPTION" as "DESCRIPTION"
from' at line 1
at oracle.xdo.dataengine.XMLPGEN.processMergedDataSet(XMLPGEN.java:1647)
at oracle.xdo.dataengine.DataProcessor.processData(DataProcessor.java:376)
at oracle.xdo.servlet.dataengine.DataProcessorImpl.processData(DataProcessorImpl.java:318)
at oracle.xdo.servlet.dataengine.DataProcessorImpl.render(DataProcessorImpl.java:672)
at oracle.xdo.servlet.ReportModelContextImpl.getReportXMLData(ReportModelContextImpl.java:329)
at oracle.xdo.servlet.CoreProcessor.process(CoreProcessor.java:407)
at oracle.xdo.servlet.CoreProcessor.generateDocument(CoreProcessor.java:101)
at oracle.xdo.servlet.ReportImpl.renderBodyHTTP(ReportImpl.java:1154)
at oracle.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java:663)
at oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:492)
at oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:462)
at oracle.xdo.servlet.XDOServlet.doGet(XDOServlet.java:280)
at oracle.xdo.servlet.XDOServlet.doPost(XDOServlet.java:313)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.xdo.servlet.metadata.track.MostRecentFilter.doFilter(MostRecentFilter.java:64)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:143)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.xdo.servlet.init.InitCheckingFilter.doFilter(InitCheckingFilter.java:63)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1499)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:263)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '."NAME" as "NAME",
"deployment_project"."DESCRIPTION" as "DESCRIPTION"
from' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281)
at oracle.xdo.dataengine.XMLPGEN.processQuery(XMLPGEN.java:1896)
at oracle.xdo.dataengine.XMLPGEN.processSQLDataSource(XMLPGEN.java:522)
at oracle.xdo.dataengine.XMLPGEN.writeData(XMLPGEN.java:437)
at oracle.xdo.dataengine.XMLPGEN.writeGroupStructure(XMLPGEN.java:338)
at oracle.xdo.dataengine.XMLPGEN.writeXMLDataStructure(XMLPGEN.java:271)
at oracle.xdo.dataengine.XMLPGEN.processDataSet(XMLPGEN.java:1787)
at oracle.xdo.dataengine.XMLPGEN.processMergedDataSet(XMLPGEN.java:1490)
... 54 more
[100217_102905976][oracle.xdo.servlet.XDOServlet][EXCEPTION] javax.servlet.ServletException: oracle.xdo.XDOException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '."NAME" as "NAME",
"deployment_project"."DESCRIPTION" as "DESCRIPTION"
from' at line 1
at oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:472)
at oracle.xdo.servlet.XDOServlet.doGet(XDOServlet.java:280)
at oracle.xdo.servlet.XDOServlet.doPost(XDOServlet.java:313)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.xdo.servlet.metadata.track.MostRecentFilter.doFilter(MostRecentFilter.java:64)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:143)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.xdo.servlet.init.InitCheckingFilter.doFilter(InitCheckingFilter.java:63)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1499)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:263)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused by: oracle.xdo.XDOException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '."NAME" as "NAME",
"deployment_project"."DESCRIPTION" as "DESCRIPTION"
from' at line 1
at oracle.xdo.servlet.ReportException.fillInStackTrace(ReportException.java:124)
at oracle.xdo.servlet.data.DataException.fillInStackTrace(DataException.java:127)
at java.lang.Throwable.<init>(Throwable.java:181)
at java.lang.Exception.<init>(Exception.java:29)
at oracle.xdo.servlet.ReportException.<init>(ReportException.java:40)
at oracle.xdo.servlet.data.DataException.<init>(DataException.java:44)
at oracle.xdo.servlet.ReportModelContextImpl.getReportXMLData(ReportModelContextImpl.java:367)
at oracle.xdo.servlet.CoreProcessor.process(CoreProcessor.java:407)
at oracle.xdo.servlet.CoreProcessor.generateDocument(CoreProcessor.java:101)
at oracle.xdo.servlet.ReportImpl.renderBodyHTTP(ReportImpl.java:1154)
at oracle.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java:663)
at oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:492)
at oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:462)
... 44 more
[100217_102905978][][EXCEPTION] UIUTils.renderError: strict servlet API: cannot call getWriter() after getOutputStream()
0 -
Only alias columns you are going to change the name of ... try your query without aliases ...
0