Errors in stdlog

[Anon Anon]

HI,

Stdlogs are full of these below messages. Can somebody suggest the reason? SDM is running and usable.

06/22 03:26:53.21 tygrra02casdp  bpvirtdb_srvr       17316 SEVERE_ERROR bpobject.c            5125 Attempt to cast type NIL BPData to ValueVALNX

06/22 03:26:53.22 tygrra02casdp  bpvirtdb_srvr       17316 SEVERE_ERROR bpmessage.c            779 BPMessage::operator[12]: index out-of-bounds   max = 2

06/22 03:26:53.22 tygrra02casdp  bpvirtdb_srvr       17316 SIGNIFICANT  bpmessage.c            783 BPMessage[ 539820032.46064.37278 ] [User chokoen]

06/22 03:26:53.22 tygrra02casdp  bpvirtdb_srvr       17316 SIGNIFICANT  bpmessage.c            783 {

06/22 03:26:53.22 tygrra02casdp  bpvirtdb_srvr       17316 SIGNIFICANT  bpmessage.c            783   method = insert

06/22 03:26:53.22 tygrra02casdp  bpvirtdb_srvr       17316 SIGNIFICANT  bpmessage.c            783   arg 0 = (string)event_log

06/22 03:26:53.22 tygrra02casdp  bpvirtdb_srvr       17316 SIGNIFICANT  bpmessage.c            783   arg 1 = (integer)-842150451

06/22 03:26:53.22 tygrra02casdp  bpvirtdb_srvr       17316 SIGNIFICANT  bpmessage.c            783   arg 2 = (integer)0

06/22 03:26:53.22 tygrra02casdp  bpvirtdb_srvr       17316 SIGNIFICANT  bpmessage.c            783 }

06/22 03:26:53.22 tygrra02casdp  bpvirtdb_srvr       17316 SEVERE_ERROR bpobject.c            5125 Attempt to cast type NIL BPData to ValueVALNX

06/22 03:26:53.23 tygrra02casdp  bpvirtdb_srvr       17316 SEVERE_ERROR bpmessage.c            779 BPMessage::operator[13]: index out-of-bounds   max = 2

06/22 03:26:53.23 tygrra02casdp  bpvirtdb_srvr       17316 SIGNIFICANT  bpmessage.c            783 BPMessage[ 539820032.46064.37278 ] [User chokoen]

06/22 03:26:53.23 tygrra02casdp  bpvirtdb_srvr       17316 SIGNIFICANT  bpmessage.c            783 {

06/22 03:26:53.23 tygrra02casdp  bpvirtdb_srvr       17316 SIGNIFICANT  bpmessage.c            783   method = insert

06/22 03:26:53.23 tygrra02casdp  bpvirtdb_srvr       17316 SIGNIFICANT  bpmessage.c            783   arg 0 = (string)event_log

06/22 03:26:53.23 tygrra02casdp  bpvirtdb_srvr       17316 SIGNIFICANT  bpmessage.c            783   arg 1 = (integer)-842150451

06/22 03:26:53.23 tygrra02casdp  bpvirtdb_srvr       17316 SIGNIFICANT  bpmessage.c            783   arg 2 = (integer)0

06/22 03:26:53.23 tygrra02casdp  bpvirtdb_srvr       17316 SIGNIFICANT  bpmessage.c            783 }

06/22 03:26:53.23 tygrra02casdp  bpvirtdb_srvr       17316 SEVERE_ERROR bpobject.c            5125 Attempt to cast type NIL BPData to ValueVALNX

06/22 03:26:53.24 tygrra02casdp  sqlagt:Audit_Log    72964 SEVERE_ERROR sqlclass.c             885 Unknown data type (-1) for parm (1) in Sql_cnx::prepare_statement() - INSERT INTO event_log ( event, kd_id, log_time, millitime, numdata1, numdata2, sd_obj_id, sd_obj_type, session_id, textdata1, textdata2, id ) VALUES (  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ?  )

