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. |