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
15%
200 - 500 GB
27%
500 - 800 GB
4%
800 - 1200 GB
4%
1200 - 1500 GB
12%
1500 - 2000 GB
15%
> 2000 GB
23%
Total votes: 26

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 21st July 2011, 04:27
dharmsan dharmsan is offline
Junior Member
 
Join Date: Jul 2011
Posts: 12
dharmsan is on a distinguished road
Baan: Baan 5 - DB: Oracle - OS: Unix
Error running in sequential dump
Baan: iBaanERP 5.0c
DB: Oracle 8.0.3.x
OS: HP-UX 1.0
C/S: Both

Hi Baan Experts,

I am trying to create a table from sequential dump through ttaad4227m000 for a diffrent company but it gets error "Error in running bdbpost".

If I make a sequential dump for the same company from which we take the dump, then it works fine.

I want to take sequential dump i.e from comp 160 for 5 tables and want to take these data in my 5 more companies, Please suggest me for this.

The following is the error:
bdbpost6.2: WARNING: 'option -O will be removed in the future'
Default separator ('\0') taken
Table M Idx RowCount Messages
----------- - --- -------- ----------------------
asint000630 1 Table already exists
bapdm001630 1 Table already exists
bapdm002630 1 Table already exists
bapdm003630 1 Table already exists
bapdm004630 3 Table already exists
ccboi001630 1 Table already exists


................................This list is so long



Regards,
dharmsan

Last edited by dharmsan : 21st July 2011 at 08:37. Reason: error not edit
Reply With Quote
Sponsored Links
  #2  
Old 21st July 2011, 10:36
mohammed mohammed is offline
Junior Member
 
Join Date: Aug 2001
Location: Jeddah, Saudi Arabia
Posts: 26
mohammed is on a distinguished road
Baan: BaaN IV c4 - DB: MSSQL 7 - OS: Windows 2000
use the delete tables option while uploading or select the append/overwrite option
the error says tables exists in those companies either u should delete those tables or over write/append the records to the tables
Reply With Quote
  #3  
Old 22nd July 2011, 03:22
dharmsan dharmsan is offline
Junior Member
 
Join Date: Jul 2011
Posts: 12
dharmsan is on a distinguished road
Baan: Baan 5 - DB: Oracle - OS: Unix
Hi mohammed,

Thanks for the quick update..

I already tick the Append if table exist,overwrite duplicate records from dump and Create rows before Index

Above three I tick and upload the same ..but the error is there.

Please suggest...
Reply With Quote
  #4  
Old 23rd July 2011, 08:20
VishalMistry's Avatar
VishalMistry VishalMistry is offline
Guru
 
Join Date: Dec 2004
Location: India, Gujarat
Posts: 605
VishalMistry has a little shameless behaviour in the past
Baan: Baan IV, ERPLn - DB: SQL Server 2000 / 2008 - OS: Windows Server 2003 / 2008
Red face

Quote:
Originally Posted by dharmsan View Post
Hi mohammed,

Thanks for the quick update..

I already tick the Append if table exist,overwrite duplicate records from dump and Create rows before Index

Above three I tick and upload the same ..but the error is there.

Please suggest...
Hi,

You can use session Convert Recover tables (ttaad4228m000). Using this session, you don't need to first take sequential dump and then restore. In the first form of this session, specify the source company and table range you want to copy, and on second form, tick-mark the option "Create table for different company" and specify target company.

Also, tick-mark Delete existing tables option if tables already exists in target company and if you don't require existing data.

Vishal
Reply With Quote
  #5  
Old 25th July 2011, 03:57
dharmsan dharmsan is offline
Junior Member
 
Join Date: Jul 2011
Posts: 12
dharmsan is on a distinguished road
Baan: Baan 5 - DB: Oracle - OS: Unix
Hi Vishal,

I tried but still the same message is there,"error in running bpbpost",

I only want to copy the data of comp 100 ,taable tifmm361 to the comp 103 .

The following log is creatge in the bse/log:

