Decision Optimization

Decision Optimization

Delivers prescriptive analytics capabilities and decision intelligence to improve decision-making.


#Analytics
#DecisionOptimization
#DecisionOptimization
 View Only
  • 1.  DBread with a long query

    Posted 07/12/12 01:09 PM

    Originally posted by: Avri


    Hi,
    I am trying to use DBread with a relatively long query: its ~ 400 rows (18,000) characters long.
    The IDE crashs without warning.
    It is crashing because of the long query because getting data via excel (SheetConection) works fine.
    How can I get an idea of what is happening ? Do I have access to the fatals log ?
    The problem occur while running Windows server 2003 32 bit, IBM ILOG OPL IDE Version: 6.3, Build id: b00129_20090612150852, and oracle client 10g version 10.02.00.03.
    Thanks a lot,
    Avri
    #DecisionOptimization
    #OPLusingCPOptimizer


  • 2.  Re: DBread with a long query

    Posted 07/13/12 09:53 AM

    Originally posted by: SystemAdmin


    Hi,

    what data types are you reading (int, string...)?
    Can you share the SQL query you're using (or a similar one that reproduces the issue)?
    OPL 6.3 is not supported anymore, I would strongly encourage you to migrate to the latest version (12.4)
    #DecisionOptimization
    #OPLusingCPOptimizer


  • 3.  Re: DBread with a long query

    Posted 07/13/12 11:09 AM

    Originally posted by: SystemAdmin


    I made a mistake in my previous post, OPL 6.3 is still supported. I still encourage you to upgrade though.
    #DecisionOptimization
    #OPLusingCPOptimizer


  • 4.  Re: DBread with a long query

    Posted 07/14/12 03:25 PM

    Originally posted by: Avri


    hi,
    Thank you for your prompt response.
    I can send you the query - I prefer to do this via mail because of IP issues.
    Thanks,
    Avri
    #DecisionOptimization
    #OPLusingCPOptimizer