Hello, I've inserted some Incident - Additional Fields from databse.
Hello, I've inserted some
Incident - Additional Fields from databse.
There are lots of fields that we don't want to insert them by hand and maybe
there will be updated by another database, and these fields should be up-todate.
So, I decided to insert them on database side.
For test, I first inserted parent field, which is picklist, but not any values and see that in table [ColumnAliases]
one row inserted with [COLUMNNAME]='UDF_CHAR8' and [TABLENAME]='WorkOrder_Fields'
for the rest I've inserted field values into [UDF_PickListValuess] table with [COLUMNNAME]='UDF_CHAR8' and [TABLENAME]='WorkOrder_Fields'
and the [VALUE] which is read from another database.
After login get these error in log and homepage.do is broken:
[12:13:27:160]|[08-05-2017]|[com.manageengine.servicedesk.servlet.ClientLogServlet]|[SEVERE]|[128]|: Login user(id):761, Error occurred-->SyntaxError: missing ; before statement, in file name:http://localhost:6263/HomePage.do, at line number:1694|
[12:13:25:786]|[08-05-2017]|[org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/].[action]]|[SEVERE]|[112]|: Servlet.service() for servlet [action] in context with path [/] threw exception [java.lang.IllegalArgumentException: Unknown Column UDF_CHAR8 specified] with root cause|java.lang.IllegalArgumentException: Unknown Column UDF_CHAR8 specified
There are lots of fields that we don't want to insert them by hand and maybe
there will be updated by another database, and these fields should be up-todate.
So, I decided to insert them on database side.
For test, I first inserted parent field, which is picklist, but not any values and see that in table [ColumnAliases]
one row inserted with [COLUMNNAME]='UDF_CHAR8' and [TABLENAME]='WorkOrder_Fields'
for the rest I've inserted field values into [UDF_PickListValuess] table with [COLUMNNAME]='UDF_CHAR8' and [TABLENAME]='WorkOrder_Fields'
and the [VALUE] which is read from another database.
After login get these error in log and homepage.do is broken:
[12:13:27:160]|[08-05-2017]|[com.manageengine.servicedesk.servlet.ClientLogServlet]|[SEVERE]|[128]|: Login user(id):761, Error occurred-->SyntaxError: missing ; before statement, in file name:http://localhost:6263/HomePage.do, at line number:1694|
[12:13:25:786]|[08-05-2017]|[org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/].[action]]|[SEVERE]|[112]|: Servlet.service() for servlet [action] in context with path [/] threw exception [java.lang.IllegalArgumentException: Unknown Column UDF_CHAR8 specified] with root cause|java.lang.IllegalArgumentException: Unknown Column UDF_CHAR8 specified