x Want to participate? Join the group to interact
Options
  • State Verified Answer
  • Replies 11 replies
  • Answers 1 answer
  • Subscribers 108 subscribers
  • Views 2323 views
  • Users 0 members are here
Browse Forums
Announcements
293
topics
370
replies
Business Object Interface
1k
topics
7k
replies
Core Financial Modules
2k
topics
8k
replies
Customization and Productivity
3k
topics
12k
replies
Distribution, Manufacturing, and Applications
2k
topics
7k
replies
General Discussion
1k
topics
3k
replies
Partner Cloud
45
topics
92
replies
Payroll, Time Tracking, and Job Cost
777
topics
1k
replies
Reporting and Analytics
963
topics
3k
replies
Sage CRM for Sage 100
164
topics
357
replies
Technical and Installation
2k
topics
9k
replies
Year-end Forum
89
topics
237
replies
dhalpin

Forms/Reports/BIE blank after upgrade

SOLVED
Posted By

Had an upgrade from v2016 to v2021 Advanced. Migration/conversion went well with no errors. However forms, reports, bie within sage 100 doesn't display data and even trying to do a crystal report outside of sage doesn't display data. I could see that it reads the records but doesn't display them. I'm out of ideas. Something seems deep rooted and I can't find it.

Here’s what I tried so far and still cannot see data:

  1. Toggled enable ODBC security on/off and made sure my role has all checked in ODBC security
  2. Created a new role that wasn’t converted called admin and assigned it to my user
  3. Tried creating a new form in sage 
  4. Checked permissions on Sage100 folder and workstation folder on C: drive
  5. Tried running as an application rather than service
  6. Tested the ODBC connection-connects fine
  7. Went into sy_odbcsecurity & sy_rolesecurity in DFDM to see if anything looks corrupted
  8. Uninstalled & Reinstalled workstation
Parents
  • FormerMember
    0 FormerMember

    Did you check to see if you DSN setup is pointing to the correct version of 100?

  • 0 in reply to FormerMember

    Yes the user dsn is pointing to correct version of Sage 100. And v2021 is on a new server. Thank you.

  • 0 in reply to dhalpin

    I should add that testing the connection works fine and it pulls in all the tables. I do have the odbc pvxodbc.log when I tried to create a crystal report report. One of the odd things is that it says userid is HPI however I didn't use that user id to log into the SOTAMAS90 datasource in crystal. I used my user id.

    Driver version: 4.40.0005
    ISAMOpen: UserID='administrator', length=13
    GetAccessibleTables:<table=ALL> Open catalog(s) \\masvr12\sage100\v2021\MAS90 , available 1478 table(s)
    ISAMClose
    Driver version: 4.40.0005
    ISAMOpen: UserID='HPI', length=3
    GetAccessibleTables:<table=ALL> Open catalog(s) \\masvr12\sage100\v2021\MAS90 , available 1478 table(s)
    <CI_Item> Open file \\masvr12\v2021\sage100\MAS90\MAS_JAA\CIJAA\CI_Item.M4T, maxksz=62
    ISAMCloseTable: Closing table CI_Item - 0 file reads, 0 re-reads, 0 writes, 0 removes
    CACHE STATS - 0 reads, size 86035456 estimated, 0 used
    <CI_Item> Open file \\masvr12\v2021\sage100\MAS90\MAS_JAA\CIJAA\CI_Item.M4T, maxksz=62
    ISAMCloseTable: Closing table CI_Item - 0 file reads, 0 re-reads, 0 writes, 0 removes
    CACHE STATS - 0 reads, size 86035456 estimated, 0 used

  • 0 in reply to dhalpin

    Also assuming you uninstalled and reinstalled Crystal, from the folder under the Sage 100 installation folder, and that didn't work - did you try to pull data through the ODBC Connection into Excel or Access? And you have tried this directly on the server as well?

  • 0 in reply to rclowe

    All the work I've done so far has been on the server and yes tested odbc thru access and same results. I did test a separate non sage small access db in crystal and it pulls in records fine.I'm leaning towards doing the migration again. 

  • 0 in reply to dhalpin

    I guess that's probably best, if you have ruled out Anti-Virus or other utilities. Did you try connecting from a Win 10 workstation?

  • 0 in reply to dhalpin
    SUGGESTED

    My guess is this is Advanced with CS/ODBC enabled?  Make sure you installed the service on the new server, changed the system configuration settings, and that firewalls don't block the port used.

    Easy way to check if this applies is by looking at SOTAMAS90's Server tab. 

    Custom DSN's probably skip by this tab, but SOTAMAS90 will populate it automatically from the system configuration.

Reply
  • 0 in reply to dhalpin
    SUGGESTED

    My guess is this is Advanced with CS/ODBC enabled?  Make sure you installed the service on the new server, changed the system configuration settings, and that firewalls don't block the port used.

    Easy way to check if this applies is by looking at SOTAMAS90's Server tab. 

    Custom DSN's probably skip by this tab, but SOTAMAS90 will populate it automatically from the system configuration.

Children
No Data

*Community Hub is the new name for Sage City