Hi Ken,

There is an easier way.

Instead of fiddling around with unpredictable params you just pass your whole symbol table = local variables
to your background job like this and use what you need in background

JOB ##class(%SYSTEM.OBJ.FM2Class).All():(:1):5

look for process-params + switch  here
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...

Evgeny,

in SQL you have a CASE ... END block for selection

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

CASE 
  WHEN search_condition THEN value_expression
  [ WHEN search_condition THEN value_expression ... ]
  [ ELSE value_expression ]
END

CASE value_expression
  WHEN value_expression THEN value_expression
  [ WHEN value_expression THEN value_expression ... ]
  [ ELSE value_expression ]
END

That's fine and nothing new.
You missed my point:

With the Class Query it's not self explaining if params got to Prepare() or to Execute()
http://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?P...

I just learned from  John Murray a few comments above

that you don't need a prepare with a Class Query.
I wasn't aware of that until a few hours ago.

Then it's obvious that any param has to go to Execute().

SQL Error 417 = Security Error

You should check your access rights inside 
- Windows
- Caché

Hi Ken,

For some odd reason Execute() requires he same parameters as Prepare() again !

ENSDEMO>d $system.SQL.Shell()
SQL Command Line Shell
----------------------------------------------------
 
The command prefix is currently set to: <<nothing>>.
Enter q to quit, ? for help.
ENSDEMO>>select * from Ens_Config.Credentials
1.      select * from Ens_Config.Credentials
 
ID      BusinessPartner PasswordObject  Password        SystemName      Username
 
.... Rows(s) Affected

write $TRANSLATE(obj.biometrics.%Get(0).timestamp,"T"," ")

Just add another IF condition and replace all  "Country" by " Relation"

If ($g(pInfo:filters("Relation"))'="") {
   Set tWHERE = tWHERE _ $S(tWHERE="":"",1:" AND ") _ "Relation %STARTSWITH '" _ pInfo:filters("Relation") _ "'"
}

try 

Do ##class(%SQL.Util.Procedures).CSVTOCLASS(2, .rowType, pFileName, pDelimiter,,1) 
;; no defaults if not required or the EXACT count:  9 params = 8 comma   
;; I counted 9 

and/or

Property Name As %String (MAXLEN="");

and/or

;; the last comma in rowType looks also suspect to me.

set  rowType=" . . . .    ,ActiveStatus Boolean" 

HTH

It's still the same answer as in one  of your previous questions:

only difference 1 hour instead of 24 hours

https://community.intersystems.com/post/configure-business-service

See the example on ENSDEMO namespace

my full support to 3 !!!!   and to 5, 2, 4 in this priority.

The difference between   ANSWER and COMMENT  causes  more confusion than being helpful.
Especially in the actual sequence.
Comment to Answers eventually may make sense. 
More than once I found myself in a Comment where it should have been an Answer.  

My suggestion:

 -handle all editing just in a modal pop-up .
- allow deleting (or hiding) your entry if you don't feel it appropriate anymore.

in namespace ENSDEMO use Demo.Dashboard.Production as an example for repeating calls

if you disable authentication  for  Username / PW you always come in as "UnknownUser"

in Mgmt Portal go to  System > Security Management > Users > Edit User for "UnknownUser"

and set Startup Tag^Routine:  ^%zmyLOGIN
and then do your own authetication.

if you intend to go to Prorammer Mode you just have to call "do ^%PMODE" at the end.
otherwise the terminal closes.

Conversion of XML to objects is a standard function in Caché.
start with http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...

and continue http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...

the principle steps

• generate a package o classes from XML Schema
• import your XML File to this package
• - - -  change whatever you want to change
• use %XML.Writer  to generate a new export file.

a different approach could be to use XSLT to transform your XML file
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...

Whatever better fits to reach your goal.

Take the example from %Net.SMTP to SAMPLE or USER independent of any ENS*

http://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?P...

and see if it runs on all 3 instances to verify SMTP access.

If it fails you may take a closer look to your firewalls  outgoing  and on SMTP server incoming.

If this works on all 3 instances than your config in ENSEMBLE is somehow different .

OR

in SAMPLES use Class Cinema.Utils. SendEmail(...) and adjust is to your needs

~~~

- For  JAVA take a look on IRIS or today to XEP ( which is incredible fast )
- For JavaScript you have nodes.js / cache.node  (also speedy)
- C#  lives by it's Windows bound libraries. 

You have to configure your SSLConfiguration = "SSLPadraoAdapcon" in Mgmt Portal.

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

for 2010.1:

http://docs.intersystems.com/cache20101/csp/docbook/DocBook.UI.Page.cls?KEY=GCAS_ssltls

It's a little bit complicated

Controlling the Use of Namespaces
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...

I'm not sure this really your problem. It could be. 

The first TEST should be your Mgmt Portal.

Language definitions are predefined and loaded at installation time.
to change it later from Mgmt Portal: 
System > Configuration > Locale Definitions 

If you run on UNICODE it should be enough to change it to PTBW - Portuguese, Brasil, Unicode (comboBox)

ending 8 = 8 bit encoded
ensing W = WIDE = Unicode

If your system is any 8bit installation. Someone else may have an answer. It may cause some troubles on a running installation. I never touched this.