Jase, I came across this about a week ago myself. I was getting it on search menus attached to view forms. According to all of the research I was able to do online the error is basically indicating that some sort of type conversion is occurring that's not supported. My specifics in case they help are 7.6.4 on Windows 2003 connecting to a remote SQL Server 2008 R2 DB. In the environment in question I had also recently installed the 2008 client tools on the machine (not sure if that's important or not). Any/All information you can provide that you find out from support is appreciated.
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jase Brandon Sent: Monday, April 18, 2011 3:17 PM To: arslist@ARSLIST.ORG Subject: Re: Overlay and custom in 7.6.4 ** Hello All, We upgraded a development 7.1 server to 7.6.04 and are getting the below error that I cannot resolve. After a week - BMC Support is stumped as well. Please see SQL log below - Does anyone have any ideas what is causing this? I've looked up C301610100 and it's 'SLMTableKeywordLookup', but I don't understand what "Multiple Step OLE DB operations generated errors" - means. Anyone? :-) Thanks, Jase <SQL > <TID: 0000001488> <RPC ID: 0000200317> <Queue: Fast > <Client-RPC: 390620 > <USER: jbran...@qualitytech.com <mailto:jblassing...@qualitytech.com> > <Overlay-Group: 1 > /* Thu Apr 07 2011 16:45:55.2840 */SELECT C301610100 FROM T1024 WHERE C1 = 'INC000000242817' <SQL > <TID: 0000001488> <RPC ID: 0000200317> <Queue: Fast > <Client-RPC: 390620 > <USER: jbran...@qualitytech.com <mailto:jblassing...@qualitytech.com> > <Overlay-Group: 1 > /* Thu Apr 07 2011 16:45:55.2840 */OK <SQL > <TID: 0000001488> <RPC ID: 0000200317> <Queue: Fast > <Client-RPC: 390620 > <USER: jbran...@qualitytech.com <mailto:jblassing...@qualitytech.com> > <Overlay-Group: 1 > /* Thu Apr 07 2011 16:45:55.2840 */Setting LOB into the above row ... <SQL > <TID: 0000001488> <RPC ID: 0000200317> <Queue: Fast > <Client-RPC: 390620 > <USER: jbran...@qualitytech.com <mailto:jblassing...@qualitytech.com> > <Overlay-Group: 1 > /* Thu Apr 07 2011 16:45:55.2840 */*** ERROR *** Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. (HRESULT: 0X80040E21) On Mon, Apr 18, 2011 at 12:48 PM, strauss <stra...@unt.edu> wrote: Further, for those of you trying to upgrade the ITSM suite to 7.6.04, all of the application upgrades threw errors and reported missing objects in the Health Checks, and I opened Issues on these errors last week (added SLM and RKM to SRM today from Friday's installs), I have started to get indications from support that every app failed to install multiple objects during the upgrades and I will need to go back and import various def files by hand. At this point I see no reason to have any confidence that you could upgrade a Staging Server and actually put that same system into production safely; I'm still planning to migrate all data and the overlay objects to a server with a clean 7.6.04 install, hoping that it is missing less objects. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of strauss Sent: Monday, April 18, 2011 10:22 AM To: arslist@ARSLIST.ORG Subject: Re: Overlay and custom in 7.6.4 Another day, another "adventure" with BMC software. Last week I finished upgrading my Staging server to 7.6.04 (ALL of ARS, Atrium Core, ITSM, SRM, SLM, RKM), or at least I think I have. There were all sorts of errors on every one of the upgrades, with Atrium having to be run twice before everything said it succeeded (AIE failed on the first try, and SHARE:Application_Properties still says it is 7.1.00.004), so I opened several Issues with BMC on Atrium, ITSM, SRM - and had more for SLM and RKM. This morning I am going to try to move on with Steps 13 and 14, and the first thing I noticed was that the upgrades created 6 new form overlays entirely on their own! No telling what I'll find in workflow, but it appears that the ITSM 7.5.00 stage within the 7.6.04 upgrade created these new forms, then when the 7.6.04 stage ran it created the 7.5 -> 7.6.04 differences as overlays. I am pretty sure that this is NOT what we were told would happen to origin objects during patches and upgrades, but I could be wrong. Audit Forms: CHG:ChangeRequest_AuditLogSystem CTM:AuditLogSystem HPD:HelpDesk_AuditLogSystem PBM:Problem_AuditLogSystem SRM:SR_AuditLog TMS:AuditLogSystem Only the SRM:SR_AuditLog is identical (overlay to overlaid); the rest reflect differences between 7.5.00 and 7.6.04 - usually a new index and several odd form properties. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"