Data Pipeline Loading Errors

this table captures error codes and their corresponding error messages that you can encounter when you load data using data pipelines also, the table contains the definitions of the parameters in the error messages, descriptions that explain the error messages, and actions you can take to resolve the errors code error message message parameters description resolution old00 key key for class class must be set to a non null value details details key the key of the missing property class the class that has the missing property details additional information about the error this error occurs when the loading process reads the pipeline definition missing a required property specify a non null value for the specified key in the pipeline definition old01 value ' value ' is not acceptable with the key key for class class expected example details details value the value that you set for the specified pipeline definition key key the pipeline definition key with an incorrect value class the class that contains the property example an example or description of the correct value details additional information about the error this error occurs when the loading process reads the pipeline definition that contains a key with an incorrect value specify the correct value for the setting corresponding to the specified key in the pipeline definition old02 no class with name ' class ' exists in the pipeline builder packages pipeline cannot run class the class that cannot be found this error occurs when the loading process reads the pipeline definition that contains an unknown class ensure that the class exists and belongs to a package specified in the 'engine builder packages' configuration option ole00 failed to extract record with index index from ' sourcename ' details details index the index of the record (index starts at 1) in the source where the error occurred sourcename the name of the source resource where the error occurred details additional information about the error this error occurs when the extraction of a record fails provide the correct source data in the accurate format, extract configuration, or compression method ole01 dataextract cannot be extracted from ' sourcedata ' details details dataextract the data to extract sourcedata the source data for the extraction details additional information about the error this error occurs when the extraction of data from a record fails provide the correct source data in the accurate format, extract configuration, compression method, or transform configuration olo00 failed to connect to sourcetype source because the specified locationtype ' location ' was not found details details sourcetype the type of the source locationtype the type of the data location argument that was not found location the value of the data location argument that was not found details additional information about the error this error occurs when the pipeline cannot find the source data (e g , cannot find the configured bucket or file path) in the pipeline definition, specify an existing data location in the source olo01 failed to connect to sourcetype source because the access credentials are unauthorized details details sourcetype the type of source where access is denied details additional information about the error this error occurs when the pipeline cannot connect to the source due to invalid credentials specify credentials in the pipeline definition with access to the specified source or configure the source to provide access to the pipeline olo10 failed to connect to sourcetype source because the file path is empty the locations searched are location details details sourcetype the type of the source location the value of the data location argument that was not found this error occurs when the pipeline cannot find the source data (e g , the file path is empty) if an empty file list was expected, set the expect empty file list configuration option to true by executing alter system alter config set 'streamloader extractorengineparameters configurationoption expect empty file list' = 'true'; then, restart the pipeline olo50 file filename was not found filename the name of the missing file this error occurs when the pipeline is configured to fail on missing files, and it cannot find a file in the list handle the missing file using your own process or configure the pipeline to skip missing files instead ols00 failed to load transformed value ' value ' to sink after transformclassname details details value the value that the loader node could not load to the sink transformclassname the class of the executed transform details additional information about the error this error occurs when the loader node cannot load a transformed value to the sink for example, the transformed value might be too large for the sink column check that the sink column is configured correctly or check that the transforms in the column are composed properly to return values that can load to the sink ols97 no table with name ' tablename ' exists in sink at ipaddress port the available tables are existingtables tablename the fully specified name of the specified table ipaddress the ip address for the loader node of the {{ocient}} sink port the external tcp port for the loader node of the ocient sink existingtables the list of existing tables in the same database and schema as the specified table this error occurs when no table with the specified name exists in the sink, but the database and schema of the table do exist specify an existing table in the pipeline definition or create a table with the specified name ols98 the column name ' columnname ' does not exist the columns available to the pipeline from the tablename table are existingcolumns columnname the name of the column that was not found tablename the table that was searched existingcolumns the columns in the table that are available to the pipeline this error occurs when the target table in the sink does not contain all the columns specified in the pipeline or a column specified as a transform target is not declared in the sink definition of the pipeline (the database ignores deleted columns this error does not occur when you load data to a deleted column ) specify an existing column in the pipeline definition or add the corresponding column to the target table ols99 failed to connect to sink at ipaddress port check that a streamloader at that address is reachable ipaddress the ip address for the loader node of the ocient sink port the external tcp port for the loader node of the ocient sink this error occurs when the pipeline cannot connect to its ocient sink using a loader node check that the loader node at the specified host and port is reachable and that the host and port of the ocient sink are configured properly olt00 cannot perform operation operationname because the inputs are inputtype expected inputs are expectedtype operationname the name of the operation that cannot be performed because its inputs are the wrong type (usually the name of a transform class) inputtype the type of inputs that the operation received expectedtype the type of inputs that the operation expects to receive this error occurs when transforms in a column are not composed correctly add, remove, or replace transforms such that each transform receives input of the correct type and that the loader node loads data of the correct type into the target column olt01 failed to transform value ' value ' using transformclassname details details value the value that was not transformed transformclassname the class of the failed transform details additional information about the error this error occurs when a transformation fails correct the source data or modify the transform to fit the source data alternatively, start the pipeline with a higher error limit so the load skips the failing record olt02 value ' value ' is not an acceptable parametername for transformclassname expected example value the incorrect value for the specified parameter parametername the name of the specified parameter transformclassname the class of the transform that is not configured correctly example an example or description of the correct value this error occurs when the parameter of the transform is not configured correctly correct the parameter of the transform olt03 failed to transform value ' value ' using transformclassname because the value is valuedescription expected example value the value that was not transformed transformclassname the class of the failed transform valuedescription a feature or description of the incorrect value for this transform example an example or description of the correct value this error occurs when a transformation fails because the data is not correct for the transform correct the source data, modify the transform configuration, or use a different transform olt04 failed to match value ' value ' to format ' format ' in transformclassname because ' valuepart ' at position valuepartposition does not match pattern ' pattern ' expected example value the value that was not parsed with the transform format format the transform format transformclassname the class of the failed transform valuepart the part of the value that was unmatched valuepartposition the position (index starts at 1) of the part unmatched in the value pattern the pattern in the transform format that did not match part of the value example an example or description of the correct value this error occurs when a transformation fails because the value does not match the specified transform format correct the source data or modify the transform format to fit the source data oltm0 failed to transform ' value ' value using transformclassname details value the value that was not transformed transformclassname the name of the failed transform details additional information about the error this error occurs when an explode transformation fails correct the source data or modify the transform to fit the source data alternatively, start the pipeline with a higher error limit so the load skips the failing record ol998 an error occurred in library library details library the name of the library where the error occurred details additional information about the error this error occurs when the ocient system detects an error from an internal library diagnose and address the error using the details provided by the library ol999 an error occurred in class class details class the class that threw the exception details additional information about the error this error occurs when the ocient system detects a general error if the details of the message are not helpful for you to resolve the error, then contact ocient support related links docid\ pprxr3cgfqtt8wx7wl6ak docid\ jtogwzl3dyxndxierzyzt