[teiid-issues] [JBoss JIRA] Resolved: (TEIID-577) Getting a major JDBC Error in the console (from the server), but don't see the exception in the process log

[Li Liang (JIRA)]

     [ https://jira.jboss.org/jira/browse/TEIID-577?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Li Liang resolved TEIID-577.
----------------------------

    Resolution: Cannot Reproduce Bug


Tested. Did not see any error working with Extension Modules.

The reported exception was thrown from JDBCExtensionModuleReader.getSourceDescriptors. To test server logging, I added test code to throw the SQLException in that method. The exactly same exception was caught in console when accessing the extension module. In the server process log, the exception was properly logged under the context EXTENSION_SOURCE_ADMIN_API (Steve H has changed ADMIN_API to EXTENSION_SOURCE_ADMIN_API).



> Getting a major JDBC Error in the console (from the server), but don't see the exception in the process log
> -----------------------------------------------------------------------------------------------------------
>
>                 Key: TEIID-577
>                 URL: https://jira.jboss.org/jira/browse/TEIID-577
>             Project: Teiid
>          Issue Type: Bug
>          Components: Server
>    Affects Versions: 6.1.0
>            Reporter: Van Halbert
>            Assignee: Li Liang
>             Fix For: 6.1.1
>
>
> Trying to look at the extension modules in the console and receive a server SQLException when it''s accessing the CS_EXT_FILES.  Unfortunately, the major exception isn't seen in the process log.   I would have thought any major sql exception shown up when the console log setting is set to information.
> Error:
> Details
> 	Error Code:ERR.014.004.0047 Message:Retrieve extension modulesExternalException: [ExternalException] ERR.014.004.0047: Error Code:ERR.014.004.0047 Message:Retrieve extension modules
> 1 [MetaMatrixComponentException] ERR.014.004.0047: Error Code:ERR.014.004.0047 Message:Error retrieving all extension module names:SELECT FILE_NAME, FILE_DESC, FILE_TYPE, SEARCH_POS, IS_ENABLED, CREATED_BY, CREATION_DATE, UPDATED_BY, UPDATE_DATE, CHKSUM  FROM CS_EXT_FILES 
> 2 [SQLException][MetaMatrix][Oracle JDBC Driver]Exception generated during deferred local transaction handling.  See next exception via SQLException.getNextException for details.
> 3 [SQLException][MetaMatrix][Oracle JDBC Driver]Broken pipe
> 	at com.metamatrix.console.models.ExtensionSourceManager.getModules(ExtensionSourceManager.java:217)
> 	at com.metamatrix.console.ui.views.extensionsource.ExtensionSourcesPanel.populateTable(ExtensionSourcesPanel.java:194)
> 	at com.metamatrix.console.ui.views.extensionsource.ExtensionSourcesPanel.init(ExtensionSourcesPanel.java:139)
> 	at com.metamatrix.console.ui.views.extensionsource.ExtensionSourcesPanel.<init>(ExtensionSourcesPanel.java:91)
> 	at com.metamatrix.console.ui.layout.WorkspaceController.createExtensionSourcesPanel(WorkspaceController.java:532)
> 	at com.metamatrix.console.ui.layout.WorkspaceController.createPanelOfClass(WorkspaceController.java:359)
> 	at com.metamatrix.console.ui.layout.WorkspaceController.doChangePanel(WorkspaceController.java:200)
> 	at com.metamatrix.console.ui.layout.WorkspaceControllerWorkItem.run(WorkspaceControllerWorkItem.java:44)
> 	at com.metamatrix.common.queue.WorkerPoolFactory$StatsCapturingSharedThreadPoolExecutor$1.run(WorkerPoolFactory.java:211)
> 	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
> 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
> 	at java.lang.Thread.run(Thread.java:637)
> Caused by: [MetaMatrixComponentException] ERR.014.004.0047: Error Code:ERR.014.004.0047 Message:Error retrieving all extension module names:SELECT FILE_NAME, FILE_DESC, FILE_TYPE, SEARCH_POS, IS_ENABLED, CREATED_BY, CREATION_DATE, UPDATED_BY, UPDATE_DATE, CHKSUM  FROM CS_EXT_FILES 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira