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

[Steven Hawkins (JIRA)]

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

Steven Hawkins updated TEIID-577:
---------------------------------

    Fix Version/s: 6.1.1


It looks like the extension module management was having it's exceptions logged to the ADMIN_API context, was this context enabled for logging?  And was ERROR level logging turned on?

This brings up the issue that the logging context should actually be 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: Steven Hawkins
>             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