Page 1 of 2 1 2 LastLast
Results 1 to 10 of 11

Thread: Vertex and Environments

  1. #1
    Senior Member GSI, Inc.'s Avatar
    Join Date
    Mar 2002
    Location
    Metro Detroit Area
    Posts
    248

    Vertex and Environments

    I am on OW 733 cum 2, AS/400 Server. We have t;he normal 3 environments setup, DEV, CRP, and PROD. How do you test a vertex update/upgrade without affecting all environments? Any help would be greatly appreciated.

    TX, Det Bobby

    Bob Aikins | Client Manager
    GSI, Inc. | Upgrade Your JD Edwards Experience™ | web: www.gsi-solutions.com
    w: 877.474.4262 x726 | c: 586.601.7843 | email: bob.aikins@gsi-solutions.com



  2. #2
    Senior Member
    Join Date
    Nov 2000
    Posts
    115

    RE: Vertex and Environments

    If you using the isam version you can actually just copy the vertex
    directory to say vertexupgrade. Then you just need to go point an
    environment to this new directory in the P7308 application.

    Mark Siebenschuh
    Enterprise Software Systems Administrator
    Physician Sales and Service
    4345 Southpoint Blvd.
    Jacksonville, FL 32216
    904-332-3092




    Mark Siebenschuh
    HP9000/Oracle 8.0.5/JDE XE/Lots of Citrix
    Mark Siebenschuh
    HPUX/Oracle 8i/Citrix

  3. #3
    Senior Member joy_fernandez's Avatar
    Join Date
    Mar 2001
    Location
    Texas - USA
    Posts
    191

    RE: Vertex and Environments

    You don't.......following are the steps we use and they work fine for us.
    Not sure if they will help you though, we are WinNT.

    Joy


    Make sure you have a good backup.
    WARNING - No OneWorld users can be using the Payroll programs while update
    is in progress.

    1. Go to the Enterprise Server and copy EVERY file in C:\QUANTUM FOR PAYROLL
    TAX\DB to the following location; D:\QUANTUM-BACKUP\MONTHLY-BACKUP prior to
    performing the monthly update.

    2. Put update CD-Rom in the Enterprise's CD drive.

    3. Double click on Windows Explorer

    4. Go to C:\QUANTUM FOR PAYROLL TAX\Utils

    5. Double click on VPRTMUPD.EXE - Enter #1 "Update Payroll Tax DataBase"

    6. Enter Data Source: C:\Quantum for Payroll Tax\db then hit Enter

    7. Enter Path of CD-Rom \DATA then hit Enter

    8. You will now receive the message updating database please wait - now wait
    (2 - 10 mins.)

    9. When completed you will receive the message Payroll Tax Monthly Update
    Successful

    10. Choose #2 for exit

    11. Double Click on LOCUPD.EXE

    12. Choose #1 then hit Enter - "Update GeoCoder DataBase"

    13. Enter the GeoCoder Data Source as C:\Quantum for Payroll Tax\db then hit
    Enter

    14. Enter Path of CD-Rom \DATA then hit Enter

    15. You will revive the message Updated Database please wait - Now wait (1 -
    5 mins.)

    16. When completed you will receive the message GeoCoder Update Successful

    17. Choose #2 for Exit then hit Enter

    Executing the Diagnostic Program:

    1. Start / Programs
    2. Quantum for Payroll Tax menu option
    3. Diagnostic Utility
    4. Enter 1 at the Please select diagnostic to execute: / Enter
    5. The program prompts you for the datasource name as follows:
    C:\Quantum for Payroll Tax\db / Enter Quantum displays the results of
    the connection.
    6. If successful connection is completed enter 2 /Enter
    7. The program prompts you for the datasource name as follows:
    C:\Quantum for Payroll Tax\db / Enter Quantum displays the results of
    the connection

    Have someone test a Payroll run in either your DV or PY environment.
    Joy Fernandez, JDE CNC & System Administrator
    EnterpriseOne-Xe - Update 7 - SP22_I1 - Oracle 9i - Citrix -
    joy.fernandez@peci.com

  4. #4
    Member
    Join Date
    Nov 2000
    Location
    WA, USA
    Posts
    43

    RE: Vertex and Environments

    You have to load Vertex locally on the workstation you are testing from. I
    found the instructions on KG ohr-01-0022

    Lori Waybright
    Inland Empire Paper Co.
    B733.2
    Win2000, ERP8, Update 1, SP22

  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    8

    Re: Vertex and Environments

    I'm from a Unix environment, but I expect it's similar...

    Testing a Vertex upgrade is like testing a OneWorld SP upgrade - it affects all environemnts. The difference being that you CAN turn Vertex on or off by environment via the F7306 table.

    What I have done is sete up a seperate instance of OW on a different port. I assume you can you do this on AS/400? How do you test an SP upgrade?

  6. #6
    New Member
    Join Date
    Nov 2001
    Location
    Fort Worth, TX
    Posts
    13

    RE: Vertex and Environments

    We set up a different vertex instance/data source for each environment then
    modified the P7308 Quantum Database Connection accordingly.

    Let me know if you need more detail.
    Je

  7. #7
    Senior Member
    Join Date
    Sep 2001
    Posts
    126

    RE: Vertex and Environments

    You can just point the database path setup in P7308 to another location for
    each environment. The F7308 is in Business Data, not System Tables so this
    is entirely possible and does work. I've done this on a NT/2K ES using the
    Vertex ISAM database and also on a NT/2K ES using Vertex in an Oracle
    database.

    ie in PROD use \\servername\Vertex\Prod\db
    in CRP use \\servername\Vertex\CRP\db

    The only thing you need to be carefull of is when you do a Business data
    refresh from PROD to CRP you need to reset the datasource path.

    Actually you can use this method to point vertex to a locally running copy
    but you'll have to remap a few UBE's and BSFN's. This way you can play with
    a Workstation instead of a Server. Check the Knowledge Garden for a list of
    UBE's and BSFN's to remap for Sales & Use Tax and Payroll Tax.

    Do you happen to be testing Quantum for Payroll Tax 2.4.X? Just an FYI -
    I've tested this ESU for it on B733.2 and it breaks more than it fixes!!!

    Colin

    B733.2 SP17.1_I1
    Intel/NT/2K/Oracle 8.1.7.1/Vertex 2.3.2 (Prod) & Vertex 2.4.2 (Dev)
    FAT & WTS
    Live on Financials, HR & Payroll

  8. #8
    Member
    Join Date
    Nov 2000
    Location
    WA, USA
    Posts
    43

    RE: Vertex and Environments

    So if it breaks more than it fixes, how do we upgrade to the 2.4.x version
    of vertex and keep our payroll running?

    Lori Waybright
    Inland Empire Paper
    B733.2, Quantum for Payroll, Optio
    Win2000, ERP8, Update 1, SP22

  9. #9
    Senior Member
    Join Date
    Sep 2001
    Posts
    126

    RE: Vertex and Environments

    Lori,

    the word from JDE is that you can still upgrade to Vertex 2.4.X. However
    you'll have the following issues:

    5961492š Payroll EE DBA Inst Override Flag š
    5958365š Payroll Program files\vertex failing š

    These are issues on B7332 AND Xe. If you don't override any DBA's then
    you're fine. As for the second issue you can install Vertex to a a new
    directory or use a 'DOS' path. For us these issues mean we pretty much can't
    run a payroll if we apply this ESU.

    We've escalated this with our Client Manager. Denver's supposed to be
    dilegently working on this but who knows when a fix will come.


    Colin

    B733.2 SP17.1_I1
    Intel/NT/2K/Oracle 8.1.7.1/Vertex 2.3.2 (Prod) & Vertex 2.4.2 (Dev)
    FAT & WTS
    Live on Financials, HR & Payroll

    ** Shared Knowledge = Better Knowledge **

    Implementing B7333 (Xe) SP18.1, SQL

  10. #10
    Member
    Join Date
    Nov 2000
    Location
    WA, USA
    Posts
    43

    RE: Vertex and Environments

    Thanks Colin for the information. Does not sound very good. Please let me
    know when you hear something from Denver.

    Lori

    Win2000, ERP8, Update 1, SP22

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.