In log.ttsp :09-06-30[15:35:28]isid09: ******* S T A R T of Log message ******
09-06-30[15:35:28]isid09: Session: ttstpoledaem (foreground) BW, process = 33
09-06-30[15:35:28]isid09: File : ptgbrg00010, line: 3871
09-06-30[15:35:28]isid09: Package: b5lfmm0, host: baansvr, release: 6.2
09-06-30[15:35:28]isid09: Locale : SHIFTJIS_HPUX, NLS: ja_JP.SJIS, TSS: SHIFTJIS, mb: 2/2
09-06-30[15:35:28]isid09: Errors : e = 0, db.error = 0, lang: j, comp: 639
09-06-30[15:35:28]isid09: Cannot change to company 632
09-06-30[15:35:28]isid09: *********** E N D of Log message ******

09-06-30[15:35:28]isid09: ******* S T A R T of Log message ******
09-06-30[15:35:28]isid09: Session: ttstpoledaem (foreground) BW, process = 33
09-06-30[15:35:28]isid09: File : ptgbrg00010, line: 3872
09-06-30[15:35:28]isid09: Errors : e = 0, db.error = 0, lang: j, comp: 639
09-06-30[15:35:28]isid09: -1: Company not available
09-06-30[15:35:28]isid09: *********** E N D of Log message ******

09-06-30[15:35:28]isid09: ******* S T A R T of Log message ******
09-06-30[15:35:28]isid09: Session: ttstpoledaem (foreground) BW, process = 33
09-06-30[15:35:28]isid09: File : ptgbrg0000, line: 197
09-06-30[15:35:28]isid09: Errors : e = 0, db.error = 0, lang: j, comp: 639
09-06-30[15:35:28]isid09: Can't change to company 632 to store the Enterprise Models
09-06-30[15:35:28]isid09: *********** E N D of Log message ******

09-06-30[15:35:28]isid09: ******* S T A R T of Log message ******
09-06-30[15:35:28]isid09: Session: ttstpoledaem (foreground) BW, process = 33
09-06-30[15:35:28]isid09: File : ptgbrg00010, line: 3871
09-06-30[15:35:28]isid09: Errors : e = 0, db.error = 0, lang: j, comp: 639
09-06-30[15:35:28]isid09: Cannot change to company 632
09-06-30[15:35:28]isid09: *********** E N D of Log message ******

09-06-30[15:35:28]isid09: ******* S T A R T of Log message ******
09-06-30[15:35:28]isid09: Session: ttstpoledaem (foreground) BW, process = 33
09-06-30[15:35:28]isid09: File : ptgbrg00010, line: 3872
09-06-30[15:35:28]isid09: Errors : e = 0, db.error = 0, lang: j, comp: 639
09-06-30[15:35:28]isid09: -1: Company not available
09-06-30[15:35:28]isid09: *********** E N D of Log message ******

09-06-30[15:35:28]isid09: ******* S T A R T of Log message ******
09-06-30[15:35:28]isid09: Session: ttstpoledaem (foreground) BW, process = 33
09-06-30[15:35:28]isid09: File : ptgbrg0000, line: 197
09-06-30[15:35:28]isid09: Errors : e = 0, db.error = 0, lang: j, comp: 639
09-06-30[15:35:28]isid09: Can't change to company 632 to store the Enterprise Models
09-06-30[15:35:28]isid09: *********** E N D of Log message ******

09-06-30[15:35:33]isid09: ******* S T A R T of Log message ******
09-06-30[15:35:33]isid09: Session: ttstpoledaem (foreground) BW, process = 35
09-06-30[15:35:33]isid09: File : ptgbrg00010, line: 3871
09-06-30[15:35:33]isid09: Package: b5lfmm0, host: baansvr, release: 6.2
09-06-30[15:35:33]isid09: Locale : SHIFTJIS_HPUX, NLS: ja_JP.SJIS, TSS: SHIFTJIS, mb: 2/2
09-06-30[15:35:33]isid09: Errors : e = 0, db.error = 0, lang: j, comp: 639
09-06-30[15:35:33]isid09: Cannot change to company 632
09-06-30[15:35:33]isid09: *********** E N D of Log message ******

