[Production error] org.hibernate.exception.SQLGrammarException: could not execute statement

[sunilasm (sun am)]

Which IIQ version are you inquiring about?

8.3p1

Hi Team,

On [07/11], we implemented a config change to add the “Comments” attribute for Role under Advanced Analytics. Subsequently, we ran the corresponding SQL scripts. Since then, we have been encountering consistent errors that are causing task failures.

We believe this issue is related to the recent config change and SQL script execution. I am attaching the word doc with steps we followed to make this config change also the logs.

Due to this our quarterly Manager certifications are getting errored out and causing lot of problems for our business.

We appreciate your help in resolving this issue.

Thank you for your support.
Steps to make Comments attribute searchable in Advanced Analytics Report (2) (1) (1).docx (564.4 KB)

[enistri_devo (Emanuele Nistri)]

Hi @sunilasm,

you have 2 principal problem about sql:

1. Comments
   
   
   
   You are triing to stored a value bigger than the size of column. You can enlarge the size of column or limit the comment in SP
   2.Manage attribute
   
   
   
   You need to check those attribute on DB and why you have a violation.
   See my topic for some advise:
   Database maintenance

PS You other error with you LDAP and Azure connettors.

[sunilasm (sun am)]

thanks @enistri_devo - i deleted the log file, and going through your reply