Closed nonprofittechy closed 2 years ago
I got the same issue with different values, and as far as I can tell, the filing code isn't invalid.
I had Court: "adams", category: "210 (Family)", Filing code "28048", which is in the database correctly:
28048 | Interpleader | | 210 | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
It is in multiple times, which is concerning, but that shouldn't matter, and the correct "28048" was sent to Tyler. My only guess is if the codes have changed since then. We can see tomorrow, as the updater code should be scheduled to run now, we can compare the difference between this data and your data to what's on the server then.
tyler_efm_codes=# select * from filing where location='adams' and name ='Interpleader';
code | name | fee | casecategory | casetypeid | filingtype | iscourtuseonly | civilclaimamount | probateestateamount | amountincontroversy | useduedate | isproposedorder | efspcode | location
-------+--------------+-----+--------------+------------+------------+----------------+------------------+---------------------+---------------------+------------+-----------------+----------+----------
28044 | Interpleader | | | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28044 | Interpleader | | 7306 | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28045 | Interpleader | | | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28045 | Interpleader | | 6189 | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28046 | Interpleader | | | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28046 | Interpleader | | 6190 | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28047 | Interpleader | | | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28047 | Interpleader | | 6191 | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28048 | Interpleader | | | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28048 | Interpleader | | 210 | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28184 | Interpleader | | | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28184 | Interpleader | | 183528 | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28185 | Interpleader | | | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28185 | Interpleader | | 183527 | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28186 | Interpleader | | | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28186 | Interpleader | | 6196 | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28187 | Interpleader | | | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28187 | Interpleader | | 6194 | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28188 | Interpleader | | | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28188 | Interpleader | | 6195 | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28189 | Interpleader | | | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28189 | Interpleader | | 7062 | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28190 | Interpleader | | | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28190 | Interpleader | | 6197 | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28191 | Interpleader | | | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28191 | Interpleader | | 6198 | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28192 | Interpleader | | | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28192 | Interpleader | | 6199 | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
That seems to be the case: I manually updated the codes this morning (missed the autotrigger last night because of time zone issues), and this is the results of that query now:
select * from filing where location='adams' and name ='Interpleader';
code | name | fee | casecategory | casetypeid | filingtype | iscourtuseonly | civilclaimamount | probateestateamount | amountincontroversy | useduedate | isproposedorder | efspcode | location
-------+--------------+-----+--------------+------------+------------+----------------+------------------+---------------------+---------------------+------------+-----------------+----------+----------
28184 | Interpleader | | | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28044 | Interpleader | | | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28044 | Interpleader | | 7306 | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28045 | Interpleader | | | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28045 | Interpleader | | 6189 | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28046 | Interpleader | | | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28046 | Interpleader | | 6190 | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28047 | Interpleader | | | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28047 | Interpleader | | 6191 | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28048 | Interpleader | | | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28048 | Interpleader | | 210 | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28190 | Interpleader | | | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28190 | Interpleader | | 6197 | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28191 | Interpleader | | | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28191 | Interpleader | | 6198 | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28192 | Interpleader | | | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
28192 | Interpleader | | 6199 | | Subsequent | False | Not Available | Not Available | Not Available | False | False | | adams
The 28048 doesn't appear anymore. The live server codes were probably updated just a few weeks ago, so it's interesting to know that courts will just change filing types that often.
@nonprofittechy can you try to find those same choices you found the wrong code with again?
I still was able to trigger the error with the same menu choices on the apps-dev server. However it's also still the case that I'm not getting a valid return date, so the error might be masked by that.
Current status: it appears that codes did change after a code refresh. So stale codes might have explained things. But it also seems that we refreshed the codes and the problem was still happening for some random case types--not just in cook:dr1 but also in adams.
@BryceStevenWilley drop any notes here if you discover more, and also if it's something to reach out to Tyler about.
Reached end of interview, did not get a valid return date. Was able to click the "send to court" button but it didn't successfully file. It's possible return date was the issue--but curious if the "unknown filing code" error was accurate and how to prevent that.
Chose category "domestic relations - general proceedings", case type "petition to declare invalidity", filing type "writ of habeas corpus"
After submitting, got back the error
Unknown filing codes are not allowed