Source not available issue

[Guest_imported]

I have problem kept getting "source not available" for the systems not frequently but some time ....

Could somebody got the same issue before..what I need to do to resolve the issue.


Wondows xp Prof for testing/wind2003 prod
datastageTx8.0.1
3maps in the system
Not much big files.

 

[OllyC]

Are you using the file adapter?

Are your input files renamed after writing them (e.g. *.tmp -> *.txt) or do you have delays on your maps? (try changing the TriggerTime in the dstx.ini)

is there a chance that the same file is written to twice?

It could be the speed of the OS or filesystem too.

Also you could try setting up retries on the input card, e.g. -IF1R3:1


Cheers,
Olly.

 

[RedSoxM3]

OllyC, with the file adapter (output), does Mercator internally write files with a .tmp extension first then rename when complete or just write the file as is and build it in the output directory?

 

[dstxaix]

I understand
1) If you use a PUT command you will not have files getting renamed automatically.
2) If the file is being written as a card, the map will write as .tmp and then rename to the required extension

 

[Guest_imported]

Ollyc
I did tried by keeping the retry option =1 but still some times I am getting the "source not available " issue.

dbl show the following:
<1252-656>: [DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation.
<1252-656>: Returned status: (-13) No error text found

I am getting problem in the source database card.

MaxThreads=1
WatchMaxThreads=0
DisableMaxThreads=0

Max concurrent map instances in IFD =0

 

[eyetry]

What kind of DB? Oracle, DB2,.....

Could a table be locked?

 

[eyetry]

looks like SQLServer...???

This info might answer the question.... not sure about your solution...

http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:6/threadid:254

http://www.mcse.ms/message993032.html

also found this....
-------------------------------------------------------
CAUSE
This issue occurs because Microsoft Windows Server 2003 Service Pack 1 (SP1) implements a security feature that reduces the size of the queue for concurrent TCP/IP connections to the server. This feature helps prevent denial of service attacks. Under heavy load conditions, the TCP/IP protocol in Windows Server 2003 SP1 may incorrectly identify valid TCP/IP connections as a denial of service attack. This behavior could lead to the issue that is described in the "Symptoms" section.

RESOLUTION
Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall your operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

To resolve this issue, turn off this new functionality in Windows Server 2003 SP1 by adding the SynAttackProtect entry to the following registry key on the computer that is running Microsoft SQL Server that houses your BizTalk Server databases.
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
Set the SynAttackProtect entry to a DWORD value of 00000000. To do this, follow these steps: 1. Click Start, click Run, type regedit, and then click OK.
2. Locate and then click the following registry key:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
3. On the Edit menu, point to New, and then click DWORD Value.
4. Type SynAttackProtect, and then press ENTER.
5. On the Edit menu, click Modify.
6. In the Value data box, type 00000000. Click OK.
7. Quit Registry Editor.
Note To complete this registry change, you must restart the computer that is running SQL Server.
--------------------------------------------------

 

[Guest_imported]

I am using sql server 2000

 

[OllyC]

Hi Suneeld,
What is your IdleDB setting in the mercator.ini file?
if unset, try setting it to 30 and retesting.

Otherwise it could be a database or network issue.

Cheers,
Olly.

 

[OllyC]

>with the file adapter (output), does Mercator internally
>write files with a .tmp extension first then rename when
>complete or just write the file as is and build it in the
>output directory?

If the PUT function is used then a temporary file will be created. The file will be given its final name when the map burst completes.

If an output card is used it depends on the OnFailure setting in the card. Setting it to rollback will mean that a temporary filename is used, setting it to commit means that there is no temporary filename used.

 

[BocaBurger]

dbl show the following:
<1252-656>: [DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation.
<1252-656>: Returned status: (-13) No error text found

This seems to point to a problem outside of WTX. Have your network admins put a snaiffer on the network.

BocaBurger
<===========================||////////////////|0
The pen is mightier than the sword, but the sword hurts more!

 

[Guest_imported]

Hi every one thanks for posting the valuable information
I just want to give a quick update
y'day I changed the idleDb=1 and enable KeepDB=0 from commented. After that I did't find any issues so far.

Ollyc you pointed that....thanks.

 

[BocaBurger]

This points to a DB issue. KeepDB=0 does the same thing as leaving it commented oout. You might be impacting performance with IdleDB=1. Better to fix the DB or network issue and try for IdleDB=10 and KeepDB=5.



BocaBurger
<===========================||////////////////|0
The pen is mightier than the sword, but the sword hurts more!