2021-12-06T14:43:04.705157-05:00
FMPD(6):WARNING: too many parse errors, count=330 SQL hash=0xx703c089
FMPD(6):PARSE ERROR: ospid=6211, error=1795 for statement:
FMPD(6):select e_id, e_name from employee where e_id in (:1 ,:2 ,:3 ,:4 ,:5 ,:6 ,:7 ,:8 ,:9 ,:10 ,:11 ,:12 ,:13 ,:14 ,:15 ,:16 ,:17 ,:18 ,:19 ,:20 ,:21 ,:22 ,:23 ,:24 ,:25 ,:26 ,:27 ,:28 ,:29 ,:30 ,:31 ,:32 ,:33 ,:34 ,:35 ,:36 ,:37 ,:38 ,:39 ,:40 ,:41 ,:42 ,:43 ,:44 ,:45 ,:46 ,:47 ,:48 ,:49 ,:50 ,:51 ,:52 ,:53 ,:54 ,:55 ,:56 ,:57 ,:58 ,:59 ,:60 ,:61 ,:62 ,:63 ,:64 ,:65 ,:66 ,:67 ,:68 ,:69 ,:70 ,:71 ,:72 ,:73 ,:74 ,:75 ,:76 ,:77 ,:78 ,:79 ,:80 ,:81 ,:82 ,:83 ,:84 ,:85 ,:86 ,:87 ,:88 ,:89 ,:90 ,:91 ,:92 ,:93 ,:94 ,:95 ,:96 ,:97 ,:98 ,:99 ,:100 ,:101 ,:102 ,:103 ,:104 ,:105 ,:106 ,:107 ,:108 ,:109 ,:110 ,:111 ,:112 ,:113 ,:114 ,:115 ,:116 ,:117 ,:118 ,:119 ,:120 ,:121 ,:122 ,:123 ,:124 ,:125 ,:126 ,:127 ,:128 ,:129 ,:130 ,:131 ,:132 ,:133 ,:134 ,:135 ,:136 ,:137 ,:138 ,:139 ,:140 ,:141 ,:142 ,:143 ,:144 ,:145 ,:146 ,:147 ,:148 ,:149 ,:150 ,:151 ,:152 ,:153 ,:154 ,:155 ,:156 ,:157 ,:158 ,:159 ,:160 ,:161 ,:162 ,:163 ,:164 ,:165 ,:166 ,:167 ,:168 ,:169 ,:170 ,:171 ,:172 ,:173 ,:174 ,:175 ,:176 ,:177 ,:178 ,:179 ,:180 ,:181 ,:182 ,:183 ,:184 ,:185 ,:186 ,:187 ,:188 ,:189 ,:190 ,:191 ,:192 ,:193 ,:194 ,:195 ,:196 ,:197 ,:198 ,:199 ,:200 ,:201 ,:202 ,:203 ,:204 ,:205 ,:206 ,:207 ,:208 ,:209 ,:210 ,:211 ,:212 ,:213 ,:214 ,:215 ,:216 ,:217 ,:218 ,:219 ,:220 ,:221 ,:222 ,:223 ,:224 ,:225 ,:226 ,:227 ,:228 ,:229 ,:230 ,:231 ,:232 ,:233 ,:234 ,:235 ,:236 ,:237 ,:238 ,:239 ,:240 ,:241 ,:242 ,:243 ,:244 ,:245 ,:246 ,:247 ,:248 ,:249 ,:250 ,:251 ,:252 ,:253 ,:254 ,:255 ,:256 ,:257 ,:258 ,:259 ,:260 ,:261 ,:262 ,:263 ,:264 ,:265 ,:266 ,:267 ,:268 ,:269 ,:270 ,:271 ,:272 ,:273 ,:274 ,:275 ,:276 ,:277 ,:278 ,:279 ,:280 ,:281 ,:282 ,:283 ,:284 ,:285 ,:286 ,:287 ,:288 ,:289 ,:290 ,:291 ,:292 ,:293 ,:294 ,:295 ,:296 ,:297 ,:298 ,:299 ,:300 ,:301 ,:302 ,:303 ,:304 ,:305 ,:306 ,:307 ,:308 ,:309 ,:310 ,:311 ,:312 ,:313 ,:314 ,:315 ,:316 ,:317 ,:318 ,:319 ,:320 ,:321 ,:322 ,:323 ,:324 ,:325 ,:326 ,:327 ,:328 ,:329 ,:330)
FMPD(6):Additional information: hd=000000XEFC172GE0 phd=000000DDA2A7J880 flg=0x28 cisid=928 sid=928 ciuid=928 uid=928 sqlid=64x3qwr207h3k
FMPD(6):…Current username=ORACLE
FMPD(6):…Application: JDBC Thin Client Action:
Detailed description:
When we try to run a query from the application, the Oracle too many parse errors happens. According to the stack trace, there appears to be an issue with parsing the SQL statement.
Justification:
Two points should be noted from the stacktrace.
- FMPD(6):WARNING: too many parse errors, count=330 SQL hash=0xx703c089
The Oracle error here is that there are too many parse errors. This indicates that the error occurred while parsing from Oracle Engine.
- FMPD(6):PARSE ERROR: ospid=6211, error=1795 for statement:
In this case, the error is 1795. This refers to the ORA-01795: maximum number of expressions oracle code. Oracle indicates that the number of accepting input parameters has exceeded the threshold.
Solution No. 1:
To avoid the error 1795, split the query into multiple queries and execute them dynamically.
Solution No. 2:
Instead of pulling directly from the main table, create a temporary table and load the data from it. This will address the issue of having too many parameters.