Error Codes

The exceptions that are thrown by the plug-in are listed with their corresponding descriptions and solutions.

Error Code and Error Message Role Category Description Solutions
TIBCO-BW-PALETTE-EXCEL-210001

\nStart of the Activity {0} + \nInput received:\n {1} \n

debug BW-Plug-in Occurs when the plug-in activities start to run in a process. None
TIBCO-BW-PALETTE-EXCEL-210002

\nActivity {0} Output data:\n {1} \n Exit of Activity {2}

debug BW-Plug-in Occurs when the plug-in activities finish performing a logic in a process. None
TIBCO-BW-PALETTE-EXCEL-210003

\nExcel File {0} opened for operation [{1}] in activity [{2}]

debug BW-Plug-in Occurs when the plug-in activities open an Excel file by using one of their actions. None
TIBCO-BW-PALETTE-EXCEL-210004

\nChanges to excel file {0} is saved and the file is closed for operation [{1}] in activity [{2}]

debug BW-Plug-in Occurs when the plug-in activities have made some changes to an Excel file and the changes have been saved in the Excel file. None
TIBCO-BW-PALETTE-EXCEL-210005

\nInput file not found:{0} for operation {1} in activity {2}

debug BW-Plug-in Occurs when the specified Excel file is not found. None
TIBCO-BW-PALETTE-EXCEL-210006

\nNew excel file created at location {0} for operation {1} in activity {2}

debug BW-Plug-in Occurs when the plug-in activity is used to create a new Excel file in a specified directory. None
TIBCO-BW-PALETTE-EXCEL-210007

\nFormula for cell located at column {0} of row {1} in sheet {2} will be set as {3}

debug BW-Plug-in Occurs when you fill a formula in a cell in an Excel sheet. None
TIBCO-BW-PALETTE-EXCEL-210008

\nA row already exists at the starting row number {0} of sheet {1}. Shifting down the existing row to create a new row at row number {2}

debug BW-Plug-in Occurs when you create a new row in a specified row number, where a row has been existed, and the existed row moves down. None
TIBCO-BW-PALETTE-EXCEL-210009

\nNo sheets present in file and user has not given any sheet names to add. Creating default sheet with name {0} for operation {1} in activity {2}

debug BW-Plug-in Occurs when you create a sheet without specifying its name, and a default name is given to the sheet. None
TIBCO-BW-PALETTE-EXCEL-210010

Changes to workbook is saved and written to process data for operation [{1}] in activity [{2}]

debug BW-Plug-in Occurs when operation is completed with process data. None
TIBCO-BW-PALETTE-EXCEL-211002

\nTotal sheets created in file {0} for operation {1} in activity {2} is {3}

debug BW-Plug-in Occurs when the Create_Rows action in the ExcelData activity completes an operation. None
TIBCO-BW-PALETTE-EXCEL-212001

\nDeleted sheet {0} from file {1}

debug BW-Plug-in Occurs when the Delete_Sheets action in the ExcelData activity is selected to delete sheets from an Excel file. None
TIBCO-BW-PALETTE-EXCEL-212002

\nTotal number of sheets deleted from file {0} is {1}

debug BW-Plug-in Occurs when the result of the deleted sheets from an Excel file is collected. None
TIBCO-BW-PALETTE-EXCEL-213001

\nA new sheet {0} has been created in excel file {1}

debug BW-Plug-in Occurs when the specified sheet is not present in the Excel file, and the specified sheet must be created before creating rows. None
TIBCO-BW-PALETTE-EXCEL-213002

\nA new row has been created at row number {0} of sheet {1} in excel file {2}

debug BW-Plug-in Occurs when a new row has been created in an Excel file. None
TIBCO-BW-PALETTE-EXCEL-213003

\nNo starting row is specified. Will create a new row in the next available empty row {0} in the sheet {1} of excel file {2}

debug BW-Plug-in Occurs when you create a new row without specifying the row number, and the row is created from the last row in the specified sheet. None
TIBCO-BW-PALETTE-EXCEL-214002

\nRow {0} of sheet {1} in file {2} has been deleted

debug BW-Plug-in Occurs when a row has been deleted from an Excel file. None
TIBCO-BW-PALETTE-EXCEL-214003

\nTotally {0} rows deleted from sheet {1} of file {2}

debug BW-Plug-in Occurs when the result of the rows deleted by the ExcelData activity has been collected. None
TIBCO-BW-PALETTE-EXCEL-215002

\nTotal cells read in row {0} of sheet {1} is {2}

debug BW-Plug-in Occurs when the result of the cells read by the ExcelData activity has been collected. None
TIBCO-BW-PALETTE-EXCEL-215003

