|
When using certain LiveCycle SQL statements, you might
see stale sessions, similar to the following, created in the Oracle
database.
select
rowid,
r.id,
r.documentid,
d.id,
(select count(distinct r2.sessionid) from tb_dm_session_reference r2 where r2.documentid=d.documentid) r2id,
d.documentid, d.sessionid
from tb_dm_session_reference r right join tb_dm_deletion d on ((d.documentid is null) or d.documentid = r.documentid) and d.sessionid = r.sessionid
To resolve this issue, you must do the following:
Add the -Dcom.adobe.idp.runPurgeDeletions=false JVM
system property to your application server.
Ensure that the Enable document storage in the database core
setting is turned off. To verify the setting:
Log
in to the LiveCycle Administration Console.
Select Settings > Core System Settings > Configurations.
Ensure that the Enable document storage in the database is
deselected.
Note: The system property prevents
the problematic query as long as the core setting Enable document storage in the database is
set to off. If the system property is not set, or if the
core setting Enable document storage in the database is set
to on, the prevention mechanism doesn't work.
|
|
|
