Millennium

"Table cannot be found" message verifying the database in a Crystal report.
You get this message for each table.
Then other errors follow when trying to connect to the Generic worktable.

The following error is found in the Cmdcrystal.log file in the Queue folder on the reporting server:

2018/04/06==10:39:26 User: DMackerel Report Name: Annual Fund Report Report Path: \\WESTLAKE02\Reports Destination: E
 
Workfile: DMackerel.wrkA86566683311405525_1
 
opening report: \\WESTLAKE02\Formats\Bio\ADDRESSEXPORT.RPT <<<<<<<<<<<<<<<<<<<<<<
 
SetTableLogin Info WESTLAKE02:milldata:DMackerel.wrkA86566683311405525_1 Error: System.Runtime.InteropServices.COMException (0x800002F4): Failed to open the connection.
Details:  [Database Vendor Code: 4060 ]
Database Connector Error: 'IM006:[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed [Database Vendor Code: 4060 ]'
Failed to open the connection.
Failed to open the connection.
ADDRESSEXOPORT {5B673687-F6C6-4485-855E-CCCAA4A1CC7D}.rpt
Details:  [Database Vendor Code: 4060 ]
   at CrystalDecisions.ReportAppServer.Controllers.DatabaseControllerClass.SetTableLocation(ISCRTable CurTable, ISCRTable NewTable)
   at CrystalDecisions.CrystalReports.Engine.Table.set_Location(String value)
   at cmdcrystal.cmdcrystal.CrystalRun.SetTableLoginInfo(TableLogOnInfo crLoginInfo, Table crTable, String sServer, String sDatabase, String sTable, String sUser, String sPwd)
 

Opening rpt in crystal reports message is "Unable to write to Y:\Bio\$$ Export for file - mini bio.rpt, it is read-only or opened by someone else"
There is a mapped drive that is set up as a share.

If unable to log in to Millennium after a server migration or restore of Millennium, it may be due to the SQL users not matching or permissions did not carry over properly.

Unable to create a super lookup filter

Split allocation gifts not split on spouse’s credited gift

Reporting-Prompting by Event code returns 0 records

 
1. Select Reporting>New Criteria>Event
2. Select the Event Profile report
3. Run the report with the existing default criteria:
           Select all Event where Code from Event is equal to '<a prompted reply>'
4. When prompted select any Event code and click OK
4. In Q Management the report generated:
 
          Report Name: cj event code User: cj
Run Date: 01/26/2018 10:19 AM
Notes: Report completed, selecting 0 records.  Total Time: 00:00:03

The Change_Date_User_ ID field is not displaying the changed date and user Id field in Profiles>Event Log>Registration

Users experience the error message below when clicking Insert to add a Guest row onto an event registrant record after clicking on Create a Non-Constituent Guest link.

*SQLExecDirect Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '-'.--37000 Statement: DSN=Web SQL;UID=tvt;==select attlnkkey from attendance_full where attregkey = - *SQLExecDirect Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '-'.--37000 Statement: DSN=Web SQL;UID=tvt;==select attkey from attendance_full where attregkey = - *SQLExecDirect Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '-'.--37000 Statement: DSN=Web SQL;UID=tvt;==select guestkey from event_guest_full where guestlnkky = - *SQLExecDirect Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'Media'.--37000 Statement: DSN=Web SQL;UID=tvt;==select gitemitmky from guest_items_full where gitemlnkky = 5900 or gitemlnkky = cial Media Workshop 1/25/18 or gitemlnkky = 0 or gitemlnkky = 5900 or gitemlnkky = cial Media Workshop 1/25/18 or gitemlnkky = 0