The results of your search are shown below. To refine your search, revise your keywords, and/or select the appropriate check boxes to the right.
System.IO.IOException: Bad file name or number running a report to the Queue
Symptom
When running a report to the queue, the log file indicates the following message
System.IO.IOException: Bad file name or number
System.IO.IOException: Bad file name or number
Product Line
DF-M19351-My Millennium > Assignments failure error "ORA-01722: invalid number" [TO_NUMBER() function, ORACLE only]
Symptom
~~Steps to reproduce:
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
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
Product Line
DF-M19340-Unable to Save Report Defaults in Millennium reporting
Symptom
Oracle Error
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
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
Product Line
DF-MM19341-ADE–Updating address removes Start Date
Symptom
ADE–Updating address removes Start Date
Product Line
DF-M19564-“There is no preferred name for this constituent, would you like to continue” appears saving additional name inserted by default
Symptom
There is no preferred name for this constituent, would you like to continue” appears saving additional name inserted by default
Product Line
DF-M19590-Constituent First Name is truncated when adding a non-constituent guest to a registrant
Symptom
Constituent First Name is truncated when adding a non-constituent guest to a registrant
Product Line
DF-FA-17599-Quick Employee Payroll missing benefit codes
Symptom
Benefit code and figures not reflected on Quick Employee Payroll Summary report
Product Line
DF-FA-17600-Voids on Payroll Voucher Register Report not reflected correctly
Symptom
The Payroll Voucher Register currently does not show voided vouchers or drop off voided vouchers
Product Line
DF-FA-17601-Tbl.APVendor error when running a Journal Report
Symptom
Unable to Run Report: Error Message: Invalid Object Name ‘tblAPVendor ‘
Product Line
DF-FA-17617-Unable to Reverse a Posted Session if using OL processing
Symptom
No information gets posted when selecting ‘Post’ on the ‘Reverse a Posted Session’ Screen if the organization is using the processing mode On-Line posting
Product Line
DF-FA-17618-Currency User Defined Field not Saving in Transaction Lines
Symptom
Numbers entered in currency user defined fields in transaction lines are not displaying after saving.
Product Line
DF-FA-17620-Clicking deposit hyperlink in bank rec does not function
Symptom
Cash Details screen does not come up if Deposit Number Column is not in first position
Product Line
DF-FA-17648-Dashboard Displays Blank Page or Crashes upon Launching
Symptom
Dashboard window displays blank page or causes Windows crash message upon launching.
Product Line
DF-FA-17649-Summary Asset Ledger has Incorrect Accumulated Depreciation
Symptom
Summary Asset ledger Accumulated Depreciation amount is incorrect
Product Line
DF-FA-17695-ACH files missing Transaction Code for Voided payroll checks
Symptom
Bank rejects voided direct deposit file due to missing information and incorrectly spaced entries
Product Line
DF-FA-17698-Unable To Create State Tax if State Unemployment is Not Checked
Symptom
State tax does not save. Message reads “Procedure or function ‘spStateTaxInsert’ expects parameter ‘@sSUTAPaidBy’, which was not supplied.”
Product Line
DF-FA-17700-Login required on each worksheet
Symptom
DrillPoint needs to login on each sheet
Product Line
DF-FA-17646-Error on Summary Budget Comparison Report when Suppress Zeros is Checked.
Symptom
Error running report with Suppress Zero checked. ‘Column ‘#tempttable2.Code_5 is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.’
Product Line
DF-FA-17737-An excluded NAE account shows up randomly in a Statement of Revenue and Expenditures report that contains an Equity Section
Symptom
The user has set up a format to exclude the NAE account. However when the report is run the GL account displays in multiple sections of the report.
Product Line
DF-FA-17696-Error in Revenue and Expense when Items by Page and Group Codes Used
Symptom
Error running report: “A column has been specified more than once in the order by list. Columns in order be list must be unique. "
Product Line
DF-FA-17795-Employee Import Fails with Error State Filing Status Required
Symptom
Issue exists when existing employees are imported that already contain state tax withholding information on their employee record. This causes the new employee next in the list to error: State Filing Status is required.
Product Line
DF-FA-17839-Unable to Enter Server Name for SMTP Greater than 30 Characters
Symptom
Cannot set up SMTP with the character limitation in the program when server name is longer than 30 characters.
Product Line
DF-FA-17849-AR Credit Appends Document Numbers Incorrectly
Symptom
A/R credit memos are being applied to the incorrect A/R invoices.
Product Line