Troubleshooting suggestions for database operation errors

The mechanism for capturing database errors is the same for both PowerBuilder C/S app and PowerServer installable cloud app. However, if you encounter inconsistent operations between them in certain scenarios, you can refer to the following information for preliminary troubleshooting:

  • Is it a database version supported by PS?

    You can find a list of supported database types and versions in Supported database types & versions. For example, Oracle 12c or later is the minimum supported version for Oracle databases.

  • Is it an unsupported feature or a feature difference?

    For more, refer to Unsupported Features & Workarounds Guide.

    Make sure the DBParm properties are correctly set. Keep in mind that not all DBParm properties are supported by PowerServer, and some are designed exclusively for use in PowerServer. For more, refer to Supported DBParm properties.

  • Have you checked the PowerServer Troubleshooting Guide for this specific problem?

    For instance, if you are encountering the error "SQLHandle not found", you can find relevant information in SQLHandle not found.

  • If you need more debugging tips, you can refer to Debugging Guide and explore further debugging options.