Error Messages Relating to References
| Code | 162142 |
| Severity | Error |
| Message | The reference {0} has a different number of columns than the database table it is mapped to. This error can be caused by not giving the exact name of the database table (including casing). |
| Description | The reference {0} has a different number of columns than the database table it is mapped to. This error can be caused by not giving the exact name of the database table (including casing). |
| Code | 162143 |
| Severity | Warning |
| Message | The reference {0} has encountered an error validating data type compatibility. This failure is not fatal, but could indicate a future failure processing data. {1} |
| Description | The reference {0} has encountered an error validating data type compatibility. This failure is not fatal, but could indicate a future failure processing data. {1} |
| Code | 162144 |
| Severity | Warning |
| Message | The reference {0} cannot validate its data type mappings because the source contains no data. Startup will proceed, but there is no guarentee that the mapping provided is valid. |
| Description | The reference {0} cannot validate its data type mappings because the source contains no data. Startup will proceed, but there is no guarentee that the mapping provided is valid. |
| Code | 162200 |
| Severity | Error |
| Message | A {0} clause cannot be specified when defining a reference. |
| Description | Invalid clause specified when defining a reference. Please remove the {0} clause and compile again. |
| Code | 162201 |
| Severity | Error |
| Message | The property {0} is not a valid property of a reference. |
| Description | The property {0} is not a valid property of a reference. Remove the property and its value and compile again. |
| Code | 162202 |
| Severity | Error |
| Message | The source property which is required was not set for the reference. |
| Description | The source property is a required element of a valid reference. Please add the source property to the properties clause of the reference. The source represents the object in the service from which data should be retrieved for this reference. |
| Code | 162203 |
| Severity | Error |
| Message | The service property which is required was not set for the reference. |
| Description | The service property is a requirement element of a valid reference. Please add the service property to the properties clause of the reference. The service represents the external source from which data should be retrieved for this reference. |
| Code | 162204 |
| Severity | Error |
| Message | A schema was not defined on the reference. The schema clause is required for references. |
| Description | A schema was not defined on the reference. The schema clause is required for references. |
| Code | 162205 |
| Severity | Error |
| Message | The value provided for one or more properties of the reference {0} were invalid. Please correct the errors identified in the messages that follow and try again. |
| Description | The value provided for one or more properties of the reference {0} were invalid. Please correct the errors identified in the messages that follow and try again. |
| Code | 162206 |
| Severity | Error |
| Message | An adapter cannot be attached to a reference. Please attach the adapter to a stream or window, or remove the attach adapter statement. |
| Description | An adapter cannot be attached to a reference. Please attach the adapter to a stream or window, or remove the attach adapter statement. |
| Code | 162207 |
| Severity | Error |
| Message | An error stream cannot collect error data from a reference since the reference doesn't generate events. Please attach the error stream to a stream or window and try again. |
| Description | An error stream cannot collect error data from a reference since the reference doesn't generate events. Please attach the error stream to a stream or window and try again. |
| Code | 162208 |
| Severity | Error |
| Message | The maximum number of reconnect attempts for a reference must be a number 0 or higher or -1 to indicate an unlimited number of reconnection attempts. Please choose a value in this range and try again. |
| Description | The maximum number of reconnect attempts for a reference must be a number 0 or higher or -1 to indicate an unlimited number of reconnection attempts. Please choose a value in this range and try again. |
| Code | 162209 |
| Severity | Error |
| Message | The reconnection attempt delay property must be a number that is greater than or equal to 0. Please provide a number in this range and try again. |
| Description | The reconnection attempt delay property must be a number that is greater than or equal to 0. Please provide a number in this range and try again. |
| Code | 162210 |
| Severity | Error |
| Message | A reference cannot be a source for a stream performing pattern matching. The source {0} is a reference. Please remove this reference as a source or remove the MATCHING clause and try again. |
| Description | A reference cannot be a source for a stream performing pattern matching. The source {0} is a reference. Please remove this reference as a source or remove the MATCHING clause and try again. |
| Code | 162211 |
| Severity | Error |
| Message | The reference {0} used as an input to this stream specifies a KEEP clause. KEEP clauses are not supported on references. Please remove the KEEP clause and try again. |
| Description | The reference {0} used as an input to this stream specifies a KEEP clause. KEEP clauses are not supported on references. Please remove the KEEP clause and try again. |
| Code | 162212 |
| Severity | Error |
| Message | The reference {0} is the only input to the derived query. A reference does not generate events and therefore must be joined with a window, stream or deltastream in order to be used in a derived query. Please join the reference table with another element and try again. |
| Description | The reference {0} is the only input to the derived query. A reference element does not generate events and therefore must be joined with a window, stream or delta-stream in order to be used in a derived query. Please join the reference table with another element and try again. |
| Code | 162213 |
| Severity | Error |
| Message | Columns from the reference {0} are being used in the primary key of the derived window. No columns from a reference can be used in the primary key of a derived element. Please choose a different primary key and try again. |
| Description | Columns from the reference {0} are being used in the primary key of the derived window. No columns from a reference can be used in the primary key of a derived element. Please choose a different primary key and try again. |
| Code | 162214 |
| Severity | Error |
| Message | The properties clause is a required clause for a reference. Please add the properties clause along with the required properties and compile again. |
| Description | The properties clause is a required clause for a reference. Please add the properties clause along with the required properties and compile again. |
| Code | 162215 |
| Severity | Error |
| Message | A reference has been used in the full outer join defined in the element {0}. References cannot be used in a full outer join. Please remove the reference from the full outer join or use a different join type where the reference is on the inner side of the join. |
| Description | A reference has been used in the full outer join defined in the element {0}. References cannot be used in a full outer join. Please remove the reference from the full outer join or use a different join type where the reference is on the inner side of the join. |
| Code | 162216 |
| Severity | Error |
| Message | A reference has been joined to another reference in the element {0}. References cannot be joined with other references. |
| Description | A reference has been joined to another reference in the element {0}. References cannot be joined with other references. |
| Code | 162217 |
| Severity | Error |
| Message | A reference cannot be used on the outer side of a join. The reference {0} is used on the left side of a left outer join or on the right side of a right outer join with {1}. Please remove the reference from the join or use a different join type. |
| Description | A reference cannot be used on the outer side of a join. The reference {0} is used on the left side of a left outer join or on the right side of a right outer join with {1}. Please remove the reference from the join or use a different join type. |
| Code | 162218 |
| Severity | Error |
| Message | In element {0}, the reference {1} does not have all of the columns of its primary key bound in the join. A reference cannot be on the many side of a join when the join is a window. Please add all of the columns from the reference's primary key to the where or on clause and try again. |
| Description | In element {0}, the reference {1} does not have all of the columns of its primary key bound in the join. A reference cannot be on the many side of a join when the join is a window. Please add all of the columns from the reference's primary key to the where or on clause and try again. |
| Code | 162219 |
| Severity | Error |
| Message | An input to the window {0} is the reference {1} on which a primary key has not been defined. A reference with no primary key defined cannot be joined with other elements to produce a window unless that window has aggregation. If the data source has a primary key, please define it on the reference, or add a group by clause to the window, or use a stream for this join element. |
| Description | An input to the window {0} is the reference {1} on which a primary key has not been defined. A reference with no primary key defined cannot be joined with other elements to produce a window unless that window has aggregation. If the data source has a primary key, please define it on the reference, or add a group by clause to the window, or use a stream for this join element. |
| Code | 162220 |
| Severity | Error |
| Message | The reference {0} used in the join does not have a primary key defined and the join involves more than one streaming element (window, stream or delta stream). When a reference without a primary key is used in a join, it can join with at most one streaming element. Break up the join query so that the reference and a single streaming element combine to form a derived stream, and then use that stream to build up the rest of the query in another derived element. |
| Description | The reference {0} used in the join does not have a primary key defined and the join involves more than one streaming element (window, stream or delta stream). When a reference without a primary key is used in a join, it can join with at most one streaming element. Break up the join query so that the reference and a single streaming element combine to form a derived stream, and then use that stream to build up the rest of the query in another derived element. |
| Code | 162221 |
| Severity | Error |
| Message | The reference {0} used in the join does not have its primary key completely bound in the join conditions and the join involves more than one streaming element (window, stream or delta stream). When a reference with a primary key is used in a join and its primary key is not entirely bound by the join condition, it can join with at most one streaming element. Bind the entire primary key of the reference in the join conditions or break up the join query so that the reference and a single streaming element combine to form a derived stream, and then use that stream to build up the rest of the query in another derived element. |
| Description | The reference {0} used in the join does not have its primary key completely bound in the join conditions and the join involves more than one streaming element (window, stream or delta stream). When a reference with a primary key is used in a join and its primary key is not entirely bound by the join condition, it can join with at most one streaming element. Bind the entire primary key of the reference in the join conditions or break up the join query so that the reference and a single streaming element combine to form a derived stream, and then use that stream to build up the rest of the query in another derived element. |
| Code | 162222 |
| Severity | Error |
| Message | The reference {0} is defined within a module, but it has a PROPERTIES clause defined. References declared within a module cannot have PROPERTIES clauses. |
| Description | No additional information available. |
| Code | 162223 |
| Severity | Error |
| Message | A reference, {0}, is being used as an input to the event cache {1}. Since references do not produce any streaming data, they cannot be used as input to an event cache. |
| Description | A reference, {0}, is being used as an input to the event cache {1}. Since references do not produce any streaming data, they cannot be used as input to an event cache. |
| Code | 162224 |
| Severity | Error |
| Message | The reference {0} is aliased multiple times in the same join. Self joins using references are not supported. If you need to construct a query using a self join, set up a view in the database that performs the self-join on the table information itself or split the join up into multiple ESP joins. |
| Description | No additional information available. |
| Code | 162225 |
| Severity | Error |
| Message | The reference {0} has been given a column name of {1} which contains blacklisted keywords. Please use another column name. |
| Description | References do not allow certain SQL keywords to prevent SQL injection. |
| Code | 162226 |
| Severity | Error |
| Message | Column {0} in reference {1} has an invalid column type. It may be unsupported by references or otherwise invalid. Please choose a valid column type. |
| Description | Column {0} in reference {1} has an invalid column type. It may be unsupported by references or otherwise invalid. Please choose a valid column type. |
| Code | 162227 |
| Severity | Error |
| Message | The reference {0} has been given a table name of {1} which contains blacklisted keywords. Please use another table name. |
| Description | References do not allow certain SQL keywords to prevent SQL injection. |
| Code | 162228 |
| Severity | Error |
| Message | The reference {0} has been given a schema name of {1} which contains blacklisted keywords. Please use another schema name. |
| Description | References do not allow certain SQL keywords to prevent SQL injection. |
| Code | 162229 |
| Severity | Error |
| Message | The reference {0} has a reconnect delay of {1}. Please provide an integer value of 0 or more. |
| Description | The reference {0} has a reconnect delay of {1}. Please provide an integer value of 0 or more. |
| Code | 162230 |
| Severity | Error |
| Message | The reference {0} has a reconnect attempt of {1}. Please provide an integer value of 0 or more. |
| Description | The reference {0} has a reconnect attempt of {1}. Please provide an integer value of 0 or more. |
| Code | 162231 |
| Severity | Error |
| Message | The reference {0} has been given a value for the parameter {1}, which is not a valid parameter name. Please double-check the documentation for a list of valid parameter names. |
| Description | The reference {0} has been given a value for the parameter {1}, which is not a valid parameter name. Please double-check the documentation for a list of valid parameter names. |
| Code | 162232 |
| Severity | Error |
| Message | There has been an internal error in intializing the reference {0}. Please double-check your environment, and contact SAP support if the problem persists. |
| Description | There has been an internal error in intializing the reference {0}. Please double-check your environment, and contact SAP support if the problem persists. |
| Code | 162233 |
| Severity | Error |
| Message | Cannot create connection for reference {0}. {1} |
| Description | Cannot create connection for reference {0}. {1} |
| Code | 162234 |
| Severity | Error |
| Message | Cannot establish connection for reference {0}. {1} |
| Description | Cannot establish connection for reference {0}. {1} |
| Code | 162235 |
| Severity | Error |
| Message | Cannot create prepared statement for reference {0}. {1} |
| Description | Cannot create prepared statement for reference {0}. {1} |
| Code | 162236 |
| Severity | Error |
| Message | Cannot get data for reference {0}. {1} |
| Description | Cannot get data for reference {0}. {1} |
| Code | 162237 |
| Severity | Error |
| Message | The reference {0} is not using a service that supports primary key discovery, and has keys specificed. Pease remove the primary keys from your reference, or use a service that supports primary key discovery. |
| Description | The reference {0} is not using a service that supports primary key discovery, and has keys specificed. Pease remove the primary keys from your reference, or use a service that supports primary key discovery. |
| Code | 162238 |
| Severity | Error |
| Message | The reference {0} has a schema that contains column {1}. The source does not contain this column. Reference column names must match source column names. |
| Description | The reference {0} has a schema that contains column {1}. The source does not contain this column. Reference column names must match source column names. |
| Code | 162239 |
| Severity | Error |
| Message | The reference {0} has encountered an error attempting to validate the datatype of column {1}. This could be caused by an invalid type mapping. Error reported: {2} |
| Description | The reference {0} has encountered an error attempting to validate the datatype of column {1}. This could be caused by an invalid type mapping. Error reported: {2} |
| Code | 162240 |
| Severity | Error |
| Message | The reference {0} has specified a primary key that does not match the source key. When specifying a primary key, the two must match. |
| Description | The reference {0} has specified a primary key that does not match the source key. When specifying a primary key, the two must match. |
| Code | 162241 |
| Severity | Error |
| Message | The reference {0} has specified a primary key, but the source schema name has not been provided as a property to the reference. When specifying a primary key for a reference, the source schema property must be provided so that the source can be identified uniquely and the primary key of the reference can be validated against the primary key enforced by the source. |
| Description | The reference {0} has specified a primary key, but the source schema name has not been provided as a property to the reference. When specifying a primary key for a reference, the source schema property must be provided so that the source can be identified uniquely and the primary key of the reference can be validated against the primary key enforced by the source. |