Bug 118900
| Summary: | Test-QGEN: Error previewing template | ||
|---|---|---|---|
| Product: | [Retired] Red Hat Enterprise CMS | Reporter: | Jon Orris <jorris> |
| Component: | other | Assignee: | Rafael H. Schloming <rafaels> |
| Status: | CLOSED RAWHIDE | QA Contact: | Jon Orris <jorris> |
| Severity: | medium | Docs Contact: | |
| Priority: | medium | ||
| Version: | nightly | CC: | tross |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | All | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2004-03-23 20:21:12 UTC | Type: | --- |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
| Bug Depends On: | |||
| Bug Blocks: | 113496 | ||
|
Description
Jon Orris
2004-03-22 16:57:40 UTC
SQL output below.
One correction: This did not occur previewing the item against the
template, just clicking the 'Templates' tab for the Content Item.
2004-03-22 11:59:23,273 [002-0] INFO rdbms.RDBMSEngine -
[com.arsdigita.cms.Template]
2004-03-22 11:59:23,273 [002-0] INFO rdbms.RDBMSEngine - [VARCHAR]
2004-03-22 11:59:23,274 [002-0] INFO rdbms.RDBMSEngine - {}
2004-03-22 11:59:23,312 [002-0] INFO rdbms.RDBMSEngine - Executing
query(sort(this = sql
{com.arsdigita.cms.templatesInUseContextsWithType}, sql
{this.useContext}), this_mapping_id0 = this.mapping.id,
this_mapping_objectType1 = this.mapping.objectType, this_useContext2 =
this.useContext, this_mimeType_mimeType3 = this.mimeType.mimeType,
this_mimeType_objectType4 = this.mimeType.objectType,
this_mimeType_javaClass5 = this.mimeType.javaClass,
this_mapping_template_label6 = this.mapping.template.label,
this_mapping_template_id7 = this.mapping.template.id,
this_mapping_template_object8 = this.mapping.template.objectType,
this_mapping_template_name9 = this.mapping.template.name,
this_mimeType_label10 = this.mimeType.label, this_mapping_item_id11 =
this.mapping.item.id, this_mapping_item_objectType12 =
this.mapping.item.objectType, this_mimeType_fileExtension13 =
this.mimeType.fileExtension)
2004-03-22 11:59:23,321 [002-0] INFO rdbms.RDBMSEngine - select
t3.mapping_id as "this_mapping_id0",
t18.object_type as "this_mapping_objectType1",
t3.use_context as "this_useContext2",
t3.mime_type as "this_mimeType_mimeType3",
t3.object_type as "this_mimeType_objectType4",
t3.java_class as "this_mimeType_javaClass5",
t3.label as "this_mapping_template_label6",
t3.template_id as "this_mapping_template_id7",
t44.object_type as "this_mapping_template_object8",
t3.name as "this_mapping_template_name9",
t3.mime_label as "this_mimeType_label10",
t3.item_id as "this_mapping_item_id11",
t62.object_type as "this_mapping_item_objectType12",
t3.file_extension as "this_mimeType_fileExtension13"
from (
select
c.use_context,
c.mime_type, c.mime_label,
c.file_extension, c.java_class, c.object_type,
c.label, c.description,
x.mapping_id, x.template_id, x.name, x.label as contextLabel,
x.item_id
from
(select mime_type, cms_mime_types.label as mime_label,
file_extension, java_class, object_type,
use_context, c.label, description
from cms_template_use_contexts c, cms_mime_types
where cms_mime_types.mime_type in (?,?)) c,
(select
m.mapping_id, m.template_id, m.use_context,
ti.name, ti.item_id, tt.label, mime_types.mime_type
from
cms_item_template_map m, cms_items ti, cms_templates tt,
cms_assets,
cms_mime_types mime_types
where m.item_id = ?
and ti.item_id = m.template_id
and tt.template_id = m.template_id
and cms_assets.asset_id = tt.template_id
and mime_types.mime_type = cms_assets.mime_type
) x
where c.use_context = x.use_context(+)
and c.mime_type = x.mime_type(+)) t3
left join acs_objects t18 on t3.mapping_id = t18.object_id
left join acs_objects t44 on t3.template_id = t44.object_id
left join acs_objects t62 on t3.item_id = t62.object_id
order by t3.use_context
2004-03-22 11:59:23,324 [002-0] INFO rdbms.RDBMSEngine - [text/xml,
text/x-jsp, 471]
2004-03-22 11:59:23,324 [002-0] INFO rdbms.RDBMSEngine - [VARCHAR,
VARCHAR, NUMERIC]
2004-03-22 11:59:23,324 [002-0] INFO rdbms.RDBMSEngine - {}
2004-03-22 11:59:23,473 [002-0] FATAL logging.ErrorReport -
Works on the trunk. Tested with Archit's suggested fix on Oracle. Need to verify postgres & check with Randy. [jorris@goodeats test-qgen]$ p4 diff //cms/dev/pdl/com/arsdigita/content-section/query-templatesInUseContextsWithType.ora.pdl ==== //cms/dev/pdl/com/arsdigita/content-section/query-templatesInUseContextsWithType.ora.pdl#1 - /var/ccm-devel/dev/jorris/test-qgen/cms/pdl/com/arsdigita/content-section/query-templatesInUseContextsWithType.ora.pdl ==== 29,30c29,30 < c.label, c.description, < x.mapping_id, x.template_id, x.name, x.label as contextLabel, --- > c.description, > x.mapping_id, x.template_id, x.name, x.label, 35c35 < use_context, c.label, description --- > use_context, description This fix should not cause any negative side effects as it is the fix that I used on my machine while testing...I am not sure how I managed to revert the file to the pre-fix state before checking it in. So, we should be ok with the given fix. That being said, I think that persistence should give a better error message or just work on this query. The subquery that is being changed has a column named "c.label" and a column of "cms_mime_types.label as mime_label" and it appears that persistence is ignoring the "as mime_label" during the processing or something like that. But, regardless of the cause, I think that Persistence should either give a nicer error or be able to handle the situation. Fixed @41645 |