Hi all,
I've already posted this in the Audit forum, but maybe someone can help
me here too, since it's something related to IDM 3 Provisioning Module.
I have an issue with Audit and IDM3 Provisioning Module (vers. 3.0.1).
I set up everything following the manuals and workflow events got
logged for a long time. One moth ago I had this issue , which I suppose
could be connected to my actual Audit problem (I didn’t noticed it until
I had to run a report, weeks later): after a workflow stopped with an
error (special characters in a textarea field completely stucked the
user’s “requests&approval” tab, preventing him to access to the
provisioning section of the User Application).

nproduct.log

Code:
--------------------
Tue Feb 19 13:18:21 2008 [Novell Audit]:
Novell Audit Full License

Tue Feb 19 13:18:22 2008 [LGDMSSQL]: Table "NAUDITLOG" exists
Tue Feb 19 16:34:50 2008 [Novell Audit Platform Agent]: Attempting to re-establish connection to secure log server for application DirXML.
Tue Feb 19 16:34:50 2008 [Novell Audit Platform Agent]: Server reports logging protocol version: 4
Tue Feb 19 16:34:50 2008 [Novell Audit Platform Agent]: DirXML connecting to Log Server via CLEAR TEXT
Tue Feb 19 16:34:50 2008 [Novell Audit Platform Agent]: Application DirXML reconnected to Secure Logging Server, 127.0.0.1.
Thu Feb 21 15:34:51 2008 [LGDMSSQL]: [WARNING] SQL statement preparation failed
Thu Feb 21 15:34:57 2008 [LGDMSSQL]: [INFO] Retrying SQL statement (RTRY=1)
Thu Feb 21 15:34:57 2008 [LGDMSSQL]: [WARNING] SQL statement preparation failed
Thu Feb 21 15:35:02 2008 [LGDMSSQL]: [INFO] Retrying SQL statement (RTRY=2)
Thu Feb 21 15:35:02 2008 [LGDMSSQL]: [WARNING] SQL statement preparation failed
Thu Feb 21 15:35:07 2008 [LGDMSSQL]: [INFO] Retrying SQL statement (RTRY=3)
Thu Feb 21 15:35:07 2008 [LGDMSSQL]: [WARNING] SQL statement preparation failed
Thu Feb 21 15:35:07 2008 [LGDMSSQL]: [CRITICAL] An event sent to "SQLServerLogChannel" could not be processed
Thu Feb 21 15:35:07 2008 [LGDMSSQL]: [INFO] _____Event_START_____
Thu Feb 21 15:35:07 2008 [LGDMSSQL]: [INFO] Table(9)="NAUDITLOG"
Thu Feb 21 15:35:07 2008 [LGDMSSQL]: [INFO] SourceIP(0x0A7D0C0E)
Thu Feb 21 15:35:07 2008 [LGDMSSQL]: [INFO] ClientTimestamp(1203604492.114)
Thu Feb 21 15:35:07 2008 [LGDMSSQL]: [INFO] ServerTimestamp(1203604491)
Thu Feb 21 15:35:07 2008 [LGDMSSQL]: [INFO] SessionID(995971663)
Thu Feb 21 15:35:07 2008 [LGDMSSQL]: [INFO] Component(22)="DirXML\Workflow\Error"
Thu Feb 21 15:35:07 2008 [LGDMSSQL]: [INFO] ID(0x00031520)
Thu Feb 21 15:35:07 2008 [LGDMSSQL]: [INFO] Severity(4)
Thu Feb 21 15:35:07 2008 [LGDMSSQL]: [INFO] GroupID(0)
Thu Feb 21 15:35:07 2008 [LGDMSSQL]: [INFO] Originator(42)=(3),"cn=i0546,ou=staff_dexia,ou=Ute nti,o=dexia"
Thu Feb 21 15:35:07 2008 [LGDMSSQL]: [INFO] Target(42)=(3),"cn=i0546,ou=staff_dexia,ou=Utenti, o=dexia"
Thu Feb 21 15:35:07 2008 [LGDMSSQL]: [INFO] SubTarget(8)="CSE RNI"
Thu Feb 21 15:35:07 2008 [LGDMSSQL]: [INFO] Text1(27)="Notifica creazione profilo"
Thu Feb 21 15:35:07 2008 [LGDMSSQL]: [INFO] Text2(33)="53e99d34c27146e9a176df207fd0abf4"
Thu Feb 21 15:35:07 2008 [LGDMSSQL]: [INFO] Text3(255)="ID attività : [Activity11].La valutazione dell'assegnatario [IDVault.get('CN=CSE RNI,OU=applicazioni,O=dexia' , 'dexiaApplicazioni', 'dexiaManagerSicurezza')] ha restituito più assegnatari. Un'attività utente può essere assegnata solo a un unico asseg"
Thu Feb 21 15:35:07 2008 [LGDMSSQL]: [INFO] Values=1(0),2(0),3(0)
Thu Feb 21 15:35:07 2008 [LGDMSSQL]: [INFO] MIMEHint(1)
Thu Feb 21 15:35:07 2008 [LGDMSSQL]: [INFO] Data(1191)="com.novell.soa.af.impl.activity.Activi tyException: ID attività: [Activity11].La valutazione dell'assegnatario [IDVault.get('CN=CSE RNI,OU=applicazioni,O=dexia' , 'dexiaApplicazioni', 'dexiaManagerSicurezza')] ha restituito più assegnatari. Un'attività utente può essere assegnata solo a un unico assegnatario.
at com.novell.soa.af.impl.activity.UserActivity.evalu ateAddresseeExp(UserActivity.java:516)
at com.novell.soa.af.impl.activity.UserActivity.notif yArrive(UserActivity.java:151)
at com.novell.soa.af.impl.core.ProcessImpl.startActiv ity(ProcessImpl.java:1362)
at com.novell.soa.af.impl.core.ProcessImpl.forward(Pr ocessImpl.java:1295)
at com.novell.soa.af.impl.activity.ActivityNode.forwa rd(ActivityNode.java:218)
at com.novell.soa.af.impl.activity.ActivityNode.forwa rd(ActivityNode.java:200)
at com.novell.soa.af.impl.activity.LogActivity.proces s(LogActivity.java:102)
at com.novell.soa.af.impl.activity.ActivityNode.notif yArrive(ActivityNode.java:166)
at com.novell.soa.af.impl.activity.RunnableActivity.r un(RunnableActivity.java:50)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Wo rker.run(PooledExecutor.java:743)
at java.lang.Thread.run(Unknown Source)
"
--------------------



