I have generated a class using the linked procedure wizard however I can't get it to work if the datatype of one of the parameters is VARCHAR(MAX). It works fine if I change it to say VARCHAR(500) and rerun the stored procedure wizard.

I get the following error returned.:

ErrorMsg: SQLState: (07002) NativeError: [0] Message: [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error

0 12
0 1K
InterSystems Developer Community is a community of 23,770 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

In old Caché versions it was possible to create a new role based on predefined %Developer by copying it and adding some resources as needed. It was true at least from 2010.1 to 2015.1.

After upgrade from 2015.1.4 to 2017.2.1 it turned that it's only partially true now. User with a "New-Developer" role can enter Studio and open existing cls/mac/etc for editing and everything is OK unless he tries to create something new (Ctrl-N), than he gets a pop-up with %msg: <User xxx does not have enough privilege to execute stored procedure %CSP.StudioTemplateMgr_Templates>

1 3
0 505
Question
· May 30, 2018
Git / Atelier question

I posted a question here about a week ago about GIT. I believe we understand it well enough to use. We are still trying to determine the best flow for our needs.

But now the question is how do we integrate this with GIT?

We are new to both Git and Atelier and would love to get advice.

Currently I believe the flow would be something like this:

1.Create a branch from our origin repository (let's say Ticket 123 branch)

2.Download that branch locally to our PCs with Cache running a local instance

3. Checkout Ticket 123 branch locally

0 4
0 584

I was wondering if there is a way of adding additional headings under the settings tab for services etc?

I'm aware its possible to add items under the additional settings heading, but being able to split these out into separate headings would look a lot nicer.

0 2
0 258
Question
· Nov 1, 2016
WebSocket proxy to telnet

Is there any easy way to create a WebSocket to Telnet proxy within the Cache environment?

I would like to use a html5 telnet emulator to connect to cache, but need to create a proxy,

Is this a simple task?

0 8
0 1.6K
Question
· May 30, 2018
Change property heading

Release 2017.2.

I have created a class that extends Ens.BusinessOperation, and in my class I have defined a custom property. How can I change the property's heading that is displayed on the Management Portal Settings tab?

0 3
0 321
Question
· May 23, 2018
DeadJobAlert question

We have received a dead job alert. We want to know when occurs this, I mean, Ensemble kills a job automatically if it is consuming a lot of memory or CPU? Or is the operating system who kills the job and Ensembe detects it and alerts?

0 1
0 497

Hi,

We want to monitor an Ensemble Production and send custom email alerts in function of some Rules. For example, if we normally receive 1 message per second, if suddenly we receive 5 or more messages per second, we want to send an email alert. And if tomorrow we don't want to check this again, we want to disable it through Ensemble Business Rules.

0 4
0 1.2K
Announcement
· May 25, 2018
Atelier 1.2 has landed!

Just now when I started up my Eclipse I was offered an Atelier update. After waiting for so long, how could I possibly refuse? Wish me luck! laugh

1 8
0 577

I have a vendor that is sending me an Abbreviation in FT1:16.4.2 that I need to look up against a table to find the correct ID for.

FT1|1|||20180523161501|20180523161503|CG|1906551^Lipid Profile|||1||||||^^^ LAB&06CL|||Z00.00||00410^Knerr^Joel||721410||30100001^Lipid Profile|

But in my Business Process when I refer to request.GetValueAt("FT1:16.4.2") its not recognizing that this field contains information. Is my syntax wrong?

0 5
0 868

While testing Atelier 1.0.255 I noticed that the namespace subtree of my Atelier project used different icon shading for the top-level Classes folder compared with the top-level Routines one:

Drilling down into parts of the Wasabi package helped me work out the significance of white-filled icons versus brown-filled ones:

A package is white if there are no classes in it, but only subpackages.

1 8
0 533

Hi - is anyone successfully using Atelier on a Mac? I seemed to have installed everything correctly but I cannot create Atelier projects or edit mac routines. Eclipse is giving a lot of spurious errors. I have yet to find anyone that has a good word to say about Eclipse and they all use other IDEs but that's what Intersystems have chosen. If people are able to use it on the Mac then fine, I'll just carry on googling... Thanks

0 3
0 449

Hi All

I'm looking for the a simple-quick-easy solution to monitor a SQL table thought Ensemble.

I have a process that update a DataBase ,a scheduled task that runs every night (Not Ensemble)

In the end it updates a table (replica_status) with a new recored with two fileds: Id, DateTime

I looked around the community but didn't find an answerd case.

I'm thinking on a Task that will run a sql outboud adapter BO that checks that table and send a alert if no new record was created yesterday

is this the right approach or is there's a better solution?

0 5
0 470

Hi Community!

New session recording from Global Summit 2017 is already on DC YouTube Channel:

SQL – Things You Should Know

https://www.youtube.com/embed/7fQ_ozYtAqk
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

1 2
0 538
Question
· May 7, 2018
Load data from excel

Hi everybody,

I need to load data from excel to a class in cache, but this class has foreign key and property like AS ..... (other class). This class represent an item product that belongs to a line, the line blelongs a group and the group belongs a Category.

Example:

0 5
0 1.9K

Hi,
I created a REST service that works well if called via VPN, for example the url http://192.168.10.60:57772/fm/status returns a JSON string as expected.
If I replace the ip 192.168.10.60 with the ip used for our public website nothing happens. If I remove the port :57772 the browser returns a 404 error page.
Do I have to use a different port or is this caused by the settings of our web server? (We are using Apache Web Server: Apache Cache_Server_Pages-Apache_Module/2016.1.0.656.0-1601.1554d)

0 4
0 474

Hello; we have users on the system with cache logins. They have access to a specific namespace, and no access to %SYS of course. I'd like to give each user the ability to change his own password from within our application, using Security.User.PasswordExternal. This only exists in the %SYS namespace, and the average user can't get to it.

Should I give the users access to this column in this table (column Password, table Security.Users)? What about access to the namespace? Is this possible? Has anyone done this before?

Thanks,

Laura

0 10
0 1.3K
Question
· May 18, 2018
Database not mounting

Hi Guys,

I'm upgrading Cache 2008 to 2014, and for two clients so far all good, but with this third one and while trying to mount the main database that includes the data, I'm getting error #36 "database is not mountable"!?

but cache instances the old 2008 and the new 2014 at installed the same way (8 bit) and Cache.dat is (archive) NOT read only so I don't know what could be the problem?

Thanks

0 9
0 1.5K

Some of the templates in Atelier display "on" in the "Auto Insert" column. I can't figure out how they differ from the ones that aren't so marked. Some Googling suggests that it should insert without displaying the template popup if there is only one matching template. However, I see the popup every time.

0 5
0 422