I have a server job which runs weekly, wherein I extract data from a staging table and DM table. The staging data is loaded from a DSS and data extracted from the staging is that which has changed in the DSS within the last 8 days. A comparison is then done within a transformer on an ID between the staging data and DM data. If the ID is new it is inserted into the DM table. This works fine in 7.0 development server. However, on the production server which is 7.0.1, rows get randomly dropped every week.
How the comparison is done is, the ID of staging data is compared with the ID of the DM data. If the DM ID is NULL (checked using IsNull()), then the row is passed through.
Why does this problem happen? As I can see, there is some difference between server lookup stage of 7.0 and 7.0.1; or there is some difference is the functioning of IsNull().
Please let me know if anyone knows of any such issue.
Regards,
Vinod
Lookup works in 7.0 but fails in 7.0.1
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 82
- Joined: Wed Jul 14, 2004 7:21 am
- Location: India
Lookup works in 7.0 but fails in 7.0.1
Integrity is what you do when no one is watching
Hi,
IMHO, you can try to verify your assumptions.
Run the 7.0 having your source from production (for reading only) and output it to a test DB or files.
If the result is the same as 7.0.1 on prod then you missed something that your dev/test environments doesn't contain or missed something else.
If the results are different then you might be on to something different in versions.
By the way do you use NLS in tihs job and do you promote it via VC?
IHTH,
IMHO, you can try to verify your assumptions.
Run the 7.0 having your source from production (for reading only) and output it to a test DB or files.
If the result is the same as 7.0.1 on prod then you missed something that your dev/test environments doesn't contain or missed something else.
If the results are different then you might be on to something different in versions.
By the way do you use NLS in tihs job and do you promote it via VC?
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
-
- Participant
- Posts: 82
- Joined: Wed Jul 14, 2004 7:21 am
- Location: India
Hi Roy,
I have already done this and the results of the job are different in both cases, and that's how I have narrowed it down to IsNull(). And no, the default NLS mapping is used in the job and the default NLS mapping is the same on both servers.
Regards,
Vinod
I have already done this and the results of the job are different in both cases, and that's how I have narrowed it down to IsNull(). And no, the default NLS mapping is used in the job and the default NLS mapping is the same on both servers.
Regards,
Vinod
Integrity is what you do when no one is watching
Do oyu use VC to promote jobs?
If So does this job by any chance has NLS in a where part?
If So does this job by any chance has NLS in a where part?
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
-
- Participant
- Posts: 82
- Joined: Wed Jul 14, 2004 7:21 am
- Location: India
I guess you'll need to ready a test case and contact your support provider
I must say I'm
some what by the fact your not working on the same version in dev/prod.
If your performing lookups and testing the lookup data for IsNull(key column) try putting the lookup link's NOTFOUND attribute instead and see if it works ok (it's in the link variables).
IHTH,
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
I must say I'm
![Shocked :shock:](./images/smilies/icon_eek.gif)
If your performing lookups and testing the lookup data for IsNull(key column) try putting the lookup link's NOTFOUND attribute instead and see if it works ok (it's in the link variables).
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
-
- Participant
- Posts: 82
- Joined: Wed Jul 14, 2004 7:21 am
- Location: India
-
- Participant
- Posts: 232
- Joined: Sat May 07, 2005 2:49 pm
- Location: USA