\nNext row number to read in sheet {0} of file {1} is {2}

debug BW-Plug-in Occurs when the current row has been read and the next row is to be read. None
TIBCO-BW-PALETTE-EXCEL-215004

\nNext sheet number to read in file {0} is {1}

debug BW-Plug-in Occurs when the specified sheet is read, the information of the next sheet is provided to the following activity. None
TIBCO-BW-PALETTE-EXCEL-221001

Retrieved Meta Data value for {0} is {1} for file: {2} operation [{3}] in activity [{4}]

debug BW-Plug-in Occurs when the ExcelMetadata activity is used to get metadata from Excel file. None
TIBCO-BW-PALETTE-EXCEL-510001

Activity Name:{0}, Operation Name:{1};-- Exception occurred while open/locked excel file at {2}, close/unlock it and perform the action

error BW-Plug-in Occurs when the plug-in is used to perform some operations on the opened Excel file. Close the opened Excel file
TIBCO-BW-PALETTE-EXCEL-510002

Activity Name:{0}, Operation Name:{1};-- Workbook could not be retrieved for file {2}

error BW-Plug-in Occurs when a workbook object in an Excel file fails to be retrieved, which might be caused by the Excel file being damaged or abnormal. Enter the correct directory for the valid Excel file in the FilePath element in the Input tab.
TIBCO-BW-PALETTE-EXCEL-510003

Activity Name:{0}, Operation Name:{1};-- Input file:{2}not found

error BW-Plug-in Occurs when the input Excel file is not present in the specified directory. Provide a valid Excel file that is present in the specified directory.
TIBCO-BW-PALETTE-EXCEL-510004

Activity Name:{0}, Operation Name:{1};-- No such sheet in workbook file {2} for given sheet {3} {4}

error BW-Plug-in Occurs when a given sheet is not present in the Excel file. Ensure that the given sheet in the Excel file is present.
TIBCO-BW-PALETTE-EXCEL-510005

Activity Name:{0}, Operation Name:{1};-- No such directory {2} is present in the file system while creating new file

error BW-Plug-in Occurs when the input directory is not present in the file system. Provide a directory that is present in the file system.
TIBCO-BW-PALETTE-EXCEL-510006

Activity Name:{0}, Operation Name:{1};-- Invalid file extension in user input data {2}

error BW-Plug-in Occurs when the format of the input Excel file is incorrect. Provide a correct format for the input Excel file. At present, only the .xlsx format is supported.
TIBCO-BW-PALETTE-EXCEL-510007

Activity Name:{0}, Operation Name:{1};-- StartingRowPointer should be greater than 0

error BW-Plug-in Occurs when the value in the StartingRowPointer element in the Input tab is equal to or less than zero. Ensure that the value in the StartingRowPointer element in the Input tab is greater than zero.
TIBCO-BW-PALETTE-EXCEL-510008

Activity Name:{0}, Operation Name:{1};-- No such row {2} is present in sheet {3} for file {4}

error BW-Plug-in Occurs when the plug-in is used for carrying out operations, such as reading cell values from a row, which is not present in the Excel file. Ensure that the row where operations are carried out is present in the Excel file.
TIBCO-BW-PALETTE-EXCEL-510009

Activity Name:{0}, Operation Name:{1};-- No such cell {2} is present in row {3} in sheet {4} for file {5}

error BW-Plug-in Occurs when the plug-in is used for carrying out operations, such as reading cell values from a column that is not present in the Excel file. Ensure that the column where operations are carried out is present in the Excel file.
TIBCO-BW-PALETTE-EXCEL-510010

Activity Name:{0}, Operation Name:{1};-- The tag name {2} for cell in Row {3}: Column {4} is duplicated in sheet {5} for file {6}

error BW-Plug-in Occurs in the process of creating and updating rows when the same tag name is entered in different TagName elements under different Cell nodes in the Input tab. Ensure that the tag name is not used more than once.
TIBCO-BW-PALETTE-EXCEL-510011

Activity Name:{0}, Operation Name:{1};-- Input file could not be created:{2}

error BW-Plug-in Occurs when the input file path is incorrect and the input file cannot be created. Ensure that the correct file path is entered
TIBCO-BW-PALETTE-EXCEL-510013

Activity Name:{0}, Operation Name:{1} ;-- Starting Sheet Pointer cannot be less than zero or empty

error BW-Plug-in Occurs when the value entered in the StartingSheetPointer element is less than or equal to zero. Ensure that the value entered in the StartingSheetPointer element is greater than zero.
TIBCO-BW-PALETTE-EXCEL-510014

Activity Name:{0}, Operation Name:{1};-- Error while plotting X-Axis in sheet {2} for file {3}

