Versions Compared

Old Version 13

changes.mady.by.user David Rogers

Saved on

compared with

New Version Current

changes.mady.by.user David Rogers

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

IssueWorkaround

Crystal Reports fail from Synmain when TLS 1.0 is disabled

Cause:

Synergetic 'ODBCAutoConfig' and File > Workstation Config defaults to using SQLSRV32.DLL

This is due to the default ODBC driver SQLSRV32.DLL which does not support TLS 1.1+

Jira Legacy
serverSynergetic Management Systems
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId3587bf9f-563b-3952-afa4-4457c6487443
keyDSY-18676


Disable ODBCAutoConfig (HKLM\Software\Wow6432Node\ComputingDirections\ODBCAutoConfig = 0) - note that this cannot be disabled in multi-tenant environments at this stage.

Change ODBC reg setting to use newer SQL driver

Key: HKCU\Software\ODBC\odbc.ini\Synergetic\Driver

Value: 'C:\Windows\system32\sqlncli11.dll'


The ODBC settings will require manual update via reg key import to switch between environments (prod/dev/test) or tenants in a  multi-tenant environment.

SEQTA Sync JDBC error

none available

...

Set up on HERA3\DevTest for v70Executed against 


 SynMain fixed DSY-18676 - SynMain fixed
  •  Tracking progress - DSY-20570 - Tracking progress
    ProgramsTestsComments
    SynMain
    1. Authentication: Windows & DB
    2. Accessed Maintenance Programs
    3. Executed basic functionality (incl. Finance)
      1. Created Student
      2. Completed Debtor Cash Receipt posting
    		(tick)
    SynWeb
    1. Authentication: Windows & DB
    2. Accessed Maintenance Programs
    3. Executed basic functionality (incl. Finance)
      1. Created Student
      2. Completed Purchase Order Requisition (incl. email received)
    		(tick)
    Community Portal
    1. Accessed all pages
    2. Executed some functionality
    		(tick)
    Form Builder
    1. Copied form
    2. Published form
    3. Submitted form (Application received in SynMain)
    		(tick)
    Online Event Booking
    1. Completed through to paid event
    		(tick)
    SADT
    1. Signed In/Out (data correct in SynMain)
    		(tick)
    SSRS
    1. Ran finance/non-finance report
      1. STUYR
      2. DEBFEE
    		(tick)
    Service Suite
    • Service Running
    • Logs Produced
    • Scheduled Reports emailed

    Working on issue where scheduled Crystal reports to be emailed are erroring due to TLS

    Working on solution that does not conflict with SynWeb fix

    Core APIHas been utilised through testing (e.g. Form Builder/Payments)(tick)
    Application Portal
    1. Authentication: DB
    2. Created and processed new form
    		(tick)
    DB PatcherDatabase has been patched without error(tick)
    Crystal Reports

    SynMain

    • Finance
    • Non-finance

    SynWeb

    • Finance
    • Non-finance

    Working in SynMain, no longer working in SynWeb

    Have located issue and working on finalising solution

    Jira Legacy
    serverSynergetic Management Systems
    serverId3587bf9f-563b-3952-afa4-4457c6487443
    key
    Jira Legacy
    serverSynergetic Management Systems
    serverId3587bf9f-563b-3952-afa4-4457c6487443
    key
    Study PeriodAccessed and checked in Student(tick)
    SIF

    Executed calls to retrieve data

    1. StudentPersonals
    		(tick)
    Power BI

    Finance & Non-Finance report produces correct data

    		(tick)

    ...