Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0000877Openbravo ERP01. General setuppublic2007-01-28 00:242022-11-21 17:50
Reporteruser71 
Assigned Toalostale 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionunable to reproduce 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0000877: Delete client and copy client don't work
DescriptionDelete clients and copy clients does not work on OB 2.21 PostgreSQL 8.1.4.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2022-11-21 17:45hgbotNote Added: 0143925
2022-11-21 17:50hgbotNote Added: 0143926
2022-11-22 09:43plujanNote Deleted: 0143926
2022-11-22 09:43plujanNote Deleted: 0143925

Notes
(0004466)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1646187 [^]
(0000682)
user71   
2007-01-29 12:36   
(edited on: 2008-06-12 09:17)
Logged In: YES
user_id=1656537
Originator: YES

File Added: Openbravo 29.01.2007.xls
(0000683)
user71   
2007-01-29 21:56   
(edited on: 2008-06-12 09:17)
Logged In: YES
user_id=1656537
Originator: YES

File Added: AccountsROOpenbravo.csv
(0000684)
cromero   
2007-01-30 11:35   
(edited on: 2008-06-12 09:17)
Logged In: YES
user_id=1500614
Originator: NO

For the import account problem, you are having problems because you account names are bigger than 40 characters that is the maximun specified for that column on DB.
You will hate to make them shorter to make it works.
Carlos Romero
Openbravo Team
(0000685)
cromero   
2007-04-13 12:57   
(edited on: 2008-06-12 09:17)
Logged In: YES
user_id=1500614
Originator: NO

Could you be more specific with your error?

We know a problem Deleting a Copying clients on Postgre: Postgre doesn't allow disable constraints, they must be dropped and recreated after the process. This provokes recalculate current OIDs, so after Delete or Copy a client all OIDs are modified (and the application begins to fail).

Restart Database actualizes all references and all start to work again. So we can advice you, at this moment until we found a better solution, to restart the database in Postgre after Deleting or Copy a client.

Many thanks for your feedback

Carlos Romero
Openbravo Team
   
(0000686)
user71   
2007-04-14 21:20   
(edited on: 2008-06-12 09:17)
Logged In: YES
user_id=1656537
Originator: YES

I have installed OB 2.22 with Bitrock Installer for Postgre and I have no problems in deleting Clients.
But, when I login with the same System Administrator Role, in General Rules/Client Rules/Copy Client,I can select only the System Client to copy from. I have created before a Testing Client which is visible only for deleting.
(0000687)
user71   
2007-04-17 22:07   
(edited on: 2008-06-12 09:17)
Logged In: YES
user_id=1656537
Originator: YES

File Added: AccountsROOpenbravo60.csv
(0000688)
user71   
2007-04-17 22:14   
(edited on: 2008-06-12 09:17)
Logged In: YES
user_id=1656537
Originator: YES

File Added: AccountsRO60Openbravo Imp.rar
(0000689)
user71   
2007-04-17 22:16   
(edited on: 2008-06-12 09:17)
Logged In: YES
user_id=1656537
Originator: YES

File Added: AccountsRO60Openbravo Imp.rar
(0000690)
user71   
2007-04-17 22:17   
(edited on: 2008-06-12 09:17)
Logged In: YES
user_id=1656537
Originator: YES

File Added: AccountsRO60Openbravo ICS ok.rar
(0000691)
user71   
2007-04-17 22:19   
(edited on: 2008-06-12 09:17)
Logged In: YES
user_id=1656537
Originator: YES

File Added: AccountsRO60Openbravo Account Element.rar
(0000692)
user71   
2007-04-17 22:20   
(edited on: 2008-06-12 09:17)
Logged In: YES
user_id=1656537
Originator: YES

File Added: AccountsRO60Openbravo Account Combination.rar
(0000693)
user71   
2007-04-17 22:41   
(edited on: 2008-06-12 09:17)
Logged In: YES
user_id=1656537
Originator: YES

File Added: AccountsRO60Openbravo Period.rar
(0000694)
user71   
2007-04-17 22:57   
(edited on: 2008-06-12 09:17)
Logged In: YES
user_id=1656537
Originator: YES

File Added: Openbravo 17.04.2007.xls
(0000695)
user71   
2007-05-01 21:00   
(edited on: 2008-06-12 09:17)
Logged In: YES
user_id=1656537
Originator: YES

File Added: AccountsROOpenbravo_v1.1.csv
(0000696)
plujan   
2007-05-09 20:53   
(edited on: 2008-06-12 09:17)
Logged In: YES
user_id=1759992
Originator: NO

Please double check if this bug is fixed on 2.22 sp1
(0000697)
alostale   
2007-05-10 08:52   
(edited on: 2008-06-12 09:17)
Logged In: YES
user_id=1500722
Originator: NO

Copy and delete client work on r2.30.

About the role to log with in order to execute the copy client process it should be Openbravo Admin, not System Administrator.