Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Administration & Installation

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
14%
200 - 500 GB
32%
500 - 800 GB
4%
800 - 1200 GB
4%
1200 - 1500 GB
11%
1500 - 2000 GB
14%
> 2000 GB
21%
Total votes: 28

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 13th February 2011, 09:07
ciptadi ciptadi is offline
Junior Member
 
Join Date: May 2006
Location: City: Cakung District : East Jakarta Country : Indonesia
Posts: 16
ciptadi is on a distinguished road
Baan: BaaN V - DB: ORACLE 9.i - OS: WIN 2000 SERVER
Red face Create Table from Seq Dump result error can't create index 9999 (error 2452)
Baan: iBaanERP 5.0c
DB: Oracle 10.1.0.x
OS: Windows 2003
C/S: Server

Dear all.

Now I'm migrating from old BaaN server to the new one.
We have finished baan app. on new server and now we are in stage Creating table from sequential dump.
It's second time we replace BaaN server and as usual we create 1 production company(777) and 1 trial company (707). this trial company is used to test the result of migration, before we launch the 777 company.

Steps >> Copy data from Old server (live company 777) to dump file.
>> copy all dumped file, the original used for process 'create table form seq dump for company 777)
>> the one copy of dumped file will be used for trial company (707) of course after some needed steps(like copy company data, etc)

~ Process 'create table from seq dump for live(777) company was running successfully.

Problem:
Now we are still processing 'create table from seq dump for trial comp(707), problem occurs not at all, just for dump file of table 'tfgld417' with it's huge size (it's divided into 2 dump file #2,097,153 KB and #189,025 KB), at the end of error file of this process, typed 'Adding index ... Can not create index 9999 (error 2452).

I guess this error occurs because i select 'Create row before index' (for other small tables when this error occur then I un-check 'Create row before index' and when i recreate table, this error disappears.
My question, can we ignore this error, and then continue to reorganize tables ?
(I assume this error appear because baan can't create index, and I guess it will done when we reorganize table)

I hope somebody can help because 29 hours onwards, this new server must going 'live'.

Thank you very much and best regards.
Ciptadi Nugroho

Note: I attached my screen shot for 'create table from seq dump'
Attached Files
File Type: doc Error Ca not create index.doc (248.0 KB, 28 views)
Reply With Quote
  #2  
Old 14th February 2011, 11:16
jclju1's Avatar
jclju1 jclju1 is offline
Guru
 
Join Date: Jan 2002
Posts: 565
jclju1 is on a distinguished road
Baan: Baan IV, Baan 5.0c, SSA ERP LN 6.1 - DB: bisam, Oracle, Informix, Sql Server - OS: Unix (all), Windows
Index can not be created because of duplicate key.

$ oerr ora 1452
01452, 00000, "cannot CREATE UNIQUE INDEX; duplicate keys found"
// *Cause:
// *Action:

Quote:
for other small tables when this error occur then I un-check 'Create row before index' and when i recreate table, this error disappears.
Check number of records in original table. Do you have all records in table?
Reply With Quote
  #3  
Old 16th October 2018, 09:37
DivyaDya DivyaDya is offline
Junior Member
 
Join Date: Sep 2018
Posts: 3
DivyaDya is on a distinguished road
Baan: 9.2 - DB: SQL - OS: Windows-10
Create a Index

Quote:
Originally Posted by jclju1 View Post
Index can not be created because of duplicate key.

$ oerr ora 1452
01452, 00000, "cannot CREATE UNIQUE INDEX; duplicate keys found"
// *Cause:
// *Action:


Check number of records in original table. Do you have all records in table?
How to Create a Index in baan ??
example (CREATE INDEX index_name ON tablename) is possible or not?
Reply With Quote
  #4  
Old 18th October 2018, 01:26
Brendan Shine's Avatar
Brendan Shine Brendan Shine is offline
Senior Member
 
Join Date: Oct 2001
Location: Washington
Posts: 142
Brendan Shine is on a distinguished road
Baan: LN, Vc&b, IVc4, IVc3, IVb, Triton 3.1b - DB: Informix 7.31 FC6, Oracle 7,8,9,10 - OS: HP-UX 11, AIX, Dynix/ptx 4.4.4
If your schema definition for the indexes does NOT allow duplicates and you have duplicates in your data then you will have issues whether you load all rows then create indexes or load a row update indexes repeat until done. Most ERP indexes are unique and index1 always, but others (index2,3...) uniqueness or allow duplicates depends on needs. You may need to find duplicate keys and cleanup data.
Reply With Quote
Sponsored Links
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Import Data from File NPRao Tools Administration & Installation 5 30th August 2005 10:01
Create Table from Sequential Dump Joy Conner Tools Administration & Installation 8 2nd November 2004 21:24
create table from sequential dump pwinter Tools Administration & Installation 5 28th March 2003 23:37
how to create new index for a baan table valathappan Tools Development 4 13th February 2002 00:13
how to create a new index for a baan table TDPUR045 valathappan Tools Development 0 8th January 2002 07:58


All times are GMT +2. The time now is 08:48.


©2001-2018 - Baanboard.com - Baanforums.com