Hi,
Controller job was hung yesterday and finally we aborted the job. Following is the error message logged for the Sub-job:
Event type:Fatal
Message:
Job name:GetProfileHashDataJob
Event #:4308
Timestamp:10/18/2006 2:42:18 PM
Event type:Warning
User:USEIT007\dsadmin
Message:
GetProfileHashDataJob..SiteRegistrationTable: DSD.BCIConnect connecting to , call to SQLConnect failed.
SQLSTATE=S1090, DBMS.CODE=0
[DataStage][SQL Client]Invalid parameter length
Job name:GetProfileHashDataJob
Event #:4309
Timestamp:10/18/2006 2:42:18 PM
Event type:Fatal
User:USEIT007\dsadmin
Message:
GetProfileHashDataJob..SiteRegTableToSiteRegHash: |GeProfileHashDataJob..SiteRegistrationTable: DSD.BCIConnect connecting to , call to SQLConnect failed.
SQLSTATE=S1090, DBMS.CODE=0
[DataStage][SQL Client]Invalid parameter length|
Job name:GetProfileHashDataJob
Event #:4310
Timestamp:10/18/2006 2:42:27 PM
Event type:Control
User:USEIT007\dsadmin
Message:
Job GetProfileHashDataJob aborted.
Job name:GetProfileHashDataJob
Event #:4311
Timestamp:10/18/2006 3:28:18 PM
Event type:Info
User:USEIT007\dsadmin
Message:
GetProfileHashDataJob..SiteRegHash.ToSiteRegHash: Write caching disabled
Please advise.
Job is Hanging
Moderators: chulett, rschirm, roy
I ran the sub job, individually and it completed successfuly with some warning message as below:
Job name:GetProfileHashDataJob
Event type:Warning
User:USEIT007\dsadmin
Message:
GetProfileHashDataJob..SiteRegTableToSiteRegHash: Synchronization error Resource = GetSiteProfileHashDataJob..SiteRegHash.ToSiteRegHash, CurWave = 225, LastWave = 225, Expected 0
Any idea about this Synchronization error?
Job name:GetProfileHashDataJob
Event type:Warning
User:USEIT007\dsadmin
Message:
GetProfileHashDataJob..SiteRegTableToSiteRegHash: Synchronization error Resource = GetSiteProfileHashDataJob..SiteRegHash.ToSiteRegHash, CurWave = 225, LastWave = 225, Expected 0
Any idea about this Synchronization error?
dsx
Hi
Check this:
viewtopic.php?t=84050&highlight=curwave+lastwave.
And do a search on the warning in the forum, there are many posts discussed.
Check this:
viewtopic.php?t=84050&highlight=curwave+lastwave.
And do a search on the warning in the forum, there are many posts discussed.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Any time there's a warning about BCIConnect() failing, it means that DataStage was unable to connect to a data source (typically through ODBC or UV stage, or DRS stage with ODBC selected). You need to check ("job starting" event in job log) that any parameters had correct values. You need to test whether the connection can be (could have been) made.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.