Sage 100

 View Only

  • 1.  VI Import into CI_Item

    Posted 11-04-2020 17:58
    New issue with client on v2018.4 Advanced. In August, I wrote a simple VI job that imports values of a UDF into CI_Item. The user wrote today that he gets a message when importing. The job does not fail, however.
    VI Message 2
    During troubleshooting, I/he created a new job and copied the original job. This message appeared:
    VI Message 1
    After clicking "OK", I could see that the Table Name field was blank (should have been CI_Item). I checked his role, and he has the permission checked to allow VI Imports in the CI and IM modules.
    Any thoughts on what might be going on with both/either of these issues?


    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------


  • 2.  RE: VI Import into CI_Item

    Posted 11-04-2020 18:46
    Perhaps give him full access temporarily to determine if it is a rights issue.  Or since it is a simple import, do a quick rewrite and test.  What happens if you run the import?

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 3.  RE: VI Import into CI_Item

    Posted 11-05-2020 09:21
    Don't forget to check if ODBC security is turned on and user maybe has less than full access on that.

    ------------------------------
    Bruce Kern
    SWK Technologies Inc.
    ------------------------------



  • 4.  RE: VI Import into CI_Item

    Posted 11-05-2020 12:39
    Look in Role permissions... new options were added recently.


    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 5.  RE: VI Import into CI_Item

    Posted 11-06-2020 10:13
    On the original job, the message seems to indicate there is Sage default perform logic for CI in place. In the old days this was added by default in Import Job Maint as it was necessary to accomplish running some part of the job. It sounds like you could click on the Perform button in the Configuration tab, find where the default perform of ../CI/CI_VIPerform.m4p is set and delete that. It's consistent with how the job runs successfully otherwise. This type of error typically occurs after a recent upgrade for import written in a older version of Sage. Hope that helps.

    ------------------------------
    Alnoor Cassim

    Email: alnoor@asifocus.com
    Ph: 949-689-9887
    Orange County, CA
    ------------------------------



  • 6.  RE: VI Import into CI_Item

    Posted 11-06-2020 13:19

    Alnoor, not clear on "where the default perform of  ../CI/CI_VIPerform.m4p is set and delete that."  The Vi job is newly created, not brought over in an upgrade.  I just created a new VI job in my local 2018.10 and the perform logic is defaulted.  Screenshots come from my local.

    Perform Logic
    Perform Logic 2


    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------

    Original Message


  • 7.  RE: VI Import into CI_Item

    Posted 11-06-2020 13:23
    Click here (see image) and look at the list.  Delete anything you don't need.  I've seen new VI jobs created with junk Perform logic automatically, causing errors until deleted.


    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 8.  RE: VI Import into CI_Item

    Posted 11-06-2020 17:55
    Thanks for all the suggestions.  Perform Logic was it.  Thanks for showing me where to look, Kevin.  There was one entry in there and I deleted it.  Interesting, they are on 2018.4.  When I created a new job in my 2018.10, there was no default perform logic.  Go figure.

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------

    Original Message


Related Content