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

 

 

 

 


Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: April 21, 2017