Writeback to Database node error in Monitoring and Alerting Server Log for Oracle database

Writeback to Database node error in Monitoring and Alerting Server Log for Oracle database

book

Article ID: KB0077026

calendar_today

Updated On:

Products Versions
Spotfire Statistica 13.1 and higher

Description

When troubleshooting MAS issues, it is recommended to check windows event log and MAS log . The MAS log files are typically located in "C:\Windows\System32\LogFiles\MAS\" and will correspond to logging level set in the "MAS Configuration" tool.

This article explains the below error generated in MAS log:
---------------------------------------------------------------------------------------
Error in node '0020 Write Spreadsheet to Database':

Oracle bulk load completed with a warning return code. This means that some rows were discarded or rejected, or the load was discontinued. See log for details: D:\Profiles\Users\abc\AppData\Local\Temp\d357ac01-db2d-4660-b717-0342636e201e.log]
------------------------------------------------------------------------------------------

Cause :When a writeback node (included in a scheduled workspace) trying to write a table back to the Oracle database , and if the table violates the column restriction of the database setup, it will result in Oracle errors returned in this referred location (e.g.D:\Profiles\Users\<Username>\AppData\Local\Temp).

For instance, a column in the destination database is set to allow a max value at 100.  Whenever a value larger than 100 is being written back to the database via a WriteBack to Database node, Oracle generates a relevant error log in the Temp folder.
 

Issue/Introduction

This article walks through an example of troubleshooting Monitoring and Alerting Server (MAS) log error with Writeback to database node involved.

Resolution

Resolution:
1. Go to the folder referred in the MAS error, such as D:\Profiles\Users\abc\AppData\Local\Temp.
2. Open and check the errors indicated in the log file.
3. Correct Oracle related errors.
4.  It is also recommend to regular check and correct the Oracle database issues logged in the Temp folder and clear up those log files timely. Otherwise, log files could pile up Temp folder, which might lead to other unexpected errors/behavior of MAS service.