Nueva publicación

Encontrar

Artículo
· 10 jul, 2024 Lectura de 1 min
Open Exchange

Nova aplicação iris-size-django no OpenExchange

#Innovatium #InterSystems IRIS #Open Exchange

Por que usá-la?

Esse app oferece uma interface fácil para analisar armazenamento:

  • Filtro por base de dado (namespace), nome da global, tamanho utilizado ou tamanho alocado;
  • Veja a soma dos tamanhos usado e alocado para os filtros aplicados;
  • Exporte a tabela para JSON, CSV, ou XML.

 

Como usar

Siga as instruções no arquivo README do repositório GitHub e configure as definições para conectar à sua instância.

 

Como adaptar às suas necessidades

Já que foi construído com Python e Django, você pode facilmente adicionar métodos de análises específicas em api/methods.py e usar as views em views.py para exibí-las.

Além disso, se quiser salvar os dados analisados numa instância local, mas analisar uma externa, você pode definir o arquivo settings.py para a local e usar iris.connect("host:porta/NAMESPACE", "usuário", "senha") em api/methods.py para a instância externa.

 

Mais informação

Você pode ler minha série de artigos Um portal para administrar armazenamento feito com Django para um passo a passo completo do processo de desenvolvimento dessa aplicação.

Fique à vontade para entrar em contato!

Comentarios (0)1
Inicie sesión o regístrese para continuar
Pregunta
· 10 jul, 2024

Capturing the SQL command sent to Cache for an external system

#Caché

Is there a way to capture the SQL command that was sent to Cache ? I need to know how to do this. Any help would be appreciated. It is from an external application using JDBC or OBDC. Thanks

4 comentarios
Comentarios (4)2
Inicie sesión o regístrese para continuar
Resumen
· 10 jul, 2024

InterSystems Community Q&A Monthly Newsletter #38

#Comunidad de Desarrolladores Oficial #Resumen
Top new questions
Can you answer these questions?
#InterSystems IRIS
Keyboard Mapping in iris session when using Windows ssh.exe
By Jeffrey Drumm
Migrating source control projects from Subversion to Github with IRIS
By Kevin Kindschuh
How to "real" training a machine learning model
By Kurro Lopez
Component registration
By ala zaalouni
Global Mirroring
By Meenakshi Muthu
Increase performance of production
By Meenakshi Muthu
Deferred lock
By Meenakshi Muthu
Error: Invalid Community Edition license, may have exceeded core limit. - Shutting down the system : $zu(56,2)= 0
By Moussa SAMB
Polybase and IRIS
By Adam Doherty
Why does the Rule Editor display a sad face?
By Joshua Wigley
Which are the best practises to handle large JSON?
By Pietro Di Leo
%DynamicObject (JSON) Response into Class Structure
By Scott Roth
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "IRIS"
By Saghir Hussain
Error importing globals from Caché to Iris
By Josep Balagué
Global can be shared by all namespace
By Meenakshi Muthu
How to read from a file
By Smythe Smythee
%session & passing credentials between ZenPages that reside on different healthshare servers
By Carl Maklad
How to call another method in a generated method
By Shuheng Liu
How to send WRITE formatted output to a variable
By Lynn Lantz
CREATE TABLE AS SELECT fails when one specific field is present
By Stefan Schick
How to convert an embeddings vector to be saved as %Vector
By Ditmar Tybussek
Problem with handling Nacks/Errors on IRIS
By Ali Chaib
How can i see the request size in kilobytes/megabytes?
By omer
Migration from Intersystems IRIS to Oracle DB
By Meenakshi Muthu
OnInit() Question - Ens.BusinessOperation (HTTP.OutboundAdapter)
By Scott Roth
#InterSystems IRIS for Health
Best Practice Question - Connecting to REST API's outside of the network
By Scott Roth
JWT enabled FHIR Server web app access
By Ashok Kumar
VS Code client-side editing and class/package changes
By Robert Barbiaux
How to pass the cloned-object from one rule to another, and send the modified object to target Process or Operation in Rule Editor?
By William Liu
Has anyone worked with in Fhir R4 Binary deserialization (From Athena)?
By Victor Castanon
Testing XML input to Router Management Portal or via XML document viewer
By Thomas Haig
Handling non-8-bit characters in HTTP headers.
By Otto Medin
Why do I have running jobs with no Process ID?
By Chris Pursey
Interpreting Application Error Log
By Kim Trieu
Create a unique constraint on an existing table
By Michael Wood
SQL DatePart Not Working With ISO 8601 Formatted Date & Time
By Carl (booz Allen) Deitrich
Looking for examples of creating a JSON web service as "business service" and converting the JSON data received to a HL-7 message in a Transformation.
By Will
Recommended way to read ???? ?? ??? files
By Yone Moreno Jimenez
How to remove line feed and carriage return from start and end, but not from the middle of a string
By Yone Moreno Jimenez
How to apply huge amount of Biz Rules on a cloned object by using Rule Editor?
By William Liu
#InterSystems IRIS BI (DeepSee)
#Ensemble
#HealthShare
#TrakCare
#VSCode
#38Monthly Q&A fromInterSystems Developers
Pregunta
· 10 jul, 2024

Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "IRIS"

#ODBC #SQL #InterSystems IRIS

Hi

I get the following error when I am trying to create a linked server connection via MS OLE DB Provider for ODBC Drivers in MS SQL Server Management Studio. The message I get is:

The OLE DB provider "MSDASQL" for linked server "IRIS" reported an error. The provider did not give any information about the error.
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "IRIS". (Framework Microsoft SqlClient Data Provider)

I have setup the InterSystems ODBC setting on the server. Have enabled a number SPN settings but still getting this error

The full error message is :

 

===================================

The linked server has been created but failed a connection test. Do you want to keep the linked server?

===================================

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType, Boolean retry)
   at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(String cmd, Boolean retry)
   at Microsoft.SqlServer.Management.Smo.LinkedServer.TestConnection()
   at Microsoft.SqlServer.Management.SqlManagerUI.LinkedServerProperties.DoPreProcessExecution(RunType runType, ExecutionMode& executionResult)

===================================

The OLE DB provider "MSDASQL" for linked server "IRIS" reported an error. The provider did not give any information about the error.
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "IRIS". (Framework Microsoft SqlClient Data Provider)

------------------------------
For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqls...

------------------------------
Server Name: ........\..........
Error Number: 7399
Severity: 16
State: 1
Procedure: sp_testlinkedserver
Line Number: 1

Any thoughts?

2 comentarios
Comentarios (2)1
Inicie sesión o regístrese para continuar
Pregunta
· 10 jul, 2024

Component registration

#Interoperabilidad #Python #InterSystems IRIS

When registering the components: I used this command:
"Utils.migrate("/external/src/CoreModel/Python/settings.py)" ;
The error appears: "An error has occurred: iris.cls: error finding class",
I changed with these two lines:
result = subprocess.run(["iop", "-m", "/external/src/CoreModel/Python/settings.py"], stdout=subprocess.PIPE, stderr=subprocess.PIPE, check=True)
subprocess.run(["iop", "-m", "/external/src/CoreModel/Python/settings.py"], stdout=subprocess.DEVNULL, stderr=subprocess.DEVNULL, check=True)
 also there is an error:
"An error occurred: Command '['iop', '-m', '/external/src/CoreModel/Python/settings.py']' returned non-zero exit status 1."

Could you please help me?
 

2 comentarios
Comentarios (2)1
Inicie sesión o regístrese para continuar