Rechercher

Question
· Mars 8, 2018

Instance is down although there is process attached to shared memory

While trying to start the instance INSTANCE001, getting below error, where cache.shid file doesnot contains anything.

This is in a Linux server.

Any help is appreciated.

$ ccontrol start INSTANCE001

INSTANCE001 startup failed: Instance is down although there is process attached to shared memory

You can get the shared memory ID in cache.shid file

then run 'ipcs -m -a' to see the number of processes still attached.
7 Comments
Discussion (7)2
Connectez-vous ou inscrivez-vous pour continuer
Question
· Fév 20, 2018

How to start with Zen mojo application

Hi Guys,

I would like to develop a login page in Zen mojo application with Desktop and mobile application.  It should be adopt with desktop, android and iOS application.

If any lead would be appreciated. 

Thanks,

Arun Kumar D. 

4 Comments
Discussion (4)2
Connectez-vous ou inscrivez-vous pour continuer
Question
· Fév 9, 2018

Execute store procedure in SQL database problems

Hi, I am trying to execute a store procedure within an ensemble operation to connect to aMsSQL database and I am having problem to pass the input arguments... I have tried several things but only one seems to work and it is not the ideal solution.

ADAPTER = "EnsLib.SQL.OutboundAdapter";

This is the code that works...as you can see the parameter is added to the sql query...not the best solution but the only that works at the moment.

SET SQLQuery = "EXEC [dbo].[xxxx] '" _ pRequest.RawContent _ "'"
SET tSC=..Adapter.ExecuteProcedure(,,SQLQuery,)

I have tried to call a store procedure that does not expect any parameters...and is also working:

SET SQLQuery2 = "{ call Test }"
SET tSC = ..Adapter.ExecuteProcedure(,,SQLQuery2,)

But when I am trying to do the call right based on the documentation...it is not working:

SET SQLQuery3 = "{ call xxxx(?) }"
SET tSC = ..Adapter.ExecuteProcedure(,,SQLQuery3,,"aaaa")

What the ExecuteProcedure is returning is a error message that includes the following:

<Ens>ErrGeneraln SQLState: (HY001) NativeError: [0] Message: [Microsoft][ODBC SQL Server Driver]Memory allocation failure 

Store procedure:

ALTER PROCEDURE [dbo].[xxxx] 
    @HL7MSG                        varchar(max)AS
BEGIN

Looking at the documentation that call seems to be right and looking at some examples I got from internet...everybody seems to use that call same way...but not sure why it is nor working for me.

Can anyone see any problem or help me with this please?

Thanks

9 Comments
Discussion (9)0
Connectez-vous ou inscrivez-vous pour continuer
Question
· Fév 5, 2018

I am curious about Terminal function

Hi global developers!

I am using terminal but I have some problem with it.

I use $C(1) (ascii code 1) to separate data but I can't see it in the terminal and This is really hard to see in the table.

So I want to get you guys good brain and skill :)

how can I see it in the terminal ?

Terminal(intersystems) :

I can't see anything

another program :

It replaced ascii code 1 (=SOH) to  ┌ (Special Character)

I want to see like another program in Intersystems's terminal.

Thank you smart developers!

3 Comments
Discussion (3)0
Connectez-vous ou inscrivez-vous pour continuer
Question
· Jan 29, 2018

Guidance on modifying class definitions and switching my application to the new definitions

Hello,

I have a property which I need to move from one class definition to another as follows:

Old definition:

Class SCHED.SchedEntry
{
  
  Property Experiment as %String;

  Property ScanSlot as list of TracerEntry;

}

Class SCHED.TracerEntry
{
  
  Property Tracer As %String

}

I want to move the Experiment property to the TracerEntry class so that there is a different Experiment allowed for each ScanSlot, like this:

Class SCHED.SchedEntry 
{

  Property ScanSlot as list of TracerEntry;

}

Class SCHED.TracerEntry 
{

  Property Tracer As %String;

  Property Experiment As %String;

}

We already have an application running on our production system using the old class definitions, which contains a lot of data.

What are the best practices for updating the development system with the new definitions and migrating the data?  It seems to me that if I compile the new classes, I will no longer be able to access the Experiment property in the SchedEntry class. 

2 Comments
Discussion (2)0
Connectez-vous ou inscrivez-vous pour continuer