SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Database backup failure:Possible failure reasons: Problems with the query, "ResultSet" property not...


Database backup failure:Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection...

Author
Message
jeet_personal
jeet_personal
SSC Rookie
SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)

Group: General Forum Members
Points: 29 Visits: 96
The backup job in the MP is failing due to the following reason:

Executing the query "BACKUP DATABASE [RestoreAdminData_Forest] TO DISK = N'I:\\backup\\RestoreAdminData_Forest\\RestoreAdminData_Forest_backup_200905272100.bak' WITH NOFORMAT, NOINIT, NAME = N'RestoreAdminData_Forest_backup_20090527210006', SKIP, REWIND, NOUNLOAD, STATS = 10
" failed with the following error: "A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.
80 percent processed.
90 percent processed.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Any iDea why this is happening? the databases are in SIMPLE recovery mode
Jeffrey Williams 3188
Jeffrey Williams 3188
SSCertifiable
SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)

Group: General Forum Members
Points: 7663 Visits: 9966
This is happening because you are backing up across the network and there is a blip on the network. The ideal solution is to backup locally and copy to the network storage instead.

However, that may not be an option - so you need to identify the OS error (64, 995, etc...) and search the support site at Microsoft for possible fixes.

Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs

Shawn Melton
Shawn Melton
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2233 Visits: 3512
N'I:\\backup\\RestoreAdminData_Forest\\RestoreAdminData_Forest_backup_200905272100.bak'


Are you trying to run this job on the SQL server or through SSMS on your client machine? Have you tried going straight to it with using the UNC path, just "\\\backup..." instead of the drive letter? Do you have other jobs pointing to this network share?

Shawn Melton
PS C:\>(Find-Me).TwitterURL
@wsmelton
PS C:\>(Find-Me).BlogURL
meltondba.wordpress.com
john_1726
john_1726
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 16
When I attempt to run an SSIS stored procedure, I am receiving the following error:

[Execute SQL Task] Error: Executing the query "INSERT INTO tmpSQLXTABSOURCE
..." failed with the following error: "Error converting data type nvarchar to float.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Here is the the particular query that is causing a problem:

SELECT AnalysisSetID, LegalEntityID, FieldID, PeerGroupID, FieldDataSetID, DataSetYear, BCTypeID, BCMnemonic, SUM(CAST(DataValue AS float)) AS DataValue,
DataTable, SystemDataTypeID
FROM dbo.qryXTABData
GROUP BY AnalysisSetID, LegalEntityID, FieldID, PeerGroupID, BCTypeID, DataSetYear, BCMnemonic, DataTable, FieldDataSetID, SystemDataTypeID, DataValue
HAVING (SystemDataTypeID = '{7FD263E9-E684-4C0B-A095-D4273182F295}') AND (AnalysisSetID = '6bac995b-b776-4bf3-bfeb-4264270450f1')

Then when I change it to the following, this particular query works!

SELECT AnalysisSetID, LegalEntityID, FieldID, PeerGroupID, FieldDataSetID, DataSetYear, BCTypeID, BCMnemonic, SUM(CAST(DataValue AS decimal)) AS DataValue,
DataTable, SystemDataTypeID
FROM dbo.qryXTABData
GROUP BY AnalysisSetID, LegalEntityID, FieldID, PeerGroupID, BCTypeID, DataSetYear, BCMnemonic, DataTable, FieldDataSetID, SystemDataTypeID, DataValue
HAVING (SystemDataTypeID = '{7FD263E9-E684-4C0B-A095-D4273182F295}') AND (AnalysisSetID = '6bac995b-b776-4bf3-bfeb-4264270450f1')

Does anyone have any idea as to why using the cast to float would fail but the cast to decimal succeeds?

Then I try to update the appropriate view in SQL Server, but when I attempt to run the entire code from the stored procedure, I receive the following error:

Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__tmpSQLXT__2C3AA4296EAEBD9A'. Cannot insert duplicate key in object 'dbo.tmpSQLXTABSOURCE'.
The statement has been terminated.

Does anyone have any suggestions?

TIA.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search