E1: DB: Connection to Primary V7R3 AS400 Sever Fails with Error - "OS400QL009 - OpenSQLCursor:Open SQL cursor: Crsr3. QSQLMSG *LIBL - SQL0313 - Number of host variables not valid" (Doc ID 2301783.1)

Last updated on AUGUST 07, 2024

Applies to:

Symptoms

The issue is specific to V7R3 and specific to setups where there are multiple servers/LPAR's. If there is only one server/LPAR where all datasources point to same server this issue does not occur.

The issue surfaces when services are started on secondary server and it tries to connect to the primary server to fetch System table information. Primary server sends error code SQL0313 in-place of requested data to secondary server.

Error in kernel log:

Following configuration points have been verified but did not helped:

• Cleared SQLPKG on both servers.
• Verified PTF on both servers and they are same.
• WRKRDDIRE entries have been verified.
• EDRSQL services have been restarted and verified.
• User ONEWORLD password matches on both servers.
• Verified that we can query SY920 library tables from the secondary AS400 server via Client Access using the RDB entry.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.