New Data Source-Sql Problem

[Pincognos]

Hi,

I want to add new data source to Cognos Analytics directly and write sql. I added in data server connection succesfully. (Ms sql data source) But when I open new report and write sql I get error. Could you help me for solving this problem?

Error:
RSV-SRV-0042 Trace back:
RSReportService.cpp(762): XQEException: CCL_CAUGHT: RSReportService::processImpl()
RSReportServiceMethod.cpp(259): XQEException: CCL_RETHROW: RSReportServiceMethod::process(): asynchRunSpecification_Request
RSASyncExecutionThread.cpp(871): XQEException: RSASyncExecutionThread::checkException
RSASyncExecutionThread.cpp(317): XQEException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): asynchRunSpecification_Request
RSASyncExecutionThread.cpp(916): XQEException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRunSpecification_Request
RSQueryMgrBasic.cpp(296): XQEException: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommand
QFSSession.cpp(1238): XQEException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSSession.cpp(1236): XQEException: CCL_CAUGHT: QFSSession::ProcessDoRequest()
QFSSession.cpp(1197): XQEException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSConnection.cpp(2012): XQEException: CCL_RETHROW: QFSConnection::DescribeDataSourceQuery
QFSQuery.cpp(487): XQEException: CCL_RETHROW: QFSQuery::DescribeDataSourceQuery
XQEConnector.cpp(300): XQEException: CCL_THROW: XQEConnector::send

[Reinhard]

Did you specify the datasource in the properties for the sql object in the query explorer?

[chinnucognos]

It is because you didn't selected Package while creating new report and write/inject SQL after selecting packag

[Kiran P]

Yes, selecting a package is mandatory irrespective of whether you use anything from that package in your report or not.