Good morning,
we are experiencing an OnDemand issue during "search" phase :
while using both OnDemand fat client, or web client, or ODWEK API (Vector<ODHit> ODFolder.search()), a search request on a specific subset of documents triggers a severe error message which interrupts brutally the research :
"The server failed during a search operation,id:2090" (com.ibm.edms.od.ODException)

Here are the messages in OnDemand syslogs :  

"Time Stamp",Userid",Log Id",Severity",View",Msg Num",Message",Account",
"2025-03-20 10:49:32.772887","232494","639303534","Error","No","13","DB Error: Warning:  Unexpected SQL_SUCCESS_WITH_INFO -- SQLSTATE=Not Defined, SQLCODE=1, File=arsdoc.c, Line=3563",""
"2025-03-20 10:49:32.766433","232494","639303534","Error","No","13","DB Error: [IBM][CLI Driver][DB2/LINUXX8664] SQLSTATE 01517: A character that could not be converted was replaced with a substitute character.  -- SQLSTATE=01517, SQLCODE=0, File=arsdoc.c, Line=3563",""
"2025-03-20 10:49:14.014712","232494","639303534","Info","No","65","Application Group Query: Name(XXXX) Agid(13506) Count(1001) SegStart(2020-03-17) SegStop(2020-03-17) Sql(4;ODDAT_bDate,appID,ODDAT_iDate,ODDAT_iDate;'2020-03-17','XXXX','2020-03-23 00:00:00','2020-03-23 23:59:59';WHERE ODDAT_bDate = ? AND ( ODTBL.appID = ? AND ODDAT_iDate BETWEEN ? AND ? ) ) SqlR() FullTextSearch() FullTextScore() ServerTextSearch() AnnColor() AnnText() OrderBy()",""

I don't know exactly what the C program "arsdoc.c" does on line 3563, but it looks to try to link the ApplicationGroup tables (ARSAPP & ARSAG) with the meatadata technical table (XVE1) and triggers a DB2 SQL error 01517.

Has anyone already experienced that and can help ?

Thanks in advance

Regards

check the codepage on the client and server.

"Time Stamp",Userid",Log Id",Severity",View",Msg Num",Message",Account","2025-03-20 10:49:32.772887","232494","639303534","Error","No","13","DB Error: Warning:  Unexpected SQL_SUCCESS_WITH_INFO -- SQLSTATE=Not Defined, SQLCODE=1, File=arsdoc.c, Line=3563","""2025-03-20 10:49:32.766433","232494","639303534","Error","No","13","DB Error: [IBM][CLI Driver][DB2/LINUXX8664] SQLSTATE 01517: A character that could not be converted was replaced with a substitute character.  -- SQLSTATE=01517, SQLCODE=0, File=arsdoc.c, Line=3563","""2025-03-20 10:49:14.014712","232494","639303534","Info","No","65","Application Group Query: Name(XXXX) Agid(13506) Count(1001) SegStart(2020-03-17) SegStop(2020-03-17) Sql(4;ODDAT_bDate,appID,ODDAT_iDate,ODDAT_iDate;'2020-03-17','XXXX','2020-03-23 00:00:00','2020-03-23 23:59:59';WHERE ODDAT_bDate = ? AND ( ODTBL.appID = ? AND ODDAT_iDate BETWEEN ? AND ? ) ) SqlR() FullTextSearch() FullTextScore() ServerTextSearch() AnnColor() AnnText() OrderBy()",""