Incorrect syntax near keyword 'USER'.

[MARUBUN SUPPORT]

Hi Team,

Product:
CA Identity Manager

Question:

The following message was detected from the integrated authentication IDM server.

　◆server.log
ERROR [ims.llsdk.directory.jdbc.jdbcbase] (pool-11-thread-8) Failed to find objects by friendly name in database. Got exception: キーワード 'USER' 付近に不適切な構文があります。
ERROR [ims.llsdk.directory.jdbc.jdbcbase] (Thread-11565 (HornetQ-client-global-threads-776871148)) Failed to find objects by friendly name in database. Got exception: キーワード 'USER' 付近に不適切な構文があります。
ERROR [im.feeder] (pool-11-thread-3) java.lang.NullPointerException
ERROR [ims.llsdk.directory.jndi] (Thread-11578 (HornetQ-client-global-threads-776871148)) Search failed with filter (&(tblUsers.loginid=s-uozumi)tblUsers.loginid <> 'pdadmin')

キーワード 'USER' 付近に不適切な構文があります。 -> Incorrect syntax near keyword 'USER'.

It looks like an error that the filter search failed because the object cannot be found from the database friendly name.


Thanks,

[Rinat Matityahu]

Hello
Can you please attach the complete log?
Also, please confirm whether user store is JDBC or JNDI

Thank you
Rinat