When i tried to open my application in Universal GUI, the application opens but no data is getting displayed from DB and it is showing error messages as ” Reset dataset failed. Error: An unknown error occurred, please contact your administrator.” and “ [unknown_error]” .
It is not updated with latest data model change too. Has someone faced this before? What could be the issue?
Solved
Getting error message while using Universal GUI(2021.3.12.0)
- Warrior
- 29 replies
Best answer by Vincent Doppenberg
Hello Usha,
It appears that you have either a view or an expression column that produces a value for a column that does not fit into the int domain that was assigned to the column.
To find the subject which produces this error, open the developer tools of the browser, navigate to the Network tab and then reproduce the issue in the Universal GUI. In the network tab you will see a red request that resulted in a 500 status code. The URL of this request will refer to the subject that produced the error. You can narrow this down some more by looking at the columns that have an int data type. Check if any of them are expression columns and if their expressions can produce values that are not convertible to int. If the subject is a view, then check if the query for your view can produce invalid values for these columns.
I hope this helps.
This topic has been closed for comments
Are the application model and database model the same? And is this on SQL server or a different database system? Also, any additional information in the indicium log?
- Warrior
- 29 replies
Hi Erwin,
Yes both the models are same and we are using this SQL server sisarbv-sql.thinklab.cloud.
I could see lot of error logs in indicium error log, such as,
TSFMessagesMiddleware: An unhandled exception occurred while processing the request. (fffadd8a)
System.OverflowException: Value was either too large or too small for an Int32.
And also i could see error message for invalid columns which we added in our latest version and completed code creation and IAM sync successfully. We could see it gets reflected in our end application but not in the Universal GUI.
Wondering what we are missing out here.
Hello Usha,
Could you paste the full error messages (with the entire call stack below the error message included) for the System.OverflowException and also the other error you mentioned regarding invalid columns?
These errors are almost certainly the cause of your problems and with this additional information we will be able to help you solve them.
Hello Usha,
It appears that you have either a view or an expression column that produces a value for a column that does not fit into the int domain that was assigned to the column.
To find the subject which produces this error, open the developer tools of the browser, navigate to the Network tab and then reproduce the issue in the Universal GUI. In the network tab you will see a red request that resulted in a 500 status code. The URL of this request will refer to the subject that produced the error. You can narrow this down some more by looking at the columns that have an int data type. Check if any of them are expression columns and if their expressions can produce values that are not convertible to int. If the subject is a view, then check if the query for your view can produce invalid values for these columns.
I hope this helps.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.