php - SqlClient.SqlException:找不到列“dbo”或用户定义的函数或聚合的“dbo.fn_rt_getlevel”，或者名称不明确

我正在服务器中发送请求。

$custormerParams = array(
          "CustomerID" =>123,
          "CustomerAltID" =>'cusAlt',
          // "Participating" =>12,
          "CustClassificationID" =>12345,
          "StatusTypeID" =>1,
          // "PrimaryName" => $primaryName,
          "Email" => "[email protected]",
          // "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();
        }

最佳答案

我不知道您是否解决了该问题，但是值得检查表中是否包含触发器。可能是触发器在不存在的功能上运行。删除触发器可以解决问题。

由于它给您一个特定的SQL错误，因此该问题很可能是数据库本身造成的。

关于php - SqlClient.SqlException:找不到列“dbo”或用户定义的函数或聚合的“dbo.fn_rt_getlevel”，或者名称不明确，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/17022844/