Hi,
We have a simple job that has a dummy file going into an ODBC stage (SQL server) taht runs an update statement. Looks like everything is successful but the job throws the warning below. This is the first time we are executing this job in Version 8.0. I just ported this project over from version 7.5.
Thanks - - John
Server:NJROS1BBLA0681
Project:CostFoundation
Job No:169
Job name:Zero_EnteredCost
Invocation:
Event Number:42
Event type:Warning
User:PRUDENTIAL\X090842
Timestamp:4/13/2010 12:36:24 PM
Message Id:-1
Message:
Zero_EnteredCost..Zero_EnteredCost.IDENT1.dummy_in: DSD.BCIPut call to SQLExecute failed.
SQL statement:UPDATE cfssas_enteredcostelement_in Set EnteredCost = 0 WHERE EnteredCost is not null
2528 Rows affected.
dummy = "x "
Warning while sql seems to be executing
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 am
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 am
I just ran the same job in Version 7.5 and I do not receive a warning and no log entry for teh number of rows updated just the following:
Project:CostFoundation (PAERSCBBLA0293)
Job name:Zero_EnteredCost
Event #:55
Timestamp:4/13/2010 12:46:36 PM
Event type:Info
User:PRUDENTIAL\X090842
Message:
Zero_EnteredCost..Zero_EnteredCost: DSD.BCIConnect call to SQLConnect returned informational message.
Project:CostFoundation (PAERSCBBLA0293)
Job name:Zero_EnteredCost
Event #:55
Timestamp:4/13/2010 12:46:36 PM
Event type:Info
User:PRUDENTIAL\X090842
Message:
Zero_EnteredCost..Zero_EnteredCost: DSD.BCIConnect call to SQLConnect returned informational message.
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 am
It's probably something that should have happened in the early version that they "fixed" in the later release. That "informational message" is what you now see - the number of rows affected. There may be some setting in the DB or ODBC options to turn that off, be curious what support comes back with as it really shouldn't be classed as a failure. IMHO.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 am