InterSystems Caché is a multi-model DBMS and application server
i have this error
DrawTableError : <MAXSTRING> zDrawTable+349^%CSP.Util.TablePane.2
perhaps i have the possibility of Deleting all history queries, but i think better to check the table where last queries were stored and solve it by deleting wrong registries. anybody knows where is the table 'QueryHistory'.
Hi All,
I have configured my application with IIS 8.5 in windows server 2012.
I have tried to generate sample HTML report . The issue is
when the url is like 'http:\\192.168.1.2\test...mode='html'....' the reports are generated successfully.
but while using systemname like 'http:\\mysystemname\test....mode='html'...' the reports are not generated and throws error like
looking for what the timeout value is for the connection for shadowing. and if it is known the timeout for mirroring also.
I'm currently getting this error and when we go to mirroring it would be good to know also, this way we can go back to our network vendor and give them as much info as possible.
10/19/16-12:19:40:696 (d30b6) 2 [SHADOWING] SHADOW SERVER (PRODSHAD): <ZREAD>ReadNone+3^SHDWUTIL;ERROR #1071: TCP read timed out - remote server is not responding (repeated 16 times)
thanks
Paul
Hi,
I try to programmatically create a parameter for a dataCombo ZEN Component (which is in turn created on the server side at runtime).
Set tParm = ##class(%ZEN.Auxiliary.parameter).%New()
Set tParm.id = "pRegion#"_pExamContainerCount, tParm.name = "pRegion#"_pExamContainerCount
Hi
I'm trying to use the ##class(%File).RemoveDirectory utility to delete a windows folder. The folder has nothing in it, but it is not getting deleted.
Since now i have been working from external connection but i want to work with the SQL utility of Management Portal
i dont know how to do with several instructions like in other editors like this example
update Prod.Articulos set Alto = 1646, Ancho = 16, Fondo = 80 where CodigoNum = '100' and Empresa = 'CO' update Prod.Articulos set Alto = 1646, Ancho = 16, Fondo = 400 where CodigoNum = '101' and Empresa = 'CO' update Prod.Articulos set Alto = 1646, Ancho = 16, Fondo = 400 where CodigoNum = '102' and Empresa = 'CO'
it returns
Hi,
How to change READ ONLY Database to READ/WRITE
Could not find an option to edit it.
PS:
Cache 2016.1.0.656
Thanks,
Sansa.S
Can Cache Monitor (^MONMGR) and System Monitor be configured to also send 'OK' messages? With the first bad email, you still wonder if things are still broken, when in-fact normalcy has been restored, some even within some seconds.
typical examples : -
------ - - - -- - - - -- - -- --- - -- -- -- - - - -- -- -- - --- - - - -- - - -- - - -- --- - - -- -- -- - - --- - - - - --- -- --- - - -- -- --- - - --- - --- -- - - -- -
Sent: Monday, 14 November 2016 11:51 AM
To: Email
Hi All,
I have SourceControl utility class as in sys namespace
Class %MW.Web Extends %CSP.Page {... }
Previously with Cache 2010.1 and below there was no problem accessing it through
localhost:57772:/csp/myns/%MW.Web.cls
But now with newer version at least with 2016.2 I' ll get Forbidden message from it.
With Web Gateway HTTP Trace Facility
Running TuneTable accounts among other the parameter named Block Count. In documentation, we see that this is an approximate numbers of 2K-blocks in which SQL-maps are stored. Databases in recent Cache doesn't support 2K-physical blocks so SQL-blocks are not physical blocks as it seems. So two questions:
- what are these blocks?
- how knowledge about count of blocks can help in SQL optimization?
A new Health Connect customer has a few experienced Java folks on their interface team. As they get more into Health Connect and learn Caché ObjectScript they thought it would be useful to have a list of common Java statements with an equivalent statement in ObjectScript. They mentioned string manipulation as an example, but would be interested in other areas as well.
This seems like something that is probably already floating around somewhere. Does anyone have something like this or other "COS jumpstart for Java devs" materials?
Thanks,
Marc
I'm working on a REST service which will include a binary stream as a request property. I'm currently encoding the stream as BASE64 and passing it as a string value, but I was wondering if there is anything in the Caché JSON support that may be a better fit for encoding this data? Thanks Chris
Hi all,
We've found that in most cases when we open a new CSP session the CGI varaiable %CGIEVAR("HTTP_COOKIE") contains the client name.
It looks like that : "state=SYSADM%3A0; Username=Urish; CSPWSERVERID=Cache for Windows (x86-64) 2013.1.1 (Build 501_1_13062) Sun Aug 11..."
In some other cases this CGI only contains $zv - like "CSPWSERVERID=Cache for Windows (x86-64) 2013.1.1 (Build 501_1_13062) Sun Aug 11 2013 23:20:33 EDT"
Hi,
I have a requirement to convert uname -n (Unix comamnd) with its equivalent Cache class. Can anyone help on this please
Thanks & Regards,
Sadagopan TS
Hi All,
We are accessing the intersystem`s cache database via UNIX ODBC and displaying the data in PHP website . Recently we have upgraded the PHP version to 5.6. We are getting the nondisplayable characters (�) for only strings. But the numbers and date fields are displaying correctly.
While querying the database via ISQL everything working fine (No Special characters).
I have looked around the internet and found the PHP 5.6 changed the default character to UTF-8.
For this issue anything, we can do from cache side.
Thanks in advance.
Hello, I would like to know if CACHE has any limitations on uploading files.
Why am I asking this, why am I going through a problem here.
What happens is that when uploading files or images that are larger than 2.7 MB CACHE is limiting the size to 2.7 MB, any file larger than that is saved corrupted.
Already at the time of uploading the file or image, CACHE is limiting the size of the file to 2.6 MB.
I need to catch the user using a bookmark to get into the application in the 'middle'; i.e. the user is getting into the application not at the home page. I've tried OnPreHTTP to redirect, but I can't catch the new session, and it doesn't redirect.
How can you redirect to the home page upon login?
Thanks,
Laura
Hi,
I am using the &sql () tag to retrieve the value from the Cache DB.
below is the piece of code i am using:
script language="cache" method="retrieveDetail" arguments="pVariable" returntype="%String"
&sql( select columnA,
into :tempVariable1
from TABLE
where COLUMNC = pVariable
quit tempVariable1
i have to return the ColumnA value back to the calling procedure.
can i know how it can be done ? since i am getting an javascript error.
Hi,
I have a problem which i think has a simple solution but which i and others haven't yet cracked. I want to display text output to a text box in monospaced font. At the moment the style sheet is shown below, I have tried various other options such as specifying a specific font such as Courier New. None of the browsers I have tried (Safari, Firefox on OSX, IE) display as monospace, although the last 2 come close. I wonder whether I need a <pre> tag, but I can't see how to do that in Zen.
Suggestions?
Hello!
The question I have today is the next. Suppose I have this simple class describing the REST application:
Good day!
Is there an opportunity to debug the ISCAgent behaviour (in Linux)? ISCAgent uses /etc/iscagent/iscagent.conf as configuration file, but in docs I've found a description only for two parameters (port number and interface - http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...). Other parameters I can see by running /usr/local/etc/cachesys/ISCAgentCtrl status:
If I run SELECT * FROM HS_Message.PatientSearchRequest ORDER BY ID Desc every row has a unique ID but every other row is an exact duplicate. Why would this be?
I try to run the cmd command in the studio terminal, but i am getting the <NOTOPEN> Error.
Even ZF(-1) also not working. Any help, Please!!!
Note: i restart the Cache instance service with full privilege
Code:
Set Path="mkdir E:\Sample\New"
Open Path:"QR":10
Error:<NOTOPEN>
This command working on my PC, but on server throws error.
Many Thanks
Can somebody explain this behaviour of Cache (and many other calculating machine as well) :
WRITE 1/3*12
4
WRITE 1/3*5
1.666666666666666667
W 1/3*18
5.999999999999999999
W 1/3*21
6.999999999999999999
W 1/3*24
7.999999999999999999
How can we make more occurate caculations in Cache ?
I'm writing an operation to use the LDAP Outbound Adapter to query AD.
The operation's settings include a basic Credentials selector, to allow you to use the built in Credentials function of Ensemble. This can be referenced in the operation with ..Adapter.Credentials
Hi All,
How to create a .xlsx or .xls (Activate.Excel ) file using cache.
Thanks,
Sansa.S
Hello Everyone.
Sorry if it is a dumb question, but I'm new.
First: I have to create a Excel MultipleSheet Report. That I'm fine with doing.. but they want me to give every Workbook that is created it's unique reportName, that is generated with the user input on the page. Is it possible to do so?