10:52 a.m.
Error Installing Teiid with a Postgres Repository
-------------------------------------------------
Key: TEIID-436
URL: https://jira.jboss.org/jira/browse/TEIID-436
Project: Teiid
Issue Type: Bug
Components: JDBC Driver
Affects Versions: 6.0.0
Reporter: Ted Jones
Assignee: Steven Hawkins
While running setupmm with a local Postgres repository, I encountered the following fatal
error:
/home/tejones/apps/EnterpriseDataServicesPlatform/03202009/server-0.0.1-SNAPSHOT/config/install/setup_server.xml:453:
[MetaMatrixComponentException] ERR.014.004.0054: Error inserting extension module Next
Startup using SQL statement: INSERT INTO
CS_EXT_FILES(FILE_UID,CHKSUM,FILE_NAME,SEARCH_POS,IS_ENABLED,FILE_DESC,CREATED_BY,CREATION_DATE,UPDATED_BY,UPDATE_DATE,FILE_TYPE)
VALUES
1 [DBIDGeneratorException] ERR.003.013.0011: Error creating id for CS_EXT_FILES context.
2 [DBIDGeneratorException] ERR.003.013.0014: Could not obtain a unique ID blocksize of 100
for context CS_EXT_FILES.
3 [ManagedConnectionException] ERR.003.013.0016: Unable to obtain the managed connection
for the DBID transaction
4 [MetaMatrixException] ERR.003.015.0003: JDBCPlatform Program Error, unable to create
platform.
5 [MetaMatrixException] ERR.003.015.0003: JDBCPlatform Program Error, unable to create
platform.
6 [IllegalArgumentException]
--
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
10:58 a.m.
New subject: [JBoss JIRA] Updated: (TEIID-436) Error Installing Teiid with a Postgres Repository
[
https://jira.jboss.org/jira/browse/TEIID-436?page=com.atlassian.jira.plug...
]
Steven Hawkins updated TEIID-436:
---------------------------------
Fix Version/s: 6.1.0
Assignee: (was: Steven Hawkins)
This is likely due to case sensitivity in the table/element names.
Error Installing Teiid with a Postgres Repository
-------------------------------------------------
Key: TEIID-436
URL: https://jira.jboss.org/jira/browse/TEIID-436
Project: Teiid
Issue Type: Bug
Components: JDBC Driver
Affects Versions: 6.0.0
Reporter: Ted Jones
Fix For: 6.1.0
While running setupmm with a local Postgres repository, I encountered the following fatal
error:
/home/tejones/apps/EnterpriseDataServicesPlatform/03202009/server-0.0.1-SNAPSHOT/config/install/setup_server.xml:453:
[MetaMatrixComponentException] ERR.014.004.0054: Error inserting extension module Next
Startup using SQL statement: INSERT INTO
CS_EXT_FILES(FILE_UID,CHKSUM,FILE_NAME,SEARCH_POS,IS_ENABLED,FILE_DESC,CREATED_BY,CREATION_DATE,UPDATED_BY,UPDATE_DATE,FILE_TYPE)
VALUES
1 [DBIDGeneratorException] ERR.003.013.0011: Error creating id for CS_EXT_FILES context.
2 [DBIDGeneratorException] ERR.003.013.0014: Could not obtain a unique ID blocksize of
100 for context CS_EXT_FILES.
3 [ManagedConnectionException] ERR.003.013.0016: Unable to obtain the managed connection
for the DBID transaction
4 [MetaMatrixException] ERR.003.015.0003: JDBCPlatform Program Error, unable to create
platform.
5 [MetaMatrixException] ERR.003.015.0003: JDBCPlatform Program Error, unable to create
platform.
6 [IllegalArgumentException]
--
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
11:43 a.m.
New subject: [JBoss JIRA] Commented: (TEIID-436) Error Installing Teiid with a Postgres Repository
[
https://jira.jboss.org/jira/browse/TEIID-436?page=com.atlassian.jira.plug...
]
Ramesh Reddy commented on TEIID-436:
------------------------------------
There is similar issue with the Derby database. The explanation I have seen for this is,
since these databases keep their data file based the table names, the casing matters when
it used on Win vs Linux environments.
Error Installing Teiid with a Postgres Repository
-------------------------------------------------
Key: TEIID-436
URL: https://jira.jboss.org/jira/browse/TEIID-436
Project: Teiid
Issue Type: Bug
Components: JDBC Driver
Affects Versions: 6.0.0
Reporter: Ted Jones
Fix For: 6.1.0
While running setupmm with a local Postgres repository, I encountered the following fatal
error:
/home/tejones/apps/EnterpriseDataServicesPlatform/03202009/server-0.0.1-SNAPSHOT/config/install/setup_server.xml:453:
[MetaMatrixComponentException] ERR.014.004.0054: Error inserting extension module Next
Startup using SQL statement: INSERT INTO
CS_EXT_FILES(FILE_UID,CHKSUM,FILE_NAME,SEARCH_POS,IS_ENABLED,FILE_DESC,CREATED_BY,CREATION_DATE,UPDATED_BY,UPDATE_DATE,FILE_TYPE)
VALUES
1 [DBIDGeneratorException] ERR.003.013.0011: Error creating id for CS_EXT_FILES context.
2 [DBIDGeneratorException] ERR.003.013.0014: Could not obtain a unique ID blocksize of
100 for context CS_EXT_FILES.
3 [ManagedConnectionException] ERR.003.013.0016: Unable to obtain the managed connection
for the DBID transaction
4 [MetaMatrixException] ERR.003.015.0003: JDBCPlatform Program Error, unable to create
platform.
5 [MetaMatrixException] ERR.003.015.0003: JDBCPlatform Program Error, unable to create
platform.
6 [IllegalArgumentException]
--
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
2:10 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-436) Error Installing Teiid with a Postgres Repository
[
https://jira.jboss.org/jira/browse/TEIID-436?page=com.atlassian.jira.plug...
]
Ted Jones commented on TEIID-436:
---------------------------------
Turns out this error was caused by assuming a particular URL format for Postgres. There
are optional portions of the url for Postgres which I left off. If host and port are
omitted they are assumed to be localhost and 5432 respectively. So,
jdbc:postgresql:dv_tejones is equivalent to jdbc:postgresql://localhost:5432/dv_tejones.
We should check for all possible combinations of the url OR require that the url is
entered in the full format.
Error Installing Teiid with a Postgres Repository
-------------------------------------------------
Key: TEIID-436
URL: https://jira.jboss.org/jira/browse/TEIID-436
Project: Teiid
Issue Type: Bug
Components: JDBC Driver
Affects Versions: 6.0.0
Reporter: Ted Jones
Fix For: 6.1.0
While running setupmm with a local Postgres repository, I encountered the following fatal
error:
/home/tejones/apps/EnterpriseDataServicesPlatform/03202009/server-0.0.1-SNAPSHOT/config/install/setup_server.xml:453:
[MetaMatrixComponentException] ERR.014.004.0054: Error inserting extension module Next
Startup using SQL statement: INSERT INTO
CS_EXT_FILES(FILE_UID,CHKSUM,FILE_NAME,SEARCH_POS,IS_ENABLED,FILE_DESC,CREATED_BY,CREATION_DATE,UPDATED_BY,UPDATE_DATE,FILE_TYPE)
VALUES
1 [DBIDGeneratorException] ERR.003.013.0011: Error creating id for CS_EXT_FILES context.
2 [DBIDGeneratorException] ERR.003.013.0014: Could not obtain a unique ID blocksize of
100 for context CS_EXT_FILES.
3 [ManagedConnectionException] ERR.003.013.0016: Unable to obtain the managed connection
for the DBID transaction
4 [MetaMatrixException] ERR.003.015.0003: JDBCPlatform Program Error, unable to create
platform.
5 [MetaMatrixException] ERR.003.015.0003: JDBCPlatform Program Error, unable to create
platform.
6 [IllegalArgumentException]
--
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
2:22 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-436) Error Installing Teiid with a Postgres Repository
[
https://jira.jboss.org/jira/browse/TEIID-436?page=com.atlassian.jira.plug...
]
Ted Jones commented on TEIID-436:
---------------------------------
The rest of the stack trace:
[importConfigExtensionTask] java.lang.IllegalArgumentException
[importConfigExtensionTask] at
com.metamatrix.common.jdbc.JDBCURL.parseOnDelimiter(JDBCURL.java:90)
[importConfigExtensionTask] at
com.metamatrix.common.jdbc.JDBCURL.parseForSlash(JDBCURL.java:84)
[importConfigExtensionTask] at
com.metamatrix.common.jdbc.JDBCURL.parseURL(JDBCURL.java:76)
[importConfigExtensionTask] at
com.metamatrix.common.jdbc.JDBCURL.<init>(JDBCURL.java:44)
[importConfigExtensionTask] at
com.metamatrix.common.jdbc.JDBCPlatformFactory.getPlatform(JDBCPlatformFactory.java:175)
[importConfigExtensionTask] at
com.metamatrix.common.jdbc.JDBCPlatformFactory.getPlatform(JDBCPlatformFactory.java:148)
[importConfigExtensionTask] at
com.metamatrix.common.id.dbid.spi.jdbc.DBIDResourceTransaction.<init>(DBIDResourceTransaction.java:77)
[importConfigExtensionTask] at
com.metamatrix.common.id.dbid.spi.jdbc.DBIDResourceTransactionFactory.createTransaction(DBIDResourceTransactionFactory.java:55)
[importConfigExtensionTask] at
com.metamatrix.common.connection.TransactionMgr.getWriteTransaction(TransactionMgr.java:88)
[importConfigExtensionTask] at
com.metamatrix.common.id.dbid.spi.jdbc.PersistentIDController.createIDBlock(PersistentIDController.java:84)
[importConfigExtensionTask] at
com.metamatrix.common.id.dbid.spi.jdbc.PersistentIDController.getUniqueID(PersistentIDController.java:118)
[importConfigExtensionTask] at
com.metamatrix.common.id.dbid.DBIDGenerator.getUniqueID(DBIDGenerator.java:131)
[importConfigExtensionTask] at
com.metamatrix.common.id.dbid.DBIDGenerator.getID(DBIDGenerator.java:66)
[importConfigExtensionTask] at
com.metamatrix.common.extensionmodule.spi.jdbc.JDBCExtensionModuleWriter.addSource(JDBCExtensionModuleWriter.java:154)
[importConfigExtensionTask] at
com.metamatrix.common.extensionmodule.spi.jdbc.JDBCExtensionModuleWriter.addSource(JDBCExtensionModuleWriter.java:89)
[importConfigExtensionTask] at
com.metamatrix.common.extensionmodule.spi.jdbc.JDBCExtensionModuleUtil.importExtensionModule(JDBCExtensionModuleUtil.java:227)
[importConfigExtensionTask] at
com.metamatrix.installer.anttask.extensions.ExtensionConfigImportTask.execute(ExtensionConfigImportTask.java:111)
[importConfigExtensionTask] at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
[importConfigExtensionTask] at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown
Source)
[importConfigExtensionTask] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[importConfigExtensionTask] at java.lang.reflect.Method.invoke(Method.java:597)
[importConfigExtensionTask] at
org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
[importConfigExtensionTask] at org.apache.tools.ant.Task.perform(Task.java:348)
[importConfigExtensionTask] at org.apache.tools.ant.Target.execute(Target.java:357)
[importConfigExtensionTask] at
org.apache.tools.ant.Target.performTasks(Target.java:385)
[importConfigExtensionTask] at
org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
[importConfigExtensionTask] at
org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
[importConfigExtensionTask] at
org.apache.tools.ant.Project.executeTargets(Project.java:1181)
[importConfigExtensionTask] at
org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416)
[importConfigExtensionTask] at
org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
[importConfigExtensionTask] at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
[importConfigExtensionTask] at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown
Source)
[importConfigExtensionTask] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[importConfigExtensionTask] at java.lang.reflect.Method.invoke(Method.java:597)
[importConfigExtensionTask] at
org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
[importConfigExtensionTask] at org.apache.tools.ant.Task.perform(Task.java:348)
[importConfigExtensionTask] at org.apache.tools.ant.Target.execute(Target.java:357)
[importConfigExtensionTask] at
org.apache.tools.ant.Target.performTasks(Target.java:385)
[importConfigExtensionTask] at
org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
[importConfigExtensionTask] at
org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
[importConfigExtensionTask] at
org.apache.tools.ant.Project.executeTargets(Project.java:1181)
[importConfigExtensionTask] at
org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416)
[importConfigExtensionTask] at
org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
[importConfigExtensionTask] at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
[importConfigExtensionTask] at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown
Source)
[importConfigExtensionTask] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[importConfigExtensionTask] at java.lang.reflect.Method.invoke(Method.java:597)
[importConfigExtensionTask] at
org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
[importConfigExtensionTask] at org.apache.tools.ant.Task.perform(Task.java:348)
[importConfigExtensionTask] at org.apache.tools.ant.Target.execute(Target.java:357)
[importConfigExtensionTask] at
org.apache.tools.ant.Target.performTasks(Target.java:385)
[importConfigExtensionTask] at
org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
[importConfigExtensionTask] at
org.apache.tools.ant.Project.executeTarget(Project.java:1298)
[importConfigExtensionTask] at
org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
[importConfigExtensionTask] at
org.apache.tools.ant.Project.executeTargets(Project.java:1181)
[importConfigExtensionTask] at org.apache.tools.ant.Main.runBuild(Main.java:698)
[importConfigExtensionTask] at org.apache.tools.ant.Main.startAnt(Main.java:199)
[importConfigExtensionTask] at org.apache.tools.ant.Main.start(Main.java:161)
[importConfigExtensionTask] at org.apache.tools.ant.Main.main(Main.java:250)
[importConfigExtensionTask] [MetaMatrixException] ERR.003.015.0003: JDBCPlatform Program
Error, unable to create platform.
[importConfigExtensionTask] 1 [IllegalArgumentException]
[importConfigExtensionTask] at
com.metamatrix.common.jdbc.JDBCPlatformFactory.getPlatform(JDBCPlatformFactory.java:201)
[importConfigExtensionTask] at
com.metamatrix.common.jdbc.JDBCPlatformFactory.getPlatform(JDBCPlatformFactory.java:148)
[importConfigExtensionTask] at
com.metamatrix.common.id.dbid.spi.jdbc.DBIDResourceTransaction.<init>(DBIDResourceTransaction.java:77)
[importConfigExtensionTask] at
com.metamatrix.common.id.dbid.spi.jdbc.DBIDResourceTransactionFactory.createTransaction(DBIDResourceTransactionFactory.java:55)
[importConfigExtensionTask] at
com.metamatrix.common.connection.TransactionMgr.getWriteTransaction(TransactionMgr.java:88)
[importConfigExtensionTask] at
com.metamatrix.common.id.dbid.spi.jdbc.PersistentIDController.createIDBlock(PersistentIDController.java:84)
[importConfigExtensionTask] at
com.metamatrix.common.id.dbid.spi.jdbc.PersistentIDController.getUniqueID(PersistentIDController.java:118)
[importConfigExtensionTask] at
com.metamatrix.common.id.dbid.DBIDGenerator.getUniqueID(DBIDGenerator.java:131)
[importConfigExtensionTask] at
com.metamatrix.common.id.dbid.DBIDGenerator.getID(DBIDGenerator.java:66)
[importConfigExtensionTask] at
com.metamatrix.common.extensionmodule.spi.jdbc.JDBCExtensionModuleWriter.addSource(JDBCExtensionModuleWriter.java:154)
[importConfigExtensionTask] at
com.metamatrix.common.extensionmodule.spi.jdbc.JDBCExtensionModuleWriter.addSource(JDBCExtensionModuleWriter.java:89)
[importConfigExtensionTask] at
com.metamatrix.common.extensionmodule.spi.jdbc.JDBCExtensionModuleUtil.importExtensionModule(JDBCExtensionModuleUtil.java:227)
[importConfigExtensionTask] at
com.metamatrix.installer.anttask.extensions.ExtensionConfigImportTask.execute(ExtensionConfigImportTask.java:111)
[importConfigExtensionTask] at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
[importConfigExtensionTask] at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown
Source)
[importConfigExtensionTask] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[importConfigExtensionTask] at java.lang.reflect.Method.invoke(Method.java:597)
[importConfigExtensionTask] at
org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
[importConfigExtensionTask] at org.apache.tools.ant.Task.perform(Task.java:348)
[importConfigExtensionTask] at org.apache.tools.ant.Target.execute(Target.java:357)
[importConfigExtensionTask] at
org.apache.tools.ant.Target.performTasks(Target.java:385)
[importConfigExtensionTask] at
org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
[importConfigExtensionTask] at
org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
[importConfigExtensionTask] at
org.apache.tools.ant.Project.executeTargets(Project.java:1181)
[importConfigExtensionTask] at
org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416)
[importConfigExtensionTask] at
org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
[importConfigExtensionTask] at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
[importConfigExtensionTask] at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown
Source)
[importConfigExtensionTask] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[importConfigExtensionTask] at java.lang.reflect.Method.invoke(Method.java:597)
[importConfigExtensionTask] at
org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
[importConfigExtensionTask] at org.apache.tools.ant.Task.perform(Task.java:348)
[importConfigExtensionTask] at org.apache.tools.ant.Target.execute(Target.java:357)
[importConfigExtensionTask] at
org.apache.tools.ant.Target.performTasks(Target.java:385)
[importConfigExtensionTask] at
org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
[importConfigExtensionTask] at
org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
[importConfigExtensionTask] at
org.apache.tools.ant.Project.executeTargets(Project.java:1181)
[importConfigExtensionTask] at
org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416)
[importConfigExtensionTask] at
org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
[importConfigExtensionTask] at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
[importConfigExtensionTask] at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown
Source)
[importConfigExtensionTask] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[importConfigExtensionTask] at java.lang.reflect.Method.invoke(Method.java:597)
[importConfigExtensionTask] at
org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
[importConfigExtensionTask] at org.apache.tools.ant.Task.perform(Task.java:348)
[importConfigExtensionTask] at org.apache.tools.ant.Target.execute(Target.java:357)
[importConfigExtensionTask] at
org.apache.tools.ant.Target.performTasks(Target.java:385)
[importConfigExtensionTask] at
org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
[importConfigExtensionTask] at
org.apache.tools.ant.Project.executeTarget(Project.java:1298)
[importConfigExtensionTask] at
org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
[importConfigExtensionTask] at
org.apache.tools.ant.Project.executeTargets(Project.java:1181)
[importConfigExtensionTask] at org.apache.tools.ant.Main.runBuild(Main.java:698)
[importConfigExtensionTask] at org.apache.tools.ant.Main.startAnt(Main.java:199)
[importConfigExtensionTask] at org.apache.tools.ant.Main.start(Main.java:161)
[importConfigExtensionTask] at org.apache.tools.ant.Main.main(Main.java:250)
[importConfigExtensionTask] Caused by: java.lang.IllegalArgumentException
[importConfigExtensionTask] at
com.metamatrix.common.jdbc.JDBCURL.parseOnDelimiter(JDBCURL.java:90)
[importConfigExtensionTask] at
com.metamatrix.common.jdbc.JDBCURL.parseForSlash(JDBCURL.java:84)
[importConfigExtensionTask] at
com.metamatrix.common.jdbc.JDBCURL.parseURL(JDBCURL.java:76)
[importConfigExtensionTask] at
com.metamatrix.common.jdbc.JDBCURL.<init>(JDBCURL.java:44)
[importConfigExtensionTask] at
com.metamatrix.common.jdbc.JDBCPlatformFactory.getPlatform(JDBCPlatformFactory.java:175)
[importConfigExtensionTask] ... 54 more
Loading extension module error Error inserting extension module Next Startup using SQL
statement: INSERT INTO
CS_EXT_FILES(FILE_UID,CHKSUM,FILE_NAME,SEARCH_POS,IS_ENABLED,FILE_DESC,CREATED_BY,CREATION_DATE,UPDATED_BY,UPDATE_DATE,FILE_TYPE)
VALUES
Error Installing Teiid with a Postgres Repository
-------------------------------------------------
Key: TEIID-436
URL: https://jira.jboss.org/jira/browse/TEIID-436
Project: Teiid
Issue Type: Bug
Components: JDBC Driver
Affects Versions: 6.0.0
Reporter: Ted Jones
Fix For: 6.1.0
While running setupmm with a local Postgres repository, I encountered the following fatal
error:
/home/tejones/apps/EnterpriseDataServicesPlatform/03202009/server-0.0.1-SNAPSHOT/config/install/setup_server.xml:453:
[MetaMatrixComponentException] ERR.014.004.0054: Error inserting extension module Next
Startup using SQL statement: INSERT INTO
CS_EXT_FILES(FILE_UID,CHKSUM,FILE_NAME,SEARCH_POS,IS_ENABLED,FILE_DESC,CREATED_BY,CREATION_DATE,UPDATED_BY,UPDATE_DATE,FILE_TYPE)
VALUES
1 [DBIDGeneratorException] ERR.003.013.0011: Error creating id for CS_EXT_FILES context.
2 [DBIDGeneratorException] ERR.003.013.0014: Could not obtain a unique ID blocksize of
100 for context CS_EXT_FILES.
3 [ManagedConnectionException] ERR.003.013.0016: Unable to obtain the managed connection
for the DBID transaction
4 [MetaMatrixException] ERR.003.015.0003: JDBCPlatform Program Error, unable to create
platform.
5 [MetaMatrixException] ERR.003.015.0003: JDBCPlatform Program Error, unable to create
platform.
6 [IllegalArgumentException]
--
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
2:02 p.m.
New subject: [JBoss JIRA] Assigned: (TEIID-436) Error Installing Teiid with a Postgres Repository
[
https://jira.jboss.org/jira/browse/TEIID-436?page=com.atlassian.jira.plug...
]
Van Halbert reassigned TEIID-436:
---------------------------------
Assignee: Van Halbert
Error Installing Teiid with a Postgres Repository
-------------------------------------------------
Key: TEIID-436
URL: https://jira.jboss.org/jira/browse/TEIID-436
Project: Teiid
Issue Type: Bug
Components: JDBC Driver
Affects Versions: 6.0.0
Reporter: Ted Jones
Assignee: Van Halbert
Fix For: 6.1.0
While running setupmm with a local Postgres repository, I encountered the following fatal
error:
/home/tejones/apps/EnterpriseDataServicesPlatform/03202009/server-0.0.1-SNAPSHOT/config/install/setup_server.xml:453:
[MetaMatrixComponentException] ERR.014.004.0054: Error inserting extension module Next
Startup using SQL statement: INSERT INTO
CS_EXT_FILES(FILE_UID,CHKSUM,FILE_NAME,SEARCH_POS,IS_ENABLED,FILE_DESC,CREATED_BY,CREATION_DATE,UPDATED_BY,UPDATE_DATE,FILE_TYPE)
VALUES
1 [DBIDGeneratorException] ERR.003.013.0011: Error creating id for CS_EXT_FILES context.
2 [DBIDGeneratorException] ERR.003.013.0014: Could not obtain a unique ID blocksize of
100 for context CS_EXT_FILES.
3 [ManagedConnectionException] ERR.003.013.0016: Unable to obtain the managed connection
for the DBID transaction
4 [MetaMatrixException] ERR.003.015.0003: JDBCPlatform Program Error, unable to create
platform.
5 [MetaMatrixException] ERR.003.015.0003: JDBCPlatform Program Error, unable to create
platform.
6 [IllegalArgumentException]
--
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
2:12 p.m.
New subject: [JBoss JIRA] Work started: (TEIID-436) Error Installing Teiid with a Postgres Repository
[
https://jira.jboss.org/jira/browse/TEIID-436?page=com.atlassian.jira.plug...
]
Work on TEIID-436 started by Van Halbert.
Error Installing Teiid with a Postgres Repository
-------------------------------------------------
Key: TEIID-436
URL: https://jira.jboss.org/jira/browse/TEIID-436
Project: Teiid
Issue Type: Bug
Components: JDBC Driver
Affects Versions: 6.0.0
Reporter: Ted Jones
Assignee: Van Halbert
Fix For: 6.1.0
While running setupmm with a local Postgres repository, I encountered the following fatal
error:
/home/tejones/apps/EnterpriseDataServicesPlatform/03202009/server-0.0.1-SNAPSHOT/config/install/setup_server.xml:453:
[MetaMatrixComponentException] ERR.014.004.0054: Error inserting extension module Next
Startup using SQL statement: INSERT INTO
CS_EXT_FILES(FILE_UID,CHKSUM,FILE_NAME,SEARCH_POS,IS_ENABLED,FILE_DESC,CREATED_BY,CREATION_DATE,UPDATED_BY,UPDATE_DATE,FILE_TYPE)
VALUES
1 [DBIDGeneratorException] ERR.003.013.0011: Error creating id for CS_EXT_FILES context.
2 [DBIDGeneratorException] ERR.003.013.0014: Could not obtain a unique ID blocksize of
100 for context CS_EXT_FILES.
3 [ManagedConnectionException] ERR.003.013.0016: Unable to obtain the managed connection
for the DBID transaction
4 [MetaMatrixException] ERR.003.015.0003: JDBCPlatform Program Error, unable to create
platform.
5 [MetaMatrixException] ERR.003.015.0003: JDBCPlatform Program Error, unable to create
platform.
6 [IllegalArgumentException]
--
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
2:14 p.m.
New subject: [JBoss JIRA] Resolved: (TEIID-436) Error Installing Teiid with a Postgres Repository
[
https://jira.jboss.org/jira/browse/TEIID-436?page=com.atlassian.jira.plug...
]
Van Halbert resolved TEIID-436.
-------------------------------
Resolution: Done
the reason the postgres failed was because there's an old property that was being
picked up from the installation properties file (which isn't needed now), but if the
user didn't change it to correspond to the driver being used, this error would occur
Error Installing Teiid with a Postgres Repository
-------------------------------------------------
Key: TEIID-436
URL: https://jira.jboss.org/jira/browse/TEIID-436
Project: Teiid
Issue Type: Bug
Components: JDBC Driver
Affects Versions: 6.0.0
Reporter: Ted Jones
Assignee: Van Halbert
Fix For: 6.1.0
While running setupmm with a local Postgres repository, I encountered the following fatal
error:
/home/tejones/apps/EnterpriseDataServicesPlatform/03202009/server-0.0.1-SNAPSHOT/config/install/setup_server.xml:453:
[MetaMatrixComponentException] ERR.014.004.0054: Error inserting extension module Next
Startup using SQL statement: INSERT INTO
CS_EXT_FILES(FILE_UID,CHKSUM,FILE_NAME,SEARCH_POS,IS_ENABLED,FILE_DESC,CREATED_BY,CREATION_DATE,UPDATED_BY,UPDATE_DATE,FILE_TYPE)
VALUES
1 [DBIDGeneratorException] ERR.003.013.0011: Error creating id for CS_EXT_FILES context.
2 [DBIDGeneratorException] ERR.003.013.0014: Could not obtain a unique ID blocksize of
100 for context CS_EXT_FILES.
3 [ManagedConnectionException] ERR.003.013.0016: Unable to obtain the managed connection
for the DBID transaction
4 [MetaMatrixException] ERR.003.015.0003: JDBCPlatform Program Error, unable to create
platform.
5 [MetaMatrixException] ERR.003.015.0003: JDBCPlatform Program Error, unable to create
platform.
6 [IllegalArgumentException]
--
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
5511
days inactive
5536
days old
7 comments
4 participants
participants (4)
-
Ramesh Reddy (JIRA) -
Steven Hawkins (JIRA)
-
Ted Jones (JIRA)
-
Van Halbert (JIRA)