[
https://issues.jboss.org/browse/TEIID-1878?page=com.atlassian.jira.plugin...
]
Andriy Rokhmanov commented on TEIID-1878:
-----------------------------------------
CompositeMetadataStore.getSchema("CHORUS_METADATA")
for round with CHORUS_METADATA.PROPERTY:
getSchemas() returns this:
{
CHORUS_PLATFORM_METADATA_FILE=Schema name=chorus_platform_metadata_file,
nameInSource=null, uuid=mmuuid:5b93cd57-a63b-47e9-907d-897ff4cfdbc4,
CHORUS_PLATFORM_CHORUS_METADATA=Schema name=chorus_platform_chorus_metadata,
nameInSource=null, uuid=mmuuid:5094c5cc-a75d-4ba8-ba14-19162985511c,
RESULTSETSTORE=Schema name=resultsetstore, nameInSource=null,
uuid=mmuuid:d6a07ecf-65c5-439e-9096-a88881a77d60,
TIMESERIES=Schema name=timeseries, nameInSource=null,
uuid=mmuuid:8a0b231f-f6d9-4d13-a318-9248deee4a4f,
CHORUSDATA=Schema name=chorusdata, nameInSource=null,
uuid=mmuuid:824b3811-3f8e-4d2d-876c-c98747e918cb,
CHORUS_UISERVICES=Schema name=chorus_uiservices, nameInSource=null,
uuid=mmuuid:ed1bd4ac-b74a-48a0-be29-701cf5fe1620,
H2UTIL=Schema name=h2util, nameInSource=null,
uuid=mmuuid:5691ee51-13ac-4812-8485-f869829fcc5e,
DEMODATA=Schema name=demodata, nameInSource=null,
uuid=mmuuid:a048f249-49e0-4162-89c2-f37fa8e9e91f,
DEMODATA_METADATA_FILE=Schema name=demodata_metadata_file, nameInSource=null,
uuid=mmuuid:80d9586f-7630-4e2d-9f8a-b33bd9dc4ac3,
DEMODATA_FILE=Schema name=demodata_file, nameInSource=null,
uuid=mmuuid:5f62ade1-373e-412d-bb42-929c69f43e5c,
DEMO=Schema name=demo, nameInSource=null,
uuid=mmuuid:0170fbd2-418c-482c-afec-af64b24a92d3,
LOG4J=Schema name=log4j, nameInSource=null,
uuid=mmuuid:2c27ac7f-5065-4875-bc97-98a166783505,
LOG=Schema name=log, nameInSource=null, uuid=mmuuid:3318f5f9-05cc-4630-a258-e71d833e7e80,
DEMODATA_STORED_PROCEDURE=Schema name=demodata_stored_procedure, nameInSource=null,
uuid=mmuuid:52e635ed-c0e4-466d-8cd1-fd50027b36a9,
DEMO_ALERTS=Schema name=DEMO_ALERTS, nameInSource=null,
uuid=mmuuid:f68767ba-181f-4c03-a46e-4e13f62da8de,
CHORUS_LICENSE=Schema name=chorus_license, nameInSource=null,
uuid=mmuuid:34026b9b-fc49-412f-a459-a5b2a132ad97,
DEMOALERTDATA=Schema name=demoalertdata, nameInSource=null,
uuid=mmuuid:79ae86a7-21d2-45be-9fa8-a5d55d30f8f7,
CHORUS_PLATFORM_SECURITY_FILE=Schema name=chorus_platform_security_file,
nameInSource=null, uuid=mmuuid:e939c8f4-4fb8-4fec-9951-dca2f7b83a5c,
CHORUS_SECURITY=Schema name=chorus_security, nameInSource=null,
uuid=mmuuid:3d62e7ec-7ba8-499a-a315-03cc0067895b,
CHORUS_NOTES=Schema name=chorus_notes, nameInSource=null,
uuid=mmuuid:8159ea5b-a314-4fb3-82a0-9ca4218545f6,
CHORUS_METADATA=Schema name=chorus_metadata, nameInSource=null,
uuid=mmuuid:3748079a-7497-4cba-808c-824b40ec4788,
CHORUS_METRIC_VIEW=Schema name=chorus_metric_view, nameInSource=null,
uuid=mmuuid:b7c3c0d0-9b05-43c7-a04f-037cacd8921e,
DEMODATA_CHORUS_METADATA=Schema name=demodata_chorus_metadata, nameInSource=null,
uuid=mmuuid:e45cf796-e6ed-48be-916c-709c68b523b0,
CHORUS_METRIC_NAME=Schema name=chorus_metric_name, nameInSource=null,
uuid=mmuuid:efcc7589-2c4c-4a89-9b16-c3cb0f788c16,
CHORUS_ALERT_VIEW=Schema name=chorus_alert_view, nameInSource=null,
uuid=mmuuid:f6feb3c0-ebb3-4912-b380-7cc198618626,
CHORUS_METRIC_DATA=Schema name=chorus_metric_data, nameInSource=null,
uuid=mmuuid:75aa85f3-719a-49d4-a492-15e5f96b24c0,
CHORUS_TSF=Schema name=chorus_tsf, nameInSource=null,
uuid=mmuuid:f8392899-13e7-4df1-88f5-c438f5bc3563,
SYSADMIN=Schema name=SYSADMIN, nameInSource=null,
uuid=mmuuid:82f6153e-31e0-4034-b335-013cb418da34,
SYS=Schema name=SYS, nameInSource=null, uuid=mmuuid:49b9c0f9-2c4c-42d3-9409-2d847d29a1de,
PG_CATALOG=Schema name=pg_catalog, nameInSource=null,
uuid=mmuid:5a84789f-c794-4748-803a-09b6b605f6b9
}
For round with CHORUS_METADATA.PROPERTY_CHORUS_NON_MAT_VIEW:
getSchemas() returns this:
{
CHORUS_PLATFORM_METADATA_FILE=Schema name=chorus_platform_metadata_file,
nameInSource=null, uuid=mmuuid:5b93cd57-a63b-47e9-907d-897ff4cfdbc4,
SYSADMIN=Schema name=SYSADMIN, nameInSource=null,
uuid=mmuuid:82f6153e-31e0-4034-b335-013cb418da34,
SYS=Schema name=SYS, nameInSource=null, uuid=mmuuid:49b9c0f9-2c4c-42d3-9409-2d847d29a1de,
PG_CATALOG=Schema name=pg_catalog, nameInSource=null,
uuid=mmuid:5a84789f-c794-4748-803a-09b6b605f6b9
}
So in the second round result = null, and exception.
Problem with accessing custom generated materialized views
----------------------------------------------------------
Key: TEIID-1878
URL:
https://issues.jboss.org/browse/TEIID-1878
Project: Teiid
Issue Type: Bug
Affects Versions: 7.6
Environment: java version "1.6.0_22"
Java(TM) SE Runtime Environment (build 1.6.0_22-b04)
Java HotSpot(TM) 64-Bit Server VM (build 17.1-b03, mixed mode)
JBoss 5.1.0
Windows 7, 8GB RAM
Reporter: Andriy Rokhmanov
Assignee: Steven Hawkins
Attachments: server_bootstrap.log, server_select.log
We have a problem with custom-generated materialized view. The way we do it works fine
with Teiid 7.3 but fails when we try to migrate to 7.6.
Here is the SQL which gives the problem:
select * from chorus_metadata.property;
Remote org.teiid.api.exception.query.QueryPlannerException: Group does not exist:
chorus_metadata.property_CHORUS_NON_MAT_VIEW
Some additional info:
1. System tables:
select * from SYS.tables where Name like 'property%' and SchemaName =
'chorus_metadata';
VDBName SchemaName Name Type NameInSource IsPhysical
SupportsUpdates UID Cardinality Description
IsSystem IsMaterialized OID
------- --------------- ---------------------------- ---- ------------ ----------
--------------- ------------------------------------------- ----------- -----------
-------- -------------- ---
Chorus chorus_metadata property_union View NULL true false
mmuuid:319d6147-6145-4f56-bc2e-42326b19368c 0 NULL false
false 393
Chorus chorus_metadata property_CHORUS_NON_MAT_VIEW View NULL true false
mmuuid:bb25b63d-bded-4704-8638-e507197af6f1 0 NULL false
false 398
Chorus chorus_metadata property View NULL false false
mmuuid:9070f66d-df9c-4f37-bd4f-00020ceef492 0 NULL false true
399
select * from SYSADMIN.matviews;
VDBName SchemaName Name TargetSchemaName TargetName
Valid LoadState Updated Cardinality
------- --------------- -------------- ---------------- ------------------------------
----- ------------- ------- -----------
Chorus chorus_metadata property NULL #MAT_CHORUS_METADATA.PROPERTY
false NEEDS_LOADING NULL 0
Chorus pg_catalog pg_class NULL #MAT_PG_CATALOG.PG_CLASS
false NEEDS_LOADING NULL NULL
Chorus pg_catalog pg_attribute NULL #MAT_PG_CATALOG.PG_ATTRIBUTE
false NEEDS_LOADING NULL NULL
Chorus pg_catalog pg_index NULL #MAT_PG_CATALOG.PG_INDEX
false NEEDS_LOADING NULL NULL
Chorus pg_catalog pg_proc NULL #MAT_PG_CATALOG.PG_PROC
false NEEDS_LOADING NULL NULL
Chorus pg_catalog matpg_relatt NULL #MAT_PG_CATALOG.MATPG_RELATT
false NEEDS_LOADING NULL NULL
Chorus pg_catalog matpg_datatype NULL #MAT_PG_CATALOG.MATPG_DATATYPE
false NEEDS_LOADING NULL NULL
Note: looks like the chorus_metadata.propoerty needs loading, but attempt to load it
fails with the same error:
CALL SYSADMIN.refreshMatView(viewname=>'chorus_metadata.property',
invalidate=>'true');
Remote org.teiid.api.exception.query.QueryResolverException: Group does not exist:
chorus_metadata.property_CHORUS_NON_MAT_VIEW
2. The view chorus_metadata.property_CHORUS_NON_MAT_VIEW is actually exist and
available:
select * from chorus_metadata.property_CHORUS_NON_MAT_VIEW;
propertyName objectName subType propertyValue
objectInstance
----------------- ------------------------------- ----------- -----------------------
-----------------------
Sequence chorusdata.note Column 1
CREATED_ON
Sequence demodata.someSeq Column 1
...
3. How the chorus_metadata.property gets defined (sample code):
org.teiid.metadata.Table table =
org.teiid.metadata.MetadataFactory.addTable("property");
table.setMaterialized(true);
table.setVirtual(true);
table.setSelectTransformation(
"/*+ cache */ SELECT propertyName, objectName, subType, propertyValue,
objectInstance FROM chorus_metadata.property_CHORUS_NON_MAT_VIEW");
table.setTableType(Type.View);
Note: we tried today a patch for TEIID-1868, it did not help.
Let us know please if we can help with any additional information.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see:
http://www.atlassian.com/software/jira