Caché

Syndicate content 127 

Short question: Why are (almost) all Java-Classes marked as deprecated? I never had any problems. And the docu for java-bindings are still (version 2016.2.1) not marked as deprecated. I ask, because in my case everything works and the writing of Unittests is easier than in Objectscript and i cannot find a note about the reason of the deprecation (at least in the classes i have checked).

Last answer 18 January 2017
0   0 2
0

comments

324

views

0

rating

I want do to a "simple thing". Show a dynamic log of actions in the browser as we can see on Terminal. For that, I guess to make a simple CSP Page that show a new line every WRITE command is the thing I need.  

But how I refresh after each WRITE?

How I can refresh the content automatically?

I made a simple CSP Page and in method OnPage I do this test:

    write "Start..",!
    for i=1:1:10{
        hang 1
        write "Doing "_i,!
    }

 

Last answer 16 January 2017 Last comment 16 January 2017
0   0 1
237

views

0

rating

How do i do the following:

Pass multiple values from one class to an excel report class using multiple tabs?

 

I want to request the data in the request class using a SQL statement changing values in the SQL statement, and then parse the values to the excel report to each sheet respectively.

 

How do I do it?

Last answer 16 January 2017
0   0 1
0

comments

181

views

0

rating

I'm currently re-engineering an application from CSP pages directly accessing COS Methods, to an Angular/Material front end accessing a REST DAL.  Both the Angular front end and REST services are hosted from the same Caché instance and the same namespace, but the REST services have their own CSP application, with all calls being routed through a Dispatch class.  

Last answer 5 January 2017 Last comment 5 January 2017
0   0 2
292

views

0

rating

the boss started using his new mac laptop, and now we are getting macintosh's own html escape characters being stored in the database especially in our text blocks, when we then print it we see things like don%u2019t instead of don't

so for example instead of the apostrophe we see %u2019 being stored. We've already noticed %u2018, %u2019, %u201C, %u201D, %2026

I'd like to replace the %u2019 with the nearest equivilent (especially when he starts to use left and right quote marks)

Last answer 5 January 2017
0   0 1
0

comments

203

views

0

rating

Hello community!

After reading a lot near InterSystem's Jobs and Terminal I/O documentation sections multiple times, I still does not understand one concept.

Maybe this question will be kind of incorrect, but please take it as is: is it possible to change the current device to be terminal device?

Let me explain what I want to achieve.

Last answer 2 January 2017 Last comment 3 January 2017
0   0 1
210

views

0

rating

I want to generate a list object of routines from the ^$ROUTINE global without directly reading the [^$ROUTINE] global.


E.G. I want to create an array/variable/object with names of all routines that start with "ABC" so that an application process can use each routine name as input for a subsequent process.

Last answer 29 December 2016 Last comment 29 December 2016
0   0 0
322

views

0

rating

I have a server with public web application with Unauthenticated access and there seems to  be a problem that CSP session ends, but associated license persists for some time (hours). If several users log in, we can hit license limit and all the other users get 503 Service unavailable error.

We are currently debugging it and moving to authenticated web applications,  but is there a way to free these licenses quickly?

Here's how it looks like in SMP:

 

 

Last answer 14 December 2016
0   0 1
0

comments

408

views

0

rating

I see that there is an "Insert Special Character" option from the text editor where "é" can be selected, but would it be possible to create a "Caché" button that inserts the word "Caché"? I can see cases where mixing these words can be confusing. An even more important reason would be searching. If the word "Cache" is used instead of "Caché" in many places, it may be difficult to find information about the "Cache".


If a "Caché" button existed, it may encourage the correct spelling to be used. I am not sure if this is a real problem, but I see the possibility of it happening.

Last answer 8 December 2016 Last comment 13 December 2016
+ 1   0 2
424

views

+ 1

rating

Hi,

Thanks for your time.

Plain $ZF(-1) and $ZF(-2) calls from Cache Studio or Terminal have stopped launching the OS shell from Win10.

cmd (Windows Command Prompt) should be launched.

Configuration:

Windows 10 Anniversary Update, Ensemble 2016.2.0.585.0 Developer Edition x64

Is this common? I have enabled both %Developer role and a Cache CallOut privilege for all users that operate in this scenario.

In Terminal, W $ZF(-1) prints -1, W $ZF(-2) prints -1

In Studio, W $ZF(-1) hangs the IDE, W $ZF(-2) prints 0

Last answer 8 December 2016 Last comment 8 December 2016
0   0 1
566

views

0

rating

