Since a last IAM Sync today our scheduled system flow won't be executed anymore. Last run was at 2.21: PM (UTC) today but the next run every 3 minutes will be updates, but the task won't be executed.We have both Indicium and Indicium Basic running against this IAM to support both Universal and Windows UI via Indicium.An IIS restart didn't fix the issue, nor a sync of the IAM did fix it.Running IAM 2021.1
We have a task with a barcode as the last parameter that is scanned using an externally connected barcode scanner:According to the documentation, the task should submitted directly, but that doesn't happen.How do I get this working?
HiWe’ve created a Task under ‘email Table’ that will send email & document as an attachment to the Receiver email id when over email_status=’open’ in the Email table. Task(send_status_email) which sends email with attachment Process Flow Design Page When we Start that task to send email - In The process Flow Monitor 1st time the process action are Excutes in this way start_tab_task → decision → decision_attachment_to_disk → write_file, After the write_file Process Action ,an infinite loop will run which always then Go to process action (decision_attachment_to_disk → write_file) from where the process flow Nevers Go to the Process Action SMTP_Connector.process Monitor windowSMTP_Connector Input ParametersProcee Action - Write_disk file input Parameters Need Some Suggestions from some expert who can help to complete this Task.If this information is not sufficient ,Please free to reach me .Regards, Sujit
The Windows GUI produces empty lists in some screens when querying the database via Indicium Basic. In one of these cases the view being queried loads quite some time and then throws a 502 error (verified in Firefox). In another one loading is quick but the server gives a blank answer. In both cases the GUI translates this into an empty list. Both cases are views. Here’s a URL as an example:http://servername/indicium_windows/iam/184/vw_webshop_xml_07_persons?$filter=((bedrijf_nummer%20eq%201)%20and%20(klant_groep_nummer%20eq%2016))I don't see anything particularly weird about this URL.Any ideas what could be the cause?When connecting directly with SQL Server the GUI works fine. However we need to be able to use the end-product off-premise and in some cases the Windows GUI is the preferred method.
I have a task in a tree-view to jump to a given date in the scheduler (calendar). This is a detail tab of the tree view. The task starts the process flow below. Unfortunately the activate scheduler returns status code -1. What could be the reason?
It is very unfortunate that the 'Manual' option is no longer available.We used this option very often to have more control over the scripts that are run on the database. For example, it is not always desirable to perform the Checks and Indexes scripts, especially with larger databases.I would appreciate it if this option comes back in the platform.The Release plan blog mentioned that the creation process has been simplified, in my opinion it is not.
Hi all, I have a question concerning a failed synchronization to IAM. As can be seen on the image below, the synchronization to IAM has failed on the step ‘Synchornizing: project’. However, it doesn't seem possible to abort the failed synchronization. So, how do I abort a failed synchronization to IAM.I have tried to cancel it via maintenance → jobs, but this doesn't seem to work. Additionally, in maintenance → Jobs, the ‘active job’ isn't listed as an active job (second image) Thanks in advance. Failed synchronizationNo active jobError
/-This is more of a SQL question-/For the project I work on I'm in charge of realizing functionality to import large amounts of Product data (ASCII format / .txt file data). The database I work with is placed in a environment where multiple companies work on the same database. In the application, they only see their own data. For example, if 30 companies use the database and all have a pool of 1 million Products, then the 'Product’ table will have 30 million records in total but will only see their own 1 million products.The data that I will import consists possibly over a million records and will be inserted into the single ‘Product’ table. What I'm worried about is that inserting 1 million products in one go will take a very long time, so I want to look at possible ways to accelerate this process and making sure that importing big files does not take hours.I have read about removing indexes, parallel processes and such to speed up the process but I'm not fully convinced it would be t
I want to create users in IAM using API. In order to POST the details , I am using below JSON query as the Body. Its working via Postman, but not through SF. I think the format to write JSON query is not correct. Has someone tried it. Please let me know the correct format to use JSON query in Body of an API.Postman DetailsSF input
When in code review i want to compare code. Normally an external tool would open. My collegues work in Winmerge but the it policy changed and we now have to work in Kdiff3. Iver installed this tool on my computer but when i press the button in TSF it does not open but provides a message:Het systeem kan het opgegeven bestand niet vindenany idea how to fix this?
I have just exported and imported a project version from one Azure tenant to a new Azure tenant and when I now do the creation it fails on creating functions. The reason is that the function to create the tsf_user() has this layout: create function "tsf_user"()returns varchar(128)returns varchar(128)with schemabindingwith schemabindingasbeginWho can help me with this?
When we execute a print task it takes the parameters planning_tekenkamer_onderdeel_id and bgs_bestand. The report doesn't import the parameters planning_tekenkamer_onderdeel_id and bgs_bestand.
Hi,Short question, but since the latest upgrade of the SF the step in page ‘Generate Source Code’This step sometimes takes around 15 minutes. I can’t explain why, since we do not have a crazy amount of ‘Functions’ in the code group: 14. All quite simply functions as well, e.g. get usr_id, get_dateAny thoughts on why this specific step (other are crazy fast!) takes so long, and what can be done to fix it? Thanks! Blommetje
I'm trying to convert some trigger logic to default logic, because I would like to use the 'system versioned tables'. Having triggers causes a lot of records in the history table, which isn't necessary.I'm currently using a trigger to update the 'update_user' and 'update_date_time', and also an update_counter for preventing concurrent editing. I've tried to set up a default which sets the update_user and update_date_time. Problem is that it's only fired when a column has default logic enabled and the value is changed. What I want is that the default is also triggered when the user starts editing. Or maybe after he's done editing. Then I would like to update the update user / datetime. When inserting a record this happens (e.g. @cursor_from_col_id is null), but when editing it isn't.A work around is passing all table columns to the default, but I don't want this because it's unneccesary and a performance killer.Any suggestions on this case, preventing unneccesary records in the history
Every time I run ‘Creation’ de upgrade-file gives me back 4 tables which not have been changed for months. Luckily, these are not the biggest tables but it is very confusing to see not only he tables that really needs to be converted. What could be the reason they keep coming back ?
After upgrading 2023.1 to 2023.3.12.0 the icons in the menu and the tasks are lost.
What could be the reason that table icons are not shown on detail tabs in de Windows GUI?I am currently using WinGUI 2021.3.10 on a SF 2021.2 model
Hi , I am getting below error , its not the issue with reference as stated in This is is only coming in the acceptance environment.The same set of data used in developement environment works well.Can you please let me know what I am missing?
Is there a way I can set a keyboard shortcut to execute a (specific) task so that I don't have to use the touchscreen in the Universal GUI? Thank you very much.
Hello, So I have 2 tasks on two different tables. I have an id on the first table and I want pass it as a parameter on the second task, I do not have a column for the id in the second table. I tried to put it as an output in a process flow but it's taking the id as null.As you can see in the images below in the first task I have the current_id but in the second one is null. This is the first taskThis is the second task
During the generation process I get this error, while the correct Storage location has been set in the IAM of TSF. I need to know why we get this error. How can we find out what is causing the error?
I ran into a problem in Thinkwise which caught me by surprise.I was testing a task that uses a taskparameter with weight as domain:As shown above the domain is a NUMERIC(9,2)When I try to enter a point or a comma into the resulting task field I get nothing. But my colleague is able to enter the decimal separator. For example 38.5 becomes 385 on my system and 38,5 on my colleagues system.I figured out it had something to do with the fact that my windows keyboard profile isn't 100% standard: When I restore the decimal separator and number grouping character back to the Dutch default (comma and point) instead of my preferred point and space TW works fine again.Is this a known issue? Is there something that I can do to work around this (other software on my PC prefers the point as decimal separator ;) )
If we don't have outlook open we get the following message when using the mailer:If outlook is open then the mailer does start up in outlook.
Good afternoon,I have added columns to some of the tables in my data model, but when trying to deploy these changes, the upgrade code group is not generated, leading to errors in the checks code group because the new columns are not created:What can be the issue here?
Since the introduction of temporal tables, code history tables are gone. But when we make changes in templates, we sometimes like to simply see the complete code history, also changes made in previous project versions (/ branches).I don't think code the Code Review tab doesn't work that easy. Or do we miss something?
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
