Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006460Openbravo ERP01. General setuppublic2008-12-10 14:022009-01-27 17:30
Reporterroklenardic 
Assigned Toalostale 
PriorityimmediateSeveritycriticalReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 8.04
Product Version2.40beta 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0006460: Copy Client process fails
Description1) Log in with Openbravo/openbravo username
2) select BigBazaar Admin role
3) click on the General Setup || Client || Copy Client
4) select Bigbazaar within the listbox
5) enter the name of the new client, e.g. Company00

Run the process by clicking OK. After quite a while (10-15min), I receive a yellow warning message box:
Warning
This process left 110 disabled constraints

Also, there is no new client Company00.

Running the
select count(*) from user_constraints where status='DISABLED';

returns:
COUNT(*)
----------------------
110

1 rows selected

So there are actually that many constraints left disable which is critical to the stability of the system.
Steps To Reproduce
Proposed Solution
Additional Information
Tagsplatform1_sprint1
Relationships
blocks defect 0004701 closed alostale Copy Client process fails 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-12-10 14:02rafarodaNew Issue
2008-12-10 14:02rafarodaAssigned To => alostale
2008-12-10 14:02rafarodaStatusnew => scheduled
2008-12-10 14:03rafarodaOBNetwork customer => No
2008-12-10 14:03rafarodasvn_revision6695 =>
2008-12-10 14:06networkbIssue Monitored: networkb
2008-12-10 14:06networkbOBNetwork customerNo => Yes
2008-12-10 14:06networkbPriorityurgent => immediate
2008-12-11 10:29networkbSeveritymajor => critical
2008-12-11 13:02alostaleNote Added: 0011174
2008-12-11 13:03svnbotCheckin
2008-12-11 13:03svnbotNote Added: 0011175
2008-12-11 13:03svnbotStatusscheduled => resolved
2008-12-11 13:03svnbotResolutionopen => fixed
2008-12-11 13:03svnbotsvn_revision => 11099
2008-12-12 12:12alostaleTag Attached: platform1_sprint1
2009-01-27 17:30psarobeRegression testing => No
2009-01-27 17:30psarobeStatusresolved => closed

Notes
(0011174)
alostale   
2008-12-11 13:02   
I do not get that error, but this other one instead. Anyway, although the error the process worked properly: the client was copied and no constraints were disabled.

      
Error:
Error in SQL, line: 3669. Executing: DROP INDEX C_TEMP_SELECTION_KEY
ORA-01418: specified index does not exist

Error in SQL, line: 3670. Executing: DROP INDEX C_TEMP_SELECTION2_KEY
ORA-01418: specified index does not exist

Error in SQL, line: 3827. Executing: DROP INDEX M_PRODUCT_CUSTOMER_KEY
ORA-01418: specified index does not exist

Error in SQL, line: 3828. Executing: DROP INDEX M_PRODUCT_CUSTOMER_UNIQUE
ORA-01418: specified index does not exist

Error in SQL, line: 3829. Executing: DROP INDEX M_PRODUCT_EXPENSETYPE
ORA-01418: specified index does not exist

Error in SQL, line: 3833. Executing: DROP INDEX M_PRODUCT_KEY
ORA-01418: specified index does not exist

Error in SQL, line: 3838. Executing: DROP INDEX M_PRODUCT_RESOURCE
ORA-01418: specified index does not exist

Error in SQL, line: 3843. Executing: DROP INDEX M_PRODUCT_VALUE
ORA-01418: specified index does not exist

Error in SQL, line: 4626. Executing: update RV_Cash_Detail set posted='N' where ad_client_id=1000002
ORA-01779: cannot modify a column which maps to a non key-preserved table

Error in SQL, line: 103353. Executing: CREATE INDEX AD_CLIENT_NAME ON AD_CLIENT(NAME) TABLESPACE USERS
ORA-00955: name is already used by an existing object

Error in SQL, line: 103357. Executing: CREATE INDEX AD_COLUMN_NAME ON AD_COLUMN(AD_TABLE_ID,COLUMNNAME) TABLESPACE USERS
ORA-00955: name is already used by an existing object

Error in SQL, line: 103378. Executing: CREATE INDEX AD_IMPFORMAT_NAME ON AD_IMPFORMAT(AD_CLIENT_ID,NAME) TABLESPACE USERS
ORA-00955: name is already used by an existing object

Error in SQL, line: 103391. Executing: CREATE INDEX AD_ORG_VALUE ON AD_ORG(AD_CLIENT_ID,VALUE) TABLESPACE USERS
ORA-00955: name is already used by an existing object

Error in SQL, line: 103394. Executing: CREATE INDEX AD_PREFERENCE_ATTRIBUTE ON AD_PREFERENCE(AD_CLIENT_ID,AD_ORG_ID,AD_WINDOW_ID,AD_USER_ID,ATTRIBUTE) TABLESPACE USERS
ORA-00...
(0011175)
svnbot   
2008-12-11 13:03   
Repository: openbravo
Revision: 11099
Author: alostale
Date: 2008-12-11 13:03:22 +0100 (Thu, 11 Dec 2008)

fixed bug 0006460: Copy Client process fails

---
U branches/r2.3x/database/model/functions/AD_COPY_CLIENT.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=11099&sc=1 [^]