search

uic-utah / uic-forms

7520 form filler outer
MIT License
0 stars 0 forks source link

Querier not getting the UICArtPen #18

Closed CanDKD closed 4 years ago

CanDKD commented 5 years ago

https://github.com/agrc/uic-forms/blob/0e40a9b1db1fc6b7fb552f1ff918b69c588ef34a/uic-forms/services/Querier.cs#L168-L221

This appeared to be working on Sept 12, 2018 when I ran the tool for period Oct 1, 2017 to March 31, 2018 and we were writing to the pdf forms. Does not seem to work now when we are writing to csv file. Steve can you check your local instance against the current development instance to make sure we have the same UICArtPen wells?

steveoh commented 5 years ago

What dates are you using and what is the object id of the artpen that is not being picked up? Also, what db configuration are you testing in?

steveoh commented 4 years ago

Is this still an issue?

CanDKD commented 4 years ago

I will create some ArtPen Wells in Dev with various parameters set to capture the queries then run uic-forms.exe against DEV. I'll get back to you.

CanDKD commented 4 years ago

Steve, I created 2 UICArtPen wells in DEV that should be captured by uic-forms.exe. I tried to run the most recent version dated 10/22 against 'staging' but it crashes. I think we have recreated DEV since that time. here is the latest log.txt file .

7520-20191104.log.txt

steveoh commented 4 years ago

looks like it wasn't able to connect... 2019-11-04 13:19:51.439 -07:00 [Verbose] Connecting to UDEQ...

steveoh commented 4 years ago

The dev database isn't versioned right now. That would cause this tool to fail as it needs the versioned views. That isn't the issue here probably but it's a good thing to note as a requirement.

steveoh commented 4 years ago

@CanDKD i'm going to need more information. The artpens are used in 8 query locations. The query I ran found items so can you provide me the test case data where you are expecting the artpens to be found. Thanks!

This is the query we built before https://github.com/uic-utah/uic-forms/blob/c7647b8af0ea3739fbfbb4b73805aa0fc886446e/uic-forms/services/Querier.cs#L187-L221

It says that the artpen guid needs to be in the well aor_fk and then goes through and adds the well class, ca type, ca date, review date, and ident4ca where clause options.

and here is a sample where we use the query https://github.com/uic-utah/uic-forms/blob/c7647b8af0ea3739fbfbb4b73805aa0fc886446e/uic-forms/Program.cs#L99-L103

CanDKD commented 4 years ago

I think we may have a problem traversing the M:N relationship between AOR and ArtPen. I checked the AOR Validation> no artificial penetrations query in the UIC Tool and that isn't working correctly either. Here is a screenshot of the facility, well, authorization and artpens I created in DEV to check the uic-forms.exe and query.

image

Can you view the bridging table for this relationship? I can't see it. If nothing is in that table I need to build it manually.

Maybe 10 hours isn't enough to sort this out.

steveoh commented 4 years ago

Did you RNP these features to default? I only see one artpen connected as uic admin?

steveoh commented 4 years ago

So after some digging, it appears that the view can't see the data because it has not been compressed?

@michaelagrc, at your next convenience, would you compress uic dev?

CanDKD commented 4 years ago

Yes, I ran rnp-delete.bat then ran uic-forms.exe. I don't recall that compression was an issue in that past because I have successfully run the exe without first compressing. I have also run the .exe in Pro and reproduced the results I sent to EPA in Oct. At that time I did not have any UICArtPen wells to report. I thought we had this UICAoR / UICArtPen M:N issue resolved in the past. I still think there is an issue with how we migrated Prod to Pro with the M:N relationship.