Questions & Conversations

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

  • 2,377 Topics
  • 8,127 Replies

2377 Topics

J. de Lange
Captain
J. de LangeCaptain
asked in Questions & Conversations

Change detection @col parameter not filled.

Hi,I’m struggling with the change detection. It seems that our @col_id parameter doesn’t get filled (always null). In the docs it says that the column will only have a value when the logic is called if the table to which the column belongs, is shown as a detail. In our case we display the grid of a table and we have the form of this object under a detail tab. Context, layout and default procedures have no problem reading our @col_id but in the change detection, the value is always null.I thought the primary key columns of an object would be available and filled when a detail tab is opened or a row is selected. Is this not the case? Is there a way around this? I would rather not refresh all objects whenever one object gets changed. 

5
Anne Buit
Community Manager
2 years ago
K
Vanguard
kensonlatchmansingVanguard
asked in Questions & Conversations

Tab page in Universal

Hi, Lately I have been trying to group some fields in my form component to another tab. This is very easy to do in web/desktop gui (img.1). img. 1But now I’m trying to achieve the same thing in Universal but just can’t seem to figure it out. My form component in Universal is as seen on img. 2img. 2 Keep in mind I would like do achieve this without adding another table. Is there a way I can do this for Universal GUI? Thanks.

1
Mark Jongeling
Administrator
2 years ago
E
Sidekick
efitskieSidekick
asked in Questions & Conversations

How to automate login to universal to download deployment scripts

We have deployed the Software Factory to Azure. With the new 2022.1 release we are unable to save the deployment .sql scripts. As workaround (or improvement) we can download the files from indicium (/iam/sf/code_file?$filter=project_id eq '<project>' and project_vrs_id eq '<project_version>' and code_file_generated_code ne null&$select=code_file_id, code_file_generated_code)I would like to automate the download process, but struggle to get the login token from indicium.How do i programmatically authenticate to indicium to download the deployment scripts? 

6
E
Sidekick
2 years ago
E
Sidekick
Edwin SaanSidekick
asked in Questions & Conversations

Printing labels on Zebra printer

Has anyone dealt with printing labels on a Zebra Printer. With 2 of my clients I have the same issue that I cannot use the full width of the label.The label is automatically scaled to about 70% of it’s label size.And whatever setting I do, I just does not use the full width of the label.I have created reports in as well Dev Express as SSRS and both have the same problem. With DevExpress If I print my label on a HP Laserjet on A4, the label size is correct. If I print it to the Zebra printer the label is scaled to about 70%.I have contacted Zebra and they told me that the paper size of the label is not correct, but I setup the paper size of the label correctly in Dev Express and in the printer driver itself (I’m getting a bit nuts of this)The label size is 105 x 83. I already tried to change every single parameter step by step, but the label is still scaled to about 70%. The last attempt was a bit bigger but still 3-4 centimers of the label is not used. Preview in DevExpressPage setup i

2
E
Sidekick
2 years ago
T
Apprentice
Thomas OfmanApprentice
posted in Questions & Conversations

Add index in SF for performance optimization in IAM synchronization

We are looking to upgrade our TW software to version 2022.1, and during my tests I encountered some performance issues while synchronizing our latest version. Our performance monitor pointed towards the function look_up_chain_granted. This function is called around 1.5 million times, as our application contains a high amount of Roles. At 1.25ms per execution this could take a very long time. The performance index suggested adding the index stated below and this decreased the avg execition time to 0.075ms, which helped with decreasing the total sync time from almost one hour to just ten minutes.I would suggest Thinkwise take a look at this suggestion as it has helped us very much.CREATE NONCLUSTERED INDEX [<Name of Missing Index, sysname, >] ON [dev_sf_upgrade_test_2022].[dbo].[ref_col] ([project_id],[project_vrs_id],[target_col_id]) INCLUDE ([abs_order_no]) 

3
Mark Jongeling
Administrator
2 years ago
Freddy
FreddyThinkwise Local Partner Brasil
asked in Questions & Conversations

Universal GUI - Maps

Hi. Is there more elaborate documentation available on the Maps component for the Universal GUI? I've read the docs and some postings here, but can't figure it out how I should set it up. And is there also a listing of supported Maps providers? Before I used MapQuest, does this still work? 

10
Freddy
2 years ago
Hugo Nienhuis
Superhero
Hugo NienhuisSuperhero
asked in Questions & Conversations

HTTP connector - encoding - nvarchar

I am using the HTTP-connector to sent a message with content-type application/json. I use a nvarchar(max) variable for the content input. I would like to know whether the http-connector sends the message UTF-8 encoded or UTF-16 encoded.I would like to use a Content-Type application/json; charset=utf-8 but I suspect I have to encode the content as UTF-8. Is this best done using a varbinary(max) or should I do this in a different way? Hope anyone can help.

