zedalaye / fbclone

A wonderful tool to take care of your Firebird databases
33 stars 19 forks source link

Target database cannot be opened #6

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
* What steps will reproduce the problem?
1. fbclone -v -s SIGAA.FDB -su SYSDBA -sp masterkey -t sigaa_utf.fdb -tu SYSDBA 
-tp masterkey -tc UTF8 -rc WIN1252 -wc UTF8 >> fbclone.log

* What is the expected output? What do you see instead?
I'm not sure about the converted file is ok. When I try to open it on IBExpert 
I get a warning about the wrong user or password.
The source file size is 21.5KB and the target has only 11.0KB.

* What version of the product are you using? On what operating system?
FBClone 2.1.4
Windows7 Pro
Firebird 2.5
IBExpert

I tried to log the verbose I see on screen (by using ">> filename"), but only a 
small and initial part is logged - I don't know why.
It would be good to have an option for that. 

Take a look at the final part I can see on screen:
:
:
------ failure ------
GRANT SELECT ON PESSOA TO PROCEDURE GERAR_CAMPANHA_NATAL, PROCEDURE GERAR_RANCHO
_NATAL, PROCEDURE POP_RESUMO_ALIMENTO, PROCEDURE POP_RESUMO_FAMILIA, PROCEDURE P
OP_RESUMO_ODONTO, PROCEDURE POP_RESUMO_OFTALMO;
----- exception -----
unsuccessful metadata update
table/view PESSOA does not exist
This operation is not defined for system tables.

GDS Code: 335544351Error Code: 31
---------------------
------ failure ------
GRANT SELECT ON PESSOA_COMPLEMENTO TO PROCEDURE GERAR_CAMPANHA_NATAL, PROCEDURE
GERAR_RANCHO_NATAL, PROCEDURE POP_RESUMO_ALIMENTO, PROCEDURE POP_RESUMO_FAMILIA,
 PROCEDURE POP_RESUMO_ODONTO, PROCEDURE POP_RESUMO_OFICINA, PROCEDURE POP_RESUMO
_OFTALMO, PROCEDURE POP_RESUMO_RANCHO, PROCEDURE POP_RESUMO_VESTUARIO, PROCEDURE
 POP_RESUMO_VISITA;
----- exception -----
unsuccessful metadata update
table/view PESSOA_COMPLEMENTO does not exist
This operation is not defined for system tables.

GDS Code: 335544351Error Code: 31
---------------------
------ failure ------
GRANT SELECT,DELETE ON VESTUARIO_PESSOA TO PROCEDURE EXCLUIR_VESTUARIO_PESSOA;
----- exception -----
unsuccessful metadata update
table/view VESTUARIO_PESSOA does not exist
This operation is not defined for system tables.

GDS Code: 335544351Error Code: 31
---------------------
--- 1204 error(s) ! ---

Original issue reported on code.google.com by mich...@gmail.com on 8 Aug 2012 at 10:14

Attachments:

GoogleCodeExporter commented 9 years ago
You can log errors to the log file, or another log file using 2> :

fbclone -v ... > allfine.log 2> errors.log

or

fbclone -v ... > clone.log 2>&1

2>&1 redirects the error output descriptor to standard output descriptor

Original comment by pierr...@gmail.com on 9 Nov 2012 at 12:14

GoogleCodeExporter commented 9 years ago
Sorry the delay. I was not working in this project for long time, but I getting 
back on it now.

I think I couldn't express myself well (maybe, because English is not my first 
language :) )

I know how to use redirection... It was that " >> fbclone.log" that generated 
the log file I had attached before.

Do you took a look into that file? It's trunked. That's why I had written: "... 
but only a small and initial part is logged - I don't know why"

Don't you think that these fragment of report - that I saw on screen - should 
be inside of the log file?

Please consider spend two and a half minutes and watch this video I recorded: 
http://youtu.be/cvazg32ff9w

/Micheus 

Original comment by mich...@gmail.com on 13 Feb 2013 at 6:56

GoogleCodeExporter commented 9 years ago
[deleted comment]
GoogleCodeExporter commented 9 years ago
Thanks for your advice Pierre !
fbclone -v ... > allfine.log 2> errors.log
got general log in allfine and errors in errors. worked perfect for me ! 

Original comment by marianne...@gmail.com on 28 Feb 2013 at 8:57

GoogleCodeExporter commented 9 years ago
Pierre, my apologies, I got back to that project and I finally discover that I 
was using a wrong parameter for charset:
>> 1. fbclone -v -s SIGAA.FDB -su SYSDBA -sp masterkey -t sigaa_utf.fdb -tu 
SYSDBA -tp masterkey -tc UTF8 -rc WIN1252 -wc UTF8 >> fbclone.log
they should be:
>>... -tc UTF8 -rc NONE -wc WIN1252
as you post in your Wiki doc (that I didn't see before, I don't know why).

Thank you for share this useful tool.

/Micheus

Original comment by mich...@gmail.com on 12 Jun 2013 at 12:46