My Oracle Support Banner

OGG-DB2 ISeries(AS/400)-OGG-00146 Call To First Position Returned With Error Status -1 (Doc ID 2441163.1)

Last updated on AUGUST 30, 2018

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 to 12.2.0.1.0 [Release 12.2]
IBM i on POWER Systems

Symptoms

Problem Summary
---------------------------------------------------
Prod Down-GG-DB2 iSeries(AS/400)-OGG-00146 Call to First position returned with error status -1

Problem Description
---------------------------------------------------
Set up GG for DB2 for iSeries (AS/400) 12.2.0.2.3 in production, Extract fails with following error
OGG-00146 Call to First position returned with error status -1: Journal must include the system sequence number in the fixed length data: ITHAEIJRN /EIJRNG

Production is down, this is stopping the production deployment until resolved. This is the same version and configuration as the QA system, same table names and Journal names.

  Oracle GoldenGate Capture for DB2 for i
  Version 12.2.0.2.3 OGGCORE_12.2.0.2.0_PLATFORMS_170727.1430
 IBM i, ppc, 64bit (optimized), IBM DB2 for i on Jul 27 2017 23:01:56
Operating System Version:
OS400
Version 7, Release 2
Node: NVHND1-S61
Machine: 0010000F798R
** Running with the following parameters **
2018-08-21 16:57:20 INFO OGG-03059 Operating system character set identified as US-ASCII.
2018-08-21 16:57:20 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
EXTRACT PTGC
INCLUDE ./dirprm/sourcedb_login.inc
SOURCEDB NVHNDS61 USERID GG_APP, PASSWORD ***, BLOWFISH, ENCRYPTKEY DEFAULT
2018-08-21 16:57:20 INFO OGG-03036 Database character set identified as UTF-8. Locale: root.
2018-08-21 16:57:20 INFO OGG-03037 Session character set identified as UTF-8.
REPORTCOUNT EVERY 15 MINUTES, RATE
EXTTRAIL ./dirdat/point/pg
DISCARDFILE ./dirrpt/PTGC.dsc, APPEND
GETTRUNCATES
NOCOMPRESSUPDATES
NOCOMPRESSDELETES
TABLE EIGR11DAT.PMSPSA15 ;

Database Version:
AS
Version 07020
ODBC Version 3.00

Driver Information:
QSQCLI.SRVPGM
Version 07020
ODBC Version 3.00

Error Codes
---------------------------------------------------
OGG-00146 Call to First position returned with error status -1: Journal must include the system sequence number in the fixed length data: ITHAEIJRN /EIJRNG

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


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