Skip to end of metadata
Go to start of metadata

Message

The installation of Loftware Oracle Connector fails with the repeated error message:

Unexpected SQL Error: Closed Connnection

When the lwconn.log is reviewed, the connection was closed by the database at the same point each time.

Dec 08, 2015 11:15:57 AM :: Install :: Grant permissions for v2 objects...
Dec 08, 2015 11:15:57 AM :: Install :: Dropping existing synonyms...
Dec 08, 2015 11:15:57 AM :: Install :: Creating v2 synonyms...
Dec 08, 2015 11:15:57 AM :: Install :: Closed Connection

The errors that follow are all related to the action being performed and the reason for the errors are all the same:

Dec 08, 2015 11:16:08 AM :: Install :: there was a problem with setting up the ps in getID: Closed Connection
Dec 08, 2015 11:16:08 AM :: Install :: An error occurred when inserting group LW_EXPANSION_GROUP: Closed Connection
Dec 08, 2015 11:16:08 AM :: Install :: An error occurred when looking up label ID for CARTON.LWL: there was a problem with setting up the ps in getID: Closed Connection
Dec 08, 2015 11:16:08 AM :: Install :: An error occurred when looking up label ID for CARTON.LWL: Closed Connection
Dec 08, 2015 11:16:08 AM :: Install :: An error occurred when looking up label ID for PALLET.LWL: there was a problem with setting up the ps in getID: Closed Connection
Dec 08, 2015 11:16:08 AM :: Install :: An error occurred when looking up label ID for PALLET.LWL: Closed Connection

Explanation

It appears that the customer database security closes the connection due to experiencing several SQL commands for deletion of objects that do not exist. Part of the install attempts to remove 24 public synonyms before adding them, so that this same package can be used to upgrade existing installations. These 24 commands all return an error when run manually of "ORA-01432: public synonym to be dropped does not exist". When run by the installer package, they all run within a few milliseconds and may trigger a security measure that severs the connection.

Solution

To resolve this issue, have the database administrator manually add the synonyms prior to the install so that when this point in the installation is reached, no errors are returned.

Manually run the following SQL create commands prior to running the Connector installation:

"create public synonym inv_sync_print_request for loftware.inv_sync_print_request;"
"create public synonym clob_sync_print_request for loftware.clob_sync_print_request;"
"create public synonym lps_config for loftware.lps_config;"
"create public synonym lps_config_seq for loftware.lps_config_seq;"
"create public synonym lps_printer for loftware.lps_printer;"
"create public synonym lps_server for loftware.lps_server;"
"create public synonym lps_server_seq for loftware.lps_server_seq;"
"create public synonym lps_printer_seq for loftware.lps_printer_seq;"
"create public synonym lps_label for loftware.lps_label;"
"create public synonym lps_label_seq for loftware.lps_label_seq;"
"create public synonym lps_label_type for loftware.lps_label_type;"
"create public synonym lps_label_type_seq for loftware.lps_label_type_seq;"
"create public synonym lps_label_group for loftware.lps_label_group;"
"create public synonym lps_label_group_seq for loftware.lps_label_group_seq;"
"create public synonym lps_label_hierarchy for loftware.lps_label_hierarchy;"
"create public synonym lps_label_hierarchy_seq for loftware.lps_label_hierarchy_seq;"
"create public synonym lps_label_lookup_field for loftware.lps_label_lookup_field;"
"create public synonym lps_label_lookup_field_seq for loftware.lps_label_lookup_field_seq;"
"create public synonym lps_label_lookup_key for loftware.lps_label_lookup_key;"
"create public synonym lps_label_lookup_key_seq for loftware.lps_label_lookup_key_seq;"
"create public synonym lps_printjob_seq for loftware.lps_printjob_seq;"
"create public synonym lps_chain_holder for loftware.lps_chain_holder;"
"create public synonym lps_chain for loftware.lps_chain;"

Once the above operation is complete, try the Connector installation again. 

 

 

Article Number

2017095

Versions

Loftware Oracle Connector 4.1.0.0

Environment

Supported Loftware Connector for Oracle Environments