Skip to main content

Questions & Conversations

Software Factory & IAM (Installation, Development, Deployment, Integration) | E-learning | Documentation | Community

  • 2,918 Topics
  • 10,070 Replies
2918 Topics
P
Vanguard
pvleeuwenVanguard
asked in Questions & Conversations
OAuth connector gives blank screen

I am trying to use the OAuth connector to make a synchronization with the tax service platform of the British Government. I have followed the docs and set everything up accordingly. However when the proces action of the OAuth login connector is reached, a white screen comes up and nothing is happening. I assume thinkwise is adding the client_id, scope and redirect_uri to the Authorization URL? I was hoping to find more information in the debug screen to find out what URL’s etc are being called, but that is not the case. Can someone tell me what I am doing wrong here? I below screenshots you can see my settings. Settings in OAuth servers White screen. Nothing happening. My proces flow

41417
P
Vanguard
Freddy
FreddyThinkwise Local Partner Brasil
asked in Questions & Conversations
Universal GUI performance

What could be the reason a query is taking way more time through the GUI than direct on SMSS? If I copy this query into SMSS and execute it, it's done instantly. While via the GUI it takes quite some milliseconds.

26516
Freddy
Freddy
FreddyThinkwise Local Partner Brasil
asked in Questions & Conversations
Indicium - Initial connection takes a long time.

What can be the reason that the initial connection takes seconds… I have another query that runs 5 ms direct on DB.. and this time I see that it stays for seconds in initial connection. and after 6.7 minutes it's done..

463
Freddy
M
Sidekick
Marco KleiwegSidekick
asked in Questions & Conversations
Problem Automatic license renewal 2021.1

The license is not automatically renewed.The registration has been successful.Starting the IIS application manually also works fine; when i start it as administrator as well when i start it as de pool-user.Automatically it does not work. I'm working with the installation 2021.1 I have checked the problemsolving: idle-time is set to 0 and startmodus is AlwaysRunning. The authorization on the wwwroot-map is set correctly. So beats me. What can i do? Who has any ideas?

1438
V
Moderator
Freddy
FreddyThinkwise Local Partner Brasil
asked in Questions & Conversations
Filter Form with required values

