DF-M17574-Relations System Default view disabled for a Non-Constituent relationship
Invalid File Name, Load report failed error or invalid report file path message running report
~~Crystal Exception opening: \\mill.livelab.net\Formats\bio\ROSTER ONE ACROSS.RPT
CrystalDecisions.Shared.CrystalReportsException: Load report failed. ---> System.Runtime.InteropServices.COMException: Invalid file name.
at CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.Open(Object& DocumentPath, Int32 Options)
at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.Open(Object& DocumentPath, Int32 Options)
at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened()
--- End of inner exception stack trace ---
at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened()
at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename, OpenReportMethod openMethod, Int16 parentJob)
at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename)
at cmdcrystal.cmdcrystal.CrystalRun.RunCrystalReport()
reg exception 2: CrystalDecisions.CrystalReports.Engine.LoadSaveReportException: Invalid report file path.
at CrystalDecisions.CrystalReports.Engine.EngineExceptionUtils.DoThrowException(String message, EngineExceptionErrorID id)
at CrystalDecisions.CrystalReports.Engine. .X(String
, EngineExceptionErrorID
)
at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename, OpenReportMethod openMethod, Int16 parentJob)
at CrystalDecisions.CrystalReports.Engine.ReportDocument.()
at CrystalDecisions.CrystalReports.Engine.ReportDocument.get_Database()
at cmdcrystal.cmdcrystal.CrystalRun.RunCrystalReport()
at cmdcrystal.cmdcrystal.Main(String[] args)
DF-M20015-OCD-Phone types and Internet Address types display all values regardless if they are marked for the OCD or not
DF-M20020-Insert Gift via default generates error: Invalid column name 'continitds' Error Code 207
Error Message -- Insert
INSERT INTO creditcard_full(credcctype, credmethod, credfirst6, credlast4, credexpyr, credexpmn, credccnm, credaddrl1, credaddrl2, credcity, credstate, credzip, credcntry, credemail, credsave, credid, credlnkfil, credlnkkey, credtender, credamount, credstatus, credguid, credapprov, credref, credmasked, credspsid, credinitum, credindate, credinitvr, continitds) VALUES ('visa ', 'R', ' ', '', ' ', ' ', 'Mr. Chris Jones', '1120 Burgess Dr', '', 'Leander', 'TX ', '78641-7783', 'USA ', '', 'Y', '0000000263', '05', 2605479153, 'cc', 300.00, '', '', '', '', '', '', 'V', 'Feb 26, 2016', 'AA,BB', 'E')
SQL_ERROR
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'continitds'.
Error Code 207
DF-M20071- Activity reporting truncating activity description to 50 characters
DF-M20087-Activity reporting crashes IIS when editing a report with more than 45 activities listed in the select statement
Message received is either 503, Service Unavailable or "You are not properly logged on to Abila Millennium"
DF-M20071-Activities not available for including in reporting in Edit>Criteria
DF-M20071-The same activity appears in both panes when selecting Activities for inclusion in Edit>Criteria reporting selects
DF-M20140-Drive-Constituent Title bar not displaying in Recently Viewed records
DF-M20166-Editing data to hide in online constituent directory uploads true publish flag in Advanced data examiner pending tables
Error writing record to correspondence_pending” table after corebio_pending and correspondence_pending tables were dropped inadvertently
0000085307 *****|Error writing record to correspondence_pending
Troubleshooting steps:
Reviewed system and SQL server errors:
SQLExecDirect Error: [Oracle][ODBC][Ora]ORA-00904: "CORRADESRC": invalid identifier--S0022 Statement DSN Web SQL
Frequent timeouts log users out of Millennium Oracle database
Millennium log files indicate a problem with TNS listener
An error occurred generating a temporary report file name
Run Roster One Across
Changed report format path to new server path.
The output path displays new server output path with filename \ip\export\test1
Running report returns error
'An error occurred generating a temporary report file name'
Error: Path - \\141.133.64.202\Queue, filename - M Wg ^af, Number – 267
DF-M19803-Drive > Relations & Circles > Circles: The apostrophe in the Circle Name prevents displaying circles
DF-M19822-Tax receipting utilizes process date rather than effective date
DF-M19827-Pledge payments not selected for tax receipts if payments exist on pledge in prior years
System.IO.IOException: Bad file name or number running a report to the Queue
System.IO.IOException: Bad file name or number
DF-M19848-Past due tasks not displayed in red in My Millennium unless due date is one month prior to current date
DF-M19351-My Millennium > Assignments failure error "ORA-01722: invalid number" [TO_NUMBER() function, ORACLE only]
1. Login to Millennium ( as a non admin user)
2. Go to the My Millennium > Assignments > New > Gift
3. Insert Gift Assignment
o Assignment Name: test_gifts_1
o Apply Notification To: select Any Constituent
o Gift Amount Exceeds: 10.00
o Click on the "Insert" button
4. Navigate to ORACLE database Server and login as DBA
5. Launch "Oracle SQL Developer" tool and connect to a database
6. Execute SQL statement below (e.g. asgnkey=5027)
o select asgnkey, asgnstate from assignments where asgnname ='test_gifts_1''
7. Copy the "SELECT" statement
o select giftkey, giftid from gifts where to_number(giftcrdate) >= to_number(sysdate) and giftamount > 10.00
Note:
• QA tested this issue in v.2015.1 and v.2016.1 (this issue is applicable to oracle system only)
• If you'll execute the statement (step # 7) in Oracle SQL Developer tool, the system generates the error
o ORA-01722: invalid number
• The correct statement should be:
o select giftkey, giftid from gifts where to_number(to_char(giftcrdate,'yyyymmdd')) >= to_number(to_char( sysdate, 'yyyymmdd')) and giftamount > 10.00
DF-M19340-Unable to Save Report Defaults in Millennium reporting
ISAPI call failed. Error: Could not update report defaults.
[Oracle][ODBC][Ora]ORA-01400: cannot insert NULL into (“MILLORA”.REPORT_OPTIONS”.”USERID”)
SQL system
Export report path will not save in Millennium reporting