06/22 03:26:53.24 tygrra02casdp  sqlagt:Audit_Log    72964 SEVERE_ERROR sqlclass.c             885 Unknown data type (-1) for parm (2) in Sql_cnx::prepare_statement() - INSERT INTO event_log ( event, kd_id, log_time, millitime, numdata1, numdata2, sd_obj_id, sd_obj_type, session_id, textdata1, textdata2, id ) VALUES (  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ?  )

06/22 03:26:53.25 tygrra02casdp  sqlagt:Audit_Log    72964 SEVERE_ERROR sqlclass.c             885 Unknown data type (-1) for parm (3) in Sql_cnx::prepare_statement() - INSERT INTO event_log ( event, kd_id, log_time, millitime, numdata1, numdata2, sd_obj_id, sd_obj_type, session_id, textdata1, textdata2, id ) VALUES (  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ?  )

06/22 03:26:53.25 tygrra02casdp  sqlagt:Audit_Log    72964 SEVERE_ERROR sqlclass.c             885 Unknown data type (-1) for parm (4) in Sql_cnx::prepare_statement() - INSERT INTO event_log ( event, kd_id, log_time, millitime, numdata1, numdata2, sd_obj_id, sd_obj_type, session_id, textdata1, textdata2, id ) VALUES (  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ?  )

06/22 03:26:53.25 tygrra02casdp  sqlagt:Audit_Log    72964 SEVERE_ERROR sqlclass.c             885 Unknown data type (-1) for parm (5) in Sql_cnx::prepare_statement() - INSERT INTO event_log ( event, kd_id, log_time, millitime, numdata1, numdata2, sd_obj_id, sd_obj_type, session_id, textdata1, textdata2, id ) VALUES (  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ?  )

06/22 03:26:53.26 tygrra02casdp  sqlagt:Audit_Log    72964 SEVERE_ERROR sqlclass.c             885 Unknown data type (-1) for parm (6) in Sql_cnx::prepare_statement() - INSERT INTO event_log ( event, kd_id, log_time, millitime, numdata1, numdata2, sd_obj_id, sd_obj_type, session_id, textdata1, textdata2, id ) VALUES (  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ?  )

06/22 03:26:53.26 tygrra02casdp  sqlagt:Audit_Log    72964 SEVERE_ERROR sqlclass.c             885 Unknown data type (-1) for parm (7) in Sql_cnx::prepare_statement() - INSERT INTO event_log ( event, kd_id, log_time, millitime, numdata1, numdata2, sd_obj_id, sd_obj_type, session_id, textdata1, textdata2, id ) VALUES (  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ?  )

06/22 03:26:53.27 tygrra02casdp  sqlagt:Audit_Log    72964 SEVERE_ERROR sqlclass.c             885 Unknown data type (-1) for parm (8) in Sql_cnx::prepare_statement() - INSERT INTO event_log ( event, kd_id, log_time, millitime, numdata1, numdata2, sd_obj_id, sd_obj_type, session_id, textdata1, textdata2, id ) VALUES (  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ?  )

06/22 03:26:53.27 tygrra02casdp  sqlagt:Audit_Log    72964 SEVERE_ERROR sqlclass.c             885 Unknown data type (-1) for parm (9) in Sql_cnx::prepare_statement() - INSERT INTO event_log ( event, kd_id, log_time, millitime, numdata1, numdata2, sd_obj_id, sd_obj_type, session_id, textdata1, textdata2, id ) VALUES (  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ?  )

06/22 03:26:53.27 tygrra02casdp  sqlagt:Audit_Log    72964 SEVERE_ERROR sqlclass.c             885 Unknown data type (-1) for parm (10) in Sql_cnx::prepare_statement() - INSERT INTO event_log ( event, kd_id, log_time, millitime, numdata1, numdata2, sd_obj_id, sd_obj_type, session_id, textdata1, textdata2, id ) VALUES (  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ?  )

