Questions & Conversations

Hello there, I have created a subroutine/stored procedure to have the AD groups automatically synchronized using an SQL Agent job. Initially this job starts up fine (every evening at 20:00), but after some time the job fails with the message below: Executed as user: {service account}. <msg id="not_authorized_usr_admin"></msg> [SQLSTATE 42000] (Error 50000).  The step failed. If I then manually kick off the stored procedure, the job will function correctly again for some time. Below the stored procedure which is used: declare sync_ad_groups cursor fast_forward for select usr_grp_id, active_directory_grp_name from iam.dbo.usr_grp where 1 = 1 and usr_grp_type = 1 open sync_ad_groups fetch next from sync_ad_groups into @usr_grp_id, @active_directory_grp_name while @@fetch_status <> -1 begin if @@fetch_status <> -2 begin exec iam.dbo.task_import_active_directory_grp @usr_grp_id =

Are process flows executed in mobile? I've created a simple proces flow that would help mobile users a lot when filling in a checklist… After update progress to the next row… That's all.But it seams the processflow isn't callled at all (in the mobile viewer; I'm still in the test fase).Am I missing something here or are process flows not executed in mobile?

It seems impossible to import rows to the column defintion in TSF because of mandatory fields.    

I have the web gui on an Azure App Service. But I notice the “Logs” folder isn't created, and if it exists the files aren't placed there. I use this ini settings: Server = server.database.windows.netDatabase = iam-databaseRuntimeConfiguration = RDBMS = SQLSERVERMetasource = IAMLanguage = engAuthentication = rdbmsExecutionmode = developerCSVLogging = TrueLogToFile = Yes When I copy the GUI folder with the same ini to a local IIS application it does create the folder and a Debug.log on start-up. Do I have to do a bit more on Azure, or am I looking at a bug?

Is it possible in the control 'progress bar’, to don't show the 0% if the value of the column is NULL? I would like to show the progress bar, however when the value is NULL, there should not be a progress bar. When the value 0-100 is used, it should be shown.

This topic is kind of a follow up on this topic:https://community.thinkwisesoftware.com/development-13/open-a-screen-first-time-and-ignore-it-the-next-time-1251 Because our application is a bit overwhelming the first time you start it, or the first time you’ll use features / subjects in the application, we want to help the user. We’ve found a tool called “Inline manual”. A video about what it does can be seen here: https://inlinemanual.com/product-demo/. In short you can “walkthrough” a user, show tooltips to help the user etcetera. Easily explain some actions step by step what to do. Simple things how the look-ups work, how you can add records etcetera. First time users really need some help, and that could be perfectly done by such tool. This could be an enormous improvement in “User onboarding”. Please note we only use the Web GUI, and are tempting to use the universal GUI as soon as it is feature complete for us. As we’ve tried to see if it’s interesting for us we’ve encountere

In IAM it is possible to configure a task to be executed when starting the application. I've tested this and it works fine. It is mandatory to also enter a name for the Startobject, but whatever is entered here, it's all excepted… But I’m thinking of a way to not always execute the task, depending on circumstances or other settings.. A way to get this done might be creating a processflow instead of a task to get this done… This is also an option in the combobox, but I'm not able to select a processflow here… So, what is the use of selecting Proces here if it is not a procesflow in the application?? Or is Proces something else than a processflow in this case?  

I’ve just upgraded to SF 2020.2 and noticed I cannot download / edit the reports:If I click the button (in red) and save the file, it results in a empty file. I did use the task ‘Upload images and reports to database’ according to the manual.I’ve checked the table ‘report’. The column ‘file_spec_data’ does contain some binary data I see, but when downloading it remains empty. How can I edit DevExpress reports?

When pressing enter while adding/editting data in a list, you will automatically go to the next editable field.  However, when pressing enter while editing the last record in the list, you will go to the next editable field in the last line. Our user thinks that is confusing behaviour. The user thinks he is making a mistake and his changes aren't saved.Is there an alternative for this?

We’ve created a system flow that sends e-mails via a ‘queue’ table. We capture the SMTP status code in a process variabele and act according to the response. The SMTP status code will be updated in the queue table.   When testing we try to set-up a recipient with an incorrect e-mail address. The response we expect is status code ‘-4’ (Unsuccessful (one or more addressees could not be reached)) but the result is ‘0’ (Succeeded)   Our task then marks the e-mail as ‘sent’ because SMTP status code 0 is returned. However Outlook itself response with a ‘Delivery has failed’.   Why does the SMTP connector return 0 and not -4?

In the Software Factory (2020.1) I cannot remove a Platform under Project overview > Platforms. It keeps referring to ‘Excluded menus’. But where can I find ‘Excluded menus’? I cannot find it in the Full model and have no clue where to look. (What is an Excluded menu actually?) The DELETE statement conflicted with the REFERENCE constraint "ref_platform_platform_excluded_menu". The conflict occurred in database "SOFTWARE_FACTORY", table "dbo.platform_excluded_menu".  

Hi all, I have a finance overview grid, with three group label. General Cost Revenue Is it possible to have the group label border extend through the grid?  This would greatly improve on the usability.   

Hi,  Is there any solution for the following problem. I have a lot of fields that need to be edited (addresses, money, etc) and that needs be printed. This works quite well, but the client would love to have a wysiwyg-sort of editor.  So, ideally I want to have my text-fields on the left, and a live pdf preview on the right.   Any chance this can be done? Much appreciated!    

