Problem Statement:
Showcase iSeries Driver: Unknown error occurred in 'getObjectLibrary', reason: Descriptor index not valid.
Solution:
The 'getObjectLibrary' (program SPGTOBJLIB) is a stored procedure which should be in file SYSROUTINE in library QSYS2.
You can run a query against the SYSROUTINE file to see if it (and other stored procedures) are there using the following select statement:
In Query (where SCSERVER is your ShowCase server library name):
SELECT SUBSTRING( SPECIFIC_SCHEMA, 1, 30 ) AS SPECIFIC_SCHEMA, SUBSTRING( SPECIFIC_NAME, 1, 30 ) AS SPECIFIC_NAME FROM QSYS2.SYSROUTINES SYSROUTINE WHERE SPECIFIC_SCHEMA = 'SCSERVER'
OR
In Interactive SQL (where SCSERVER is your ShowCase server library name):
SELECT SUBSTR ( SYSROUTINE . SPECSCHEMA, 1, 30 ) SPECIFIC_SCHEMA, SUBSTR ( SYSROUTINE . SPECNAME, 1, 30 ) SPECIFIC_NAME FROM QSYS2/SYSROUTINE SYSROUTINE WHERE SYSROUTINE . SPECSCHEMA = 'SCSERVER'
If objects are missing restore QSYS2 from a previous save or run the following command to create stored procedures.
CALL SCSERVER/CRTSCIBMSP PARM('SCSERVER' '*ALL' '*INST')
(where SCSERVER your server library name)
Note: You MUST end the Showcase Server FIRST.
If this fails then you will need to reinstall the ShowCase server library.
Ref#: 1476474
