DB2 Bind Qualifier Error While Migrating From 11.4 To 12.3 Documaker Version

(Doc ID 2269657.1)

Last updated on MAY 30, 2017

Applies to:

Oracle Documaker - Version 12.3 to 12.3 [Release 12]
Information in this document applies to any platform.

Symptoms

On : 12.3 version, Documaker Server, AIX

When attempting to migrate Documaker Server from release 11.4 to 12.3, facing the following DB2 Bind qualifier error:

ERROR
-----------------------
DM12041: Error : FAP library error: Transaction:, area:
  code1:, code2:
  message:<
Error in function:
  DB2EmbeddedSQL
Error in statement:
  EXEC SQL PREPARE sqlStmt INTO :*sqldaTemp FROM :HVSqlStmt
Statement:
  SELECT DISTINCT CURRENT TIMESTAMP FROM sysibm.sysdummy1
Error Description:
  SQL0805N Package "DSNDSN0.E7470USP.DB2LIB.544262504E464465" was not found. SQLSTATE=51002
State Message:
  SQLSTATE 51002: The package corresponding to an SQL statement execution request was not found.
Location: File db2lib.sqc, Line 3389
Additional Comments:
  In function DB2Prepare>.
DM18038: Error in GenArcArchive(): Unable to DBAdd(hTempIdxFile,NewTrnFileRecord,ArcIdxRecordSize).'


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Binding the collection separately and not as a part of the Documaker process. Below is the command used and results.
axrsgpar1614:/home/docucorp> db2bind.sh soh_a
Starting db2bind.sh.
  connect to DSNDSN0 user e0108x2 using xxxxxxx (Connection established)
  bind db2lib.bnd owner E7470DBA qualifier E7470DBA collection E7470USP (Bind was successful)
Ending db2bind.sh.
2. Running the Documaker batch script in Unix to generate output and Archive the documents.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms