Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

SQL selection error #691

Open
wfastrononomer opened this issue Jan 20, 2025 · 3 comments
Open

SQL selection error #691

wfastrononomer opened this issue Jan 20, 2025 · 3 comments

Comments

@wfastrononomer
Copy link

wfastrononomer commented Jan 20, 2025 •
edited
Loading

looks like the UHS got lost in the noise:

2025-01-18 08:26:18.94: Calculating noise model for 259046 frame sets...

2025-01-18 08:33:22.93: SQL or Database Error: Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them.

Script executed: SELECT fieldID,filterID,productID FROM Requiredstack WHERE programmeID=107 and fieldID IN (0,1,2,3,4,5,6,7,8,9,10,...
and then all other fieldIDs up to ...,65785).
@wfastrononomer wfastrononomer converted this from a draft issue Jan 20, 2025
@wfastrononomer
Copy link
Author

I think this is in cu6 - I don't think we want the uhsVariability tables.

@wfastrononomer wfastrononomer moved this from To do to In progress in 401 UHS DR3 Jan 22, 2025
@wfastrononomer
Copy link
Author

update Programme set variabilityTable='NONE',bestMatchTable='NONE' where programmeID=107
Update RequiredFilters set isSynoptic=0 where programmeID=107

./parsing/surveyparser.py WSA UHS

Drop all the tables I mentioned before.

Run cu19.

@wfastrononomer
Copy link
Author

Best improve cu6 code too.
Updated in r13633

@wfastrononomer wfastrononomer moved this from In progress to Done in 401 UHS DR3 Jan 24, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
401 UHS DR3
Status: Done
Milestone
No milestone
Development

No branches or pull requests
1 participant
@wfastrononomer