Hi,  I’ve a scenario with a sales order with a sender company with related location and receiver company with related location. What is the best approach to make lookups for the both locations? For sender location, it should filter the available locations on the sender company and for the receiver location, it should filter on the receiver company. Both sender and receiver are retrieved from company table and location from the related company_location table. Can I use same lookup or should I create different ones?  I have this scenario for more tables in the application. Thanks in advance.   HJ van Dalfsen

Because of an earlier issue (https://community.thinkwisesoftware.com/deployment-12/what-is-causing-the-clear-panel-message-in-the-panel-informatie-1030), I installed the latest web GUI (2020.1.14). Unfortunately that caused another problem. I am getting the following error: Deze taak kon niet worden uitgevoerd omdat er een component mist. Raadpleeg uw systeembeheerder voor advies. Well, I could ask my system administrator, but I don't think he will be able to help me with this, so I am asking you guys for help. The situation is that there are a few tasks that are being executed managed by a process flow. The first one is a SP and the second one is a task that executes TSFReportMailer. I think the problem is with the second task. Is this a known bug? What can we do about it?

When I create a Deployment Package I notice a difference between the upgrade methods “Smart” and “Full”, also described here: https://docs.thinkwisesoftware.com/docs/sf/creation.html#3-generate-source-code. We often have small changes, so using the upgrade method ‘smart’ is preferred, because a ‘full’ update is quite heavy and can take a while. But when choosing for ‘smart’, the script ‘020_Upgrade.sql’ isn't (always) created. I have this situation for example when I only change a query in a view (no model changes). Why isn't there a 020_Upgrade.sql containing an update of sf_product_info table generated when having only some minor changes?

When the user opens the (desktop) application for the first time, our application might be a bit overwhelming. That's why we want some 'tutorial' or landing page where the software is explained. This could be a web page with some videos embedded in it. This is a bit like downloading a new app on your phone where the important parts are highlighted in a 'scroller view' (each dot is a page) or there is a highlight on certain button or action. The user should keep seeing this window, until he clicks somewhere saying "Don't show again". I did read this post that looks a bit similar: https://community.thinkwisesoftware.com/development-13/how-do-i-set-a-table-as-a-start-object-or-landing-page-when-ever-a-user-logs-in-889 By following the steps described on the link above we could add a menu item with 'first start' and set that as a start object for each user. Problem is that it will start each time, where it's quite difficult for a beginner user to disable this the next time: You have to

How do you translate Maps extender item? I've input the translation objectsd in the extender, but they are not showing in the Translations form.  

Check constraints is only defined on tables. However it could be helpful to define constraints on columns or even domains. Searching on internet I find references that constraints on domains have the advantage of defining them just once instead of defining them for every use. I have not found any information in the community, so I assume there is a reason why constraints are only defined on a table. So what reasons are there for only defining a constraint on a table instead of also defining them on columns and domains?

I'm trying to insert a record via the Indicium Universal OData API. I'm getting stuck on a read only field. Consider the following data model as example: I have the tables project and project_vrs (having a reference between them). Please note that ‘project_id’ is read-only in the table project_vrs, and there is no identity used. If you generate the model you'll see the following screen: The user can open/add a ‘Project’ and via the details he can access ‘project_vrs’. It also allows him to add a project_vrs. My question is, how can I reproduce the Windows GUI behaviour via the OData API? Doing a POST call via Postman inserts the project:   The project_id ‘TEST’ is created. When I try to add project_vrs I get an http 403 error: The Indicium log shows the following interesting line: dbug: Indicium.Controllers.TableController[0] Cannot change the value of the property 'project_id' of 'project_vrs'.The application model prohibits editing this property. This is probably cause

Do temporal tables count as one or two tables for licensing?

I'm experimenting with the OData API and I was wondering what the possible response messages are in case of exceptions / errors. I found out that there's a response header provided called “TSFMessages”, which is base64 encoded. Decoding this value gives a result like below: { "MessageType": "ApplicationDbMessage", "RawMessage": "<msg id=\"import_error\"></msg>", "MessageID": null, "NamedParameters": null} Is there an overview of all MessageTypes? E.g. what can I expect? And what do the other parameters do?

I managed to create an API task to upload images in the application, save a record in the database and store the file in azure file storage. This opens the door to new features  One more optimization could be made for how the storage location should now be included in the API call. I would like to get the yellow marked piece from the settings in IAM. Or rather not want to participate in the API call at all.   Any idea how this could best be solved?

I'm pretty sure I have asked this before (either in TCP or perhaps when calling Thinkwise): is there a way to set the size of a popup (lookup) in the GUI? I've checked TCP but can't find the answer I'm looking for. Neither in the ini documentation (looked for “window”, “size”, “popup” etc etc etc) Either by setting a extended property or in an INI file. And if so, is it configurable per subject (don't think so) and if not, isn't that something to add as a new idea here?

Hi All, perhaps it’s an old bug and is it solved already. (We’re still on the 2018 version, hopefully we will update this summer)  Is anyone know with the behaviour that a list bar menu group is opened when starting the application. In this group is only one item. If we close the group, the group will not open again. It stays closed until we restart the application, and then it’s opened by default. I don’t see any settings in the SF or the IAM related to this ‘feature’