2
Hugo Nienhuis
Superhero
2 years ago
Freddy
FreddyThinkwise Local Partner Brasil
asked in Questions & Conversations

Process flow to send report (SRSS) to an email

Anyone has experience with how to set up the flow, especially how do I catch the generated PDF from de start_table_report to be able to send it by email?  Where does it, by default, get saved? 

12
Freddy
2 years ago
Freddy
FreddyThinkwise Local Partner Brasil
posted in Questions & Conversations

Universal GUI - Filter condition not changing

Since the latest Universal GUI you can change the filter condition. I have a key field that keeps showing up as 'contains' in stead of 'equal to' (as defined in the SF).. It's a numerical field. Any ideas?

6
Mark Jongeling
Administrator
1 year ago
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.. 

3
Freddy
2 years ago
Freddy
FreddyThinkwise Local Partner Brasil
posted in Questions & Conversations

Filter form dropdown (related table) empty when starting empty with filter.

How can I have an empty grid (to start with) and a dropdown from a related table?  Now it stays empty, because I guess there is not information shown yet in the list. 

4
Mark Jongeling
Administrator
1 year ago
htimmermans
Captain
htimmermansCaptain
asked in Questions & Conversations

max_no_of_records not working for indicium_universal?

We have a table with readings per vehicle. This table is reachable via indicium universal for external parties. They can query by vehicle, sort on date etc etc… That's all fine. But if one forgets to use Ttop=10 of $top=100 for example in the URL, a list of thousans of records can and will be returned.When setting for example max_no_of_records on a table, the (windows) GUI respects such a setting. Indicium universal however ignores this setting completely. Will this be introduced in a future release of indicium universal? And will there be a way to query a variant in the future?  

4
Mark Jongeling
Administrator
1 year ago
P
Apprentice
Pierius Lycklama A NijeholtApprentice
asked in Questions & Conversations

Download indicium XLSX via running tasks

I like to achieve the following in our application (Web GUI):When the user executes a certain task a download* is started and shown in the running tasks window. When the download is finished the user can retrieve the file via the running tasks window.* The download is the response of a select request to indicium with the option to export as XLSX added (&$export=xlsx).It should behave the same as how you can download a GUI via the TCP website.What steps are needed to achieve this?

3
Mark Jongeling
Administrator
1 year ago
Freddy
FreddyThinkwise Local Partner Brasil
asked in Questions & Conversations

Universal GUI Business Intelligence

Hi. I am trying some cubes and charts. Why do only column values get shown the elements, as when they are added as a row they get their DB values. Socio Type (Combo with Elements), as a column and states as rows I see the named elements.  Socio Type (Combo with Elements), as a row I see the DB values instead of elements.  

2
Freddy
2 years ago
mperrott
Hero
mperrottHero
asked in Questions & Conversations

Azure AD single sign on in Universal GUI

Dear all,As per subject I’m trying to setup the SSO on the Universal GUI for part of my users and facing an issue. The documentation mentions the setup of the SSO from Thinkwise perspective which is sufficient, but there is no documentation at least for the setup for Azure/AWS/Google perspective what is actually needed.My Setup:I have a Resource group (RG) called TEST I have a VNET for the RG I have SQL server and App service in the VNET I have a Front Door having the default *.azurefd.net and my custom domain The Front Door points to my App service and redirects traffic correctly. The Indicium and Universal are installed on the App service. The whitelist of client redirect URLs in IAM is my custom domain only.For the SSO:I have done the App registration I have added the new configuration in App Service for the OpenID Microsoft authentication I have added my custom domain on App serviceProblem I face and would like some input is that,The App registration requires that the Redirect URIs

4
Sjors Niesten
Apprentice
1 year ago
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. 

16
Freddy
2 years ago
Rucha Naik
Rucha NaikPartner
asked in Questions & Conversations

Can Universal GUI used without user_id and password

The project I am working on needs to fill a form (which is developed in SF) by the candidates. This form will be sent as the link to the candidate in an email. When the candidate clicks this link it should take the candidate to the form. My question is :If the candidate does not have the log in details for SF , can he still open and save his data through the form?  Can the universal GUI url open without user id and password?

3
Mark Jongeling
Administrator
2 years ago
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? 

2
Freddy
2 years ago
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 reachedThe 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. 

2
Freddy
2 years ago
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 startThe 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.configure

2
E
Sidekick
2 years ago
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? 

2
Freddy
2 years ago
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

1
E
Moderator
2 years ago
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? 

2
G
Apprentice
2 years ago
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 messageError lineI 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.

2
MtHoen
Apprentice
2 years ago
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. 

2
Freddy
2 years ago

Badges

Show all badges
Terms & ConditionsCookie settings