[teiid-issues] [JBoss JIRA] (TEIID-3032) Database Logging: Problems with Microsoft

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3032?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12984679#comment-12984679 ] 

Steven Hawkins commented on TEIID-3032:
---------------------------------------

The ERRORs related to the drops seem to be erroneously reported as you'd expect them to fail if the tables don't exist.  The unsuccessful create is due to plan being a reserved word for SQL Server.  Ideally hibernate would know this and quote it, but we should be able to do that manually as well.

> Database Logging: Problems with Microsoft
> -----------------------------------------
>
>                 Key: TEIID-3032
>                 URL: https://issues.jboss.org/browse/TEIID-3032
>             Project: Teiid
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>    Affects Versions: 8.7.1
>            Reporter: Van Halbert
>
> Installed the teiid extension:  database logging, and seeing the following errors:
> 14:46:55,588 WARN  [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID50036 VDB Logging.1 model "LoggingData" metadata failed to load. Reason:TEIID60013 Duplicate Table check_constraints
> 14:46:55,844 INFO  [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 57) HHH000227: Running hbm2ddl schema export
> 14:46:56,119 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 57) HHH000389: Unsuccessful: drop table auditlog
> 14:46:56,120 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 57) Cannot drop the table 'auditlog', because it does not exist or you do not have permission.
> 14:46:56,343 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 57) HHH000389: Unsuccessful: drop table commandlog
> 14:46:56,343 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 57) Cannot drop the table 'commandlog', because it does not exist or you do not have permission.
> 14:46:56,857 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 57) HHH000389: Unsuccessful: create table commandlog (id bigint identity not null, applicationname varchar(255), executionid varchar(50), modelname varchar(255), plan varbinary(MAX), principal varchar(50), requestid varchar(50), rowcount int, sessionid varchar(50), sourcecommand bit, sourcerequestid bigint, sqlcmd varchar(MAX), eventtype varchar(10), logtime datetime2, transactionid varchar(100), translatorname varchar(50), vdbname varchar(255), vdbversion int, primary key (id))
> 14:46:56,858 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 57) Incorrect syntax near the keyword 'plan'.
> 14:46:56,858 INFO  [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 57) HHH000230: Schema export complete



--
This message was sent by Atlassian JIRA
(v6.2.6#6264)