Data Integrator unstable

[Former Member]

Hello,

I've been having problems with this for some time, I hope somebody can help. My DI installation seems to have become unstable in the last couple of months. Occasionally, scheduled jobs will fail. I'm learning along the way how to check the logs. Some of the logs I checked suggest that there is a connection time out:

(12.1) 06-02-10 07:00:47 (E) (9120:9428) CON-120302: Initialization

ODBC call <SQLDriverConnect> for data source <xxxx> failed: <[Microsoft][ODBC SQL Server Driver]Timeout expired>. Notify

Customer Support.

The same job will sometimes be ok, sometimes fail like this.

Even when I am working with Designer, sometimes the job server stops responding. The logs show:

(12.1) 06-03-10 17:00:07 (2312:9968) JobServer: Notification error while sending message to <inet:172.16.10.102:3112> with message type <16>. Error Message: RWSocketError: in

RWSocket::connect: TIMEDOUT (BODI-850171)

After this happens (when using my WinXP PC), even if I run Designer on the server, the Job server is totally not responding. However, the process al_jobserver.exe is still showing in Task Manager. After I restart the Job server, it will usually be ok (sometimes require reboot).

My WinXP PC is running firewall, which I can't seem to turn off. However, Designer is specified in the Exceptions.

More Background: DI V12.1. Server OS Windows 2003 SE SP2. Client OS WinXP SP3.

Database SQL server 2005: same server for repository and destination database.

This server is also running BOE XI3.1 (I'm advising to change to dedicated hardware, but it will take time).

Can anybody please advise? Thanks in advance!

JT

[Former Member]

Jonathan,

can you please suggest how you fixed this issue ? i am experiencing the same exact issue in our environment.

RS

[Lee_Morgan]

Hi Jonathan,

Can you please confirm if the suggested action has helped resolve the problem?

Thanks,

Lee

[Former Member]

I am facing an issue while using the CASE transform of data services. I am getting an error as below.

ODBC call <SQLDriverConnect> for data source <CHANGE_THIS> failed: <[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server

I am not sure what it means I what i need to do next. Kindly help with a simple and effective way to get through this error.

Thanks for your help.

[Former Member]

It seems you imported some ATL files and didn't change the datastore configurations. Check the datastore configurations (right click the datastore and select Edit from the context menu). In the new window, replace "CHANGE_THIS" with appropriate values.

Regards,

Shine

[Former Member]

Thanx for your help.

I made the changes as suggested by you and it is working absolutely fine.

[Former Member]

we had the same issue and we found that defualt setting for logintimeout is 30 secs and change it to more than 180 and see if it helps.

sqlserverlogintimeout

sqlserverquerytimeout

Raj

[Former Member]

Hello Rajesh,

Thanks for the suggestion. May I know where to make this change?

JT

[Former Member]

Hi JT,

You can either add these below statements to DSCONFIG.txt under [al_engine]

but i would suggest that open the DI Designer on any client machine

Click on Tools -

---

> Options and Expand Job Server

Select General ---> you would see a sceen which shows Set attribute Values

Section - al_engine

Key - sqlserverlogintimeout

value - 180

Raj