Help get this topic noticed by sharing it on Twitter, Facebook, or email.

SELECT INTO now failing

I have tested the linked server connection successfully
I can query thru Force.com with the login

Between our update run of 11am and noon something happened and we can't do INSERT INTO run

This is what we are trying to run that is failing
SELECT *
INTO dbo.SFDCPRD_Account
FROM [SALESFORCE_PROD]...Account

This is the error we get now when that runs

OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE_PROD" returned message "Error 1 : UNKNOWN_EXCEPTION: java.io.IOException: ORA-01114: IO error writing block to file (block # )
".
Msg 7320, Level 16, State 2, Line 1
Cannot execute the query "SELECT "Tbl1005"."Accessories_Allowed_on_Subsidy__c" "Col1008","Tbl1005"."Account_Alert__c" "Col1009","Tbl1005"."Account_Alert_Active__c" "Col1010","Tbl1005"."Account_Alert_Notes__c" "Col1011","Tbl1005"."Account_Alias__c" "Col1012","Tbl1005"."Account_Safe_ID__c" "Col1013","Tbl1005"."AccountNumber" "Col1014","Tbl1005"."AccountSource" "Col1015","Tbl1005"."Action_Details__c" "Col1016","Tbl1005"."Action_Taken__c" "Col1017","Tbl1005"."Active_Store__c" "Col1018","Tbl1005"."Additional_Info__c" "Col1019","Tbl1005"."Aging_Status__c" "Col1020","Tbl1005"."Alarm_Type__c" "Col1021","Tbl1005"."AnnualRevenue" "Col1022","Tbl1005"."Approval_Status__c" "Col1023","Tbl1005"."Assigned__c" "Col1024","Tbl1005"."Authorization_Form_Created__c" "Col1025","Tbl1005"."Authorization_Form_Indicator__c" "Col1026","Tbl1005"."Bill_To_Country_Code__c" "Col1027","Tbl1005"."Billing_Contact__c" "Col1028","Tbl1005"."BillingCity" "Col1029","Tbl1005"."BillingCountry" "Col1030","Tbl1005"."BillingPostalCode" "Col1031","Tbl1005"."BillingState" "Col1032","Tbl1005"."BillingStreet" "Col1033","Tbl1005"."Brand_Notes__c" "Col1034","Tbl1005"."Brands_Customer_Buys__c" "Col1035","Tbl1005"."Buying_Group__c" "Col1036","Tbl1005"."Buying_Group_sfdc__c" "Col1037","Tbl1005"."Cage_Number__c" "Col1038","Tbl1005"."Cell_Phone__c" "Col1039","Tbl1005"."Clean__c" "Col1040","Tbl1005"."Close_Date__c" "Col1041","Tbl1005"."Concept__c" "Col1042","Tbl1005"."Corporate_Account_Indicator__c" "Col1043","Tbl1005"."Cost_Center__c" "Col1044","Tbl1005"."CreatedById" "Col1045","Tbl1005"."CreatedDate" "Col1046","Tbl1005"."Credit_Approval_Indicator__c" "Col1047","Tbl1005"."Credit_Card_Merch_ID__c" "Col1048","Tbl1005"."Credit_Card_PNS_Nbr__c" "Col1049","Tbl1005"."Credit_Card_Processor__c" "Col1050","Tbl1005"."Credit_Hold__c" "Col1051","Tbl1005"."Credit_Hold_Active__c" "Col1052","Tbl1005"."Credit_Hold_Instructions__c" "Col1053","Tbl1005"."Credit_Hold_Text__c" "Col1054","Tbl1005"."Credit_Limit_1__c" "Col1055","Tbl1005"."Credit_Limit_2__c" "Col1056","Tbl1005"."Credit_L...
1 person has
this problem
+1
Reply