OMPM Import

[pizzi]

Hello

I'm trying to import my OMPM scans to the database with the ImportScans.bat
script. Some scans are working without any problems. With some scans I get
the following error:

E920}00003.cab"...
Importing extracted data...
ERROR: Import operation failed.
Invalid character value for cast specification.
<?xml
version="1.0"?><Error><Record><HResult>0x80004005</HResult><SQLState>22018
</SQLState><NativeError></NativeError><Source>Microsoft OLE DB Provider for
SQL
Server</Source><Description><![CDATA[Invalid character value for cast
specificat
ion.]]></Description></Record></Error>

Any ideas?

 

[PICKLEPICKLE]

Crack open the XML file using notepad and look for any dates that ar
pre-1900's

When I encountered this error, my <ModifiedDate><![CDATA[ ]]> for th
file was from the year 1601. When I changed it to 1901 the file importe
just fine

Words