AccuTrack/AccuSQL: Operator/operand type mismatch error
Symptoms:
When you attempt to import to AccuSQL, you may receive an error message that is similar to the following:
Operator/operand type mismatch
Cause:
There is not a current Semester or an existing Semester does not include today's date.
Resolution:
1.
If there is not a current Semester you'll need to either extend an existing Semester to include today's date, or create a new semester.
2.
To edit a semester date, or create a new semester go to System >> Semesters >> Make changes >> Click Save
3.
Retry importing
Related Articles
AccuTrack/AccuSQL: How to Change the Database Location
Method 1: Sign-in to the AccuSQL client as a system administrator and change the database location Step 1: Open AccuTrack/AccuSQL and log in with Admin credentials. Now, from the right-side menu of the System Administration screen, ...AccuSQL: How to Change the SQL Native Client Driver to the latest available version?
Step 1: From right side of the System Administration screen, Click on Database Step 2: Click on Database Location Step 3: Select the SQL Server radio button and Click Next Step 4: Select the SQL Native Client driver from the drop-down ...AccuTrack/AccuSQL: How to enable the Service Type list box in the Activities Sign-In Screen
Step 1: From the System Admin screen, click on Control Panel from the Administrative Options column on the right-hand side of the screen. Step 2: Select Activity Screen Options from the left-hand column Step 3: Click on the checkbox next to 'Show ...AccuTrack/AccuSQL: How to change Terminology
Step 1: From the System Admin screen, click on Control Panel from the Administrative Options column on the right-hand side of the screen. Step 2: Select System Options from the left-hand column Step 3: Click on the Terminology button Step 4: ...AccuTrack/AccuSQL: How can I get back into the software when I changed my database location to a data path it does not like?
AccuTrack/AccuSQL: How can I get back into the software when I changed my database location to a data path it does not like? This is simply that the database location is not set properly or your windows account does not have access to the required ...