View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0024393 | mantisbt | db mssql | public | 2018-05-03 04:52 | 2018-05-16 02:20 |
Reporter | rafique.kakati | Assigned To | |||
Priority | high | Severity | major | Reproducibility | have not tried |
Status | new | Resolution | open | ||
Product Version | 2.11.1 | ||||
Summary | 0024393: APPLICATION ERROR #401 Database query failed. Error received from database was #-52: SQLState: IMSSP | ||||
Description | When I am trying to Print Reports and Issue Trends of a project whose tickets are greater than 2100, i am getting below error. this is not in the case of csv or excel exports. Please can you help me regarding the same. Attaching the image for the same APPLICATION ERROR 0000401 Database query failed. Error received from database was #-52: SQLState: IMSSP | ||||
Tags | No tags attached. | ||||
|
|
Hi, While searching for the solution of above, found the below link where in they have mentioned that SQL Server Parameters per user-defined function limit is 2,100, below is the link. Can you please help me to modify the query (bug_api.php) so that this issue can be resolved, where in all the data can be printed with this restriction. function bug_get_bugnote_stats_array( array $p_bugs_id, $p_user_id = null ) { $t_query = 'SELECT n.id, n.bug_id, n.reporter_id, n.view_state, n.last_modified, n.date_submitted, b.project_id' } |
|
Hi, Is there any solution for the same? |
|