WebCOBRA.com Community Message Boards

pmckenna
Posts: 5
Since: 03/07/2008

Hi Team - When using the WebAPI_Loader.exe\Load Access Database, I am receiving the following error:

"We could not connect to the Access Database. Actual Error: The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again."

Can you please clarify what the issue is? If the issue resides in WebCOBRA, how can I determine where the duplicate values reside? I appreciate your help.

PM

jwolgamott
Posts: 257
Since: 09/26/2005

PM--

The API Loader goes through several stages when getting records from the WebAPI and inserted them into Access.

Which stage are you receiving the Access Insert error?

Once we know this, you should look into that table (QB for example) and note the last record successfully inserted.

We can then diagnose why the loader is trying to insert the record twice.

(Don't post that person's information here.. Once you have the record, email it to spt@travisoft.com with a link to this page, and we can diagnose together).

jwolgamott
Posts: 257
Since: 09/26/2005

Paul --

I'm glad you were able to run the API loader this morning without a problem.

We didn't do anything on our end; The problem may have been (but I can't tell for sure) consistency . It's possbile as you made the 30th API call, another user has inserted a record into page 2, which moves a QB onto your current page.

For our larger customers we move to a nightly refresh of the API data, which solves some of the consistency issues. We're rolling this out site wide within the next 1-2 weeks.

Basically, this shouldn't be a problem for you moving forward.

jkubicina
Posts: 12
Since: 03/07/2008

Jesse,
I'm receiving the same error today on step 4 of the load process. Would you be able to advise? Do you need me to provide the last QB that was added to the table via email?
Thanks,
Jimmy

pmckenna
Posts: 5
Since: 03/07/2008

Hi Jesse - I'm receiving this error again today. Please let me know if you would like me to send you the QB data, thanks.

Paul

jwolgamott
Posts: 257
Since: 09/26/2005

Paul --

I found the duplicate QB Group in the cache and removed him for you -- please try the download again.

pmckenna
Posts: 5
Since: 03/07/2008

Hi Team - I am trying to download the Access API data and it get to the 4th step, Getting QBS and I am getting a popup box stating "Sorry, we had an error: Unspecified Error in your request". If I click OK, the process runs on the Getting QBs, but after a half hour, I still don't have any progress. Have you seen this before with the API downloader to the access file?

Paul

Julie.Dickens
Posts: 1
Since: 05/18/2009

We just switched to WEBCOBRA I was not informed that we would have to recreate our Access Reports. Who can I talk to on this issue? Julie

travis
Posts: 44
Since: 04/22/2009

@Julie.Dickens -- Welcome to WebCOBRA!

I'm not sure what you'd like to talk about, but if you have questions regarding data structures, you can post them here (and read other people's comments and questions that blazed trails before you).