First time here? Check out the FAQ!

L_Status field, download failure

  • retag add tags

Good day, our credentials are as follows:

Login URL: Login ID: ZipRealty

We are currently getting an Exception error when attempting incremental data downloads for source OK_NWOAR. The following message, alluding to the field 'L_Status', indicates that we are getting characters in that field that are uncommon, perhaps even invalid. The failures began approx. 11/17/2021 13:30:04.

Error message as follows: "An invalid value was given for a calculated field [DMQLtoSQL.getSubquery: Calculated field query value cannot be parsed into constituant parts: L_Status]"

Please advise if any invalid values may have made it into the L_Status field for this source.

Thank you for your time and efforts.

djn1990's avatar
asked 2021-11-18 15:28:49 -0500
edit flag offensive 0 remove flag close merge delete


add a comment see more comments

1 Answer


It looks like you must have fixed this already.
I see some failures earlier where you were passing query strings like:
Which is why the errors were returned.
The status values being passed should look like: (L_Status=|1_0,1_1)
It looks like you switched to using queries like: (L_UpdateDate=2021-11-18T00:20:29+),(L_StatusCatID=|1,2,3)

bwolven's avatar
answered 2021-11-18 18:38:15 -0500
edit flag offensive 0 remove flag delete link


add a comment see more comments

Your Answer

Login/Signup to Answer