Staged user database schema / IDL mismatch

Bug #1104516 reported by Jeff Godin
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Evergreen
Fix Released
Undecided
Unassigned
2.3
Fix Released
Undecided
Unassigned
2.4
Fix Released
Undecided
Unassigned

Bug Description

In fm_IDL.xml, the stgu and stgba classes have references to sequences which do not exist in the database schema.

staging.usr_stage_row_id_seq -- a typo, s/usr/user/ matches the existing sequence in the database.

staging.billing_address_stage_row_id_seq -- does not exist because the table staging.billing_address_stage table is created with LIKE, and uses the sequence staging.mailing_address_stage_row_id_seq

The above issues lead to errors when attempting to create staged users using the API method open-ils.actor.user.stage.create

Revision history for this message
Jeff Godin (jgodin) wrote :

The commit here contains a single commit which addresses the IDL fixes, as well as the OU setting issue in bug 1104517. I plan to split the changes out and will create a working branch in the usual place for signoff. For now, just getting this bug documented and the preliminary fix out there: http://git.evergreen-ils.org/?p=evergreen/tadl.git;a=commit;h=de88b461de89ca541b5f18b9f048bdeaecbff60f

Revision history for this message
Bill Erickson (berick) wrote :

see bug #1104517 -- pushed to 2.3+

Changed in evergreen:
milestone: none → 2.5.0-alpha1
assignee: Jeff Godin (jgodin) → nobody
status: In Progress → Fix Committed
Ben Shum (bshum)
Changed in evergreen:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.