Millennium

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

 

All users in Oracle database are frequently logged out of Millennium with the following error message



Millennium log files indicate a problem with TNS listener




 

Using ADE tool, error occurs when loading data into the correspondence_pending table.
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

 

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
 

~~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