SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
DB Zip/Unzip Expert

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
DB Zip/Unzip Expert
Author Message
Roberto



Joined: 22 Mar 2005
Posts: 3

Post DB Zip/Unzip Expert Reply with quote

DB Tools Ver 4.1.46
Created a zip file worth 1.8GB off one oracle server.
Trying to unzip it to new oracle server. Got error
after a few minutes:
Error:
Bad zip file
(Extract_currentfile)Error-105 occured while unzipping file

Was successfully able to unzip said zipped file using winzip.

Tried to zipping just one small table. Was able to unzip
with no problem.

TIA

Thu Aug 28, 2003 5:50 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Re: DB Zip/Unzip Expert Reply with quote

How many tables (approximately) were zipped?

Can you unzip just individual tables from that huge file?

: DB Tools Ver 4.1.46
: Created a zip file worth 1.8GB off one oracle server.
: Trying to unzip it to new oracle server. Got error
: after a few minutes: Error: Bad zip file
: (Extract_currentfile)Error-105 occured while unzipping file

: Was successfully able to unzip said zipped file using winzip.

: Tried to zipping just one small table. Was able to unzip
: with no problem.

: TIA

Thu Aug 28, 2003 8:17 pm View user's profile Send private message
Roberto



Joined: 22 Mar 2005
Posts: 3

Post Re: DB Zip/Unzip Expert Reply with quote

: Please do not cross-post. Your message will be answered in DB Tools forum.
Sorry about that...I already posted on the other discussion group before
I realized I posted it on the wrong group.

Fri Aug 29, 2003 11:34 am View user's profile Send private message
Roberto



Joined: 22 Mar 2005
Posts: 3

Post Re: DB Zip/Unzip Expert Reply with quote

: How many tables (approximately) were zipped?
There are about 116 tables

: Can you unzip just individual tables from that huge file?
Using DB zip/unzip I got the same error. And i picked one
table that is fairly small.


Fri Aug 29, 2003 11:44 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Re: DB Zip/Unzip Expert Reply with quote

I will email you a diagnostic version of the zip DLL that will provide more detailed error description. I hope that will help to pinpoint the cause of problem. I should get a hold of this file later today or at the latest tomorrow morning.

: There are about 116 tables
: Using DB zip/unzip I got the same error. And i picked one
: table that is fairly small.

Fri Aug 29, 2003 12:08 pm View user's profile Send private message
Roberto



Joined: 22 Mar 2005
Posts: 3

Post Re: DB Zip/Unzip Expert Reply with quote

: I will email you a diagnostic version of the zip DLL that will provide more
: detailed error description. I hope that will help to pinpoint the cause of
: problem. I should get a hold of this file later today or at the latest
: tomorrow morning.
Thanks. I appreciate your help and prompt response.

Fri Aug 29, 2003 2:07 pm View user's profile Send private message
Roberto



Joined: 22 Mar 2005
Posts: 3

Post Re: DB Zip/Unzip Expert Reply with quote

: I will email you a diagnostic version of the zip DLL that will provide more
: detailed error description. I hope that will help to pinpoint the cause of
: problem. I should get a hold of this file later today or at the latest
: tomorrow morning.
I ran the unzip again and got this error:

Error:

Bad zip file

(extract_currentfile)Error-105 occured while unzipping files.

Additional info: (closecurrentfile) Error-105 occured while

extracting UPS.I_SHIPMENT.DATA

I_SHIPMENT is a very large table. 2,858,000 plus rows and counting.

thanks

Wed Sep 03, 2003 2:39 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Re: DB Zip/Unzip Expert Reply with quote

Can you extract that table using WinZip?

: I ran the unzip again and got this error: Error: Bad zip file

: (extract_currentfile)Error-105 occured while unzipping files.

: Additional info: (closecurrentfile) Error-105 occured while

: extracting UPS.I_SHIPMENT.DATA

: I_SHIPMENT is a very large table. 2,858,000 plus rows and counting.

: thanks

Wed Sep 03, 2003 4:53 pm View user's profile Send private message
Roberto



Joined: 22 Mar 2005
Posts: 3

Post Re: DB Zip/Unzip Expert Reply with quote

: Can you extract that table using WinZip?
Yes.

Thu Sep 04, 2003 12:00 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Re: DB Zip/Unzip Expert Reply with quote

It appears that we sent you another version of the zip routines DLL which is based on Zlib 1.1.4 same as in WinZip. Have you tried that version yet?

: Can you extract that table using WinZip?

Thu Sep 04, 2003 12:11 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Re: DB Zip/Unzip Expert Reply with quote

It appears that we sent you another version of the zip routines DLL which is based on Zlib 1.1.4 same as in WinZip. Have you tried that version yet?

: Yes.

Thu Sep 04, 2003 12:25 pm View user's profile Send private message
Roberto



Joined: 22 Mar 2005
Posts: 3

Post Re: DB Zip/Unzip Expert Reply with quote

: It appears that we sent you another version of the zip routines DLL which is
: based on Zlib 1.1.4 same as in WinZip. Have you tried that version yet?
I got an email with the attachment "24x7srv.dll" that I put
in the db tools install directory. It still failed, only this
time it stated which table it has having problem with.

Error message I got after using new 24x7srv.dll:

Error:
Bad zip file
(extract_currentfile)Error-105 occured while unzipping files.
Additional info: (closecurrentfile) Error-105 occured while
extracting UPS.I_SHIPMENT.DATA

As a test I zipped and unzipped using DB tools all tables
except for 2 very large tables. That went fine.

Then I did just the 2 large tables by themselves. This one
failed.

Thu Sep 04, 2003 3:48 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.