Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0027498 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| defect | [Modules] Resource and Reservation Management for Contracts | major | always | 2014-08-28 18:01 | 2014-08-28 18:01 | |||||||
| Reporter | rafaroda | View Status | public | |||||||||
| Assigned To | jonalegriaesarte | |||||||||||
| Priority | normal | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Any | Database | Any | Java version | ||||||||
| OS Version | Database version | Ant version | ||||||||||
| Product Version | SCM revision | |||||||||||
| Regression date | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Regression level | ||||||||||||
| Review Assigned To | ||||||||||||
| Regression introduced in release | ||||||||||||
| Summary | 0027498: Error on installation ORA-00936: missing expression | |||||||||||
| Description | Error when installing module on Oracle ORA-00936: missing expression | |||||||||||
| Steps To Reproduce | Install module on Oracle and get error when executing creating VIEW OBREC_RESOURCECONTRACT_V [java] 387050 WARN - SQL Command failed with: ORA-00936: missing expression [java] [java] 387059 WARN - -- END [java] -- ----------------------------------------------------------------------- [java] -- VIEW OBREC_RESOURCECONTRACT_V [java] -- ----------------------------------------------------------------------- [java] CREATE OR REPLACE FORCE VIEW OBREC_RESOURCECONTRACT_V AS SELECT get_uuid() AS obrec_resourcecontract_v_id, project.ad_client_id, project.ad_org_id, project.created, project.createdby, project.updated, project.updatedby, project.isactive, project.c_project_id, resource.obre_resource_id, resource.name, project.startdate, project.datefinish, resource.em_obrec_resrecursive_id FROM obre_resource resource CROSS JOIN c_project project WHERE resource.ad_client_id = project.ad_client_id AND NOT (EXISTS (SELECT 1 FROM obre_reservation reservation WHERE reservation.c_project_id = project.c_project_id AND reservation.obre_resource_id = resource.obre_resource_id)) AND resource.isactive = 'Y' AND project.em_obcntr_contract_status <> 'OBCNTR_DRAFT' | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2014-08-28 18:01 | rafaroda | New Issue | |
| 2014-08-28 18:01 | rafaroda | Assigned To | => jonalegriaesarte |
| 2014-08-28 18:01 | rafaroda | Relationship added | blocks 0027493 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |