0027496: Error on installation ORA-00936: missing expression

Openbravo Issue Tracking System - Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0027496

Modules

Apartment Rental Contract Management

public

2014-08-28 17:56

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

0027496: Error on installation ORA-00936: missing expression

Description

Error on module installation on Oracle ORA-00936: missing expression

Steps To Reproduce

When installing module, ORA-00936: missing expression on VIEW OBARCNT_RESERVATION_V

[java] 386606 WARN - SQL Command failed with: ORA-00936: missing expression
     [java]
     [java] 386639 WARN - -- END
     [java] -- -----------------------------------------------------------------------
     [java] -- VIEW OBARCNT_RESERVATION_V
     [java] -- -----------------------------------------------------------------------
     [java] CREATE OR REPLACE FORCE VIEW OBARCNT_RESERVATION_V AS SELECT get_uuid() AS obarcnt_reservation_v_id, resource.ad_client_id, resource.ad_org_id, resource.created, resource.createdby, resource.updated, resource.updatedby, resource.isactive, enquiry.obarcnt_enquiry_id, enquiry.startdate, enquiry.enddate, resource.obre_resource_id, resource.value, resource.name, resource.resource_type, resource.obre_resource_category_id, resource.obre_resource_group_id, resource.c_location_id, resource.m_product_category_id, resource.hascapacity, resource.capacity_default, resource.capacity_max, resource.m_product_id, obarcnt_isreserved(resource.obre_resource_id, enquiry.startdate, enquiry.enddate) AS isbooked, obarcnt_isenquiry(resource.obre_resource_id, enquiry.startdate, enquiry.enddate) AS isenquiry, resource.em_obarcnt_owner_id, resource.em_obarcnt_subway, resource.em_obarcnt_bedroom, resource.em_obarcnt_livingroom, resource.em_obarcnt_wc, resource.em_obarcnt_bathroom, resource.em_obarcnt_garbage_location, resource.em_obarcnt_area FROM obre_resource resource CROSS JOIN obarcnt_enquiry enquiry WHERE resource.ad_client_id = enquiry.ad_client_id AND NOT (EXISTS (SELECT 1 FROM obarcnt_enquiryline eline WHERE eline.obarcnt_enquiry_id = enquiry.obarcnt_enquiry_id AND eline.obre_resource_id = resource.obre_resource_id)) AND resource.isactive = 'Y' AND (enquiry.docstatus NOT IN ('BOOKED', 'REFUSED'))

Proposed Solution

Additional Information