Yuam ib tug BDC runtime kev piav

Kuv los yuam ib tug BDC kev no lub limtiam uas manifested nws tus kheej rau cov neeg siv interface thiab ua tus 12 nas muv cav Thaum runtime.

Ua ntej, qhov no nyob hauv cov neeg interface:

Kuj tsis paub liaj teb mus tau ntxig yaam tseem ceeb txhua lub Identifier nuav los yog txim tuag SpecificFinder MethodInstance nrog lub npe … Xyuas input tsis tau nrog txhua Identifier uas sau tseg rau qhov chaw no TypeDescriptors.

Ntawm no yog ib qho screen txhaj:

clip_image001

Kuv tseem ua txoj xov tshwm nyob rau lub 12 nas muv ca thaum yuav (siv kuv patented high-tech-don't-try-this-at-home uas "mysterious tsis" txujci):

11/14/2007 09:24:41.27 w3wp.exe (0x080C) 0x0B8C SharePoint Portal neeg rau zaub mov ua lag ua luam cov ntaub ntawv 6q4x High kos hauv BusinessDataWebPart.OnPreRender: System.InvalidOperationException: Cov nqi no Identifier ”, yam ”, yog invalid. Xav pom Identifier tus nqi rau cov hom 'System.String'. tom Microsoft.Office.Server.ApplicationRegistry.MetadataModel.Entity.FindSpecific(Nruas[] subIdentifierValues, LobSystemInstance lobSystemInstance) tom Microsoft.SharePoint.Portal.WebControls.BdcClientUtil.FindEntity(Qhov chaw qhov chaw, Nruas[] userValues, LobSystemInstance lobSystemInstance) tom Microsoft.SharePoint.Portal.WebControls.BusinessDataItemBuilder.GetEntityInstance(Saib desiredView) tom Microsoft.SharePoint.Portal.WebControls.BusinessDataDetailsWebPart.GetEntityInstance() tom Microsoft.SharePoint.Portal.WebControls.BusinessDataDetailsWebPart.SetDataSourceProperties()

Kuv nrhiav ib ncig thiab nrhiav tau tej yam ua nyob rau hauv lub Rooj sab laj MSDN, tab sis lawv tsis txaus kuv nkag siab kuv yog ua dab tsis ncaj ncees lawm. Kuv saib ib webcast los Ted Pattison uas kuv niaj hnub muaj squirreled mus rau ib tug neeg rau zaub mov thiab tuaj kom paub kuv qhov teeb meem.

Nyob rau hauv kuv ADF, Kuv yuav siv rau ib SQL database li:

            <Khoom Lub npe="RdbCommandText" Hom="System.String">
              <![CDATA[
                XAIV SETID, CARRIER_ID, EFFDT, DESCR, EFF_STATUS, TAXPAYER_ID, NETWORK_ID, FRT_FORWARD_FLG, ALT_NAME1, ALT_NAME2, LANGUAGE_CD,
                      LUB TEB CHAWS, ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, LUB ZOS, NUM1, NUM2, HOUSE_TYPE, ADDR_FIELD1, ADDR_FIELD2, ADDR_FIELD3,
                      CHEEB NROOG, LUB XEEV, KOJ, GEO_CODE, IN_CITY_LIMIT, COUNTRY_CODE, XOV TOOJ, EXTENSION, FAX MUS, LAST_EXP_CHK_DTTM, FREIGHT_VENDOR,
                      INTERLINK_DLL, TMS_EXCLUDE_FLG los dbo.PS_CARRIER_ID_VW nrog (nolock)
                QHOV TWG
                  (SETID <> 'FEEM') thiab
                  (qis(CARRIER_ID) >= sab(@MinId)) thiab
                  (qis(CARRIER_ID) <= sab(@MaxId)) thiab
                  (qis(DESCR) NYIAM sab(@InputDescr))
                ]]>
            </Khoom>

Kuv tau muab qhov SQL los ntawm ib tug neeg DBA thiab kuv muab kuv mus nkag siab hais tias nws yog ib tug tshwj xeeb saib lawv tsim cia rau kuv. Cov yuam sij nws yog CARRIER_ID.

Ntawm no yog cov yoov nkag tau kuv:

      <Identifiers>
        <Identifier Lub npe="CARRIER_ID" TypeName="System.String" />
        <Identifier Lub npe="DESCR" TypeName="System.String" /> 
</Identifiers>

Qhov chaw nyob ntawm kab, Kuv tswj tau rau kuv tus kheej lawm lub ntsiab ntawm yam <Identifiers> thiab ntxiv DESCR txawm tias tsis tau ib identifier. Kuv muab DESCR lub teeb identifiers thiab presto! Nws cov ua haujlwm.

I hope this saves someone some grief 🙂

Ntawv cim npe Technorati: , , ,

2 xav txog"Yuam ib tug BDC runtime kev piav

  1. Paul Galvin

    Pieter, koj probalby solved no lawm los, tab sis, kuv xam yog hais tias nws yuav yuav txog lub ntsiab txhais rau nram qab kawg. Tej zaum lub SQL teb xwb no heev pub rau 60 chars? Ib yam dab tsi nyiam ntawd?

    Teb
  2. Pieter Veenstra

    nyob zoo,

    Kuv twb tau txais ib qhov teeb meem nrog ib BDC, thiab kuv xav tias koj yuav pab tau txog qhov no?

    Kuv tabtom siv ob identifiier teb ( ib tug xov tooj thiab cov hauj lwm teb), tav twg tag nrho cov cim ntau tshaj 60 Kuv tabtom tau txais rau cov foollowing uas tsis:

    Invalid ntawv luam tus nqi

    Teb ntawv muaj cov ntaub ntawv invalid. Thov kos cov nqi thiab sim dua.

    Koj puas to taub qhov twg no txwv ntawm 60 cim los ntawm? thiab yuav ua li cas los txhim kho qhov teebmeem?

    Tam sim no kuv yog limiting tau cov hauj lwm nyob rau hauv xws li ib txoj kev uas tag nrho cov cim ntawd tsis dhau 60.

    Teb

sau ntawv cia

Koj email chaw nyob yuav tsis muab luam tawm. Search cim *