Cannot run reports after upgrading from Visual 7 to 9
Ever since upgrading to Visual 9, we haven't been able to run reports out of Synoptix. When we go to 'Connection Setup' to modify our connection, the Entity ID drop-down menu is blank. If we change back to the Visual 7 'Host database container name', our Entity ID is there, but it isn't with the Visual 9 'Host database container name'. I'm assuming this has something to do with the changes made in Visual 9, but I'm not sure how to fix this in regards to this issue. Any ideas?
Hello Adam,

Thank you for the post. Whenever this happens, it means the wrong host package is selected. Beginning in Visual 7.1, Site ID or Company ID was put in place of Entity ID. In Synoptix, you have to delete your existing company connection (in Admin > Connection Setup) and add it back with the 7.1 host package which is probably "Visual MFG 7.1 MSSQL."  It's also important to keep the connection name the same within Synoptix. For example, if you have a connection named VisualProd with the "Visual MFG SQL Server" host package, you should delete it and add a new connection named VisualProd but with the "Visual MFG 7.1 MSSQL" host package. 7.1 really means 7.1 and later. This is important for your existing reports that use our default spheres. 

If you have any questions or would like to meet for a web meeting, please click "Schedule a Meeting" at the bottom of this webpage. 

Thanks,
Synoptix Support
That fixed it. Thanks for your help and quick response.
CANNOT RUN REPORTS AFTER VISUAL UPGRADE:
AMENDING YOUR VISUAL COMPANY CONNECTION


Download guide: 
.pdf   Visual Upgrade Company Changes.pdf (Size: 115.41 KB / Downloads: 7)