[BUG] Resolve faction name not working 75% of the time

Example URL: census.daybreakgames.com/s:questforever/json/get/eq2/character/446679382573?c:limit=1&c%3Ashow=faction_list&c%3Aresolve=factions%28name%2Cvalue%29

The vast majority of responses are producing data like the following:

<span style="font-family: monospace; font-size: medium;">{<span style="font-weight: bold;">id<span style="font-family: monospace; font-size: medium;">: <span style="color: blue;">1<span style="font-family: monospace; font-size: medium;">,<span style="font-weight: bold;">value<span style="font-family: monospace; font-size: medium;">: <span style="color: blue;">5000<span style="font-family: monospace; font-size: medium;">}

But maybe one in four responses is resolving the name properly and producing:

<span style="font-family: monospace; font-size: medium; background-color: rgba(234, 237, 249, 0.690196);">{<span style="background-color: rgba(234, 237, 249, 0.690196); font-family: monospace; font-size: medium; font-weight: bold;">id<span style="background-color: rgba(234, 237, 249, 0.690196); font-family: monospace; font-size: medium;">:<span style="background-color: rgba(234, 237, 249, 0.690196); font-family: monospace; font-size: medium;"> <span style="background-color: rgba(234, 237, 249, 0.690196); font-family: monospace; font-size: medium; color: blue;">1<span style="background-color: rgba(234, 237, 249, 0.690196); font-family: monospace; font-size: medium;">, <span style="background-color: rgba(234, 237, 249, 0.690196); font-family: monospace; font-size: medium; font-weight: bold;">value<span style="background-color: rgba(234, 237, 249, 0.690196); font-family: monospace; font-size: medium;">:<span style="background-color: rgba(234, 237, 249, 0.690196); font-family: monospace; font-size: medium;"> <span style="background-color: rgba(234, 237, 249, 0.690196); font-family: monospace; font-size: medium; color: blue;">5000<span style="background-color: rgba(234, 237, 249, 0.690196); font-family: monospace; font-size: medium;">, <span style="background-color: rgba(234, 237, 249, 0.690196); font-family: monospace; font-size: medium; font-weight: bold;">name<span style="background-color: rgba(234, 237, 249, 0.690196); font-family: monospace; font-size: medium;">:<span style="background-color: rgba(234, 237, 249, 0.690196); font-family: monospace; font-size: medium;"> <span style="background-color: rgba(234, 237, 249, 0.690196); font-family: monospace; font-size: medium; color: green;">"The City of Qeynos"}

This has been happening since yesterday (9 Feb 2013).

<ul >[/list]

 

After the maintenance over the past few days, Census is reporting 0 results on any number of queries up to 95% of the time. Until this issue is resolved, developing and debugging against Census is quite problematic.

This is not a bug specific to factions.

 

Factions are the only place I'm seeing the issue though (possibly because it's the only place my app uses c:resolve).  If I separately request each faction name by ID then I always get a result for that but that costs a lot in terms of network requests which isn't good in a mobile app (although I use caching to minimise that) since I can't request the entire faction list in one go.

 

As seen in my other thread, it's happening for icons (item and spell icons) and spells as well.  The icons return 404 and the spells just return 0 results.

 

Looking forward to your mobile app. <img src="/station/images/smilies/3b63d1616c5dfcf29f8a7a031aaa7cad.gif" border="0" />

We keep local copies of a ton of stuff on EQ2U just so we don't have to do repeated lookups. I mean how often do Factions change? or Achievements? Or AAs/Prestige? Or Character Spells? Once a year? If we ever did a mobile app (no serious plans as of yet), we would store a rather large blob of frequently displayed info on the device.

Good luck! <img src="/station/images/smilies/3b63d1616c5dfcf29f8a7a031aaa7cad.gif" border="0" />