I've honestly never done this, but, according to what you are showing, it seems like you are doing it right....the only thing that I can say for sure is that there is NOTHING you should be able to do to cause a thread to 'die'....if you can, it's a bug in the Remedy code that you can't fix...you might be able to avoid the crash by doing this and that...but regardless, the thread crashing is a bug in BMC's code.
On Fri, Apr 24, 2015 at 12:53 PM, Timothy Powell < timothy.pow...@pbs-consulting.com> wrote: > ** > > LJ, > > Thanks for the quick reply. > > Ok, so you’re saying that I am doing this correctly and the crash is an > un-intended consequence? > > > > TP > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *LJ LongWing > *Sent:* Friday, April 24, 2015 2:16 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: View Forms and Attachments > > > > ** > > Tim, > > I regret to inform you that you have found a bug in BMC's server. You > should not be able to do anything to crash a server, period. I see that > you are already running the latest SP of your version, so I can't recommend > doing anything other than contacting BMC and hope for a hotfix that > addresses your issue. :) > > > > On Fri, Apr 24, 2015 at 12:00 PM, Timothy Powell < > timothy.pow...@pbs-consulting.com> wrote: > > ** > > ARS 7.6.04 SP5 > > Microsoft SQL Server 2008 R2 (SP1) > > > > Concept: > > I have an external web form. People enter data into said form. That data > includes attachments. > > That data is posted to a database residing on the same database instance > the ARSystem DB resides on. > > Attachment data is posted to a SQL Image column. > > > > I have created a view form to see the posted data. Per page 190 of the > 7.6.04 Integrations Guide: > > # Beginning with release 7.6.02, view forms support additional data types. > This includes blobs (DB2, Oracle, and Informix) and images (Microsoft SQL > Server and Sybase), which map to an attachment field > > > > When I add the external columns to my view form, the ARSystem does indeed > automatically create an attachment field inside of an attachment pool for > the SQL Image column. > > > > I can see all data stored on the external DB including the image data > (although the properties are not displayed properly). > > > > **************** > > Next step: > > Now I want to move that external posted data from the view form and into a > native ARS staging form where I can massage the data and move it to its > final destination within the ARSystem application. > > > > I created a filter to push the data from the external DB to my ARS staging > form. > > When I map the fields, if I leave the attachment field out of the Push > Fields mapping, everything works great. > > When I map the fields and I INCLUDE pushing the image data to an > attachment field on the ARS staging form, the system throws a Signal and > dies; error below: > > > > Fri Apr 24 11:57:01 2015 390620 : AR System server terminated — fatal > error occurred in ARSERVER (ARNOTE 21) > > Fri Apr 24 12:02:46 2015: AR System server terminated when a > signal/exception was received by the server (ARNOTE 20) > > > > Thread Id: 2856 > > Version: 7.6.04 SP5 201308012025 Aug 1 2013 21:00:12 > > ServerName: *********DVARS1 > > Database: SQL -- SQL Server > > Hardware: x86_64 > > OS: Windows Server 2008 > > RPC Id: 325779 > > RPC Call: 183 (SGE) > > RPC Queue: 390620 > > Client: User tpowell from Remedy User (protocol 18) at IP address > xx.xxx.xxx.xxx > > Form: WebSubmitHolder > > Logging On: > > Code: c0000005 > > Operation: read > > Access Addr: 0000000000000000 > > Stack Begin: > > Addr: 000000007460814D > > Addr: 0000000000000001 > > Addr: C300000001B80674 > > Stack End > > > > I'm obviously missing something. Any ideas? Thanks in advance. > > Tim Powell > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
