Error

4 posts, 1 answered
  1. Roger Blanchard
    Roger Blanchard avatar
    343 posts
    Registered:
    29 Jun 2018
    24 Aug
    Link to this post


    I am getting the following error when trying to create a new record using a DatasetModel class.

    The LikeCodeRep is a calculated field in the ePrice temp table and added to the skip list.

    Unable to find sequence field  LikeCodeRep in table Price during SAVE-ROW-CHANGES. (11909)


    oPrice = NEW Osprey.Host.Price.PriceDatasetModel (). 

    oPrice:NewFilter("        6666", // itemnum
                     1, // packnum
                     9 // zonenum
                     ). 

           

    IF NOT oPrice:Price:Available THEN 
    DO: 
    oPrice:TrackingChanges = TRUE.
    oPrice:Price:Create(). 
    oPrice:Price:ItemNum = "        6666". 
    oPrice:Price:PackNum = 1.  
    oPrice:Price:ZoneNum = 1. 
    oPrice:SaveChanges().



    END.       
    Last modified on 24 Aug 2021 19:08 by Roger Blanchard
  2. Roger Blanchard
    Roger Blanchard avatar
    343 posts
    Registered:
    29 Jun 2018
    24 Aug in reply to Roger Blanchard
    Link to this post
    Backend-Stacktrace:
    SaveRowChanges Consultingwerk.OERA.DataAccess at line -1  (C:\ProgressWrk\OspreyVer117102\SmartComponentLibrary\Consultingwerk\OERA\DataAccess.r)
    CommitChanges Consultingwerk.OERA.DataAccess at line 1395  (C:\ProgressWrk\OspreyVer117102\SmartComponentLibrary\Consultingwerk\OERA\DataAccess.r)
    CommitChanges Consultingwerk.SmartFramework.SmartDataAccess at line 973  (C:\ProgressWrk\OspreyVer117102\SmartComponentLibrary\Consultingwerk\SmartFramework\SmartDataAccess.r)
    SaveBuffer Consultingwerk.OERA.DataAccess at line 4141  (C:\ProgressWrk\OspreyVer117102\SmartComponentLibrary\Consultingwerk\OERA\DataAccess.r)
    SaveChanges Consultingwerk.OERA.DataAccess at line 4185  (C:\ProgressWrk\OspreyVer117102\SmartComponentLibrary\Consultingwerk\OERA\DataAccess.r)
    SaveChanges Osprey.CustomClasses.OERA.OspreyDataAccess at line 195  (C:\ProgressWrk\OspreyVer117102\OspreyFramework\Osprey\CustomClasses\OERA\OspreyDataAccess.r)
    SaveChanges Consultingwerk.OERA.BusinessEntity at line 2071  (C:\ProgressWrk\OspreyVer117102\SmartComponentLibrary\Consultingwerk\OERA\BusinessEntity.r)
    SaveChanges Consultingwerk.OERA.BusinessEntity at line 2102  (C:\ProgressWrk\OspreyVer117102\SmartComponentLibrary\Consultingwerk\OERA\BusinessEntity.r)
    SaveChanges Consultingwerk.OERA.ServiceInterface at line 4727  (C:\ProgressWrk\OspreyVer117102\SmartComponentLibrary\Consultingwerk\OERA\ServiceInterface.r)
    SaveChanges Consultingwerk.OERA.ServiceInterface at line 4601  (C:\ProgressWrk\OspreyVer117102\SmartComponentLibrary\Consultingwerk\OERA\ServiceInterface.r)
    SaveChanges Consultingwerk.OERA.DatasetModelPerformer at line 1471  (C:\ProgressWrk\OspreyVer117102\SmartComponentLibrary\Consultingwerk\OERA\DatasetModelPerformer.r)
    SaveChanges Consultingwerk.OERA.DatasetModel at line 760  (C:\ProgressWrk\OspreyVer117102\SmartComponentLibrary\Consultingwerk\OERA\DatasetModel.r)
    C:\ProgressWrk\OspreyVer117102\OspreyHostBackend\Osprey\Host\Price\TestDatasetModelClass.p at line 129  (C:\ProgressWrk\OspreyVer117102\OspreyHostBackend\Osprey\Host\Price\TestDatasetModelClass.r)
    adecomm/_runcode.p at line 678  (adecomm/_runcode.r)
    C:\Progress\OpenEdge\oeide\eclipse\plugins\com.openedge.pdt.debug.core_11.7.8.00\abl\_debuglauncher.p at line 100  (C:\Progress\OpenEdge\oeide\eclipse\plugins\com.openedge.pdt.debug.core_11.7.8.00\abl\_debuglauncher.p)


      Table: ePrice



    ThrowDatasetErrors Consultingwerk.Util.DatasetHelper at line 4202  (C:\ProgressWrk\OspreyVer117102\SmartComponentLibrary\Consultingwerk\Util\DatasetHelper.r)

    SaveChanges Consultingwerk.OERA.DatasetModelPerformer at line 1477  (C:\ProgressWrk\OspreyVer117102\SmartComponentLibrary\Consultingwerk\OERA\DatasetModelPerformer.r)

    SaveChanges Consultingwerk.OERA.DatasetModel at line 760  (C:\ProgressWrk\OspreyVer117102\SmartComponentLibrary\Consultingwerk\OERA\DatasetModel.r)

    C:\ProgressWrk\OspreyVer117102\OspreyHostBackend\Osprey\Host\Price\TestDatasetModelClass.p at line 129  (C:\ProgressWrk\OspreyVer117102\OspreyHostBackend\Osprey\Host\Price\TestDatasetModelClass.r)

    adecomm/_runcode.p at line 678  (adecomm/_runcode.r)

    C:\Progress\OpenEdge\oeide\eclipse\plugins\com.openedge.pdt.debug.core_11.7.8.00\abl\_debuglauncher.p at line 100  (C:\Progress\OpenEdge\oeide\eclipse\plugins\com.openedge.pdt.debug.core_11.7.8.00\abl\_debuglauncher.p)



    Shown by:

    ShowErrorMessage Consultingwerk.Util.ErrorHelper at line 2725  (C:\ProgressWrk\OspreyVer117102\SmartComponentLibrary\Consultingwerk\Util\ErrorHelper.r)

    C:\ProgressWrk\OspreyVer117102\OspreyHostBackend\Osprey\Host\Price\TestDatasetModelClass.p at line 137  (C:\ProgressWrk\OspreyVer117102\OspreyHostBackend\Osprey\Host\Price\TestDatasetModelClass.r)

    adecomm/_runcode.p at line 678  (adecomm/_runcode.r)

    C:\Progress\OpenEdge\oeide\eclipse\plugins\com.openedge.pdt.debug.core_11.7.8.00\abl\_debuglauncher.p at line 100  (C:\Progress\OpenEdge\oeide\eclipse\plugins\com.openedge.pdt.debug.core_11.7.8.00\abl\_debuglauncher.p)
  3. Mike Fechner
    Mike Fechner avatar
    263 posts
    Registered:
    14 Sep 2016
    Answered
    24 Aug in reply to Roger Blanchard
    Link to this post
    Looks like a few extra spaces around the field name LikeCodeRep in the error message. 

    Does your skip field list contain that field name with some extra spaces or tabs? I know that the attach-data-source method for instance does not like extra white spaces around field names. 

    Calculated fields don't need to be in the assign skip list at all - as they don't have a counter-part in the DB table.
  4. Roger Blanchard
    Roger Blanchard avatar
    343 posts
    Registered:
    29 Jun 2018
    24 Aug in reply to Mike Fechner
    Link to this post
    Hmm, I removed it from the skip list and no more error.

    Thanks...
4 posts, 1 answered