0027498: Error on installation ORA-00936: missing expression

Openbravo Issue Tracking System - Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0027498

Modules

Resource and Reservation Management for Contracts

public

2014-08-28 18:01

Reporter

rafaroda

Assigned To

jonalegriaesarte

Priority

normal

Severity

major

Reproducibility

always

Status

new

Resolution

open

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Regression date

Regression introduced by commit

Regression level

Review Assigned To

Support ticket

OBNetwork customer

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'

Proposed Solution

Additional Information