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 < [email protected]> 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_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
