You need to sign in to do that
Don't have an account?
Problems with the scripts
Hi,
Is there one table called "AccountTeamMember" in Developer force, or not? I've got this problem below, why?
Select * from MERCH...AccountTeamMember;
Msg 7314, Level 16, State 1, Line 1
The OLE DB provider "DBAmp.DBAmp" for linked server "MERCH" does not contain the table "AccountTeamMember". The table either does not exist or the current user does not have permissions on that table.
And how to resolve the problem with this script as well?
Select * from MERCH...ActivityHistory;
OLE DB provider "DBAmp.DBAmp" for linked server "MERCH" returned message "Error 1 : INVALID_TYPE_FOR_OPERATION: entity type ActivityHistory does not support query".
Msg 7320, Level 16, State 2, Line 1
Cannot execute the query "SELECT "Tbl1002"."AccountId" "Col1004","Tbl1002"."ActivityDate" "Col1005","Tbl1002"."ActivityType" "Col1006","Tbl1002"."CallDisposition" "Col1007","Tbl1002"."CallDurationInSeconds" "Col1008","Tbl1002"."CallObject" "Col1009","Tbl1002"."CallType" "Col1010","Tbl1002"."CreatedById" "Col1011","Tbl1002"."CreatedDate" "Col1012","Tbl1002"."Description" "Col1013","Tbl1002"."DurationInMinutes" "Col1014","Tbl1002"."EndDateTime" "Col1015","Tbl1002"."Id" "Col1016","Tbl1002"."IsAllDayEvent" "Col1017","Tbl1002"."IsClosed" "Col1018","Tbl1002"."IsDeleted" "Col1019","Tbl1002"."IsReminderSet" "Col1020","Tbl1002"."IsTask" "Col1021","Tbl1002"."IsVisibleInSelfService" "Col1022","Tbl1002"."LastModifiedById" "Col1023","Tbl1002"."LastModifiedDate" "Col1024","Tbl1002"."Location" "Col1025","Tbl1002"."OwnerId" "Col1026","Tbl1002"."Priority" "Col1027","Tbl1002"."ReminderDateTime" "Col1028","Tbl1002"."Status" "Col1029","Tbl1002"."Subject" "Col1030","Tbl1002"."SystemModstamp" "Col1031","Tbl1002"."WhatId" "Col1032","Tbl1002"."WhoId" "Col1033" FROM "ActivityHistory" "Tbl1002"" against OLE DB provider "DBAmp.DBAmp" for linked server "MERCH".
This error is reporting a problem connection to your MERCH database, which is not part of the Salesforce platform. From the error, it sounds like this is an integrated database being used by your company.
Thanks. Do you know if the 1st table above does exist inside DeveloperForce or not?