function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Edward_chanEdward_chan 

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".

Jeff MayJeff May

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.

Edward_chanEdward_chan

Thanks. Do you know if the 1st table above does exist inside DeveloperForce or not?