06/22 03:26:53.28 tygrra02casdp  sqlagt:Audit_Log    72964 SEVERE_ERROR sqlclass.c             885 Unknown data type (-1) for parm (11) in Sql_cnx::prepare_statement() - INSERT INTO event_log ( event, kd_id, log_time, millitime, numdata1, numdata2, sd_obj_id, sd_obj_type, session_id, textdata1, textdata2, id ) VALUES (  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ?  )

06/22 03:26:53.28 tygrra02casdp  sqlagt:Audit_Log    72964 ERROR        sqlclass.c            1002 SQL Execute  failed: [Microsoft OLE DB Provider for SQL Server] [ SQL Code=3621 SQL State=01000] The statement has been terminated.; [Microsoft OLE DB Provider for SQL Server] [ SQL Code=515 SQL State=23000] Cannot insert the value NULL into column 'id', table 'mdb.dbo.event_log'; column does not allow nulls. INSERT fails.

06/22 03:26:53.28 tygrra02casdp  sqlagt:Audit_Log    72964 ERROR        sqlclass.c            1003 Clause (INSERT INTO event_log ( event, kd_id, log_time, millitime, numdata1, numdata2, sd_obj_id, sd_obj_type, session_id, textdata1, textdata2, id ) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )) Input (<event:int>0|<kd_id:UNDEFINED>(NULL)|<log_time:UNDEFINED>(NULL)|<millitime:UNDEFINED>(NULL)|<numdata1:UNDEFINED>(NULL)|<numdata2:UNDEFINED>(NULL)|<sd_obj_id:UNDEFINED>(NULL)|<sd_obj_type:UNDEFINED>(NULL)|<session_id:UNDEFINED>(NULL)|<textdata1:UNDEFINED>(NULL)|<textdata2:UNDEFINED>(NULL)|<id:UNDEFINED>(NULL))

06/22 03:26:53.28 tygrra02casdp  sqlagt:Audit_Log    72964 ERROR        sqlsrvr.c              651 Execution failed. MISC_DB_ERROR

Regards,

Anusha

[Anon Anon]

Hello Anusha

In general if no functionality is lost then you need not worry too much about  these error messages. They mean that some function tried to convert some data from BPData to ValueVALNX but the BPData variable was null so the conversion function logs this error and returns a NULL converted variable of type ValueVALNX.

 

Unknown data type (-1) for parm (1) in Sql_cnx::prepare_statement() - INSERT INTO event_log

Cannot insert the value NULL into column 'id', table 'mdb.dbo.event_log'; column does not allow nulls. INSERT fails.

 

- Are you trying to insert data into any of the tables?

- Are you trying archive/purge on the event_log table?

- The error here indicate the inserts are happening into the event_log table. There could be some rouge entries in this table resulting in these errors.

 

Also you may consider restricting entries into the event_log table. The Event_log table stores all the different activities that take place on SDM. In the Event_log table there is a column called Event. This column value varies from 1-21.

 

Event - Value

Login - 1

Logout -2

CR_CREATE - 3 and so on..

 

The system environment variable @NX_EVENT_LOG_EXCLUDE, which is set in the NX.env file and requires a restart of the CA Service Desk Manager services, lets you control the amount of data that is stored in the event log (event_log table). This variable lets you store only the events you want to track, report on, and use as part of the Recent Activity that can be launched as a button from the Quick Profile page.

 

In this variable, commas separate list items (for example, @NX_EVENT_LOG_EXCLUDE = FAQ,KD_OPEN). For example, if you use the LOGIN,LOGOUT events from the following table (@NX_EVENT_LOG_EXCLUDE value of LOGIN,LOGOUT), the product does not record login and logout events.

 

For more details on Event_Log values and how to exclude refer Page 354 - Event Log Data Storage Customization- of the Servicedesk R12.7 Implementation Guide

 

Hope this helps.

 

Regards

Nas