Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

File missing Expand / Collapse
Author
Message
Posted Tuesday, November 12, 2013 3:40 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, August 17, 2014 3:50 AM
Points: 329, Visits: 858
I have a BCP command that generates files from several views. It generates about 80 files and takes about 15 mins to complete. After the files generation step is complete, I zip the files using 7za.exe. But I am running into issues of one file missing in the zip when the customer gets it. It doesn't happen every day. Just once in a while.
Any idea what could have happened during the BCP process? Anything I can do to prevent it from happening?
Post #1513649
Posted Wednesday, November 13, 2013 6:23 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:03 PM
Points: 2,345, Visits: 2,843
From your description it is very hard to tell what the problem could be.
I suspect one of the queries within the BCP process occasionally won't return data (no rows present or maybe a non-desruptive error?). If possible build a logging mechanism inside or around the BCP process that records the rowcount of each seperate step and the creation of the file(s).


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1513837
Posted Thursday, January 9, 2014 9:49 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, August 17, 2014 3:50 AM
Points: 329, Visits: 858
with BCP logging, the following error message came out. Anything I could check?

SQLState = 08001, NativeError = 0
Error = [Microsoft][SQL Native Client]Unable to complete login process due to delay in opening server connection
Post #1529428
Posted Thursday, January 9, 2014 10:54 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:03 PM
Points: 2,345, Visits: 2,843
This error looks like the server is very busy and is under a lot of stress at that moment. Therefor it doesn't have the resources available to handle the login.
Setup a monitoring (perfmon) to see how the resources (CPU, memory, etc) are used.


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1529459
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse