APAR status
Closed as program error.
Error description
Table definitions that are created from shared tables in the repository have a missing quote character at the end of the locator information. Table defintions can be created from shared table by using the "Create Table Definition from shared table..." wizard or it was automatically created if it was imported using the Connector Metadata Import wizard. This causes SQLBuilder to fail to locate the table if it was used in the SQL.
Local fix
The fix will be a client-side fix to include the missing quote when generating the locator information for table defintions.
Problem summary
**************************************************************** USERS AFFECTED: This is a client issue so it is platform independent. Users who created table definitions from shared tables or imported table definitions via the connector metadata import wizard will see this issue if they then used these tables in SQLBuilder. **************************************************************** PROBLEM DESCRIPTION: Table definitions that were created from shared tables via the "Create Table Definition from shared table..." or imported via the connector metadata import wizard has a missing end quote in the locator information. If these tables are used in the SQLBuilder, the next time SQLBuilder is opened to re-edit the SQL an error message is displayed stating that the table could not be found. **************************************************************** RECOMMENDATION: Install the patch and re-create / re-import the table definitions. This change is included in 8.1 Fix Pack 1. ****************************************************************
Problem conclusion
Fixed the generation of the locator information to include the misisng quote when doing either the import or the table definition creation. Users will need to re-create their tables or re-import after applying the patch to fix the problem.
Temporary fix
Comments
APAR Information
APAR number
JR31922
Reported component name
WIS INFORM ANAL
Reported component ID
5724Q36IA
Reported release
810
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-02-05
Closed date
2009-02-16
Last modified date
2009-12-15
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
CLIENT
Fix information
Fixed component name
WIS INFORM ANAL
Fixed component ID
5724Q36IA
Applicable component levels
R810 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSZJLG","label":"InfoSphere Information Analyzer"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
15 December 2009