All
Accepted answers
David Hockenbroch · Jun 24 go to post

I'm with you there. The DC AI Bot's automatic answers to every post in the developer community is one of the worst implementations of AI that I regularly encounter. You can write up a correct, thoughful reply to a question here, and then come back two hours later to see an AI post that's been placed above yours in the thread that doesn't fully address the question. If you're also invested in the Global Masters program, it's extra frustrating because you're supposed to be getting rewarded when your post is accepted as an answer, but the AI will come in after you and take that away sometimes. That experience discourages human interaction, which is what the DC is supposed to be fostering. It's also a bit disheartening to see my own articles get misapplied because the bot didn't understand the full scope and context of a question.

David Hockenbroch · Jun 24 go to post

I've had very mixed results with different forms of AI. Just yesterday, I asked Alexa+ to "Continue my Crime Junkie podcost" and it said, "I don't understand what you're asking. How can I continue your crime?" My experience has been that the old Alexa was faster and much more accurate. 

As for technical things, though, I'll sometimes read Google's AI overview for very simple questions, like if I forget the exact syntax of a command I rarely use. For deeper things, I haven't found anything AI that's particularly useful. The catch with AI is that you have to know how to prompt it properly. When I'm first learning things, I don't even know if I'm asking the right questions. AI will answer them, but experienced members of this community will tell me if the question is wrong. A lot of them will also be able to tell me what other followup issues I'm going to hit and advise me there. I haven't seen AI ever address my fundamental misunderstanding of the scope of the issue I'm asking about. That's probably part of why AI has been having such a bad impact on the Dunning-Kruger effect. (Yes, I'm aware of the irony of referring to a video that was probably AI-generated to bring some awareness to one of the negative impacts of AI.)

David Hockenbroch · Jun 8 go to post

The default %JSON.Adaptor will meet most of your needs. One reason I found to modify it was just that I wanted to make its export to string and export to stream methods accessible via SQL. I have that on Open Exchange.

David Hockenbroch · May 11 go to post

I'm not sure it'll be much better performance-wise, but you could make it something like:

AND ((TOURINFO.TNR = TNRHead.TNR) OR (TOURFIND.TNR IS NULL AND SGNRFIND.TNR = TNRHead.TNR = TNRHead.TNR))
David Hockenbroch · Apr 29 go to post

What I've found a written about here may be relevant, but I'm  not sure how to address that issue in your specific use case.

David Hockenbroch · Apr 27 go to post

I have the added wrinkle of writing software for the millwork industry in America. The ' and " are used to denote units of length (feet and inches respectively) so it is pretty common for them to be in the data too, especially in descriptive fields. Ultimately, we usually end up using a | as a separator instead of a , .

David Hockenbroch · Apr 27 go to post

In your record update timestamp, if you change the calculation to use $ZDT($ZTS,3), you'll have the timestamp in UTC.

You can also set up a property compute code as { Set {*} = $USERNAME} to keep track of the last user to update the record.

David Hockenbroch · Mar 26 go to post

If you really want to dig into the structure behind the XLSX files, change the extension on one of them from .xlsx to .zip and you can navigate through the file structure.

David Hockenbroch · Mar 16 go to post

A 403 is forbidden, not page not found. Does the user you're trying to log in as have whatever permissions they need for your web application? You can try temporarily giving the user the %All role, and if that fixes the issue, you know for sure it's got something to do with permissions.

David Hockenbroch · Mar 11 go to post

You could do as Robert said, or you could create an SQL gateway connection to the execution namespace and query it from the original namespace.

David Hockenbroch · Mar 9 go to post

If this is your application and your Entra instance, you may check the application's manifest (in Entra, go to app registrations, click your app, then click manifest) and make sure there isn't an accessTokenAcceptedVersion or requestedAccessTokenVersion that is set to 1. That would require you to use the older endpoints, not the v2 ones you are trying to access. It will need to be set to null or 2.

David Hockenbroch · Mar 2 go to post

No need to get fancy with extra apps and paid services. You can usually email a text message to a phone using plain old SMTP if you know the provider so you can look up the SMS gateway for them. Here are some of the biggest ones, at least where I am:

  • Verizon & Xfinity: vtext.com
  • AT&T: txt.att.net
  • T-Mobile: tmomail.net
  • Sprint: messaging.sprintpcs.com
  • Boost Mobile: sms.myboostmobile.com

If your provider isn't on that list, you can most likely find the SMS gateway via a simple Google search. Then you can send an email using the phone number and that domain as the recipient, and it will go to the phone as a text message with a subject line. For example, if you send an email to a Verizon user, the email address would look something like 5551234567@vtext.com. You can even do this from within Outlook or Gmail if you want to test it out. Mind the character limits, of course.

