Welcome
Product Documentation
Messages Guide
Messages
HPS6209
SQL error while executing SQL statement: {0}

Release Notes
Product Documentation
- Licensing
- Getting Started
- User's and Administrator's Guide
- Web Application Programmer's Guide
- Cloud Deployment
- Rich Client Platform Programmer's Guide
- Messages Guide
  - Messages
    - HAT0001
      Loading configuration data from {0}.
    - HAT0002
      The message log file is {0}.
    - HAT0003
      The trace log file is {0}.
    - HAT0040
      A program exception occurred. There may be additional messages in this log which describe the error. The following information may help determine the cause, if this log is requested by HCL service: {0}
      {1}
    - HAT0060
      File {0} was not found.
    - HAT0061
      Directory {0} was not found.
    - HAT0062
      Archive file {0} could not be created.
    - HAT0300
      An unexpected exception was received: {0}
    - HAT0350
      An error occurred reading the file {0}.
    - HAT0351
      An error occurred writing the file {0}.
    - HAT0352
      Cannot find the file named {0}.
    - HAT0353
      Creating the file {0}.
    - HAT0354
      Failed to delete the file named {0}.
    - HAT0400
      An exception occurred creating the host configuration. A message containing the exception details follows.
    - HAT0401
      Cannot connect to the host using the following session properties:{0}
    - HAT0402
      Session is in CONNECTION_ACTIVE state, but not CONNECTION_READY state. A possible reason could be that the TN server port specified does not support the data stream expected. Session properties being used:
      {0}
    - HAT0403
      Cannot load the application {0}.
    - HAT0405
      Session is ready, but no host data was available. Session properties:{0}
    - HAT0410
      An error occurred while processing this request. Detailed error information: {0}
    - HAT0411
      The host connection is inactive.
    - HAT0412
      An error occurred while processing an application Web page "{0}".
    - HAT0413
      An exception occurred. {0}
    - HAT0414
      An error occurred while scanning for screen matches.
    - HAT0415
      The wfhats.xml file is malformed.
    - HAT0600
      An error occurred while retrieving the action list for the screen customization "{0}".
    - HAT0601
      The action {0} specifies an invalid parameter.
    - HAT0602
      Cannot insert null value to the host screen at row {0}, column {1}.
    - HAT0603
      Cannot insert the value {0} to the host screen at row {1}, column {2}, because the host screen size is {3}.
    - HAT0604
      An exception occurred while calculating the value for the global variable {0}. The action which failed was {1}. A message containing the exception details follows.
    - HAT0605
      An error occurred while processing the actions for the screen customization "{0}".
    - HAT0606
      Global variable "{0}" does not exist.
    - HAT0607
      The index {0} for global variable "{1}" is out of bounds. The global variable has {2} elements.
    - HAT0608
      Cannot insert the value "{0}" to the host screen at row {1}, column {2}, because the location is not contained in an unprotected field.
    - HAT0700
      The attribute "{0}" of widget setting does not exist.
    - HAT0701
      The value of attribute "{0}" in widget setting is empty.
    - HAT0702
      The value of attribute "{0}" in widget setting is invalid.
    - HAT0703
      An error occurred while processing a transformation fragment {0}.
    - HAT0800
      An exception occurred setting the property of print session. A message containing the exception details follows.
    - HAT0801
      An exception occurred processing PDF I/O to client browser. A message containing the exception details follows.
    - HAT0910
      User credentials could not be retrieved from Web Express™ Logon.
    - HAT0911
      Web Express™ Logon macro could not be initialized.
    - HAT0912
      Web Express™ Logon cannot retrieve user credentials because the client servlet request was not provided.
    - HAT0913
      Web Express™ Logon cannot retrieve user credentials because the credential mapper was not initialized.
    - HAT0914
      Verify that the connection has been configured to support Web Express™ Logon.
    - HAT0915
      The plug-in {0} is not appropriate for the environment it is running in. Be sure to choose the proper plug-in implementation class for each environments.
    - HPS5001
      The value {0} of the attribute {1} in the XML element {2} is not a valid value
    - HPS5007
      Failed to delete the file named {0}
    - HPS5008
      There was an error reading the file {0}
    - HPS5009
      There was an error writing the file {0}
    - HPS5010
      The installation directory parameter {0} specifies a directory {1} that is not an absolute path
    - HPS5011
      The installation directory parameter {0} specifies a path {1} that does not exist
    - HPS5012
      {0} is not a directory
    - HPS5013
      The XML element {0} is missing the required attribute {1}
    - HPS5014
      The initialization parameter {0} is missing. It should specify the installation directory name
    - HPS5015
      The XML element {0} is missing either the attribute {1} or the attribute {2}
    - HPS5016
      The XML element {0} is not a valid element in the file {1}
    - HPS5017
      Unexpected error {0} occurred. {1}
    - HPS5018
      An unexpected exception has occurred. {0}.
    - HPS5019
      There was an XML parse error while reading the file {0} or its DTD file at line {1} in column {2}. The error message is {3}
    - HPS5020
      An exception occurred while parsing XML file {0} : {1}.
    - HPS5021
      Invalid value of attribute {0} in object {1}. {0} can only be greater than 0.
    - HPS5022
      Invalid value of attribute {0} in object {1}. {0} cannot be equal to 0
    - HPS5023
      Invalid value of attribute {0} in object {1}. {0} can only be 0 or higher
    - HPS5024
      Invalid value of attribute {0} in object {1}. {0} can only be -1 or higher.
    - HPS5025
      Missing mandatory attribute {0} in object {1}
    - HPS5027
      Error creating object {0}. Object {1} not defined.
    - HPS5028
      Object {0} already defined
    - HPS5029
      The runtime is not started.
    - HPS5030
      {0} expired. Cannot get a connection from {1}.
    - HPS5031
      Object {0} not defined
    - HPS5032
      Cannot load Pool Manager {0}
    - HPS5033
      Too little memory. {0} bytes available
    - HPS5034
      No HttpSession available
    - HPS5035
      HPS5035 There is no data source object {0} in HttpSession. A possible cause is the use of multiple browsers from a single machine to a chained application. See documentation for more information.
    - HPS5036
      Attempt to create user list with invalid type: {0}.
    - HPS5037
      Attempt to create user list with invalid name: {0}.
    - HPS5038
      Error creating object {0}. Object is empty
    - HPS5039
      Cannot get a User from user list {0}
    - HPS5040
      Invalid value of attribute {0} in object {1}. {0} can only be -1 or greater than 0
    - HPS5041
      Value of attribute {0} specified, but no file name specified.
    - HPS5043
      Internal error, attribute {0} in Conn object is null.
    - HPS5044
      SQL connection is closed.
    - HPS5045
      JDBC exception while checking connection state : {0}
    - HPS5046
      JDBC driver {0} not loadable, received exception: {1}
    - HPS5047
      JDBC getConnection call failed for URL {0}, received exception: {1}
    - HPS5048
      Call to method {0} not expected for JDBC connections.
    - HPS5049
      The following Session properties are not acceptable to HOD : {0}. Exception received: {1}
    - HPS5050
      Cannot recover connection if HodLogonSpec is null.
    - HPS5051
      Cannot recover connection if logon or alternate logon macros are null
    - HPS5052
      Cannot set up a connection to the host using the following session properties: {0}
    - HPS5053
      Received InterruptedException: {0}
    - HPS5054
      Macro state STATE_EMPTY not reached. Current® macro state is {0}
    - HPS5055
      Ran out of time while playing HOD macro: Macro file name = {0} Macro = {1}
    - HPS5056
      Problem encountered while playing macro in file {0} Current® state is {0} Initial fragment of the macro: {1}
    - HPS5057
      PropertyVetoException received from HOD: {0}
    - HPS5058
      MacroException received from HOD: {0}
    - HPS5059
      HOD extract event {0} not expected. Extracts are not permitted in logon or logoff macros
    - HPS5060
      Both UserPool and BeanRef are null - cannot provide value for prompt {0} to HOD macro
    - HPS5061
      Ran out of time while supplying prompt values to HOD macro in file {0}. Exception received: {1}
    - HPS5062
      Macro prompt value could not be provided. Exception received: {0}
    - HPS5063
      Received the following MacroErrorEvent while playing HOD macro: {0}
    - HPS5064
      No get_userid method (with either 0 or 1 argument) in bean
    - HPS5065
      No get_password method in bean
    - HPS5066
      No "getter" method {0} for parameter {1} in bean {2}
    - HPS5067
      Exception received when calling getter method in bean: {0}
    - HPS5068
      Exception received: {0}
    - HPS5069
      Attempt to set connection state to {0} is not valid.
    - HPS5070
      Cannot change originating Pool. Old: {0}, New: {1}.
    - HPS5071
      Cannot change connection specification. Old: {0}, New: {1}
    - HPS5072
      There is no Pool Manager
    - HPS5073
      An encryption key is needed to start the system.
    - HPS5074
      An encryption key is needed because user list {0} is encrypted.
    - HPS5075
      Received STATE_PLAY_ERROR while playing macro in file {0}
    - HPS5077
      Session is in CONNECTION_ACTIVE state, but not CONNECTION_READY state. A possible reason could be that the TN server port specified does not support the data stream expected. Session properties being used: {0}
    - HPS5079
      HOD macro {0} has one or more syntax errors
    - HPS5080
      Invalid value of attribute {0} in object {1}. {0} can only be -1 or greater than {2}
    - HPS5081
      The value {0} assigned to the attribute {1} in the file {2} is not valid. It should be a number. A value of {3} will be used.
    - HPS5082
      Missing property {0} in user list {1}
    - HPS5083
      Failed to find the file named {0}
    - HPS5084
      Could not set up a connection
    - HPS5086
      Invalid value of attribute {0} in object {2}. {0} cannot be greater than attribute {1}. The value of attribute {1} will be used.
    - HPS5090
      System start
    - HPS5091
      System shutdown
    - HPS5092
      {0} Security attribute {1} appears to be corrupted, or the encryption key is incorrect. {2}
    - HPS5093
      {0} Invalid schema value for {1} property. {2}
    - HPS5094
      {0} User property {1} conflicts with schema. {2}
    - HPS5095
      User {0} not found in user list {1}
    - HPS5096
      Pool {0} exceeded its capacity. Overflow connection created
    - HPS5097
      Pool {0} exceeded its capacity. Request failed
    - HPS5098
      Ran out of time while playing HOD macro: Macro file name = {0} Macro = {1} Exception received: {2}
    - HPS5099
      Internal error, the following attribute or result is unexpected {0}
    - HPS5100
      User ID {0} from UserPool {1} was used to set up a session to host {2}, and must be recovered
    - HPS5101
      The WebSphere® servlet engine cannot create an HttpSession object to store the host connection with the key {0}.
    - HPS5102
      Insufficient rights to the file {0}. Please check file owner and permissions
    - HPS5103
      The data source connection has been removed, probably because the maxBusyTime has expired
    - HPS5107
      User list {0} not found
    - HPS5108
      Connection Pool {0} not found
    - HPS5109
      Hostname {0} cannot be resolved
    - HPS5110
      RemoteException received when making RMI call: {0}
    - HPS5111
      Integration object {0} has no methods. Check your Java™ CLASSPATH
    - HPS5117
      Key {0} not present in message file
    - HPS5136
      There is no runtime on host "{0}" named {1}.
    - HPS5137
      Checkin screen did not match current PS. Connection = {0} ECL error = {1} Screen description = {2} Screen dump = {3}
    - HPS5142
      License limit has been reached. No further connections are allowed. For more information on licensing enablement, see the InfoCenter at ({0}).
    - HPS5143
      An Exception was caught when creating an HOD screen for connection {0}. This probably is caused by an environment configuration problem. Perhaps the X Window System DISPLAY variable is not set, or RAWT is not configured properly.
    - HPS5145
      Cannot connect to the host using SSL. If importing a certificate is required for this SSL connection, make sure that it has been imported from the Telnet server into a valid PKCS12 file, and that the password (SSLP12Password) and path (SSLP12FilePath) for the PKCS12 file are specified correctly. The session properties are: {0}
    - HAT5551
      Parameter {0} is missing
    - HAT5552
      Conflicting parameters {0}
    - HAT5556
      File has been opened {0}
    - HAT5557
      File not found {0}
    - HAT5561
      A fix for {0} cannot be applied to {1}.
    - HAT5562
      {0} fix information for {1} was not found in {2}
    - HAT5563
      {0} cannot be restored because it has not been applied
    - HAT5564
      {0} cannot be committed because it has not been applied
    - HAT5565
      Fix {0} has an unknown type {1}
    - HAT5571
      CAPAR {0} was applied on {1}
    - HAT5572
      CAPAR {0} was committed on {1}
    - HAT5573
      CAPAR {0} has an unknown state {1}
    - HAT5574
      APAR {0} was applied on {1}
    - HAT5575
      APAR {0} was committed on {1}
    - HAT5576
      APAR {0} has an unknown state {1}
    - HAT5577
      Fix type {0} is a valid type for {1}
    - HAT5578
      APAR {0} for build {1} will be applied to build {2}
    - HAT5579
      CAPAR {0} for build {1} will be applied to build {2}
    - HAT5581
      Source file {0} is available
    - HAT5582
      There are no CAPARs applied to this component.
    - HAT5583
      There are no APARs applied to this component.
    - HAT5584
      There are no CAPARs or APARs applied to this component
    - HAT5585
      The {0} build level is {1} dated {2}
    - HAT5586
      Report for {0} version {1}
    - HAT5587
      CAPAR {0} includes fix {1}
    - HAT5588
      APAR {0} includes fix {1}
    - HAT5589
      {0} is not applied or committed
    - HAT5590
      {0} is included in fix {1}
    - HAT5591
      {0} cannot be applied because it was superseded by {1}
    - HAT5592
      {0} cannot be applied until prereq fix {1} is committed
    - HAT5593
      {0} cannot be applied because it requires prereq fix {1}
    - HAT5594
      {0} has already been applied
    - HAT5595
      Write permission is denied for target {0}.
    - HAT5596
      Source file {0} is missing
    - HAT5597
      Read permission is denied for {0}
    - HAT5598
      Checking source file {0}
    - HAT5599
      {0} - Checking applied fix {1}
    - HAT5602
      Checking target file {0}
    - HAT5603
      Target file {0} is missing and cannot be replaced
    - HAT5604
      Directory {0} is missing
    - HAT5605
      Existing file {0} will be replaced
    - HAT5606
      Target file {0} is missing and cannot be removed
    - HAT5607
      Target file {0} is missing and cannot be restored
    - HAT5611
      File {0} was previously backed up
    - HAT5612
      Checking backup file {0}
    - HAT5613
      Backup file {0} is missing
    - HAT5614
      Target file {0} is missing and will be created.
    - HAT5615
      Write access is permitted for target {0}.
    - HAT5616
      Read access is permitted for {0}
    - HAT5617
      Source file {0}
    - HAT5618
      Target file {0}
    - HAT5619
      Creating directory {0}
    - HAT5620
      Existing target file {0} will be backed up
    - HAT5621
      Backing up file {0}
    - HAT5623
      Applying new file {0}
    - HAT5624
      Removing old file {0}
    - HAT5627
      File {0} was previously restored
    - HAT5628
      Restoring original file {0}
    - HAT5629
      {0} cannot be restored because it has been committed
    - HAT5630
      {0} cannot be restored because it has not been applied
    - HAT5635
      {0} has concurrent {1} fix requirements - see the readme file
    - HAT5641
      {0} has already been committed
    - HAT5642
      {0} must be committed before a new fix can be applied
    - HAT5643
      {0} for build {1} cannot be applied to build {2}
    - HAT5644
      {0} for build {1} cannot be applied to build {2}
    - HAT5645
      The request was successful
    - HAT5646
      The request was not successful
    - HAT5647
      The final return code is {0}
    - HAT5648
      Log file {0} contains 1 additional message.
    - HAT5649
      Log file {0} contains {1} additional messages.
    - HAT5653
      System Information {0} {1}
    - HAT5654
      Today is {0}
    - HAT5655
      Fix type {0} is not a CAPAR or APAR
    - HAT5656
      Unable to construct the XML image {0}
    - HAT5657
      Unexpected xerces exception {0}
    - HAT5658
      Unexpected exception {0}
    - HAT5659
      Internal program problem {0}
    - HAT5700
      User Parameter {0} {1}
    - HAT5703
      Checking {0} root {1}
    - HAT5704
      Unable to locate {0} root {1}
    - HAT5705
      {0} root located {1}
    - HAT5706
      {0} product not found
    - HAT5708
      {0} not found.
    - HAT5710
      {0} located {1}
    - HAT5711
      Fix file not found {0}
    - HAT5712
      Unknown action {0}
    - HAT5713
      Extracting fix {0} ...
    - HAT5714
      Extracting the fix control file {0}
    - HAT5715
      Fix control file {0} is missing
    - HAT5716
      Extracting the fix data files
    - HAT5745
      {0} can not be applied until previous maintenance is applied to your HCL ZIETrans projects. See the readme for information on applying maintenance to your HCL ZIETrans projects.
    - HPS5747E
      Unable to copy application configuration files
    - HPS5748E
      Security Exception {0}
    - HPS5750E
      Arguments are {0}
    - HPS5905
      Exception occurred attempting to invoke ConnMgr to cleanup a connection
    - HPS5950
      {0}: {1}: {2}: HPubEJB2_Reference={3}, JNDI_NAME={4}, PROVIDER_URL={5}, INITIAL_CONTEXT_FACTORY={6}
    - HPS5951
      {0}: accessHandle==null || hPubLinkKey==null
    - HPS5952
      {0}: getEJBObject(): {2}: {3}
    - HPS5953
      {0}: processIO({1}): {2}: {3}
    - HPS5954
      {0}: HPubEJB.remove(), ejb={1}: {2}: {3}
    - HPS5955
      {0}: ejb.getHandle(), ejb={1}: {2}: {3}
    - HPS5956
      {0}: HttpServletRequest.getSession(true), hPubLinkKey={2}
    - HPS6002
      Conn exception while releasing session to the Session Manager
    - HPS6003
      Unable to acquire connection from the Session Manager
    - HPS6004
      Exception while invoking a property's read method
    - HPS6005
      Internal processing error
    - HPS6006
      Introspection exception
    - HPS6007
      Connection Link Key is null when trying to acquire a chained non-web connection
    - HPS6008
      Connection Link Key is null when trying to release a chained non-web connection
    - HPS6009
      Unexpected exception: {exception text}
    - HPS6100
      Unable to acquire session from the Session Manager
    - HPS6101
      Internal HOD macro processing error
    - HPS6102
      Internal macro processing error, extraction coordinates out of bounds
    - HPS6103
      Internal macro processing error, macro empty
    - HPS6105
      Received unexpected interrupted exception while waiting
    - HPS6106
      Unable to communicate with the Session Manager
    - HPS6107
      Illegal access exception while invoking a property's read method
    - HPS6108
      Invocation target exception while invoking a property's read method
    - HPS6109
      Exception occurred, cannot retrieve current screen
    - HPS6112
      Received the following MacroErrorEvent while playing Host On-Demand macro: {0}
    - HPS6202
      Internal error: Unable to locate read method for property
    - HPS6203
      Internal error: Unable to locate marker for end-of-input-variable in SQL statement
    - HPS6204
      Internal error: Unable to locate ForSQL read method for property
    - HPS6205
      SQL error while opening statement
    - HPS6209
      SQL error while executing SQL statement: {0}
    - HPS6210
      Numeric input values cannot be blank. Enter a value for all numeric input fields
    - HPS7001
      Unexpected exception {0}.
    - ZTR0003
      Failure processing the borrow interval {0}. Default 30m assigned. Verify the value entered for {1} in runtime properties. For more information on licensing enablement, see the InfoCenter at ({2}).
    - ZTR0004
      Failure in loading private key specified in the path {0}. Verify the valid private key file exists in the path given for {1} in runtime properties. For more information on licensing enablement, see the InfoCenter at ({2}).\nError message : {3}.
    - ZTR0005
      Failure processing the license server response for session {0}. Refer to the following error message for details. \n {1}.
    - ZTR0006
      Failure processing the license server response for session {0}. The given feature {1} {2} is unavailable in the license server.
    - ZTR0007
      Failure during license server request preparation/processing for session {0}. Refer to the following error message for details. \n {1}.
    - ZTR0009
      License server not found. Response code returned is {0} for the server URL {1}.
    - ZTR0010
      License server response received with no payload for the session {0}.
    - ZTR0011
      License unavailable for session {0}. Error occurred while forwarding to error page jsp. Refer below error for details.\n {1}.
    - ZTR0012
      License unavailable for reissue of the session {0}.
    - ZTR0013
      License unavailable for the session {0}.
    - ZTR1001
      The field {0} in web.xml is blank.
    - ZTR1002
      The request has been discarded as the origin check failed.
    - ZTR1003
      The request has been discarded as the origin check failed.
    - ZTR1004
      The request has been discarded due to token unavailability.
    - ZTR1005
      The request has been discarded due to token mismatch.
  - Notices
- Advanced Macro Guide
- Troubleshooting
- Configure DCAS for Web Express Logon

HPS6209

SQL error while executing SQL statement: {0}

An error was received for the SQL call: executeUpdate.

Investigate the cause of the SQL error. A more detailed description of the SQL exception should be in message log file.