Questions & Conversations
Software Factory & IAM (Installation, Development, Deployment, Integration) | E-learning | Documentation | Community
- 1,897 Topics
- 6,561 Replies
Conditional formatting without specific column in forms
Setting conditional formatting without setting a specific column and without condition is now only working in grids. It can be used to show a data in a grid with a different font. Unfortunately this is not working for the same table for fields in a form. Why not?
What does "Open the table empty and show the filter screen"?
Under user preferences > Subject configuration there's a checkbox: It's not really documented for end users, but I found something similar I think it should do: https://docs.thinkwisesoftware.com/docs/sf/subjects.html#start-empty-with-filter If I have the checkbox above checked, it doesn't what I expect it should do: After opening the subject via the menu, it should immediate open the ‘Filter’ dialog (as described here). If I check the box in the subject, it does show an filter.
Process schedule to IAM error
Hello, If you want to create a Process schedule in version 2020.1 and have selected "Once" at frequency type and you want to deploy this schedule to IAM it looks like the sync is crashing. But behind the GUI screen there may be a message that NULL is not allowed in column "occur_every_time_unit" in table IAM.dbo.process_flow_schedule. The reason for this is a difference in metadata between the SF and IAM for this column. In the SF, NULL is allowed. For now I changed properties of the column in IAM.
Why can I select a view in data sets as table?
I've noticed there are updates regarding the unit testing part, especially for triggers bound to tables. But I've noticed that I can select views in the data sets > Data rows, so I tried :-). Unfortunately that doesn't work, and maybe that is OK. Question: Should views be selectable over here? If yes, then how to fix the following error: The unit test was aborted while this was not expected. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1. ERROR  Microsoft[SQL Server]Cannot alter 'dummy_view' because it is not a table. ERROR  Microsoft[SQL Server]Statement(s) could not be prepared. Hint: Debugger shows this: alter table [dummy_view] disable trigger all; Dummy_view isn't a table. If not, then they should be removed from the drop down. I’d almost assume that the data set should be created using tables only, but when it's also possible to do this by views (we have a lot in stead of in
Exception web app logging
Hi, when I open the IAM application trough a web app installation, and want to open Form tab of selected end user application, we receive the message: “An error has occurred in the application.” error in iam When we click the error we get the following “helpful” popup: helpfull popup Is there a way to get any information about the exception that occurred? For example a logfile where more details of the error are logged? That way we can get an indication of what is wrong, and possible how to fix this. Kind Regards, Edwin
Wrong behaviour debug-screen in SF
The debug screen in the SF shows annoying behavior when minimizing and again increasing the popup. In addition to the maximize button, it is desirable to have a button that can be used to switch back to the last settings (height, width and column widths). Or consider allowing the maximize button to work this way.
Change label name at runtime
I am relatively new using the Software Factory and I am looking for an option to change label names at runtime, if possible. At a certain point an option is selected. I want to changes certain label names of other input fields in the form depending on the selected option. In the database it will be the same column in the table.
User Simulation and WebGUI
For support it would be nice to be able to login to an application with the username of the one you are trying to support. (Without asking their password) In IAM there is a right simulation. Is it possible to use this right if are you loging in with a browser (using the WebGUI).
Custom validation with related object
I have added a custom validation. The validation I’ve added is to prevent ‘localhost’ as part of an url in a http connector in a process flow. This works, however, the columns pk_col_1 - pk_col_7 are a bit of magic. As far I can see they are used to calculate what to show behind the tab ‘Related Object’ in the validation screen. In this case i want the related object is reflecting the following address: I notice there is a column “Object type” which is not documented, but I think does affect what the values of pk_col_1 - 5 needs to be: But what Object type should I choose in this particular situation? And with what values the pk_col_ columns should be filled? I currently use this query: insert into validation_msg (project_id , project_vrs_id , validation_id , pk_col_1 , pk_col_2 , pk_col_3 , pk_col_4 , pk_col_5 , generated , insert_user , insert_date_time , update_user , update_date_time)select @project_id, @project_vrs_id, @validation_id, @project_id as pk_col_1, @project_vrs_
Hello, I am trying to configure the Offfice365 Exchange connector. When I've gone though the steps of the manual (https://docs.thinkwisesoftware.com/docs/kb/exchange.html), and I run the SP: exh_sync_users, error 522 shows up. The error message is: “Er kon geen verbinding worden opgezet met de Exchange koppeling: System.Net.Sockets.SocketException (0x80004005): A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.0.0.30:9988 at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.Sockets.Socket.Connect(EndPoint remoteEP) at System.Net.Sockets.TcpClient.Connect(IPEndPoint remoteEP) at UserDefinedProcedures.SendEvent[T](String exchangeServerIP, Int32 exchangeServerPort, DbToExhEventMessageBuilder message, T& result, String& errorMessage)” When I try to ping the given ip (10.0.
Executing API 'CreateFile' failed with error number 32.
Does anybody know a good way to catch and prevent the error, when a file for some reason is locked for reading and processing? Executing API 'CreateFile' failed with error number 32. Error code 32 is ERROR_SHARING_VIOLATION . So the mailer cannot read the attachment file because something else is reading it. Besides the fact that you cannot really reproduce it until it happens, I cannot really find a way to catch this error upfront. I am using the file_exists function to check upfront if all documents exists, and even though all attachments can be found, at the time of sending the mail at occasions you get this error. The only solution I can think of now is to set the AccountRetryAttempts to 2 times to tackle this problem. But it's not the fanciest solution, anyone has experiences with this?
What happend with stored procedure post_sync in IAM?
Until 2018.3 there was the post_sync procedure, which could be used to execute some statements after the synchronization process. The main reason why I am asking, is because I like to execute this statement after every sync: [b]EXEC [dbo].[task_switch_path] @project_id = @project_id, @project_vrs_id = @project_vrs_id, @old_path = 'S:\Thinkwise\Applications\', @new_path = 'Applications\', @use_iam_project = 0[/b] Is there any alternative?
Login to the Thinkwise Software Community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.