#Caché

All,

In which folder under the "C:>InterSystems>IRISHealth" are the Mumps/cache routine stored? These are the routines created via the Studio module of the IRISHealth application.

Thank you!

Hi,

I have a test version of Cache installed on my laptop, but I cannot get logged into the database. I think my ID may be locked due to too many password failure attempts. I have not changed the Admin password or SuperUser password. Does anyone know what the default password would be for the Admin and/or SuperUser Id's? Or if someone knows how I can get in and unlock/reset my password, it would be much appreciated??

Thanks,

Larry Cardinal

Happy New Year to all

I have a CSP page that throw a "414 error - Request-URI Too Long" when I put lot of text (eg : 10000 characters) into a field of a submitted form. The form is submitted using POST method.

Based on some experiments I made, it seems the max size of a URL is around 8200 characters.

What is the official limit, and is there a way to increase it ? I searched in the documentation but couldn't find anything.

Hello,

I'm inserting a row using an insert statement from dotnet InterSystems.Data.CacheClient.CacheCommand.

Is there a way to get the inserted ID or IDs if I've inserted multiple rows?

Regards, Timo

Similar to: "set obj = ##class(myClass).%OpenId(id)", which give the an instance of the object with given ID, is there a way to implement a function/classmethod to return the same by providing both class name and ID as a parameter, such as: getObjectInstanceByNameId(className As %String, id As %Integer), using ObjectScript code?

When recieivng a response and calling SendDeferredResponse I get the warning below and no response is sent.

Hi,

in our system we usually display an information if someone locks data that another user tries to edit. Like: "Data locked by <user>/<program>"

We have a global that is set at userlogin with following information:

^BA020(0,3,$job) = "<user>;<program>"

We show that information by getting the jobnr/owner from the locktable ^$LOCK("<ref>","OWNER") and looking at ^BA020.

Hello!

Not opening an instance by index key after CACHE migration to IRIS. In composite indices, when one of the values is null, when using idx open it does not return the reference.

Has anyone had this problem?

According to the IRIS documentation, once a user id is identified, at lease one license will remain (forever if I understand it correcly). The documentation says "even if the number of processes under the user ID drops back under the maximum, InterSystems IRIS continues to allocate one license unit per process for that user ID. Only when all connections by the user ID are closed and there are no more processes under the user ID does license allocation reset to one unit for that user ID."

Hello Developers.

I have a question regarding X12 834 file for Payers.

We have a client thats sending X12 834 file with single ST SE block and has thousands of members in one single block and X12 process is throwing STORE error when processing this file.

Has anyone ran into this issue and has a way of splitting 834 file into single <ST> <SE> block?

Thank you in advance

Sheetal

Hi, how do I create a trigger that will only set the value of the "Status" field for new objects, not for all available?

Class CarDealer.Order Extends (%Persistent, %Populate)
{

Property Title As %String

Hi guys.

I need validate a field string in a table. It needs have a specific mask

I want use regex + CASE expression

There is any function to this purpose in SQL?

Hi everybody!

I'm new to a Caché world and need some help! Where I work we are running Cache 2016.1 version in a server, and 2018.1 in another server. I want to upgrade the version 2016.1 to 2018.1, but I fear it can raise some errors tha I cant resolve yet. My doubt is, if I upgrade it will run ok?

Thanks in advance!

Hi,

We have 2 writer threads, each has a connection to Cache. When write records to Cache, we use PreparedStatement.executeBatch() with the batchSize 10 000.

We got very very slow insert speed.

But if only 1 writer thread used, the speed is faster, just as normal.

Any idea?