New post
AllAccepted answers
Oliver Wilms · Jan 8, 2022

User Error identified: I missed adding USING {"from":{"file":{"header":"1"}}} at the end. The correct statement that skipped "Balance" column was:

LOAD DATA FROM FILE '/irisrun/repo/data/finance-transactions-08-Jan-2022_08-25.csv'
INTO dc_data_finance.transact(TranDate,CheckNumber,Merchant,Category,SubCategory,Memo,Credit,Debit,BillPay,DebitCard,Account,Status)
VALUES("Date","Check",Merchant,Category,SubCategory,Memo,Credit,Debit,"Bill Pay","Debit Card",Account,Status)
USING {"from":{"file":{"header":"1"}}}

Oliver Wilms · Jan 8, 2022

I created a new class called "dc.data.finance.transact" avoiding RESERVED words DATE, CHECK, and TRANSACTION. Then I ran this command in SQL Management Portal:

LOAD DATA FROM FILE '/irisrun/repo/data/finance-transactions-08-Jan-2022_08-25.csv' into dc_data_finance.transact

Row count: 76 Performance: 4.318 seconds  91420 global references 1837548 commands executed 3 disk read latency (ms)  Cached Query: %sqlcq.USER.cls23  Last update: 2022-01-09 00:04:31.471

Print

  76 row(s) affected
Oliver Wilms · Nov 20, 2021

I have tried to adapt your example to run on HealthShare 2019.1. I get an error when I call  ..Adapter.ExecuteUpdateBatchParamArray from SQLInsertOperation. 

I debugged the OutboundAdapter code. The error happens on this line:

Set pHS=..%JGProxy.prepareStatement(..%ConnHandle,pSQLStatement)

..%ConnHandle is not an Object. pSQLStatement looks okay.

My code is here:

https://github.com/oliverwilms/etl/blob/main/src/Oliver/SQL/OutboundAdap...(..%25ConnHandle%2CpSQLStatement)

Any idea what is the problem?

Oliver Wilms · Sep 12, 2021

It took a while, but I made some progress. I changed my cube name from iris-for-money to iris4money (no dashes) and then the project compiled with the latest community edition image. zpm behaved a little bit better in later image, but I still had to struggle a lot to get FileCopy to work so I had data to import when installing from zpm.  

I appreciate the help I got from Dmitry Maslennikov when I called ZPM 911 on Discord channel. He pointed out that FileCopy converted filename from export.csv to export.CSV. Eventually I got my zpm testing to complete without errors after I had changed the filename in my repo to export.CSV. Hopefully I will earn ZPM bonus which I have worked so hard for.

Oliver Wilms · Aug 23, 2021

By default, only clients local to the Web Gateway’s hosting computer are allowed access to the Web Gateway Management pages. The browser through which the management forms are accessed must be running on the same machine as the web server and Web Gateway. For example:

http://localhost:<port_no>/csp/bin/Systems/Module.cxw

You can add additional clients to the list of authorized administrators by adding the client IP addresses to the System_Manager parameter in the SYSTEM section in CSP.ini (in install-dir\CSP\bin). The System_Manager parameter represents a comma- or plus-separated list of clients (by IP address) who may access the Web Gateway Management pages. The directive shown below grants access to three remote clients in addition to the default local access.

[SYSTEM]
System_Manager=190.8.7.6, 190.8.7.5, 190.8.7.4
Oliver Wilms · Aug 23, 2021

docker exec -it sam_iris_1 bash
root@IRIS:/tmp# cd /usr/irissys/csp/bin/
root@IRIS:/usr/irissys/csp/bin# ls
CSP.ini  CSP.log  CSPRT.ini  CSPa24.so  CSPa24Sys.so  CSPx.so  libz.so  temp
root@IRIS:/usr/irissys/csp/bin# ls -lt
total 3244
-rw-rw-r-- 1 www-data  www-data     6063 Aug 22 15:56 CSP.log
-rw-rw---- 1 irisuser  irisuser      253 Aug 21 23:57 CSPRT.ini
-rw-rw---- 1 irisuser  irisuser      606 Jun 26  2020 CSP.ini
-rwxrwxr-x 1 irisowner irisowner 1169384 Jun 26  2020 CSPa24.so
-rwxrwxr-x 1 irisowner irisowner  869720 Jun 26  2020 CSPa24Sys.so
-rwxrwxr-x 1 irisowner irisowner 1135208 Jun 26  2020 CSPx.so
-rwxr-xr-x 1 irisowner irisowner  117168 Jun 26  2020 libz.so
dr-xr-x--- 1 irisuser  irisuser     4096 Jun 26  2020 temp

Oliver Wilms · Aug 21, 2021

I need to correct my last response. I did receive WRC response on Friday with this:

After discussing this issue with co-workers:

The message is due to the reassignment of the IP address:

  Yes – the basically the IP address changing underneath the mirror node “changed it’s identity”. This is expected behavior for mirroring.

Possible to setup virtual IP address/or DNS name for each member then in script assign new IP to the member's DNS name

Also not to use ECS but something long these lines found in this link, look it over and see if it applies:

https://medium.com/galvanize/static-ip-applications-on-aws-ecs-c7d411421d4f