IBM Optim

IBM Optim

Enable Data Operations with Optim for AI and Cloud - accelerating innovation, reducing costs, ensuring data sovereignty


#Dataintegration
#Databases
#InfoSphereOptim
#Analyticstools
 View Only
Back to discussions
Expand all | Collapse all

Optim Archive Issue | Table with Spatial Index

  • 1.  Optim Archive Issue | Table with Spatial Index

    Posted 08/25/20 06:03 PM

    We are facing an issue while running the archive request for a table (MS SQL Server) with spatial index and it's failing with the below error messages.

    Archive Report Error Message:

    Archive Process Errors
    An unexpected error occurred accessing DB DEC.AD_GFD.
    Please refer to the trace for more information.
    Error Code = 7500, ExtCode=0.

    Optim Trace File:
    SQLText: {call optim.PSTM10V0100_CSSSPATIALINDEX(?)}
    ErrTxt1: SQLState=22003 NativeError=0 Row=1 Col=11
    ErrMsg1: [Microsoft][ODBC Driver 17 for SQL Server]Numeric value out of range.

    Please let us know if anyone seen this before ? or ideas to resolve the issue. Thanks in advance!

    Regards... Suresh

    ------------------------------
    Suresh Putteti
    ------------------------------

    #InfoSphereOptim
    #Optim


Related Content