| Brian Greiman 2005-05-19, 8:24 pm |
| We are using ASA v9.01.1964 on both consolidated and remotes. I am getting
an "Index would not be unique" error when downloading to remote database. I
am not sure what is causing this error and will not have access short of
running with full verbose mode. This is failing for me on multiple remote
users. Is there any way to force remote database to continue after failure
of this error instead of halting download completely. Please see partial
log below.
Thanks,
Brian
I. 05/19 17:03:08. Download stream: received 347843 bytes from MobiLink
Server.
I. 05/19 17:03:08. Processing download stream ...
I. 05/19 17:03:09. # rows inserted/updated into table in_price : 21
I. 05/19 17:03:09. # rows deleted in table in_price : 0
E. 05/19 17:03:09. SQL statement failed: (-196) Index
'in_price_company_si
ze_brand_price_x' for table 'in_price' would not be
unique
I. 05/19 17:03:09. ROLLBACK
I. 05/19 17:03:09. Download stream processing failed
I. 05/19 17:03:09. End synchronizing 'pub_ml_sales_subset
' for MobiLink user
'0515'
I. 05/19 17:03:09. Disconnecting from MobiLink server
I. 05/19 17:03:09. Complete log scan required.
I. 05/19 17:03:09. Synchronization completed
I. 05/19 17:03:09. Disconnecting from remote database
|