php - SqlClient.SqlException : Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fn_rt_getlevel", 或名称不明确

Question

我在服务器中发送请求。

$custormerParams = array(
          "CustomerID" =>123,
          "CustomerAltID" =>'cusAlt',
          // "Participating" =>12,
          "CustClassificationID" =>12345,
          "StatusTypeID" =>1,
          // "PrimaryName" => $primaryName,
          "Email" => "test@test.net",
          // "BillingAddress" => $BillingAddress,
          // "ShippingAddress" => $ShippingAddress,
          "ShipBadAddress" =>1,
          "ShippingAddressResidential" =>1,
          "UserName" =>"test",
          "Password" =>12345678,
          "AccountNumber" =>123456789,
          "AppDate" =>"2013-06-12T16:32:34.948Z",
          "TaxID1" =>123,
          "TaxID2" =>213,
          "Stax" =>"NA",
          "Intlsin" =>"NA",
          "Phone1" =>"7795377440",
          // "Phone2" =>"NA",
          // "Phone3" =>"NA",
          // "Phone4" =>"NA",
          // "Phone5" =>"NA",
          // "Phone5" =>"NA",
          // "Phone6" =>"NA",
          // "DLNumber" =>"NA",
          // "DLState" =>"NA",
          "EnrollerDistributorID" =>1234,
          "DefaultPaymentTypeID" =>123,
          // "AccountCreditCard" => $accountCreditCard,
          // "AccountBankAccount" => $AccountBankAccount,
          "Taxable" =>1,
          "LanguageID" =>12,
          "SponsorDistributorID" =>1,
          "RefCustomerID" =>12,
          // "CustFieldValues"=>$custfieldval,
          "BillDelOff" =>12,
          "BillingAddressVerified" =>12,
          "CreditzAccountNumber" =>"NA",
          "CreditzPassword" => "234wser",
          "CustomerTypeID" => 112,
          "EmailOptOut" =>1,
          "Export" =>1,
          "Exported" =>1,
          "InstitutionNumber" => "test",
          "JoinCategoryID" => 12,
          "Mark" =>12,
          "OrigBCKey" =>12,
          "OrigEnrollerBCKey" =>0,
          "ShipDelOff" =>"NA",
          "ShippingAddressVerified" =>1,
          "TransitNumber" =>"NA",
          "UpdateDate" => "2013-06-12T16:32:34.948Z",
        );


$custormer = array(
    "APIKey" => xxxx,
    "CompanyID" => XXXX,
    "Customer" =>$custormerParams
);
$request = array(
    "Request" => $custormer
);

传递请求:-

 try {


           $result = $this->client->__soapCall('Customer_CreateOnly', array($request),array(
            'uri' => 'My url',
            'soapaction' => ''
           ));

获取错误:-

System.Data.SqlClient.SqlException: Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fn_rt_getlevel", or the name is ambiguous.

如果我将调用任何其他函数，它工作正常..

            echo htmlentities($this->client->__getLastRequest());
             echo "<pre>";
            echo htmlspecialchars($this->client->__getLastRequestHeaders()) . "\n";
            echo "hello Response:\n hello" . htmlspecialchars($this->client->__getLastResponseHeaders()) . "hello\n";
            echo htmlspecialchars($this->client->__getLastResponse()) . "\n";
            echo htmlspecialchars($this->client->__getLastRequest()) . "\n";            
            echo "</pre>";
            return $result;

        } catch (Exception $e) {
            echo "<pre>";
            echo htmlspecialchars($this->client->__getLastRequestHeaders()) . "\n";
            echo "Response:\n" . htmlspecialchars($this->client->__getLastResponseHeaders()) . "hello \n";
            echo htmlspecialchars($this->client->__getLastResponse()) . "\n";
            echo htmlspecialchars($this->client->__getLastRequest()) . "\n";
            echo "</pre>";
            return $e->getMessage();
        }

Answer 1

我不知道您是否解决了这个问题，但可能值得检查表中是否有附加的触发器。可能是触发器正在运行，函数不再存在。删除触发器可能会解决问题。

由于它给你一个特定的 SQL 错误，问题可能出在数据库本身。