[JBoss JIRA] (TEIID-3914) Datetime values not properly encoded in OData4 entity identifiers
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3914?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3914.
---------------------------------
> Datetime values not properly encoded in OData4 entity identifiers
> -----------------------------------------------------------------
>
> Key: TEIID-3914
> URL: https://issues.jboss.org/browse/TEIID-3914
> Project: Teiid
> Issue Type: Bug
> Components: OData
> Affects Versions: 8.12.4
> Reporter: Simon Evenepoel
> Assignee: Ramesh Reddy
> Labels: odata,
> Fix For: 8.13, 9.0, 8.12.5
>
> Attachments: TEIID-3914.diff
>
>
> When the primary key of an OData entry consists of a timestamp or datetime value an odata get request returns the following error message:
> java.net.URISyntaxException: Illegal character in scheme name at index n: tablename(partofkey='keyvalue',datepartofkey=2016-01-13 11:25:03.884)
> For more information visit this thread on the user forums in which [~shawkins] said:
> _"Actually there is an issue with our handling of building the entity id to go into the response. We are not properly encoding datatime values.''_
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 10 months
[JBoss JIRA] (TEIID-3896) When error occurs in the materialization process, an ERROR should be logged instead of DEBUG
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3896?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3896.
---------------------------------
> When error occurs in the materialization process, an ERROR should be logged instead of DEBUG
> --------------------------------------------------------------------------------------------
>
> Key: TEIID-3896
> URL: https://issues.jboss.org/browse/TEIID-3896
> Project: Teiid
> Issue Type: Quality Risk
> Components: Query Engine
> Affects Versions: 8.12.2
> Reporter: Van Halbert
> Assignee: Steven Hawkins
> Priority: Minor
> Fix For: 8.13, 8.12.4
>
>
> When trying to do materialization, there's an issue (DEBUG) appearing in the server.log:
> 09:58:51,272 DEBUG [org.teiid.PROCESSOR] (Worker5_QueryProcessorQueue302) org.teiid.jdbc.TeiidSQLException: TEIID30168 Couldn't execute the dynamic SQL command "EXECUTE IMMEDIATE ('SELECT count(*) as rowCount FROM ' || matViewTable) AS rowCount integer INTO #load_count" with the SQL statement "('SELECT count(*) as rowCount FROM ' || matViewTable)" due to: Group specified is ambiguous, resubmit the query by fully qualifying the group name: Stock
> I believe this be logged as an ERROR as it appears to be detrimental to what's being materialized.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 10 months
[JBoss JIRA] (TEIID-4155) Explore the possibility to use JBeret as materialization schedular
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-4155?page=com.atlassian.jira.plugin... ]
Ramesh Reddy updated TEIID-4155:
--------------------------------
Parent: TEIID-4249
Issue Type: Sub-task (was: Enhancement)
> Explore the possibility to use JBeret as materialization schedular
> ------------------------------------------------------------------
>
> Key: TEIID-4155
> URL: https://issues.jboss.org/browse/TEIID-4155
> Project: Teiid
> Issue Type: Sub-task
> Components: Server
> Reporter: Ramesh Reddy
>
> Right now the managed external materialization uses the our own very basic job scheduler, it would be nice if we can use JBeret batch processing system to automatically create jobs based on the materialization extension properties.
> JBeret is JSR-352, looks simple enough to integrate. The advantages for us would be
> - a standard scheduler, which will also work in "embedded" as this supposed to work in Java SE
> - Gives CLI based management
> - may be better metrics on time taken and error management
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 10 months
[JBoss JIRA] (TEIID-4251) Built in support for Postgres DB as materialization target
by Ramesh Reddy (JIRA)
Ramesh Reddy created TEIID-4251:
-----------------------------------
Summary: Built in support for Postgres DB as materialization target
Key: TEIID-4251
URL: https://issues.jboss.org/browse/TEIID-4251
Project: Teiid
Issue Type: Sub-task
Components: Server
Reporter: Ramesh Reddy
If Postgres database is available along with install or assumed that it is available, then some of the materialization task can be automated, like
- Creation of a common STATUS table
- Creation of the materilization targets (create views on dbms)
- On load, on undeploy and load scripts for all the materialization views
We need to device a way this to be pluggable, such that based on success of this, we can provide additional support for other sources.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 10 months