Hello folks,

      We have recently upgraded the cache (5.x) to cache 2016. All are working perfectly. But i am struggling in Telnet.

Working Good,

      when i connect to telnet it automatically gets the username(for example when we give the system ip addr(148.168.2.50), the ip address is taken as username) and directly goto the Password field in Telnet on old cache (5.x).

Now my problem is,

      I can't get the same from my new upgrade instance 2016. When i connect to telnet  it directly goes to username field but not to password field.

Last answer 7 December 2016 Last comment 7 December 2016
0   0 1
325

views

0

rating

Hello.  When you export and then import a table of data, is the import smart enough to figure out if a row already exists in the new namespace, and if so update the row rather than just save/add the row?

For example, we have a table in DEV, and the same table in QA.  The DEV table has more fields than QA.  When we moved up the class, the field definitions went with the table into QA, so now the table definition is the same in both.

Last answer 6 December 2016 Last comment 6 December 2016
0   0 1
262

views

0

rating

Hello Fellow Caché Developers,

The purpose of this post is to ask for everyone's thoughts and input around the use of transient, SQLCalculated/Computed properties within persistent classes.

This approach allows for extra data values needed in SQL queries to be available without having to join to other tables.

Very simple/basic example to illustrate the topic:

Let's say I have a persistent class named ICDAutoCodeDefn to hold ICD Auto-Coding definitions, such as:

Last answer 1 December 2016
0   0 1
0

comments

348

views

0

rating

I have a class which defines a property as array of %String. Is it possible to index values of this property and use this property in SQL?

I have tried 'Index idx On prop(ELEMENTS)' and then a select from the generated collection table, but this is still orders of magnitude slower than queries to the containing class.

Last answer 29 November 2016 Last comment 30 November 2016
+ 1   0 2
278

views

+ 1

rating

In writing some code on:

Cache for Windows (x86-64) 2015.1 (Build 429U) Fri Feb 13 2015 14:37:23 EST

I noticed an unexpected "ROLLFAIL" error when a Unique Index fail was generated in a %Save() call.

The object SHOULD fail to save, since the Unique criteria is not met, but I didn't expect to see a ROLLFAIL error as the "Last Error".

When running the following class code:

Last answer 17 November 2016 Last comment 28 November 2016
0   0 2
436

views

0

rating

Coming from a C/C++/C# background, I was expecting the & and | operators in Cache ObjectScript to perform bitwise operations on integers, but apparently they don't.

 

I checked the online documentation http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...

but couldn't find any information on bitwise integer arithmetic.

 

So given the following code:

set x = 10  //bit pattern is : 1010

Last answer 27 November 2016 Last comment 27 November 2016
+ 1   0 1
412

views

+ 1

rating

Good Morning,   All replies are appreciated.

We have a development instance of cache that was installed and the person that installed and set it up is no longer here.  We have no id's that we have the passwords for.  I have brought the database up in emergency mode and I can get access thru the terminal using my emergency id but I do not know how to add  a user/password thru the terminal.  Can someone enlighten me or point me to documentation that I haven't found yet.

Last answer 23 November 2016 Last comment 23 November 2016
0   0 1
291

views

0

rating

We tested REST Services  as described for Caché DocServer example and for requests using http protocol it works without problems. However when we use the https protocol for the same REST Service it is not available. Our infrastructure is as follows: Apache with openssl, which works on the other hand well for CSP with https. If we switch on the web gateway http trace facility we could see the request of CSP pages by https://... but again a request of a REST Service by https:// will not result in a entry in the tracer. We hope that this description of the problem is understandable.

Last answer 23 November 2016
0   0 1
0

comments

379

views

0

rating

Hi,

is there a way to copy namespace mappings from another namespace to a new namespace programmatically with a command?

When using management portal there is an option to choose an existing namespace to copy the mappings from, I'm basically looking for the equivalent from command line / COS.

 

Thanks

Martin

Last answer 22 November 2016 Last comment 22 November 2016
0   0 2
273

views

0

rating

I get this on some queries in some namespaces.  For instance, this query:

SELECT TOP 10 SessionId, datediff(s,min(TimeCreated),max(TimeCreated)) as ResponseTime
FROM ens.messageheader
GROUP BY SessionId
ORDER BY ResponseTime DESC

It works fine in HSBUS but in HSREG it throws the error.

Server closed communication device

Does anyone know what would cause this? Would it log something more useful somewhere?

Last answer 18 November 2016 Last comment 18 November 2016
0   0 1
349

views

0

rating