WideWorldImpoters ETL Question at Container Load City Dimension

Open

#1,111 opened on Feb 16, 2023 2 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty: 4/5
Estimated time: 3-5 days
Newbie friendliness: 20/100

Issue type: Bug
Clarity: Needs clarification
Activity status: Stale
Tech stack: sql
Domain: databases

Research direction

Start with DailyETLMain.dtsx and the Execute SQL Task 'Get Lineage Key' in the 'Load City Dimension' container. Read the Integration schema definition of the getlineagekey stored procedure, trace how @NewCutOffTime is supplied, and confirm the task no longer reports missing required parameters.

Written by the indexing model from the issue text.

Description

On visual studio, I restart DailyETLMain.dtsx manually. When executing Execute SQL Task 'Get Lineage Key' in container 'Load City Dimension', an error "No value given for one or more required parameters" was encountered. I check the definition of Stored Procedure getlineagekey in Schema Integration.
The variable @TableName is "City". But what is the variable @NewCutOffTime?
Please help me for this question!! Thanks

Dominant language: PowerShell
Stars: 11.2k
Forks: 9.1k
Avg merge: 2d 7h
Merged PRs (30d): 14

Contributor guide

No contributing guide indexed for this repository

First steps

Read the whole issue, then the project's contributing guide.
Comment on the issue to say you are picking it up — it saves two people doing the same work.
Fork the repository and make your change on a branch.
Open a pull request that references the issue number.

Similar issues

harbor-db: missing STOPSIGNAL turns every container stop into an unclean shutdown Open

Difficulty 1/5 Under an hour Newbie friendliness 75/100

goharbor/harbor#23989 · Opened Sep 23, 2026
[Bug] 知识库写入失败：document_storage.py 使用 naive datetime 导致 SQLModel 报错 Open

bug

Difficulty 2/5 1-3 hours Newbie friendliness 88/100

AstrBotDevs/AstrBot#10205 · Opened Sep 23, 2026
column_count panics when called before the statement is executed Open

Difficulty 2/5 1-3 hours Newbie friendliness 72/100

duckdb/duckdb-rs#869 · Opened Sep 23, 2026
Update demo setup database to be `webapi` type Open

Difficulty 2/5 1-3 hours Newbie friendliness 70/100

OHDSI/Data2Evidence#3394 · Opened Sep 23, 2026
MultiScan: ~ScanIterator() asserts on the status operator++ just threw, so reaching max_prefetch_size aborts instead of raising MultiScanException Open

Difficulty 2/5 1-3 hours Newbie friendliness 84/100

facebook/rocksdb#15255 · Opened Sep 23, 2026

More Databases issues