QE-DEF-0323 The DSN(ODBC)/ServiceName is invalid

[jasvarun]

Hi,
I am trying to import an txt file using manage external data utility provided in Cognos10. The file is getting successfully imported and a new package is getting created in MYFolder section.

The problem is I am not able to use the data in the text files. The cognos10 is giving an error like Login failed "QE-DEF-0323 The DSN(ODBC)/ServiceName is invalid". But the previous package is working fine. the error is only coming when I am trying to use the new package with external data.

I tried the same in my Dev environment and its working fine.

Have anybody faced the same issue before? Please guide me to the solution

[MFGF]

Hi,
I am trying to import an txt file using manage external data utility provided in Cognos10. The file is getting successfully imported and a new package is getting created in MYFolder section.

The problem is I am not able to use the data in the text files. The cognos10 is giving an error like Login failed "QE-DEF-0323 The DSN(ODBC)/ServiceName is invalid". But the previous package is working fine. the error is only coming when I am trying to use the new package with external data.

I tried the same in my Dev environment and its working fine.

Have anybody faced the same issue before? Please guide me to the solution

Did you use a UNC filename to a network drive your Cognos server has access to when defining the path to your external file? If you browse and select a local drive such as C:\whatever... the server will not be able to locate the file subsequently.

MF.

[jasvarun]

Hi,
Thanks for your reply

I am giving the path like //servername/filename.txt

One more thing I would like to add. We have 4 different servers (machines)
-One for Portal
-two for dispatcher
-One for content store

Could you please tell where should we exactly place the file

[MFGF]

Hi,
Thanks for your reply

I am giving the path like //servername/filename.txt

One more thing I would like to add. We have 4 different servers (machines)
-One for Portal
-two for dispatcher
-One for content store

Could you please tell where should we exactly place the file

A UNC file name would be of the form \\servername\foldername\filename.txt - the path you specified looks like a URL not a UNC filename? The server and folder the file exists within should be accessible from the dispatcher machines in your architecture, although if you make it available from all of them it wouldn't hurt.

Cheers!

MF.

[jasvarun]

Hi,

I tried the same way as you suggested.But still I am getting the below error:

QE-DEF-0323 The DSN(ODBC)/ServiceName is invalid. Either the DSN is missing or the host is inaccessible.RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in: Bursting_M1_CBI UDA-SQL-0031 Unable to access the "Bursting_M1" database. Check that the connection parameters to the database are configured correctly. For example, ensure that the data source connection contains the signon information, such as a password, to connect to the database.UDA-SQL-0528 The XML parser returned the following message: "An exception occurred! Type:NetAccessorException, Message:Could not connect to the socket for URL 'http://www.w3.org/TR/html4/strict.dtd'".UDA-SQL-0529 XML "http://machine1234.net:9300/p2pd/servlet/dispatch/metadataUIService?pid=xml_dstream&m_..." is not a valid XML document.RSV-SRV-0042 Trace back:RSReportService.cpp(722): QFException: CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(263): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_RequestRSASyncExecutionThread.cpp(808): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(260): QFException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(864): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand():

[MFGF]

Hi,

I tried the same way as you suggested.But still I am getting the below error:

QE-DEF-0323 The DSN(ODBC)/ServiceName is invalid. Either the DSN is missing or the host is inaccessible.RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in: Bursting_M1_CBI UDA-SQL-0031 Unable to access the "Bursting_M1" database. Check that the connection parameters to the database are configured correctly. For example, ensure that the data source connection contains the signon information, such as a password, to connect to the database.UDA-SQL-0528 The XML parser returned the following message: "An exception occurred! Type:NetAccessorException, Message:Could not connect to the socket for URL 'http://www.w3.org/TR/html4/strict.dtd'".UDA-SQL-0529 XML "http://machine1234.net:9300/p2pd/servlet/dispatch/metadataUIService?pid=xml_dstream&m_..." is not a valid XML document.RSV-SRV-0042 Trace back:RSReportService.cpp(722): QFException: CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(263): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_RequestRSASyncExecutionThread.cpp(808): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(260): QFException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(864): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand():

When adding the external data file, did you select the option to allow the server to automatically load the file?

MF.

[jasvarun]

Hi,
I already checked that option.

Steps I followed.
1. In the external data management utility. I browsed to the location in one of my dispatcher server where I have stored the file
2. Check automatically loaded button ON
3. Map the fields
4.Publish the package
The new fields are visible in the newly created package. But when I use the data items it giver error.

Might there is some problem in accessing the file or may be I missed some steps

Because I did the same steps in development and it worked fine.But in the development we have dispatcher & content store in one machine.

[MFGF]

Hi,
I already checked that option.

Steps I followed.
1. In the external data management utility. I browsed to the location in one of my dispatcher server where I have stored the file
2. Check automatically loaded button ON
3. Map the fields
4.Publish the package
The new fields are visible in the newly created package. But when I use the data items it giver error.

Might there is some problem in accessing the file or may be I missed some steps

Because I did the same steps in development and it worked fine.But in the development we have dispatcher & content store in one machine.

Hi,

Are you sure that when you are browsing you are not using a mapped drive on your local machine that points to the network folder?

If unsure, manually enter the network path and filename rather than selecting it.

MF.

[jasvarun]

Hi,
The file location path is grey in my case and its not allowing me to enter manually (see screenshot).
I am giving the network path of the file without using mapped network drive

[MFGF]

Hi,
The file location path is grey in my case and its not allowing me to enter manually (see screenshot).
I am giving the network path of the file without using mapped network drive

Hi,

No - I didn't mean there. After you click Browse, you can enter the network path and filename into the address bar at the top. Is this what you are doing?

MF.

[jasvarun]

Hi,

yes, I am doing the same
like
\\servername\Path\File_Name.txt

[MFGF]

Hi,

yes, I am doing the same
like
\\servername\Path\File_Name.txt

Ok. Next thought - are there any governors restricting access to external data in your package?

MF.

[jasvarun]

Hi,
There are no restriction in the package as it is working fine in the development environment.

But there can be a chance that configuration settings in Cognos10 administration could be different in production vs development. But I don't have a clue about what settings are required to use txt file as external data source in the package.

KR,
Varun

[MFGF]

Hi,
There are no restriction in the package as it is working fine in the development environment.

But there can be a chance that configuration settings in Cognos10 administration could be different in production vs development. But I don't have a clue about what settings are required to use txt file as external data source in the package.

KR,
Varun

It's controlled by governors set in the Framework Manager model before the package is published.

MF.

[jasvarun]

hey,

Sorry to bother you. But I am not a framework expert.
So could you please guide me regarding the governor sets in the framework.

Is it any check box which needs to be checked before publishing the package?

Thanks,
Varun

[MFGF]

hey,

Sorry to bother you. But I am not a framework expert.
So could you please guide me regarding the governor sets in the framework.

Is it any check box which needs to be checked before publishing the package?

Thanks,
Varun

Hi,

Yes. Go to Project > Edit Governors. For a description, see the Framework Manager User Guide, pages 288/289:

http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/10.2.1/ug_fm.pdf

Cheers!

MF.

[PRIT AMRIT]

Hello MF,

I don't have a such an option (enable external file import etc) in FM: Go to Project > Edit Governors. PFA

Upgrade to latest fix pack would help, not very sure though  :(

Is there anything in specific you would like to see or check? Many thanks for your help indeed.

Regards,
Prit