Several of these are already stored in IRIS. When you create or edit a user, you have an option there to select a mobile provider. You can also add new providers which requires a name and the SMS gateway. These are stored in a table called %SYS.PhoneProviders.

David Hockenbroch · Feb 25 go to post

Thank you for the good review, Robert; That makes me feel like a DC celebrity! 🙂

I have corrected the return types and resubmitted the application for approval for IPM, so once that's approved, this should be fixed.

This kind of very small but impactful tinkering with the existing functionality is one of my favorite things to do.

David Hockenbroch · Feb 11 go to post

That is already true as seen in Vitaliy's comment above. Personally, I prefer to use {}.%New() and then use the %Set method because you can provide a third argument to explicitly say whether the value you are adding is a number, string, boolean, stream, etc. to eliminate any ambiguity. We have alphanumeric fields that should be considered strings, but if they happen to be all numbers, they are incorrectly inserted as numeric values in JSON if we don't specify.

David Hockenbroch · Feb 10 go to post

You would probably be better served using XPath instead of the XML reader. When you evaluate and XPath expression, it will recognize the CDATA and parse it correctly, returning either a value or another XML object.

David Hockenbroch · Jan 27 go to post

If you have Auditing turned on, you can check your audit log for login failures in system management portal. That will tell you why the login failed, which might point you in the right direction.

David Hockenbroch · Jan 27 go to post

Does the test user account have the right security resources to access the database you're trying to log into? The quick easy way to check if you have a security-related issue is to give the test user the %All role and see if the issue goes away. If it does, you need to figure out what resource/role is missing for the user account. You don't want to permanently leave the %All role on there.

David Hockenbroch · Jan 26 go to post

Yes. You can use a variable name starting with ^, like ^MyGlobal, and it will be a global. You will not be able to access it via SQL, but you will be able to see it with the globals in the system management portal. You can also reference globals in a different namespace by using ^|"namespace"|MyGlobal.

David Hockenbroch · Jan 21 go to post

It might be nice to make such tracking conditional. Like "Log all queries that take over 10 seconds to run" or whatever number is appropriate for your usage.

David Hockenbroch · Jan 20 go to post

The only places I know of are, if it caused an xDBC error, that in the system management portal under System Operation, System Logs, xDBC Error Logs, and if it was a query run through the management portal itself, you'd be looking in the global %sqlcq and for your search mask, use %sqlcq("NAMESPACE","SMPQueryHistory","USERNAME" to see the query history for a specific user. That's where the query history you see in the SQL section of the management portal is stored.

I don't know of anything overall, though.

David Hockenbroch · Jan 6 go to post

All we can tell from this is that in the class gen.Custom.HS.Model.OEOrdItem.TabularTextResultsEMR, you have a method called GetData, and on line 872 of the .1 file for that class, you have a variable named rs that is undefined.

David Hockenbroch · Jan 2 go to post

I'll echo the idea that you don't really want to be using the /api/atelier web app this way because of the %Development requirement and the arbitrary SQL execution, and because it includes a lot of other functionality that you probably don't want people to have access to.

BUT if you're really intent on using that API, then you could make your own web application in the management portal that uses the same dispatch class that /api/atelier does and create a new resource to be the required resource to access it. Make sure your users have permission to use that resource, and then assign the appropriate table and view permissions in a role that you either give to those users or assign to the Web Application as an application role.

David Hockenbroch · Dec 26, 2025 go to post

Are you looking for something like:

ClassMethod ExceptionTest() [ Language = python ]
{
    import sys
    import iris
    import traceback
    
    try:
        print(1/0)
    except ZeroDivisionError as e:
        errobj=iris.cls("%Exception.General")._New(str(e),42)
        stack_trace_list = traceback.format_tb(e.__traceback__)
        if stack_trace_list:
            last_instruction_line = stack_trace_list[-1].strip()
            errobj.Location = last_instruction_line 
        a = errobj.Log()
}

Which gives:

David Hockenbroch · Dec 4, 2025 go to post

Page not found, or Invalid Action? If it's page not found, how is the web application configured?

David Hockenbroch · Nov 26, 2025 go to post

@Enrico Parisi , with Global Masters, we get a few points for having an answer marked as correct on the community. People often only mark the first correct answer they see. So if the user who posted the question didn't see this thread before the AI bot's post appeared, it's somewhat likely that the bot's post will be marked as the correct answer even though a human user answered the question first. That's all. Seems just a little unfair to me.