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.

DF-M16703-ADE Import Tool login error when using SSL “Error encountered in determining millennium_admin access to the database”

Submitted by 181 on Thu, 09/04/2014 - 14:14
Symptom
Advanced Data Examiner Import Tool generates an error “Error encountered in determining millennium_admin access to the database” while executed from a workstation if site is using SSL
Product Line
Millennium

DF-M17269-Data Examiner: “Automatic Update” step generates an error "Insufficient security or table value inactive" for inactive lookup codes

Submitted by 181 on Mon, 11/03/2014 - 10:45
Symptom
Data Examiner: “Automatic Update” step generates an error "Insufficient security or table value inactive" for inactive lookup codes  
Product Line
Millennium

Error writing record to correspondence_pending” table after corebio_pending and correspondence_pending tables were dropped inadvertently

Submitted by 334 on Wed, 01/06/2016 - 11:11
Symptom
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

 
Product Line
Millennium

DF-M17796-ADE-Using an Import Source that is multiple words like “Soft Edit” or “Online Directory” you are unable to accept Deletions

Submitted by 181 on Fri, 02/20/2015 - 09:43
Symptom
ADE-Using an Import Source that is multiple words like “Soft Edit” or “Online Directory” you are unable to accept Deletions
Product Line
Millennium

DF-M18979-AFO>ADE>The “Export Data” process generates the error “A SQL Error Has Occurred” when an AFO label or sublabel contains apostrophes”.

Submitted by 181 on Wed, 09/02/2015 - 13:56
Symptom
The “Export Data” process generates the error “A SQL Error Has Occurred” when an AFO label or sublabel contains apostrophes”.


 
Product Line
Millennium

DF-M22244-Field lengths in ecommerce_pending tables don’t match the size of field lengths in their targeted tables

Submitted by 334 on Tue, 04/18/2017 - 08:31
Symptom
The field lengths in ecommerce_pending table are smaller than the field length in their respective destination fields.
Example:
Addrphone: char(30) -  ecomhphone: char(15)
Phnumber: char (70) – ecomhphone: char(15)
Phnumber: char(70) – ecomhphone: char(15)
Giftacctnm: char(80) – ecomacctnm: char(80?)

 
Product Line
Millennium

DF-M23148-“Conversion from string “N” to type ‘Date’ is not valid” importing running import into pending tables

Submitted by 334 on Fri, 12/15/2017 - 10:44
Symptom
“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” 
Product Line
Millennium