IBM Support

Resolving SQL data source failure after import or upgrade action

Troubleshooting


Problem

The Connection password property and its password CLI equivalent is removed from the SQL data source object in 10.5.0.13 and 10.6.0.1.

When an SQL data source defines only the password and not a password alias, the import or upgrade action that contains this configuration fails and reports error message 0x8100043e with the text The SQL connection requires a password alias and the SQL data source is not configured.

Symptom

The import or export action fails with an error that is related to the missing but required password alias.

  • On import, the error message is reported during processing.
  • On upgrade, the error message is written to the system logs.

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS9H2Y","label":"IBM DataPower Gateway"},"ARM Category":[{"code":"a8m50000000CdxAAAS","label":"DataPower-\u003EDeveloper (DV)-\u003EService Config"},{"code":"a8m50000000CdsyAAC","label":"DataPower-\u003EMGMT (MM)-\u003ESystem Config"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.5.0;10.6.0;10.6.1"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
28 August 2024

UID

ibm17166041