softwords / pineapples / issues / #981 - Warehouse Rebuild fails after work on SpEd environment tables/views — Bitbucket

Issue #981 resolved

Ghislain Hachey created an issue 2020-09-09

No description provided.

Comments (6)

Brian Lewis repo owner
- changed status to resolved
fix(warehouse): special ed rebuiild broken by table name change of lkpSpEdEnvironment

Resolves ~~#981~~

→ <<cset ddaab5522343>>
- 2020-09-09T23:20:14+00:00
Brian Lewis repo owner
fyi in this commit I have also release common.findText stored procedure, which will identify occruences of a string in the text of a view, stored proc, function etc.

This is useful for finding unsuspected references to a table name or view name e.g.
```
common.findText 'lkpEdEnvironment'
common.findText 'lkpEdEnvironment', 'warehouse'
common.findText 'lkpEdEnvironment', 'warehouse','V'
```
‌
- 2020-09-09T23:31:07+00:00
Brian Lewis repo owner
These changes are pushed to pacificemisdb and fedemis production

‌
- 2020-09-09T23:31:33+00:00
Ghislain Hachey reporter
- changed status to open
@Brian Lewis re-opening this as the regenerate still fails. Just some other renames to do.
- 2020-09-10T07:58:54+00:00
Ghislain Hachey reporter
‌
- 2020-09-10T08:00:45+00:00
Brian Lewis repo owner
- changed status to resolved
fix(warehouse): warehouse.reconcile fails after views renamed

Resolves ~~#981~~

→ <<cset 67380ff4ffed>>
- 2020-09-16T22:21:53+00:00
Log in to comment

Assignee: Brian Lewis

Type: bug

Priority: blocker

Status: resolved

Votes: 0

Watchers: 2

Jira: the preferred issue tracker for Bitbucket. Join the team!