Clarity

Hello Guys,

We are getting error like "System error. Contact system administrator." during project Creation and nothing is happening. 

While checking in App-ca log, following error is showing - 

ERROR 2017-11-23 10:40:18,666 [http-bio-<IP>-<port>-exec-1016] niku.xql2 (clarity:<user ID>:13171087__3B1F8450-9EA2-47DA-85FA-F98029C1D3C5:projmgr.projectNewPost) Internal Processing exception
com.niku.union.persistence.PersistenceException:
SQL error code: 8152
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated.
SQL error code: 3621
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]The statement has been terminated.

Anybody can please suggest resolution for this error? Service restart has not resolved this issue.

As per the error message it appears that might be some problem with at least one attribute of Project whose value does not fit into Database Column.

Also, are there any database triggers behind?

No DataBase trigger as DB is MS sql server.

Can you generate app trace or post the entire stack, the provided stack doesn;t give much information 

This seems to be an issue with data type mismatch while pushing data into database column, please look into app-system  or app-ca logs for that particular attribute id. i have a feeling this might be due to dynamic lookup where lookup id data type might have changed from numeric to string.

Regards,

Prashank Singh

You are correct Prashank. The error was due to newly created project custom attribute and after deactivating it, Project creation is ok. Thanks for your help.