#1) check that there exists a valid class WINSURGE*...   

#2) in Mgmt Portal > System Explorer > SQL you should see as Table WINSURGE_DMP.WINSURGE_RESULT_FACT

#3) #SQLCompile Path=cancreg 
seems the real source of your problem as it sets a default package cancreg  wherever that may come from

http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GCOS_macros#GCOS_macros_mpp_lbSQLCompile_Path

Eliminate it as your table is already full qualified  WINSURGE_DMP.WINSURGE_RESULT_FACT

In addition :  - VALUES :FIELD()
do you really write to ALL fields of the external table ??? 

Hint:

try to execute your SQL statement first from Mgmt Portal using dummy values before coding with strange macros directives

start with a simple statement to see if the connection works as expected:

SELECT COUNT(*) FROM WINSURGE_DMP.WINSURGE_RESULT_FACT

then try:

INSERT INTO WINSURGE_DMP.WINSURGE_RESULT_FACT VALUES (1,2,3,4,5,6)   -- whatever it needs

I like that !  

BUT: as in the original request I seem to miss the file.Read()  to fill Line somewhere in the loop.  

Time in Posix is the time as %Integer counting from Jan 1st, 1970.  A UNIX definition.
dates before are negative integers (e.g. birthdate before 1970 )   
      [that was a reason to start $h with Jan 1st, 1840. The year the oldest veteran (in 1960)  from civil war at MGH was born ] 

the WRITE is just to visualize the example

the loop in YOUR class could be: 

but that's just standard COS programming. Nothing special. see here
Then you have the local array msg with your SOAP message
Similiar the Try{ } Catch {}  construct that ignores the error that you experience as you don't get a real SOAP response here.

that's default anyhow

in technology space it's nice and compatible to the UNIX/LINUX world
in the commercial arena it is just an alien

  set s.TimeStamp=$zdt($H,3)

it is already in ODBC format.

That makes it more clear, but not easier.

Class %SOAP.WebClient  is the base for any SOAP Client in Caché.
It has a property Transport to provide a registered class for alternate transport (or no immediate transport in your case)
check the code starting with Method InvokeClient(...
and look for transport within the next 50 lines to see how that works up to here

Just to be clear:
I personally won't do it that way because of all the related maintenance risks.

That's a possible end point.
 

If you don't do to detect the structure using TCPtrace or WireShark or similar you will not see it.

As I noted. It's an advice for hackers (and network engineers)

YES. and once you have identified the content you should be able to modify it in object script according to your needs with $REPLACE, $TRANSLATE, ...... as any other string

Mike,

please create a new question as the solution is not related to the previous one.

Thx.

Evgeny,
The type of mirror depends on how it should be used:

• for Disaster Recovery, it is important to get as much real-time date across as possible.
  it is irrelevant to have indices, cubes or similar in your (very) remote data center. 
  so I'd recommend asynchronous Mirror / Shadow to feed it.
  What else you require can be generated from existing data. 
   
• for High Availability, everything to continue / restart  should be available permanently
  so my recommendation is Synchronous Mirror
   
• but in parallel, there is the recommendation to separate Production data from DeepSee cubes
  less for cube maintenance but fo queries. And that's really important!
   
• As a consequence, you would need a secondary mirror to provide high availability + performance also
  for your DeepSee cubes. Which is not a waste of effort as it allows load balancing across DeepSee. 
   
• In any case, it is a tricky exercise to build, verify and manage such a configuration.  
    

Typically a Message in Ensemble is inheriting from Ens.Request
e.g. Class EnsLib.Testing.Request Extends Ens.Request

I have no Healthshare at hands to identify your correct message
just to confirm Enslib.HL7.Message does NOT extend Ens.Request as it is a  Persistent object on it's own.

I like that    

$lf($lb(1,s,y,s-y+1),x)

That's mine: