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.

my personal experience in management portal:

changed my primary browser language from  "de"  to "en"  and the portal followed at next browser start.

So this might relate to ZEN somehow:
Do you use the $$$TEXT equivalent of ZEN ? $$$TextJS, $$$FormatText

for details and how-to see http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...

Does your Caché NLS seting support pt-br  ?  (mine includes German DEUW)

Rodrigo is right:

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

says:

• property Language as %String;

The language (RFC 1766 format) in which pages in this CSP session are to be displayed.
The %session. Language attribute is used as the default language for csp:text, span and div tags if %response.Language is not set. If %session.Language is not set by the program, then it will default to the best fit with the HTTP_ ACCEPT_LANGUAGE CGI variable.

Caché Programming Orientation Guide > Useful Skills to Learn > Browsing a Table

Browsing a Table

For basics on SQL:  https://www.w3schools.com/sql/