I have been using the query below and it was working fine but now it's giving a SQL error. There were no changes made that could cause this to stop working. There is no Field 'APPLICATIONID' in the table.

QueueSQL=select distinct (convert(char(5),SkillsetID)+'='+Skillset) from iagentbySkillsetStat where ApplicationID > 10000
QueueMappingSQL=SELECT DISTINCT (convert(char(5),SkillsetID)+'='+Skillset), SkillsetID FROM iagentbySkillsetStat iagentbySkillsetStat WHERE (iagentbySkillsetStat.ApplicationID>10000)

DB- Intersystems Cache

0 6
0 4.3K

Let's say I have a global named ^a and I need to export its nodes 1, 2, 3, 5 only.

Currently I write something like this:

Write $SYSTEM.OBJ.Export("a(1).gbl,a(2).gbl,a(3).gbl,a(5).gbl", "C:\Users\eduard\Desktop\a.xml")

Is there a way to write it shorter? I want to write global node once and list all the subscripts I need.

1 1
0 729
Question
· Sep 14, 2016
Question: CSP Session

Hi,

  I was set one session in user namespce (%session.Data("sup")="login User ").but i couldn't get this session(%session.Data("sup")) in  another namespace.

Cache version:cache 16

but i can acces in cache 5.02.

0 4
0 1.1K
Question
· Sep 15, 2016
Help

Hi All,Cache is not starting ,I checked the cconsole log it is showing the below error.
The following parameters are missing from section [Journal]: '2,12' at line 143,but i checked in last cpf file,
In cpf file consist of that particular line
[Journal]
AlternateDirectory=C:\InterSystems\CACHE16\mgr\journal\
BackupsBeforePurge=2
CurrentDirectory=C:\InterSystems\CACHE16\mgr\journal\
DaysBeforePurge=2
FileSizeLimit=1024
FreezeOnError=0
JournalFilePrefix=
JournalcspSession=0

0 2
0 402
Question
· Sep 7, 2016
Cache Certification

Caché Application Developer certification:

How to I prepare developer certification of cache .What are the topics are preparing certification . Please give the topics .I will start learning of certification course .

1 3
0 1.7K

Hi all,

Do anyone know how to force to close the CSP connection used before redirecting to a different page so a new connection ( and therefore a new session id) is generated?

The idea is to generate new CSP session once we log off our application so the session identifiers are different.

Best Regards

1 4
0 563
Question
· Sep 9, 2016
Stream Property

Hi ,

  We upgraded the cache 5.02 to cache 16.
  we are using stream property in one class .(i.e.  Property notes As Stream;) but it not support in cache 16.
 how handle this problem?

Thanks,
sansa.

0 4
0 456

I know %CSP.Daemon is supposed to clean up old CSP sessions (?). In my management portal, under System/ License Usage, I see 33 "Units" used (and there are 33 licenses in use), but usernames from old IP address and that are not being used. Their active times are often in the millions of seconds. They are not "on" the system right now.

At most, only 3 users are on the system right now.

Are these supposed to be cleaned up? Can I clean them up programmactially, and how would I know if they're not active?

Thanks,

Laura

0 8
0 1.2K
Question
· Sep 7, 2016
Caché on new hardware

A question from Benjamin Linden:

We are looking to upgrade the hardware for our server.

Do we need to buy a new Caché license? Or can we keep using the one we have?

1 2
0 340

Dear Colleagues,

Recently I am working on a Cache project should enable the customer, to update our Cache application independently from us. Our idea is a client (preferred .net) application that will copy all the necessary Cache stuff (classes, routines) into a cache database. For this, we are looking for the appropriate technology – in old times this would be a CacheDirect.

0 4
0 647

If a user simply closes a tab (running a web application), is there any good way to ensure that the license is released AND the login cookie is destroyed?

I found that if the tab is simply closed without first logging out of the application, then 1) the license hangs around forever, and 2) if the user then opens a tab, he is already logged in.

1 5
1 1.9K

Good morning, I have a ZEN application being served up through a CSPGateWay. That ZEN application is made up of two ZEN pages. One ZEN page uses a zenLink to call the other ZEN page(see below #1). The ZEN page that is called contains a tab group with one tab. That tab contains a tif image. I have components on the called ZEN page that execute JavaScript to perform simple image manipulations - zoom and rotate(see below #2). Those simple image manipulations have stopped working.

0 1
0 330
Question
· Aug 25, 2016
ZEN Mojo onEvent() callback

Hi - Trapping onselect and onchange events that occur on layout objects seems to work fine, however, according to the documentation, I should also be able to use onevent, which is defined as follows:

onevent: Defines how the page behaves when another type of event occurs within a documentView (an event other than select or change).

and has the method signature:

1 8
0 434

I've noticed that Management portal somehow manages to allow a single user to be in different namespaces in different tabs in the same application (i.e. Management Portal). I've looked at my Processes, however, and see that all of my processes using MgmtPortal think I'm in %SYS, even though 2 of them are looking at globals in two different namespaces; NamespaceA and NamespaceB.

I can even fool MgmtPortal because the first time I try to look at a global in NamespaceA it thinks I'm in %SYS! After a refresh, however, I can see the global in NamespaceA.

0 8
0 779