Updating the People form from AIE
Good morning (afternoon or evening) All, I am trying to update the people form using AIE and below are the only errors I see in the AIE loging: [Thu Jun 26 2008 09:01:34.3550] - Updating entry 903269 for form 'CTM:People' [Thu Jun 26 2008 09:01:34.3550] - + ARSetEntry -- Form[CTM:People] for Entry [PPL6163] [Thu Jun 26 2008 09:01:34.3700] - UpdateDataSchemaEntry: Error accessing form CTM:People [Thu Jun 26 2008 09:01:34.3700] - Entry 903269 was not updated due to error [Thu Jun 26 2008 09:01:34.3700] - DataExchangeOnMatch: CompareAssetsForPull failed key = 903269 rc = 1 [Thu Jun 26 2008 09:01:34.3700] - [Thu Jun 26 2008 09:01:34.3700] - ExchangeByComparingLists: Vendor Key = 903272, AR Key = 903272, Vendor Key = AR Key, check for changes [Thu Jun 26 2008 09:01:34.3700] - + Get Data SQL command : SELECT [Area], [Building], [Fax], [JobTitle], [MailID], [MailIDFull], [MailStop], [MobilePhone], [NameFirst], [NameFull], [NameLast], [NameMiddle], [NameNick], [NameNick], [Pager], [SNumber] FROM [dbo].[SitePeople] WHERE [SNumber] = '903272' [Thu Jun 26 2008 09:01:34.4010] - - Get Data SQL command OK All ideas welcome. -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Updating the People form from AIE
Howard, try deleting and then re-creating your key fields in the mapping. Drew On Thu, 26 Jun 2008, Howard Richter wrote: Good morning (afternoon or evening) All, I am trying to update the people form using AIE and below are the only errors I see in the AIE loging: [Thu Jun 26 2008 09:01:34.3550] - Updating entry 903269 for form 'CTM:People' [Thu Jun 26 2008 09:01:34.3550] - + ARSetEntry -- Form[CTM:People] for Entry [PPL6163] [Thu Jun 26 2008 09:01:34.3700] - UpdateDataSchemaEntry: Error accessing form CTM:People [Thu Jun 26 2008 09:01:34.3700] - Entry 903269 was not updated due to error [Thu Jun 26 2008 09:01:34.3700] - DataExchangeOnMatch: CompareAssetsForPull failed key = 903269 rc = 1 [Thu Jun 26 2008 09:01:34.3700] - [Thu Jun 26 2008 09:01:34.3700] - ExchangeByComparingLists: Vendor Key = 903272, AR Key = 903272, Vendor Key = AR Key, check for changes [Thu Jun 26 2008 09:01:34.3700] - + Get Data SQL command : SELECT [Area], [Building], [Fax], [JobTitle], [MailID], [MailIDFull], [MailStop], [MobilePhone], [NameFirst], [NameFull], [NameLast], [NameMiddle], [NameNick], [NameNick], [Pager], [SNumber] FROM [dbo].[SitePeople] WHERE [SNumber] = '903272' [Thu Jun 26 2008 09:01:34.4010] - - Get Data SQL command OK All ideas welcome. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Updating the People form from AIE
Drew, Trying that now, you were able to get this to work? hbr On 6/26/08, Drew Shuller <[EMAIL PROTECTED]> wrote: > > Howard, try deleting and then re-creating your key fields in the mapping. > > Drew > > On Thu, 26 Jun 2008, Howard Richter wrote: > > Good morning (afternoon or evening) All, >> >> I am trying to update the people form using AIE and below are the only >> errors I see in the AIE loging: >> >> [Thu Jun 26 2008 09:01:34.3550] - Updating entry >> 903269 >> for form 'CTM:People' >> [Thu Jun 26 2008 09:01:34.3550] - + ARSetEntry -- >> Form[CTM:People] for Entry [PPL6163] >> [Thu Jun 26 2008 09:01:34.3700] - >> UpdateDataSchemaEntry: >> Error accessing form CTM:People >> [Thu Jun 26 2008 09:01:34.3700] - Entry 903269 was not >> updated due to error >> [Thu Jun 26 2008 09:01:34.3700] - DataExchangeOnMatch: >> CompareAssetsForPull failed key = 903269 rc = 1 >> [Thu Jun 26 2008 09:01:34.3700] - >> [Thu Jun 26 2008 09:01:34.3700] - >> ExchangeByComparingLists: Vendor Key = 903272, AR Key = 903272, Vendor >> Key >> = AR Key, check for changes >> [Thu Jun 26 2008 09:01:34.3700] - + Get Data SQL >> command >> : SELECT [Area], [Building], [Fax], [JobTitle], [MailID], [MailIDFull], >> [MailStop], [MobilePhone], [NameFirst], [NameFull], [NameLast], >> [NameMiddle], [NameNick], [NameNick], [Pager], [SNumber] FROM >> [dbo].[SitePeople] WHERE [SNumber] = '903272' >> [Thu Jun 26 2008 09:01:34.4010] - - Get Data SQL >> command OK >> >> All ideas welcome. >> >> >> > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Updating the People form from AIE
We had some squirelliness after an upgrade from EIE to AIE and this is one of the things we did. We found that real simple mappings weren't returning the same number of records. I haven't tried what you're doing. Drew On Thu, 26 Jun 2008, Howard Richter wrote: Drew, Trying that now, you were able to get this to work? hbr On 6/26/08, Drew Shuller <[EMAIL PROTECTED]> wrote: Howard, try deleting and then re-creating your key fields in the mapping. Drew On Thu, 26 Jun 2008, Howard Richter wrote: Good morning (afternoon or evening) All, I am trying to update the people form using AIE and below are the only errors I see in the AIE loging: [Thu Jun 26 2008 09:01:34.3550] - Updating entry 903269 for form 'CTM:People' [Thu Jun 26 2008 09:01:34.3550] - + ARSetEntry -- Form[CTM:People] for Entry [PPL6163] [Thu Jun 26 2008 09:01:34.3700] - UpdateDataSchemaEntry: Error accessing form CTM:People [Thu Jun 26 2008 09:01:34.3700] - Entry 903269 was not updated due to error [Thu Jun 26 2008 09:01:34.3700] - DataExchangeOnMatch: CompareAssetsForPull failed key = 903269 rc = 1 [Thu Jun 26 2008 09:01:34.3700] - [Thu Jun 26 2008 09:01:34.3700] - ExchangeByComparingLists: Vendor Key = 903272, AR Key = 903272, Vendor Key = AR Key, check for changes [Thu Jun 26 2008 09:01:34.3700] - + Get Data SQL command : SELECT [Area], [Building], [Fax], [JobTitle], [MailID], [MailIDFull], [MailStop], [MobilePhone], [NameFirst], [NameFull], [NameLast], [NameMiddle], [NameNick], [NameNick], [Pager], [SNumber] FROM [dbo].[SitePeople] WHERE [SNumber] = '903272' [Thu Jun 26 2008 09:01:34.4010] - - Get Data SQL command OK All ideas welcome. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"