on 01-02-2015 1:28 PM
Friends,
Wish you a Happy New Year..
Í'm facing a breaker here. I tried to refresh a crystal report via RAS SDK. I got the below error..
The system cannot find the path specified---- Error code:-2147467259 Error code name:failed
So i just referred the RAS Log generated and below is what i found.
../cdtsagent.cpp (3321)
COM: 0x80070003
The system cannot find the path specified. -- detail msg end -->
ErrorLog 2015 1 2 6:46:49.392 26787 1062 (XBBKLME:267) (../reporthandler.cpp:12471): CReportHandler::buildReportViewerError: CSResultException thrown. ErrorSrc:"CRPE" FileName:"../reporthandler.cpp" LineNum:12467 ErrorCode:515 ErrorMsg:"This field name is not known.
Error in File {72A288FD-8118-11E4-90BA-005056B20305}.rpt:
Error in formula FRM_Total_Matches:
'//{#RT_System_Matched_ST}+{#RT_Manual_Match_ST}
This field name is not known.
Details: errorKind" DetailedErrorMsg:""
ErrorLog 2015 1 2 6:46:49.568 26787 1062 (XBBKLME:267) (../cdtsagent.cpp:3323): CDTSagent::doOneRequest reqId=134: <-- detail msg begin -- Analysis Server: 0x80004005
But the above field is validated and report works good when you refresh from Infoview with any custom DB connection.
Scenario appears like , If the custom DB configuration of crystal report is similar to the DB i want to connect , report output gets generated. Else it shoots the above error in log..
Awaiting your help guys..
Thanks,
Bharath
Hi Bharath,
What is the BO Product version you are using?
Are you using replaceConnection() method of RAS sdks to change the database connection while viewing the reports?
If yes, what hapens when you oint your report to the same database from CR designer which throws you the error from the code
Thanks,
Prithvi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Prithvi ,
I'm using BO XI 3.1 .
And Yes I'm using ReplaceConnection ( code below that i use to change DB connection)
// read initial connection info from SP based report.
ConnectionInfos conns = reportClientDoc.getDatabaseController().getConnectionInfos(null);
IConnectionInfo oldConnInfo = conns.getConnectionInfo(0);
// Modify conninfo during runtime applicable for current env
PropertyBag newLogon = new PropertyBag();
newLogon.putStringValue("Server", dbService);
newLogon.putBooleanValue("Trusted_Connection", false);
PropertyBag newAttrib = new PropertyBag();
newAttrib.putStringValue(PropertyBagHelper.CONNINFO_CRQE_DATABASETYPE, "Oracle Server");
newAttrib.putBooleanValue(PropertyBagHelper.CONNINFO_SSO_ENABLED, false);
newAttrib.putStringValue(PropertyBagHelper.CONNINFO_DATABASE_DLL, "crdb_oracle.dll");
newAttrib.putStringValue(PropertyBagHelper.CONNINFO_CRQE_DATABASENAME, "");
newAttrib.put(PropertyBagHelper.CONNINFO_CRQE_LOGONPROPERTIES, newLogon);
newAttrib.putBooleanValue(PropertyBagHelper.CONNINFO_CRQE_SQLDB, false);
newAttrib.putStringValue(PropertyBagHelper.CONNINFO_CRQE_SERVERDESCRIPTION, "Modified description");
IConnectionInfo newConnInfo = new ConnectionInfo();
newConnInfo.setAttributes(newAttrib);
newConnInfo.setUserName(dbUser);
newConnInfo.setPassword(dbPass);
// Replace the conninfo at runtime
System.out.println("attributes before change : " + oldConnInfo.getAttributes());
System.out.println("attributes after change : " + newConnInfo.getAttributes());
reportClientDoc.getDatabaseController().replaceConnection(oldConnInfo, newConnInfo, null, DBOptions._useDefault);
When i try to refresh from CR designer , it runs completely fine with any DB Connection. Its very weird.
Any ideas? Am i missing anything in the code?
Thanks,
Bharath
Prithvi,
I'm facing the scenario with few reports with different error "Failed to retrieve data from Database". But the same connection works with both Infoview & CR designer. I've pasted the RAS log below. Need your help.
../cdtsagent.cpp (3321)
COM: 0x80070003
The system cannot find the path specified. -- detail msg end -->
ErrorLog 2015 1 6 2:43:17.516 16024 1370 (XBBJ4ND:350) (../reporthandler.cpp:12471): CReportHandler::buildReportViewerError: CSResultException thrown. ErrorSrc:"CRPE" FileName:"../reporthandler.cpp" LineNum:12467 ErrorCode:723 ErrorMsg:"Failed to retrieve data from the database.
Failed to retrieve data from the database.
Failed to export the report. the database.
Error in File {737CE39C-8118-11E4-8204-005056B20302}.rpt:
Failed to retrieve data from the database.
Details: [Database Vendor Code: 936 ]" DetailedErrorMsg:""
ErrorLog 2015 1 6 2:43:17.729 16024 1370 (XBBJ4ND:350) (../cdtsagent.cpp:3323): CDTSagent::doOneRequest reqId=134: <-- detail msg begin -- Analysis Server: 0x80004005
../cdtsagent.cpp (3321)
COM: 0x80070003
The system cannot find the path specified. -- detail msg end
Thanks,
Bharath
Are you setting any parameters for your report before changing the database connection from your code?
You would need to check that the names should match in the new database. Please consider the case of parameter names.
Check the below link to understand about the error msg you getting.
http://help.sap.com/businessobject/product_guides/errors/12/0/en/html/topic180.html
Thanks,
Prithvi
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.