09-06-30[15:35:33]isid09: ******* S T A R T of Log message ******
09-06-30[15:35:33]isid09: Session: ttstpoledaem (foreground) BW, process = 35
09-06-30[15:35:33]isid09: File : ptgbrg00010, line: 3872
09-06-30[15:35:33]isid09: Errors : e = 0, db.error = 0, lang: j, comp: 639
09-06-30[15:35:33]isid09: -1: Company not available
09-06-30[15:35:33]isid09: *********** E N D of Log message ******

09-06-30[15:35:33]isid09: ******* S T A R T of Log message ******
09-06-30[15:35:33]isid09: Session: ttstpoledaem (foreground) BW, process = 35
09-06-30[15:35:33]isid09: File : ptgbrg0000, line: 197
09-06-30[15:35:33]isid09: Errors : e = 0, db.error = 0, lang: j, comp: 639
09-06-30[15:35:33]isid09: Can't change to company 632 to store the Enterprise Models
09-06-30[15:35:33]isid09: *********** E N D of Log message ******

09-06-30[15:35:33]isid09: ******* S T A R T of Log message ******
09-06-30[15:35:33]isid09: Session: ttstpoledaem (foreground) BW



Please suggest more ideas
Reply With Quote
  #6  
Old 26th July 2011, 18:00
jaotto jaotto is offline
Senior Member
 
Join Date: Jun 2007
Posts: 139
jaotto is on a distinguished road
Baan: LN - DB: Oracle - OS: Linux
bdbpost

If you are copying data from one company to another you will need to use the copy company data session (tccom0214m000) before you use bdbpost.

You may also want to try and use exchange to get the data to the new company.
Reply With Quote
  #7  
Old 29th July 2011, 09:23
VishalMistry's Avatar
VishalMistry VishalMistry is offline
Guru
 
Join Date: Dec 2004
Location: India, Gujarat
Posts: 605
VishalMistry has a little shameless behaviour in the past
Baan: Baan IV, ERPLn - DB: SQL Server 2000 / 2008 - OS: Windows Server 2003 / 2008
Quote:
Originally Posted by dharmsan View Post
Hi Vishal,

I tried but still the same message is there,"error in running bpbpost",

I only want to copy the data of comp 100 ,taable tifmm361 to the comp 103 .

The following log is creatge in the bse/log:

In log.ttsp :09-06-30[15:35:28]isid09: ******* S T A R T of Log message ******
09-06-30[15:35:28]isid09: Session: ttstpoledaem (foreground) BW, process = 33
09-06-30[15:35:28]isid09: File : ptgbrg00010, line: 3871
09-06-30[15:35:28]isid09: Package: b5lfmm0, host: baansvr, release: 6.2
09-06-30[15:35:28]isid09: Locale : SHIFTJIS_HPUX, NLS: ja_JP.SJIS, TSS: SHIFTJIS, mb: 2/2
09-06-30[15:35:28]isid09: Errors : e = 0, db.error = 0, lang: j, comp: 639
09-06-30[15:35:28]isid09: Cannot change to company 632
09-06-30[15:35:28]isid09: *********** E N D of Log message ******

09-06-30[15:35:28]isid09: ******* S T A R T of Log message ******
09-06-30[15:35:28]isid09: Session: ttstpoledaem (foreground) BW, process = 33
09-06-30[15:35:28]isid09: File : ptgbrg00010, line: 3872
09-06-30[15:35:28]isid09: Errors : e = 0, db.error = 0, lang: j, comp: 639
09-06-30[15:35:28]isid09: -1: Company not available
09-06-30[15:35:28]isid09: *********** E N D of Log message ******

09-06-30[15:35:28]isid09: ******* S T A R T of Log message ******
09-06-30[15:35:28]isid09: Session: ttstpoledaem (foreground) BW, process = 33
09-06-30[15:35:28]isid09: File : ptgbrg0000, line: 197
09-06-30[15:35:28]isid09: Errors : e = 0, db.error = 0, lang: j, comp: 639
09-06-30[15:35:28]isid09: Can't change to company 632 to store the Enterprise Models
09-06-30[15:35:28]isid09: *********** E N D of Log message ******

