Caché

Syndicate content 124 

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
190

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
296

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

382

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
388

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
522

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
300

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
246

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

324

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
264

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
411

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
388

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
279

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

355

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
257

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
313

views

0

rating

Hi,

I have a process that is importing lots of data from an external file, but every now and then I come across a STORE error.

I know that the STORE error is occurring in the %Save method of the class but I know very little else and I think its something to do with a lage amounts of Related Objects.

Is there a method of finding out more information regarding this error i.e. which actual object was being saved etc etc.

Thanks

Jim

Last answer 16 November 2016 Last comment 17 November 2016
0   0 4
824

views

0

rating

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.

cache version :

Last answer 10 November 2016 Last comment 10 November 2016
0   0 3
732

views

0

rating

Hi Everyone,

         I have frequently received this below error message in my ensemble 2009 Cconsole log.

         " 11/08-13:05:06:114 (9784) 2 Skipping SET due to compare and swap failed on ^["^^e:\test\data\"]Debug("CalcTotal1") for records in e:\test\data\ addr=39745548 "

        Please explain this, am very much trouble with this alert. And also want to know it will cause any system hangsup ?

please response quickly. Thanks

Archunan K.

Last answer 8 November 2016 Last comment 10 November 2016
+ 1   0 2
289

views

+ 1

rating

Thanks for all replies in advance.  In monitoring our audit log we are getting the error below.  We have 4 different servers running CACHE  2014.1.1 and this is happening on all 4 of them.  I have not been able to find what process is trying to logon but it is happening every 30 minutes.  We have no user processes that are running so this has to be a CACHE process.  Does anyone have an Ideal what could be running to cause this?  What kind of trace can I run to determine what process is running it?

Last answer 9 November 2016
0   0 1
0

comments

298

views

0

rating