Job is Hanging

Latha1919 · Post by **Latha1919** » Thu Oct 19, 2006 5:22 am

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.

Latha1919 · Post by **Latha1919** » Thu Oct 19, 2006 5:46 am

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?

thumsup9 · Post by **thumsup9** » Thu Oct 19, 2006 11:35 am

I remember Ray's quick fix advice to clear the Status file in your Director for this particular job and then running the job again.

meena · Post by **meena** » Thu Oct 19, 2006 11:45 am

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.

ray.wurlod · Post by **ray.wurlod** » Thu Oct 19, 2006 12:48 pm

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.