09-06-30[15:35:28]isid09: ******* S T A R T of Log message ******
09-06-30[15:35:28]isid09: Session: ttstpoledaem (foreground) BW, process = 33
09-06-30[15:35:28]isid09: File : ptgbrg00010, line: 3871
09-06-30[15:35:28]isid09: Errors : e = 0, db.error = 0, lang: j, comp: 639
09-06-30[15:35:28]isid09: Cannot change to company 632
09-06-30[15:35:28]isid09: *********** E N D of Log message ******

09-06-30[15:35:28]isid09: ******* S T A R T of Log message ******
09-06-30[15:35:28]isid09: Session: ttstpoledaem (foreground) BW, process = 33
09-06-30[15:35:28]isid09: File : ptgbrg00010, line: 3872
09-06-30[15:35:28]isid09: Errors : e = 0, db.error = 0, lang: j, comp: 639
09-06-30[15:35:28]isid09: -1: Company not available
09-06-30[15:35:28]isid09: *********** E N D of Log message ******

09-06-30[15:35:28]isid09: ******* S T A R T of Log message ******
09-06-30[15:35:28]isid09: Session: ttstpoledaem (foreground) BW, process = 33
09-06-30[15:35:28]isid09: File : ptgbrg0000, line: 197
09-06-30[15:35:28]isid09: Errors : e = 0, db.error = 0, lang: j, comp: 639
09-06-30[15:35:28]isid09: Can't change to company 632 to store the Enterprise Models
09-06-30[15:35:28]isid09: *********** E N D of Log message ******

09-06-30[15:35:33]isid09: ******* S T A R T of Log message ******
09-06-30[15:35:33]isid09: Session: ttstpoledaem (foreground) BW, process = 35
09-06-30[15:35:33]isid09: File : ptgbrg00010, line: 3871
09-06-30[15:35:33]isid09: Package: b5lfmm0, host: baansvr, release: 6.2
09-06-30[15:35:33]isid09: Locale : SHIFTJIS_HPUX, NLS: ja_JP.SJIS, TSS: SHIFTJIS, mb: 2/2
09-06-30[15:35:33]isid09: Errors : e = 0, db.error = 0, lang: j, comp: 639
09-06-30[15:35:33]isid09: Cannot change to company 632
09-06-30[15:35:33]isid09: *********** E N D of Log message ******

09-06-30[15:35:33]isid09: ******* S T A R T of Log message ******
09-06-30[15:35:33]isid09: Session: ttstpoledaem (foreground) BW, process = 35
09-06-30[15:35:33]isid09: File : ptgbrg00010, line: 3872
09-06-30[15:35:33]isid09: Errors : e = 0, db.error = 0, lang: j, comp: 639
09-06-30[15:35:33]isid09: -1: Company not available
09-06-30[15:35:33]isid09: *********** E N D of Log message ******

09-06-30[15:35:33]isid09: ******* S T A R T of Log message ******
09-06-30[15:35:33]isid09: Session: ttstpoledaem (foreground) BW, process = 35
09-06-30[15:35:33]isid09: File : ptgbrg0000, line: 197
09-06-30[15:35:33]isid09: Errors : e = 0, db.error = 0, lang: j, comp: 639
09-06-30[15:35:33]isid09: Can't change to company 632 to store the Enterprise Models
09-06-30[15:35:33]isid09: *********** E N D of Log message ******

09-06-30[15:35:33]isid09: ******* S T A R T of Log message ******
09-06-30[15:35:33]isid09: Session: ttstpoledaem (foreground) BW



Please suggest more ideas
Hi,

Have you checked event viewer of your application server. It should point you to the cause.

Vishal
Reply With Quote
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
Create Table from Sequential Dump with multibyte character devilyeye Tools Administration & Installation 1 5th July 2010 05:55
Problem with bdpost via Session ttaad4227m000 (Create Table from Sequential Dump) BOBBYLYON Tools Administration & Installation 2 16th October 2009 22:56
How can I restore dumps of TT package tables? zyilmaz Tools Administration & Installation 12 31st January 2005 11:45


All times are GMT +2. The time now is 04:57.


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