Test Environement for Match Designer

kkumardatastage · Post by **kkumardatastage** » Tue Dec 22, 2009 1:11 pm

Hi

Please help me in this issue.

i am using the matc Designer with 3 pass, in test environment i gave the proper Samle Information as Data Sample Data Set with specified file, and i gave the Frequency Information Data Frequency Data Set with Maximum Frequency Value 100 and i specified a Data Set file.
and the Test connect is good with using Configuration File of DEFAULT

after i update the test environment i am getting the following error.

## <main_program>
IBM WebSphere DataStage Enterprise Edition 8.0.1.4665
Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved

##I <main_program> The open files limit is 100; raising to 65536.
##I <main_program> orchgeneral: loaded
##I <main_program> orchsort: loaded
##I <main_program> orchstats: loaded
Resource bundle corresponding to message key return code {0} from SQLConnect(handle, {1}, ****, {2}) with message {3} not found! Check that DSHOME or APT_RESPATH is set.
##F <main_program> Fatal Error: Could not connect to datasource?? (-1; AAAA; AAAA; [DataDirect][ODBC lib] Data source name not found and no default driver specified)
:

Please can you help me in this issue.

Thanks
k

kkumardatastage · Post by **kkumardatastage** » Tue Dec 22, 2009 2:55 pm

Hi

I think we need to re-run the Match Designer, so that we will be Solving this issue. now the Match Designer is running good and giving the all the pass result.

Thank
k

ray.wurlod · Post by **ray.wurlod** » Tue Dec 22, 2009 3:43 pm

Did you change anything between the two runs, or must we assume that you encountered a transient error?

kkumardatastage · Post by **kkumardatastage** » Tue Dec 22, 2009 6:55 pm

HI Ray
No i have not changed any thing just i closed all windows and jobS of datastage and re open and run the job it was good and got the result.