error BW-Plug-in Occurs in the process of drawing a chart when one or multiple cells in a column of the given range required for drawing the chart are not present. Ensure that each cell in the given range required for drawing the chart is filled with an appropriate value.
TIBCO-BW-PALETTE-EXCEL-510016

Activity Name:{0}, Operation Name:{1};-- Unexpected error occurred while plotting chart in sheet {2} for file {3}

error BW-Plug-in Occurs when the plug-in fails to draw a plot chart in the Excel file because the Excel file might be damaged or abnormal. Provide a valid Excel file
TIBCO-BW-PALETTE-EXCEL-510017

Activity Name:{0}, Operation Name:{1};-- Cell Address for X Axis cannot be less than zero for sheet {2} for file {3}

error BW-Plug-in Occurs in the process of drawing a chart when the value of the given cell column is less than zero. Ensure that the value of the cell column is equal to or greater than zero.
TIBCO-BW-PALETTE-EXCEL-510018

Activity Name:{0}, Operation Name:{1};-- Error while retrieving core properties of file {2}

error BW-Plug-in Occurs when the Excel MetaData activity fails to get CoreProperties from the Excel file because the Excel file is damaged or abnormal. Provide a valid Excel file
TIBCO-BW-PALETTE-EXCEL-510019

Activity Name:{0}, Operation Name:{1};-- Error while retrieving extended properties of file {2}

error BW-Plug-in Occurs when the Excel MetaData activity fails to get ExtendedProperties from the Excel file because the Excel file is damaged or abnormal. Provide a valid Excel file
TIBCO-BW-PALETTE-EXCEL-510020

Activity Name:{0}, Operation Name:{1};-- The value is not conformity with the rule in specified formula "{2}" in sheet {3} for file {4}

error BW-Plug-in Occurs when the value in the cell that uses formula does not conform to formula rules. Ensure that the value in the cell conforms to formula rules.
TIBCO-BW-PALETTE-EXCEL-510021

Activity Name:{0}, Operation Name:{1};-- The font name "{2}" that is specified is invalid in current system

error BW-Plug-in Occurs when the font name entered is not supported by the current system. Enter a font name that is supported by your current system.
TIBCO-BW-PALETTE-EXCEL-510022

Activity Name:{0}, Operation Name:{1};-- Excel file name is absent in user input data

error BW-Plug-in Occurs when the input Excel file is not present in the specified directory. Provide an Excel file that is present in the specified directory.
TIBCO-BW-PALETTE-EXCEL-510023

Activity Name:{0}, Operation Name:{1};-- No Rows found in sheet {2} for file {3}

error BW-Plug-in Occurs when the given parameters for a row in the Input tab cannot be used for locating the corresponding row in the Excel file. Ensure that the parameters for the row can be used for locating the row in the Excel file.
TIBCO-BW-PALETTE-EXCEL-510024

Activity Name:{0}, Operation Name:{1};--No sheet input for file {2}

error BW-Plug-in Occurs in the process of reading values from rows in an Excel file when the sheet name is empty. Enter a valid sheet name
TIBCO-BW-PALETTE-EXCEL-510025

ERROR occurs when rename the file {0} to {1}

error BW-Plug-in Occurs in the process of creating or updating rows when the plug-in fails to rename the Excel file that is occupied by another application. Ensure that the Excel file is not occupied by another application.
TIBCO-BW-PALETTE-EXCEL-510026

Activity Name: {0}, Operation Name: {1} ;--Excel File Name in input schema is null or empty

error BW-Plug-in Occurs in the process of using the plug-in to create rows or sheets, set metadata for or get metadata from an Excel file when the file path in the Input tab is not specified or empty. Specify a valid file path in the Input tab
TIBCO-BW-PALETTE-EXCEL-510027

Activity Name: {0}, Operation Name: {1} ;-- Workbook could not be retrieved for process data received

error BW-Plug-in Occurs if the provided processData is corrupted or binary data is not from an Excel file. Check the binary data file that you have created or provided.
TIBCO-BW-PALETTE-EXCEL-510028

Activity Name: {0}, Operation Name: {1} ;-- Exception occurred while writing updated workbook data to process data

error BW-Plug-in Occurs in unexpected scenario while writing the updated processed data to stream. None
TIBCO-BW-PALETTE-EXCEL-511001

Activity Name:{0}, Operation Name:{1};-- Directory to create output excel file has not been specified

error BW-Plug-in Occurs in the process of creating sheets, when you select the Create New File check box without configuring the Choose Output Directory field in the General tab and the FilePath element in the Input tab. Ensure that the Choose Output Directory field and the FilePath element are configured when the Create New File check box is selected.
TIBCO-BW-PALETTE-EXCEL-511002

