Maximo Open Forum

 View Only

 BMXAA4210E - Database error number 1008 has occurred. Invalid SQL queries are logged in the log file. Check the SQL query to identify the error.

  • Everything Maximo
  • Infrastructure
Munikrishnan Raji's profile image
Munikrishnan Raji posted 06-19-2024 01:21

BMXAA4210E - Database error number 1008 has occurred. Invalid SQL queries are logged in the log file. Check the SQL query to identify the error.How to solve this error

Martin Fabra's profile image
Martin Fabra

Hi @Munikrishnan Raji!

You must be more specific. Does this error happen in any application? Which? Was anything changed? Will you be able to obtain the systemout.log and systemerr.log to verify if you find information about the error?

Regards!

Vivek Nagre's profile image
Vivek Nagre

I encountered with similar problem code on maximo  start center result set portlet there so in relationship we need to check the where clause.

Viet Tran's profile image
Viet Tran

What DBMS are you using? Search for the error code 1008 for that DBMS. For example, if you are using Oracle, here is the description of the error ORA-01008: "A SQL or PL/SQL statement containing a bind variable placeholder was executed without a value being provided for that placeholder."

That means, you likely have a variable placeholder (starting with a colon ":") in a Where clause. Check for any relationship, conditional expression, saved query related to the function you are running.