Jboss server.log (taken after the same error happened again, weeks
later, but it’s the same of the original, which I cannot recover) is
attached.

The issue is that it seems the Audit is not working anymore. No
workflow events are being logged (at the bottom the result of an
iManager dirxml query; the workflow events are absent, but long before
the IDM error occurred...).


Code:
--------------------
SourceIP ClientTimeStamp ClientMS ServerTimestamp SessionID Component EventID Severity Grouping Originator OriginatorType Target TargetType SubTarget Text1 Text2 Text3 Value1 Value2 Value3 MIMEType DataSize Data Signature
10.125.12.16 5-dic-2007 11.56.36 2 5-dic-2007 11.56.36 1194691988 DirXML\\Driver DirXML Error Error -1443680034 dexia\services\DexiaDriverSet\UserApplication\Subs criber 1 \DIM_PROD\dexia\Utenti\staff_dexia\i0546 0 Code(-9010) An exception occurred: javax.mail.AuthenticationFailedException at javax.mail.Service.connect(Service.java:265) at javax.mail.Service.connect(Service.java:135) at com.novell.nds.dirxml.util.mail.SendMail.generateE Mail(SendMail.java:148 9010 0 0 0 0

--------------------


Jboss is configured to send log also to audit (persistently) and the
log server has been restarted a lot of times. No configuration changes
have been done.
What to do to have the workflow events logged again?

Thanks in advance


+-------------------------------------------------------------------+
|Filename: server.zip |
|Download: http://forums.novell.com/attachment....tachmentid=772 |
+-------------------------------------------------------------------+

--
------------------------------
Kurtz
------------------------------------------------------------------------
kurtz76's Profile: http://forums.novell.com/member.php?userid=208
View this thread: http://forums.novell.com/showthread.php?t=320862