InfoSphere Optim

InfoSphere Optim

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
Back to discussions
Expand all | Collapse all

Optim Archive Issue / All Relationships turned to "UNKNOWN" status in production Site

  • 1.  Optim Archive Issue / All Relationships turned to "UNKNOWN" status in production Site

    Posted Thu September 24, 2020 02:49 PM
    We can see this occur either by entering in the windows Optim FAT for developpers by opening the relashionship tag of the AD, or , in the LINUX Server for Optim when submitting an archive via the command line API pr0cmnd.

    At the same time, the Optim dump show a strange DBMS error ORA-01455. (see the dump extract that follow).

    Can anyone help us with this type of error ?      (Optim 6.4.0 with Oracle 12.2 64 bits) (tolerate mode) 

    Thank's in advance.

    Here's a part of the optim dump:

    ---------------------------------------------------------------------
    DBMSVer: **Not Found**
    ApplVer: 9.2
    DBAlias: JDEP
    ConnStr: JDEP
    UserID: saqoptim
    Func: OCIStmtExecute
    Date: 09/20/2020 17:18:12
    SQLText: BEGIN
    saqoptim.PSTO01V0100_CSSTABLE.PSTV0100_CSSGETOBJECT(:RowsToGet,:CreatorNumIn,:Creator
    NameIn,:ObjectNameIn,:ObjectType,:ObjectStatus,:RemoteType,:SynonymType,:CreatorNumId
    ,:ObjectNumId,:TblProp,:RemoteCreator,:RemoteObject,:RemoteLink); END;
    ErrData: ORArc=1455, OpSysErr=0, ParseErrOffset=0
    ErrMsg: ORA-01455: débordement de capacité pour type de données entier en conversion de
    colonne
    PN0DSQR3 DSQCR8UT.C CheckError(02540-0002929D)
    PN0DSQR3 DSQCR8CR.C DSQLORAOpenCsr(02178-0001DB4B)
    PN0DSQ00 DSQCBCSR.C DSQLOpenCursor(00510-00012D03)
    PN0CSSR5 CSSCR01T.C CSSORAV10100GTbl(00197-000073BF)
    PN0CSS00 CSSCCTBL.C CSSCacheAddTbl(00672-000419BD)
    PN0CSS00 CSSCCTBL.C CSSLocateTbl(00229-000406D4)
    PN0CSS00 CSSCCCON.C CSSCacheBldCon(00199-00054EC4)
    PN0CSS00 CSSCCCON.C CSSCacheBldConSet(01171-0005760F)
    PN0CSS00 CSSCREL0.C CSSMergeRels(00781-0001620A)
    pr0defs RTAD.CPP RtAD RefreshRelData(17352-001BEC53)
    pr0defs RTAD.CPP RtAD CheckAD_RefreshDB(06624-00190EE7)
    pr0defs RTAD.CPP RtAD CheckAD(04974-0018BBDF)
    pr0xtrc PSWRXTRC.CPP XtrcWorker DoWork(04130-0001E592)
    pr0rcci RTRCCSVR.CPP RtRccWorkerThread Create(01069-0009AFA6)
    pr0ctls RTTHREAD.CPP RtThread InitInstance(01683-0016140D)
    Unknown Unknown Unknown(?????-05E6279F)
    Unknown Unknown Unknown(?????-01E7E563)
    Unknown Unknown Unknown(?????-003955C7)
    Unknown Unknown Unknown(?????-02DC4359)
    dsqcr8ut CheckError (2552) EXCP 09/20/2020 17:18:12 000024 0000112B 00005056
    ErrMsg: Return Error at line=2541)
    RetCode: RDBERR_DBERR(07500) General DBMS Error





    ------------------------------
    yves michaud
    Optim developer
    SAQ
    Montreal QC
    514 254 6000 #5023
    ------------------------------

    #InfoSphereOptim
    #Optim