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