Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ]

[ Issue History ] [ Print ]

ID

0006395

Type

Category

Severity

Reproducibility

Date Submitted

Last Update

defect

[Openbravo ERP] A. Platform

critical

always

2008-12-08 10:54

2008-12-31 15:55

Reporter

villind

View Status

public

Assigned To

shuehner

Priority

urgent

Resolution

fixed

Fixed in Version

Status

closed

Fix in branch

pi

Fixed in SCM revision

Projection

none

ETA

none

Target Version

OS

Any

Database

PostgreSQL

Java version

OS Version

Database version

Ant version

Product Version

2.40

SCM revision

11025

Review Assigned To

Web browser

Modules

Core

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

0006395: Inpossible to create a new document on Postgresql

Description

Happens on branches/r2.40

It is not possible to create a new document on postgresql as there are couple of to_number calls missing in
src/org/openbravo/erpCommon/utility/DocumentNo_data.xsql

Steps To Reproduce

Try to create a new document, Sales Order for example and save it.

Proposed Solution

See the attached patch

Tags

No tags attached.

AD_SEQUENCE_DOCTYPE.diff [^] (696 bytes) 2008-12-08 10:54 [Show Content] [Hide Content]

Index: src/org/openbravo/erpCommon/utility/DocumentNo_data.xsql
===================================================================
--- src/org/openbravo/erpCommon/utility/DocumentNo_data.xsql	(revision 11019)
+++ src/org/openbravo/erpCommon/utility/DocumentNo_data.xsql	(working copy)
@@ -63,7 +63,7 @@
    <SqlMethod name="nextDocTypeConnection" type="callableStatement" return="object" object="CSResponse" connection="true">
       <SqlMethodComment></SqlMethodComment>
       <Sql><![CDATA[
-        CALL AD_Sequence_DocType(?,?,?,?)
+        CALL AD_Sequence_DocType(TO_NUMBER(?),TO_NUMBER(?),?,?)
       ]]></Sql>
       <Parameter name="cDocTypeId"/>
       <Parameter name="adClientId"/>

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

backport

closed

Doc sequences and database restrictions

Notes
(0011022) villind (developer) 2008-12-08 10:57	Fixed in https://dev.openbravo.com/websvn/openbravo/?op=revision&rev=11025 [^]

(0011264) shuehner (administrator) 2008-12-12 16:57	Marking as resolved as the fix was already commited in 11164 (with reference to issue 5196)

(0011811) lakshmi (reporter) 2008-12-31 15:55	Verified the issue on Windows/Postgres with version Openbravo 2.50 (r11619). It works and closed this issue

Issue History
Date Modified	Username	Field	Change
2008-12-08 10:54	villind	New Issue
2008-12-08 10:54	villind	Assigned To	=> rafaroda
2008-12-08 10:54	villind	sf_bug_id	0 => 2405985
2008-12-08 10:54	villind	File Added: AD_SEQUENCE_DOCTYPE.diff
2008-12-08 10:54	villind	Regression testing	=> No
2008-12-08 10:57	villind	Note Added: 0011022
2008-12-09 06:57	pjuvara	Assigned To	rafaroda => shuehner
2008-12-09 06:58	pjuvara	Priority	normal => urgent
2008-12-09 06:58	pjuvara	version	=> 2.40
2008-12-10 14:08	shuehner	Status	new => acknowledged
2008-12-12 16:56	shuehner	Relationship added	related to 0005196
2008-12-12 16:56	shuehner	Status	acknowledged => scheduled
2008-12-12 16:56	shuehner	fix_in_branch	=> trunk
2008-12-12 16:57	shuehner	Status	scheduled => resolved
2008-12-12 16:57	shuehner	svn_revision	=> 11164
2008-12-12 16:57	shuehner	Resolution	open => fixed
2008-12-12 16:57	shuehner	Note Added: 0011264
2008-12-31 15:55	lakshmi	Status	resolved => closed
2008-12-31 15:55	lakshmi	Note Added: 0011811

Copyright © 2000 - 2009 MantisBT Group