December 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3264) Database Logging: Problems with Sybase

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3264?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-3264: ------------------------------------------- Bugzilla Update: Perform Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1175402 > Database Logging: Problems with Sybase > -------------------------------------- > > Key: TEIID-3264 > URL: https://issues.jboss.org/browse/TEIID-3264 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1 > Reporter: Jan Stastny > Assignee: Steven Hawkins > Attachments: server.log > > > When using Sybase DB for Database Logging in Teiid, an error is thrown upon each command, which should be logged. > The root cause says java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0SL: Unsupported SQL type 2004. > But see the server.log for further info -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3264) Database Logging: Problems with Sybase

by Jan Stastny (JIRA)

[ https://issues.jboss.org/browse/TEIID-3264?page=com.atlassian.jira.plugin... ] Jan Stastny updated TEIID-3264: ------------------------------- Attachment: server.log > Database Logging: Problems with Sybase > -------------------------------------- > > Key: TEIID-3264 > URL: https://issues.jboss.org/browse/TEIID-3264 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1 > Reporter: Jan Stastny > Assignee: Steven Hawkins > Attachments: server.log > > > When using Sybase DB for Database Logging in Teiid, an error is thrown upon each command, which should be logged. > The root cause says java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0SL: Unsupported SQL type 2004. > But see the server.log for further info -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3264) Database Logging: Problems with Sybase

by Jan Stastny (JIRA)

Jan Stastny created TEIID-3264: ---------------------------------- Summary: Database Logging: Problems with Sybase Key: TEIID-3264 URL: https://issues.jboss.org/browse/TEIID-3264 Project: Teiid Issue Type: Bug Affects Versions: 8.7.1 Reporter: Jan Stastny Assignee: Steven Hawkins When using Sybase DB for Database Logging in Teiid, an error is thrown upon each command, which should be logged. The root cause says java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0SL: Unsupported SQL type 2004. But see the server.log for further info -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3263) Invalid aggregate value

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-3263: ------------------------------------- Summary: Invalid aggregate value Key: TEIID-3263 URL: https://issues.jboss.org/browse/TEIID-3263 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.9 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Blocker Fix For: 8.10 There's a regression in TEIID-3119 - an incorrect aggregate value can be returned when using group/sort aggregation. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3262) Database Logging: Problems with DB2

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3262?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-3262: ------------------------------------ I think its an IBM configuration problem. When I ran the create table statement directly to DB2 using SQurrel, I get a different IBM Error: Error: DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=16384;BQT2, DRIVER=4.0.100 SQLState: 42727 And I found a similar issue on the IBM Knowledge base and is the following: Problem: If you are using Repotools with DB2® as your database to create tables forRational® Quality Manager, the error message SQL Message: DB2 SQL error: SQLCODE: -286, SQLSTATE: 42727, SQLERRMC: 16384;DB2ADMIN might be displayed. Solution: When you create the Rational Quality Manager database, you must increase the default bufferpool and table page size space to 16k. For more information, see the Rational Quality Manager installation documentation. I'll do more investigation. > Database Logging: Problems with DB2 > ----------------------------------- > > Key: TEIID-3262 > URL: https://issues.jboss.org/browse/TEIID-3262 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1 > Reporter: Jan Stastny > Assignee: Steven Hawkins > Attachments: stack-trace.txt > > > When Database Logging feature is turned on and configured with DB2 version 10, problems are encountered when an attempt to create a command log. > The issue produces long stacktrace, so it is attached in a text file. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3262) Database Logging: Problems with DB2

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3262?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-3262: ------------------------------------------- Bugzilla Update: Perform Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1175304 > Database Logging: Problems with DB2 > ----------------------------------- > > Key: TEIID-3262 > URL: https://issues.jboss.org/browse/TEIID-3262 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1 > Reporter: Jan Stastny > Assignee: Steven Hawkins > Attachments: stack-trace.txt > > > When Database Logging feature is turned on and configured with DB2 version 10, problems are encountered when an attempt to create a command log. > The issue produces long stacktrace, so it is attached in a text file. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3262) Database Logging: Problems with DB2

by Jan Stastny (JIRA)

[ https://issues.jboss.org/browse/TEIID-3262?page=com.atlassian.jira.plugin... ] Jan Stastny updated TEIID-3262: ------------------------------- Attachment: stack-trace.txt > Database Logging: Problems with DB2 > ----------------------------------- > > Key: TEIID-3262 > URL: https://issues.jboss.org/browse/TEIID-3262 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1 > Reporter: Jan Stastny > Assignee: Steven Hawkins > Attachments: stack-trace.txt > > > When Database Logging feature is turned on and configured with DB2 version 10, problems are encountered when an attempt to create a command log. > The issue produces long stacktrace, so it is attached in a text file. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3262) Database Logging: Problems with DB2

by Jan Stastny (JIRA)

Jan Stastny created TEIID-3262: ---------------------------------- Summary: Database Logging: Problems with DB2 Key: TEIID-3262 URL: https://issues.jboss.org/browse/TEIID-3262 Project: Teiid Issue Type: Bug Affects Versions: 8.7.1 Reporter: Jan Stastny Assignee: Steven Hawkins When Database Logging feature is turned on and configured with DB2 version 10, problems are encountered when an attempt to create a command log. The issue produces long stacktrace, so it is attached in a text file. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3261) DB Logging with DB2 - server fails to start

by Jan Stastny (JIRA)

[ https://issues.jboss.org/browse/TEIID-3261?page=com.atlassian.jira.plugin... ] Jan Stastny deleted TEIID-3261: ------------------------------- > DB Logging with DB2 - server fails to start > ------------------------------------------- > > Key: TEIID-3261 > URL: https://issues.jboss.org/browse/TEIID-3261 > Project: Teiid > Issue Type: Bug > Reporter: Jan Stastny > Assignee: Steven Hawkins > > When using DB Logging with DB2 database an error occurs during server start: > 13:02:15,237 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 56) HHH000389: Unsuccessful: create table commandlog (id bigint not null, applicationname varchar(255), executionid varchar(50), modelname varchar(255), principal varchar(50), queryplan blob(255), requestid varchar(50), row_count integer, sessionid varchar(50), sourcecommand smallint, sourcerequestid bigint, sqlcmd varchar(8196), eventtype varchar(10), logtime timestamp, transactionid varchar(256), translatorname varchar(50), vdbname varchar(255), vdbversion integer, primary key (id)) > 13:02:15,238 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 56) DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=16384;DBALLO00, DRIVER=4.12.55 -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3261) DB Logging with DB2 - server fails to start

by Jan Stastny (JIRA)

Jan Stastny created TEIID-3261: ---------------------------------- Summary: DB Logging with DB2 - server fails to start Key: TEIID-3261 URL: https://issues.jboss.org/browse/TEIID-3261 Project: Teiid Issue Type: Bug Affects Versions: 8.7.1 Reporter: Jan Stastny Assignee: Steven Hawkins When using DB Logging with DB2 database an error occurs during server start: 13:02:15,237 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 56) HHH000389: Unsuccessful: create table commandlog (id bigint not null, applicationname varchar(255), executionid varchar(50), modelname varchar(255), principal varchar(50), queryplan blob(255), requestid varchar(50), row_count integer, sessionid varchar(50), sourcecommand smallint, sourcerequestid bigint, sqlcmd varchar(8196), eventtype varchar(10), logtime timestamp, transactionid varchar(256), translatorname varchar(50), vdbname varchar(255), vdbversion integer, primary key (id)) 13:02:15,238 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 56) DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=16384;DBALLO00, DRIVER=4.12.55 -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 5 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues December 2014