System Options not retained, Display Death with Basic Data: reverts back to 'Yes'
"Report Name: Gift All Transaction: JOHNSMITH
Run Date: 04/08/2015 10:03 AM
Notes: [Oracle][ODBC][Ora]ORA-01536: space quota exceeded for tablespace 'MILLREPORTS'
Statement: Create table wrk1F8E100333_2 as select gift1.giftid id_number, gift1.giftkey timekey, gift1.giftfnum keyfileno, ' ' column_decrypt, 'A' grouptag from gifts_full gift1 where (gift1.giftbatch='07APR1501' and (gift1.gifttype='b' or gift1.gifttype='g' or gift1.gifttype='y')) Native Error: 1536 "
Error writing record to correspondence_pending” table after corebio_pending and correspondence_pending tables were dropped inadvertently
0000085307 *****|Error writing record to correspondence_pending
Reviewed system and SQL server errors:
SQLExecDirect Error: [Oracle][ODBC][Ora]ORA-00904: "CORRADESRC": invalid identifier--S0022 Statement DSN Web SQL
Millennium log files indicate a problem with TNS listener
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 - \\184.108.40.206\Queue, filename - M Wg ^af, Number – 267
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
• 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-M23148-“Conversion from string “N” to type ‘Date’ is not valid” importing running import into pending tables
The csv file contains relid, relkey and relnmy1 fields mapped to the Relation table
The identifier settings are as follows
The mapping is created for the two fields to the Relation table
After saving the mapping and we click File>Run import to pending tables, the error occurs.
“Conversion from string “N” to type ‘Date’ is not valid”
DF-M21732-Wealth Engine lookup sends corrupted data which hangs history lookup in Wealth Engine: Oracle sites only
This affects Oracle sites only.
Caution should be used as criteria is also being saved as empty, wiping out any existing criteria.