Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006395Openbravo ERPA. Platformpublic2008-12-08 10:542008-12-31 15:55
Reportervillind 
Assigned Toshuehner 
PriorityurgentSeveritycriticalReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0006395: Inpossible to create a new document on Postgresql
DescriptionHappens 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 ReproduceTry to create a new document, Sales Order for example and save it.
Proposed SolutionSee the attached patch
Additional Information
TagsNo tags attached.
Relationships
related to backport 0005196 closed alostale Doc sequences and database restrictions 
Attached Filesdiff AD_SEQUENCE_DOCTYPE.diff (696) 2008-12-08 10:54
https://issues.openbravo.com/file_download.php?file_id=499&type=bug
Issue History
Date ModifiedUsernameFieldChange
2008-12-08 10:54villindNew Issue
2008-12-08 10:54villindAssigned To => rafaroda
2008-12-08 10:54villindsf_bug_id0 => 2405985
2008-12-08 10:54villindFile Added: AD_SEQUENCE_DOCTYPE.diff
2008-12-08 10:54villindOBNetwork customer => No
2008-12-08 10:54villindRegression testing => No
2008-12-08 10:57villindNote Added: 0011022
2008-12-09 06:57pjuvaraAssigned Torafaroda => shuehner
2008-12-09 06:58pjuvaraPrioritynormal => urgent
2008-12-09 06:58pjuvaraversion => 2.40
2008-12-10 14:08shuehnerStatusnew => acknowledged
2008-12-12 16:56shuehnerRelationship addedrelated to 0005196
2008-12-12 16:56shuehnerStatusacknowledged => scheduled
2008-12-12 16:56shuehnerfix_in_branch => trunk
2008-12-12 16:57shuehnerStatusscheduled => resolved
2008-12-12 16:57shuehnersvn_revision => 11164
2008-12-12 16:57shuehnerResolutionopen => fixed
2008-12-12 16:57shuehnerNote Added: 0011264
2008-12-31 15:55lakshmiStatusresolved => closed
2008-12-31 15:55lakshmiNote Added: 0011811

Notes
(0011022)
villind   
2008-12-08 10:57   
Fixed in https://dev.openbravo.com/websvn/openbravo/?op=revision&rev=11025 [^]
(0011264)
shuehner   
2008-12-12 16:57   
Marking as resolved as the fix was already commited in 11164 (with reference to issue 5196)
(0011811)
lakshmi   
2008-12-31 15:55   
Verified the issue on Windows/Postgres with version Openbravo 2.50 (r11619). It works and closed this issue