I have a table with over 48 million records and I would like, besides some default pre-filters, to have the filter form pre-filled with an option and let the user alter these selections ( they are combo's). On of them is company type, can I give these fields by default a value and make sure that they cannot be empty?

612
Freddy
Freddy
FreddyThinkwise Local Partner Brasil
asked in Questions & Conversations
Indicium DB log

What is the reason that the dbEventLog is not reachable? This site can’t be reached The webpage at https://coragem.lef.tec.br/indicium/account/ui/dbEventLog might be temporarily down or it may have moved permanently to a new web address. The Universal is directly pointed to the SF. And will this also be available for the Indicium log? Now I have to every time go to the indicium URL download the log file.. would be easier to see it online with the latest messages.

462
Freddy
E
Sidekick
efitskieSidekick
asked in Questions & Conversations
Indicium universal throws Access is denied on WindowsCryptographicException in Azure

I’ve deployed the latest version of Indicium universal to Azure according to the instructions (https://docs.thinkwisesoftware.com/docs/deployment/azure#creating-an-azure-web-app). Unfortunately the application does not start with message: HTTP Error 500.30 - ASP.NET Core app failed to start The event log has more information: Application '/LM/W3SVC/1165921035/ROOT/indicium' with physical root 'D:\home\site\indicium\' hit unexpected managed exception, exception code = '0xe0434352'. First 30KB characters of captured stdout and stderr logs:Unhandled exception. Internal.Cryptography.CryptoThrowHelper+WindowsCryptographicException: Access is denied. at Internal.Cryptography.Pal.StorePal.FromSystemStore(String storeName, StoreLocation storeLocation, OpenFlags openFlags) at System.Security.Cryptography.X509Certificates.X509Store.Open(OpenFlags flags) at Indicium.Startup.getOpenIdSigningCertificate() in C:\azp\agent\_work\1\s\src\Indicium\Startup.cs:line 868 at Indicium.Startup.configureIdenti

1372
E
Sidekick
Freddy
FreddyThinkwise Local Partner Brasil
asked in Questions & Conversations
Http connector and large JSON results

I am working on an App and I want to incorporate the economic activities.. these are available via public API. (https://servicodados.ibge.gov.br/api/v2/cnae/subclasses) How do I process this? Because I know use a NVARCHAR(MAX) variable, but I don't think it can hold the whole result? 37.8 MB .. However it does process but only a part of all the economic activities. Is there a way to save the JSON as a file and later on process it?

512
Freddy
K
Vanguard
kensonlatchmansingVanguard
posted in Questions & Conversations
Control procedure effect on API

Hi, Recently I have been encountering some problems with the OData api because of some code written in the stored procedures. Up till now I noticed that the layout and default CP have effect on the api. For instance: I had once written in my layout CP to set some fields on Read-Only if a certain condition is met. Turns out that these fields are also set on read-only for the api, which results in not being able to update the field via a mobile app and getting a 403 error. Now I have this piece of code (as show below) which I thought would only effect the gui because I specifically added the ‘@cursor_from_col_id’. But now when I use the api to update a record, the status is always set to ‘RGS’ because I have a service type that is not equal to ‘OTH’. Removing the field from the request still doesn’t seem to help this issue. How can I tackle this issue? Is there something that need to be aware of?Thanks

471
E
Moderator
G
Apprentice
g.c.d.vanderschootApprentice
asked in Questions & Conversations
Check constraint comparing values from multiple rows

We have a requirement for which we need to ensure that in a set of rows at least one of the rows does not have an end-date. In below example it should not be allowed to add an end-date to test=3. @Robert Jan de Nie Is it possible to use check constraints to prevent this?

852
G
Apprentice
Dennis van Leeuwen
Hero
Dennis van LeeuwenHero
asked in Questions & Conversations
How to show a coloured svg icon in Universal GUI?

I have added the following three icons in the menu for the Universal GUI, all svg. 1. Heart icon #0044872. Heart icon #0000003. Colour pallet SF | Menus - Design Why does the Universal GUI only show the second icon? The other two icons should be visible in their original color in dark/light mode, right? Universal GUI - 2022.1.11 b1.0

1275
Dennis van Leeuwen
Hero
H
Captain
HarryACaptain
asked in Questions & Conversations
Start merge session with API call

Hi! We’re trying to automate our merging and branching with the SF. As stated in this question it’s already possible to execute a merge session, however I'm trying to also create the merge session. To do this I'm executing the following API call: POST indicium/iam/sf/start_merge_session{ "trunk_project_id": "TRUNK_ID", "trunk_base_project_vrs_id": "1.00_TRUNK_ID_BRANCH_ID_BASE", "trunk_current_project_vrs_id": "2.00", "branch_project_id": "BRANCH_ID", "branch_current_project_vrs_id": "1.00", "merge_direction": 1, "description": "Merge TRUNK_ID 2.00 into BRANCH_ID 1.00", } However this is returning a 403 Forbidden, am I doing something wrong or is it not yet possible to start a merge session with an API call?

1044
H
Captain
K
Rookie
Kasper ForchRookie
asked in Questions & Conversations
Bookkeeping in Thinkwise

Since Thinkwise itself doesn’t profile itself as a bookkeeping system, we have realized an integration with Exact Online for our Thinkwise application. This was recommended by Thinkwise because the integration is relatively easy due to similar code. However, it appears the integration still comes with a log of bugs and errors. Also, our customer isn’t fully satisfied with the working of Exact Online. Are there any other options/recommendations for a bookkeeping system? How do large Thinkwise customers do this (e.g. VDL Nedcar or Zeeman)? Also, how to archive invoices from Thinkwise (as they should be archived for at least 7 years)? Currently we can regenerate an invoice, but we only store data for 2 years. Could this be done efficiently in Thinkwise for 7 years? Or is it perhaps recommendable to archive every single pdf in another database? Any other ideas/suggestions?

551
Hugo Nienhuis
Superhero
MtHoen
Apprentice
MtHoen
asked in Questions & Conversations
"Column name....not match table definition" error when generating definition

Hi, I’m currently getting the following error on generation step “Execute: create_log_tables” in the Generate Definition step of my creation: Error message Error line I don't know what could have caused this, is anyone able to give me a suggestion as to how to solve this? Thanks in advance.

402
MtHoen
Apprentice
Freddy
FreddyThinkwise Local Partner Brasil
asked in Questions & Conversations
Best practice on rolling back an upgrade gone wrong.

When you make alterations to the model, especially the data part that results in an upgrade script. What are the best practices when someone create something that is not accepted by the database. In this case the you can choose to ignore and go on or to abort. To not loose data it's best to go for the abort scenario. But then you get stuck with all the renamed tables and all or partially the new tables already. When you fix the problem, there seems to be no easy way to rerun the upgrade script because with every existing you get an error.. so 130 tables renamed and 130 tables new = 260 messages.. Can there be an option to just ignore the messages? Or can there be an option to roll back the situation by deleting the new tables and renaming the backups back to its original name? Now I just 'hack' my way through it via SMSS, but perhaps the SF can offer something more elegant.

682
Freddy
K
Vanguard
kensonlatchmansingVanguard
asked in Questions & Conversations
Conditional layout with dynamic model

Hi, I have tables which have a is_deleted column. Now I want to make a clear distinction where is_deleted = 1. I can do this with conditional layout where the background color is specific color, but adding this for each table is very time consuming. fyi: My application is in Universal GUI. Is this possible with the dynamic model? If so, how should I do this? Thanks

1229
Mark Jongeling
Administrator
A
Captain
Andre te RaaCaptain
asked in Questions & Conversations
Sorting order cube view fields descending.

I have a cube view with cube view columns sorted descending. When I show the cube with the SF model, it works fine. But when I synchronise it to IAM, it does not sort the columns descending anymore (2021.2). Only when I use the ‘sort by cube field’ (not mandatory) it works also in IAM. Is there a reason for this behaviour?

783
E
Moderator
Randolph Beekman
Vanguard
Randolph BeekmanVanguard
asked in Questions & Conversations
Exchange connector: SendGetAttchment @byte_arry is null when trying to save email atttachment

Hello, We are using the Exchange connector to process e-mails, which arrive on a certain e-mail address, within our ticket system. These emails often contain attachments and are saved using the sendGetAttachment + saveAttachment. However if the attachment is an e-mail the @byte_array will be NULL and will not be saved. Does anyone have an idea why @byte_array is NULL when the attachment is an e-mail? Thanks in advance. Greetings,Randolph

1275
Randolph Beekman
Vanguard
M
Rookie
mehmet kayaRookie
asked in Questions & Conversations
An explicit DROP INDEX is not allowed on index

I created a unique index and I deployed my project. When I try to delete this index I am getting “An explicit DROP INDEX is not allowed on index ‘ sales_person.unique_sales_person’ . It is being used for FOREING KEY constraint enforcement.” error message. I tried to clean install but it didn’t work. It is in software factory version 2022.1 How can I solve this?

15753
Mark Jongeling
Administrator
H
Sidekick
H. LukassenSidekick
posted in Questions & Conversations
transfer our real-time freight data

We need to transfer our real-time freight data via an XML file to our carrier. In what way can I do this safely using Thinkwise?Is an FTP link secure enough for this?

523
Freddy
E
Sidekick
Edwin SaanSidekick
asked in Questions & Conversations
Continous barcode scanning with Android device in universal

Has anyone figured out how to implement barcode scanning in the Universal GUI. At this moment when I scan a barcode in a TEXT field the GUI does not perform an ENTER. So the value is Shown in the field but, the value is not processed by the default because the GUI does not handle the scanning action of the terminal as an entered value. (I already tried different settings on the scanner like HEX suffix 0X0A (Which is the equivalent of ENTER) But the universal GUI seems to ignore this suffix. So the result is that the value is shown in the field and the user always need to do something on the screen. We need to scan a barcode, process it’s value in a default, moves the cursor to another field or the same field. For example, scan a product barcode, scan a location, scan a product barcode, scan a location. A created a test form with only 2 fields and want the default to handle the scanned value and moves the cursor to the following ‘to-be-scanned’ field. Someone has ideas??? declare @msg v

25610
Freddy
S
Sidekick
Spyros.NeofytouSidekick
asked in Questions & Conversations
Is there a way to change the message in the confirm update/delete in the subjects settings so the default buttons can have different messages?

Is there a way to change the message in the confirm update/delete in the subjects settings so the default buttons can have different messages?

1164
Mark Jongeling
Administrator
Freddy
FreddyThinkwise Local Partner Brasil
asked in Questions & Conversations
IAM Application Language per Application

My user ID in the IAM has English as application language, but I have multiple applications in the Universal. How to I set the default Application language for my User? I am create a Portuguese Brazilian App and I cannot find out how I start that one with the pt-BR language by default…

813
Mark Jongeling
Administrator
Blommetje
BlommetjePartner
asked in Questions & Conversations
How is this status presentation made?

Well, my co-worker saw the status bar in the TCP and instantly wants to have it in our system as well. How is this created?

512
Blommetje
Rucha Naik
Rucha NaikPartner
asked in Questions & Conversations
sending an auto generated Email by using SMTP connector

For my project I am trying to send an email as soon as the candidate saves his/her details in the form. I made process using the SMTP connector as per few suggestions via the community. However, the email is not auto generated. Below is my process flow. Initially I used “Activate detail” process action instead of the “Start task”. What needs to be changed in order to generate the email after the candidate saves the details in the form. Process Flow My input parameters The variables have the details for the smtp connection to Zoho mails.

1764
Rucha Naik

Badges

Show all badges
Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings