WebCOBRA.com Community Message Boards

kotradov
Posts: 45
Since: 08/25/2008

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?

chadada
Posts: 24
Since: 08/07/2007

That normally means there is something wonky in your data and the view that gets it is giving an error. What is your administrator code so I can have a look?

kotradov
Posts: 45
Since: 08/25/2008

My code is "bcbsga"

Thanks

chadada
Posts: 24
Since: 08/07/2007

there were some dates that were in an incorrect format(they were 00/00/0000 instead of null). i cleaned those up so you should be good to go.

kotradov
Posts: 45
Since: 08/25/2008

Hello,

I am now using admin code "UNI" and I am getting the same error at step 4. Please help!!!

Thanks,
Kirk

chadada
Posts: 24
Since: 08/07/2007

Hey kirk,
Give support a call please so they can get this worked out for you.
Thanks.

jkubicina
Posts: 12
Since: 03/07/2008

I am receiving an error stating that a Duplicate Primary ID is preventing the database from being loaded. I have logged a support case and listed the name of the employee that was last loaded (Case #24655). Admin code: HRX.

If you could fix asap, that'd be great. January premiums post to the ledger balance on the first of the month, so we need to load the API today.

Thanks,
J.Kubicina

kotradov
Posts: 45
Since: 08/25/2008

I am getting a similar message now as well. My case is 24386. The response I am getting from support is that it going to need a program fix to correct and they can't give me a time frame. Can you give any further information.

chadada
Posts: 24
Since: 08/07/2007

kirk,
you are getting a 'Duplicate Primary ID is preventing the database from being loaded' error?

if so, what admincode?

kotradov
Posts: 45
Since: 08/25/2008

UNI

kotradov
Posts: 45
Since: 08/25/2008

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

chadada
Posts: 24
Since: 08/07/2007

there were some dupes in the qbgroupinformationcache table that was causing the error. removed those records for you so you should be good to go.

kotradov
Posts: 45
Since: 08/25/2008

I tried a download again and received the same error in step 4. Please help!!!

kotradov
Posts: 45
Since: 08/25/2008

It is encountering the error on record 9732 in the QB table in the web api. The record id is 3xD0000036578.

chadada
Posts: 24
Since: 08/07/2007

okay, so it looks like that qb was assigned to the same department twice, which was causing him to come back twice in the view, hence the dupe key error. fixed the data so you can download.

kotradov
Posts: 45
Since: 08/25/2008

With that done, I was able to complete step 4. Then it went to step 5 and after about 5 minutes, the following pop up message appeared:Sorry, we had an error: The underlying connection was closed: An unexpedted error occurred on a receive.

Can you try to run it on your end if you have my login information an see if you have the issue? If not, could you send run it and send me a the Access database so I have the data and could start working with it?

jwolgamott
Posts: 257
Since: 09/26/2005

@kotradov -- most of your other posts include trying to find information in the RelationalAPI, but this thread is about the WebAPI.

Are you going to utilize both systems? It seems like if you were to just utilize the RelationalAPI, you might find more success that way.

kotradov
Posts: 45
Since: 08/25/2008

Yes, I am trying to utilize both. The WebAPI seems more straightforward in trying to get QB data. I am trying to get the group data from the Relational. At this point, I am to far along with this route using both, so that is my preference.

jwolgamott
Posts: 257
Since: 09/26/2005

@kotradov -- well you can certainly continue down that road; however I highly recommend you standardize on the RelationalAPI and download it daily.

When you get the connection errors on the WebAPI, please try it again. If you get the duplicate key errors on the WebAPI, you can either alter the Access Database to allow it, or you can edit the C# code to handle that eventuality.

kotradov
Posts: 45
Since: 08/25/2008

The last error wasn't a duplicate key error. Please note the error I received in step 5.

kotradov
Posts: 45
Since: 08/25/2008

Jesse,
If you have a few minutes, could you give me a call and we could discuss some of the fields in the WebAPI and how I can find them in the Relational API.

My information should be in your support documentation.

Thanks,
Kirk Otradovec

jwolgamott
Posts: 257
Since: 09/26/2005

Kirk --

Sorry, I'm just sharing some information that I thought you'd find useful. If you'd like to speak one on one with a consultant, we have Professional Services that can help you out with that. It's a billable feature at an hourly rate -- please ask support for more information.

It might be easier if you would start a new thread and list out each field you're curious about in one post -- we could then respond in one post and the question/answer would seem more fluid.

With the connection errors -- The WebAPI just doesn't perform well on large datasets. If you were using it to integrate a phone system or send 1 QB queries, I think you'd find better success with it, but with an organization of your volume, I think you've just outgrown it. If I were you, I would commit to the RelationalAPI.