Activity Name:{0}, Operation Name:{1};-- Sheet by Name {2} already exists in file {3}, sheet names must be unique

error BW-Plug-in Occurs in the process of creating sheets when the sheet name is already present in the Excel file. Enter a sheet name that is not present in the Excel file when creating a sheet.
TIBCO-BW-PALETTE-EXCEL-511003

Activity Name:{0}, Operation Name:{1};--Invalid sheetName:{2}is in user input data

error BW-Plug-in Occurs in the process of creating sheets when the sheet name entered in the SheetName element is invalid. Ensure that the sheet name entered in the SheetName element is valid.
TIBCO-BW-PALETTE-EXCEL-512001

Activity Name:{0},Operation Name:{1};-- Unexpected error while deleting sheets in workbook file {2}. Aborting delete sheets activity.

error BW-Plug-in Occurs in the process of deleting sheets when the plug-in fails to retrieve a sheet from the Excel file because the sheet has been deleted and replaced by another sheet in the Excel file. None
TIBCO-BW-PALETTE-EXCEL-512002

Activity Name:{0},Operation Name:{1};--Cannot delete sheets because total sheets entered to delete [{2}] equals total number of sheets in excel file {3}

error BW-Plug-in Occurs in the process of deleting all sheets when not all the sheets are deleted from the Excel file. Ensure that at least one sheet is left in an Excel file when deleting sheets.
TIBCO-BW-PALETTE-EXCEL-512003

Activity Name:{0},Operation Name:{1};-- Cannot delete any sheet from excel file {2} because the file has only one sheet.

error BW-Plug-in Occurs in the process of deleting sheets when the Excel file has only one sheet left. Ensure that the Excel file has more than one sheet when deleting sheets.
TIBCO-BW-PALETTE-EXCEL-512004

Activity Name:{0},Operation Name:{1};-- Sheet pointer to delete a sheet cannot be zero or lesser. Value can be ranging from 1 to total number of sheets in excel file {2}

error BW-Plug-in Occurs in the process of deleting sheets based on sheet pointer when the value in the SheetPointer element is less than or equal to zero. Ensure that the value in the SheetPointer element is within the range of sheet number of the Excel file.
TIBCO-BW-PALETTE-EXCEL-512005

Activity Name:{0},Operation Name:{1};-- Sheet pointer to delete cannot be more than the total sheets in workbook. Value can be ranging from 1 to total number of sheets in excel file {2}

error BW-Plug-in Occurs in the process of deleting sheets based on sheet pointer when the value in the SheetPointer element is greater than the total sheet number in the Excel file. Ensure that the value in the SheetPointer element is within the range of sheet number of the Excel file.
TIBCO-BW-PALETTE-EXCEL-513001

Activity Name:{0},Operation Name:{1};-- Input sheet name could not be created:{2}

error BW-Plug-in Occurs in the process of creating rows when the plug-in fails to create a sheet because the sheet name is illegal or the Excel file is damaged. Enter values of a valid Excel file with a valid sheet name.
TIBCO-BW-PALETTE-EXCEL-514001

Activity Name:{0},Operation Name:{1};-- EndRowPointer should be greater than 0

error BW-Plug-in Occurs in the process of deleting rows when the value in the EndingRowPointerToDelete element is less than zero. Ensure that the value in the EndingRowPointerToDelete element is greater than zero.
TIBCO-BW-PALETTE-EXCEL-514002

Activity Name:{0},Operation Name:{1};-- Start Row pointer cannot be greater than end Row pointer for sheet: {2}

error BW-Plug-in Occurs in the process of deleting rows when the value in the StartingRowPointerToDelete element is greater than the value in the EndingRowPointerToDelete element. Ensure that the value in the StartingRowPointerToDelete element is equal to or less than the value in the EndingRowPointerToDelete element.
TIBCO-BW-PALETTE-EXCEL-514003

Activity Name:{0},Operation Name:{1};-- Entered sheet pointer {2} is more than total sheets in workbook. Value can be ranging from 1 to total number of sheets in excel file {3}

error BW-Plug-in Occurs in the process of reading or deleting rows when the value of the sheet pointer is greater than the total sheet number in the Excel file. Ensure that the value of the sheet pointer is equal to or less than the total sheet number in the Excel file.
TIBCO-BW-PALETTE-EXCEL-515001

Activity Name:{0},Operation Name:{1};-- RowChunckSizeToRead should be greater than 0

error BW-Plug-in Occurs in the process of reading cell values from rows when the value in the RowChunckSizeToRead element in the Input tab is equal to or less than zero. Ensure that the value in the RowChunckSizeToRead element in the Input tab is greater than zero.