Skip to Content
0

AFO issue : While selecting following query from AFO template, System got hanged.

Mar 06, 2017 at 06:45 AM

30

avatar image
Former Member

please check the attached screenshot, AFO report is generating below query on report refresh and system got hanged after that.

Thread Detail: SELECT DISTINCT "MATERIAL", "TXTMD" FROM "_SYS_BIC"."kgm.ftp.KDEM/CA_KDEM_ATTAINMENT" WHERE "MATERIAL" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ....) There are more that 4000 ? symbols in the actual select statement.

select-query-generated-by-report.jpg

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers