0027497: Error on installation ORA-00911: invalid character

Openbravo Issue Tracking System - Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0027497

Modules

Resource and Reservation Management for Contracts

public

2014-08-28 17:58

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

0027497: Error on installation ORA-00911: invalid character

Description

When installing module, Oracle error ORA-00911: invalid character

Steps To Reproduce

Install module on Oracle and when executing module script get [java] 229361 INFO - Executing moduleScript: org.openbravo.module.resources.contract.modulescript.UpdateRecursiveReservationsColumns
     [java] 229387 ERROR - SQL error in query: INSERT INTO obrec_resrecursive( obrec_resrecursive_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, type, dayofweek, dayofmonth, name) select * from obre_resrecursive;Exception:java.sql.SQLSyntaxErrorException: ORA-00911: invalid character
     [java]
     [java] 229398 ERROR - Error executing moduleScript org.openbravo.module.resources.contract.modulescript.UpdateRecursiveReservationsColumns: @CODE=911@ORA-00911: invalid character
     [java]
     [java] 229458 ERROR - Error executing moduleScript: org.openbravo.module.resources.contract.modulescript.UpdateRecursiveReservationsColumns

Proposed Solution

Additional Information