ROLAND
23rd February 2003, 10:51
Hai all... :(

I have problem with my backup compay. We have five company n every day we will backup our company but when we check the backup file we found out that our backup for 1 companies wasn't successful. there`s any know why ??
please help me.....urgent

thx

r014nd

victor_cleto
23rd February 2003, 19:46
By dump backup that means that you're running a Baan export every day and then you baclkup the dump file, right?

Have you checked if the problem was on the generation of the dump (how are you doing it?) or in the backup solution (fbackup or something?). When you create a company dump, you usually specify an error log, check what's in there. Also, if you use a job to export the company, did you checked the job history to check is it run ok?

(this are just a few ideas of what to check, you need to post more details on how your dumps/backup is done...)

ROLAND
24th February 2003, 03:22
Thanks victor_cleto...

I used session ttadv4226m000 for export dump backup n all company succes but when i`m check the dump file there`s any problem in one company how i know that`s backup failed, i checked used open that backup file with WORDPAD.exe then i find a problem in my backup company. U can see in my attach file
a difference dump backup failed n dump backup not failed.
Mr victor u can see variance in my attach file.

regards
R 014 ND

victor_cleto
24th February 2003, 13:29
If you would have a failed dump you would *not* have a dump file in the first place, so the export are running ok, I don't see any problem there.

808 dump is OK, and contains data.
802 dump is OK, and it seems that it does not contain data.

You need to review/explain your concept of a failed dump on your checks.

ROLAND
25th February 2003, 04:00
Hai victor_cleto
Thanks a lot for ur answers but can u explain ur excuse why my dump backup is ok ? and can u teach me basicly who to check dump backup file becoz i just know if thats dump backup is succes come to module tttxt030.

regrads
r 014 nd

victor_cleto
25th February 2003, 18:06
If the table that was dumped had data on it, the dump file contains (your first example):
- header information
- table data dictionary information
- data

If the table contained no data (empty, most tables in Baan or temporary tables) the dump file contains (your second example):
- header information
- table data dictionary information
[ no data! ]

When you're exporting a table, you [should] always generate a log file also: if exports are done thru Baan, don't leave the log field empty; if thru a bdbpre6.1, pipe the command into a log file.

This log file should be checked to see if records have been skipped or for other problems, this is the correct way to see if the dump was succesfull or not. Myself, I run a
egrep "rror|match|DD|corrupt" <log_file>
to see if something went wrong.

For further information abour exports, search the board on keywords "bdbpre" and/or "export".

ROLAND
28th February 2003, 10:47
hai victor_cleto

thanks for u help..i`m sorry i don`t know how to make log file : egrep "rror|match|DD|corrupt" <log_file> can u teach me how to make it if not elephant U.

thanks a lot victor

regards
roland

norwim
28th February 2003, 12:19
the egrep command is used only to evaluate the log file.
First you have to create one *g*
bdbpre6.1 -Ntdsls045 -Emylogfile -pB40Cc4 -C100 > tdsls045.dmp
should give a dumpfile named tdsls045.dmp and a logfile called mylogfile.
If you want to have a look at this logfile (vor example with vi), you won't see much, as this logfile echos all output from bdbpre like it would have been seen on the screen. (cat mylogfile and you will see what I mean).
Therefore we usually evaluate this logfiles with grep or egrep.
cat mylogfile | grep error
for example will show all lines that contain the pattern "error"

Hope that made it a little clearer
have fun

Norbert

ROLAND
3rd March 2003, 11:43
Hai Norwin :)

thanks for ur help..but please can`t u give a manual book or another becoz i`m sure understand.
First you have to create one *g* First you have to create one *g*
bdbpre6.1 -Ntdsls045 -Emylogfile -pB40Cc4 -C100 > tdsls045.dmp --> how to make it norwin.
please help..


regards
R014ND

victor_cleto
5th March 2003, 19:42
I suggest to get some tools training to get the hand on this things... (you're administering the server by yourself or there's a Baan sys admin around?)

How are you exporting your tables, thru bdbpre6.1 or thru the Baan session ttaad4226m000 (Create sequential Dump of Table)?

I don't expect you set it up thru bdbpre6.1 otherwise you would know the answer of the previous questions already.
So, I assume you're using the session mentioned above; so, on that session, you should fill the field "Name of error file" with a file <-- and this is the file that you should check for errors.

You have to look at the file using other tool because grep is a UNIX command only (but there are other utilities similar for Windows).