Hi,
I am facing a problem when Create Table From Sequential Dump (ttaad4227m000).Error prompt me as per attached.

Please advise.

Thank you.

Hi,

Look at eror file, this may be helpful to you.

Regards,
SUKHDEV SINGH

Hi,
I am facing a problem when Create Table From Sequential Dump (ttaad4227m000).Error prompt me as per attached.

Please advise.

Thank you.

Hello,

maybe your export has'nt have a field seperator ?

Regards

Dear all,
Thank you for reply. Attached herewith the error log file and sample data. I had gone thru it but do not have any idea what cause this error.

Please help.

Thank you very much :)

- Export a table of your target system with the same field separator as used in the files do you want to import.
- Replace the 2 header lines of the import files by the 2 header lines of the file created by the previous export.

Do you use another version of bdbpre as bdbpost?

Regards,
Han

Dear All,
Thank you for ur advise.
1) Yes-Export a table of your target system with the same field separator (|)as used in the files do you want to import.
2) How to Replace the 2 header lines of the import files by the 2 header lines of the file created by the previous export??
3) what is bdbpre? how to check it?

Thanks again.

Hi Dear,

Error log is being created with Name "ERR" on your server in tmp folder, you can open this in any text editor & check what message is being logged there. This may help to resolve the issue.

Regards,
SUKHDEV SINGH

Hi,
I already gone thru the error log file and also attached the error log at previous reply but i do not have any idea on it.

Thank you.

be sure that both server are using the same versoin of bdbpost which updated with updating the enterprise server

Sequential dump was made with newer version of bdbpre - second line in files txxxxxxxxxxx.S:
#$!pre-dump!$#00057cvnISO_BIN1

Possible solution: set variable PREVERSION and run bdbpre (sequential dump of table) again:

-set PREVERSION=3

@fmchong:
Use an editor or wordpad to edit the import files

Hi,
Thanks for informations.

May i know what is bdbpost & bdbpre? how to check what version of bdbpost?

:confused:

Thank you.

bdbpre and bdbpost are the commands run in the background to export/import.

you can check the version by running the command with a -V option (if I remember correctly).

Hi,
The command a -V should run at where?
1) Start > Run > cmd> a -V ????
2) Worktop > Start Shell > a -V ????

I tried both but cannot work!

Thank you.

Hi,
The command a -V should run at where?
1) Start > Run > cmd> a -V ????
2) Worktop > Start Shell > a -V ????

I tried both but cannot work!

Thank you.


Kindly Go through the complete sentence again.

bdbpre and bdbpost are the commands run in the background to export/import.

you can check the version by running the command with a -V option (if I remember correctly).


the above sentence states that you need to run bdbpre /bdbpost along with switch option (i assume you understand the switch option) which is "-v".

The dump-files have different versions, therefore you can´t import it. The source machine is exporting it as version 5 and the target machine did not allow this version. Most probably the target system has an older Software version or the parameter in the BW-config is causing the trouble.

Suggestion:

Enter the parameter "-set PREVERSION=3" in the "Command" field of the BECS "BShell Environment" on the _Source_ machine. Then the export will be in the old and famos version 3 format.

Do the export again and import it on the target machine. This should work.

Regards

Dieter

fmchong,

You have to go to a command line on your Windows 2003 server.
Then
cd %BSE%
cd bin
fillenv
set USER=baan
bdbpre -v <------- to check the version of bdbpre
bdbpost -v <------- to check the version of bdbpost
ntbshell -v <------- to check the version of your portingset.

Make sure they all match. Also from the source server do a check on the versions of both portingset and bdbpre and bdbpost. If the versions are far too distant there you can run into this kind of trouble being able to import dumps generated on a different system. The session Create table from sequential dump uses those binaries in the background so it doesn't matter whether you use the session or the command line to import the dump.

Best luck!

Nestor Molina

##

If On Windows you can check the version in explorer bij viewing the property's of the file. The will be a tab where the version is stored.

bdbpre (export) and bdbpro (import) are located in $BSE/bin

U can type in the commandprompt bdbpre -u for usage.

Normaly i would take the newest version and make an export and import eith that. U can use the latest version in different environments certainly when u import and export from the command prompt

Dear All,
Thank you very much for the information.

what fmchong means is.

Start > Run > cmd>
then type:
bdbpost -v
and then enter